ASP.NET connection to local DB not working

Question

I am trying to connect to a local SQL Server database and It is not working, the connection String is

Dim connString As String = "server=C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA;Integrated Security=SSPI;initial catalog=AdventureWorks"
sqlConn.ConnectionString = connString
sqlConn.Open()

Thanks for the Quick replies!! I am new to .NET so I guess i need to keep reading... I replaced the absolute path with "localhost" and its working now. thanks again for the help! Dim connString As String = "server=localhost;Integrated Security=SSPI;initial catalog=AdventureWorks" — Dashsa
– Dashsa, Commented Sep 15, 2011 at 18:51

Oded · Accepted Answer · 2011-09-15 18:46:45Z

4

The server parameter looks mighty fishy to me.

If this is a SQL Server instance, you are trying to connect to the data file, not the database. It should be the network name of the computer that SQL Server is installed on.

I suggest taking a look at connectionstrings.com to see how it should look like.

answered Sep 15, 2011 at 18:46

Oded

501k102 gold badges900 silver badges1k bronze badges

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

Comments

C0L.PAN1C · Accepted Answer · 2011-09-15 18:46:08Z

2

Server has to be a server name. If it's on the same box do localhost in lieu of that long funky path.

answered Sep 15, 2011 at 18:46

C0L.PAN1C

12.3k4 gold badges52 silver badges70 bronze badges

Collectives™ on Stack Overflow

ASP.NET connection to local DB not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related