Error with return query.ToList(); in ReservationQuery.cs

[scotterickson88]

System.Data.SqlClient.SqlException (0x80131904) : 'Cannot open database "MyHotelDb" requested by the login. The login failed.
Login failed for user 'BLHS\serickso'.'

[SitholeWB]

I resolved that by creating Login on my SQL instance. Try creating user under Security -> Logins.

I believe this can be avoided in future by switching from SQL Server to SQL Lite.