This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out.
I'm running on MSSQL 2008 Express, EF5 and MVC4
My web.config file looks a bit like this:
<configuration> <connectionStrings> <add name="DefaultConnection" connectionString="Data Source=\SQLEXPRESS; Initial Catalog=derpmart; User Id=appuser; Password=bacon;"/> </connectionStrings> </configuration>
I've made sure my sql server login that I'm using here has CREATE DATABASE permission on the master database, but I'm still getting the following error:
CREATE DATABASE permission denied in 'master'.
The site is currently running off the asp.net development web server that gets created when you debug a wep app so I don't know if that' running under a different username and if that could be causing the problem.
I've tried this using multiple logins (the above, sa, windows authentication on an administrator account) and still can't get anything to happen.
I'm out of ideas here so if anyone has anything to add, I'd love to hear your thoughts and suggestions. Please have thoughts and suggestions!
Now I'm getting this when I try to login with the user specified in the connection string:
TITLE: Connect to Server
Cannot connect to LOGAN-PC\SQLEXPRESS.
A connection was successfully established with the server, but then an error occurred during > the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other > end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?> ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
Fixed that, as Named Pipes was not enabled in SQL Configuration Manager. Still getting the
CREATE DATBASE error though.