SQL Server connection string woes

Question

After spending 6 hours today to get a connection with my SQL Server 2012 database from Visual Studios 2012, I give up.

Setup:

Database: App_Data/GameDB.mdf
DB Location: C:\Users\USERNAME\Documents\Visual Studio 2012\Projects\ProjectRawWar\ProjectRawWar\App_Data\GameDB.mdf

Connection string:

<add name="LocalSqlServer" 
     connectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=GameDB;Integrated Security=False;"/>

I first tried a SQL Server Compact database, didn't work.
I tried many other connection strings from connectionstrings.com, didn't work.
I tried to put the full path of the database in the connection string, didn't work.

Can someone please help me out of my misery?

Update: I just followed http://msdn.microsoft.com/en-us/library/aa983322.aspx. The database is there. I copied the connection string from the wizard right into my webconfig connectionstring, still doesnt work. Why? Where is the logic?

I tried that too. I tried server = localhost -> didnt find any database. I tried server = computername -> didnt find any database. — Wesley De Keirsmaeker
– Wesley De Keirsmaeker, Commented Oct 14, 2012 at 16:10

Sebastian Meine · Accepted Answer · 2012-10-14 16:31:22Z

1

Reading your question I am getting the feeling that you are trying to connect to a database file. While you can do that with Access "Databases" it is not possible with SQL Server databases. The file needs to be mounted or attached to SQL Server first.

Check out this MSDN article for details: http://msdn.microsoft.com/en-us/library/ms190209.aspx#SSMSProcedure

answered Oct 14, 2012 at 16:31

Sebastian Meine

11.9k1 gold badge34 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Wesley De Keirsmaeker Over a year ago

I'll take a look at that, thanks. The SQL Server Database is attached to my project tough, as I can open it in Visual Studios.

Wesley De Keirsmaeker Over a year ago

'<add name="DataContext" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|GameDB.mdf;User Instance=true" />' is currently my connectionstring. It looks like it's connecting cause now i'm getting error: 'Cannot open database "GameDB" requested by the login. The login failed. Login failed for user HPCDSBE\Wesley.DeKeirsmaeker. ' In Visual Studio my database is attached and I can work with it.

Wesley De Keirsmaeker Over a year ago

I downloaded and installed MS SQL Server Management and also this program can't connect to my Visual Studio server. Error: ` A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)`

Lawrence Johnson · Accepted Answer · 2012-10-14 18:45:40Z

0

If you're going to disable integrated security, then you need to provide a username and password.

IE:

Server=127.0.0.1;User ID=useridhere;Password=passwordhere;database=dbnamehere

Be sure to make sure the userid and password you specify has access to the database you need. For testing, you can use the 'sa' account, but that's a poor long-term solution for major security reasons.

answered Oct 14, 2012 at 18:45

Lawrence Johnson

4,0952 gold badges20 silver badges30 bronze badges

2 Comments

Wesley De Keirsmaeker Over a year ago

'<add name="DataContext" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|GameDB.mdf;User Instance=true" />' is currently my connectionstring. It looks like it's connecting cause now i'm getting error: 'Cannot open database "GameDB" requested by the login. The login failed. Login failed for user HPCDSBE\Wesley.DeKeirsmaeker. ' In Visual Studio my database is attached and I can work with it.

Lawrence Johnson Over a year ago

You need to interact with whatever the database is attached to, not the MDF file.

Wesley De Keirsmaeker · Accepted Answer · 2012-10-15 19:10:20Z

0

Ok I fixed it myself. How I did it: Delete every .sdf and .mdf file. Just made following connection strings:

    `<add name="DataContext" 
     connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\GameDB1.mdf;Integrated Security=True"
     providerName="System.Data.SqlClient" />
<add name="LocalSqlServer"
     connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\GameDB1.mdf;Integrated Security=True"
     providerName="System.Data.SqlClient" />`

Visual Studio created my database using my DBContext.

Thanks all for the information.

answered Oct 15, 2012 at 19:10

Wesley De Keirsmaeker

1,0251 gold badge9 silver badges29 bronze badges

Collectives™ on Stack Overflow

SQL Server connection string woes

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related