I hope someone can shed some light into this. I deployed a code first web app into IIS 7 using WebDeploy (with profile). Everything looked good, but when the app gets started from a web browser it returns this error:
CREATE DATABASE permission denied in database 'master'. My app has nothing to do with the master DB. However I have noticed that the default app in SQL Express for the user I'm using is master db, but since this is a code first app. the db for the
app is not yet there and cannot be selected. Does anyone knows how to correct this problem? The user in my connection string is an admin in the SQL server , the database and in the server.
I also get: Cannot open database "aspnet-SQL-20140916014146" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.
The scenario is something like this. I have SQL 2014 Express in my develo ...
Go to the complete details ...