Sql Connection String to named instance

Question

I can connect to my sql server 2008 developer server using this in a sample code project:

string connection = @"data source=.\SQLSERVER2008;Integrated Security=SSPI;Initial Catalog=RSINET.MVC";

When I try updating the web.config file like so, I get a sql exception:

 <add name="ApplicationServices" connectionString="data source=.\SQLSERVER2008;Integrated Security=SSPI;Initial Catalog=RSINET.MVC" providerName="System.Data.SqlClient"/>

The error that I get is this:

Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

I am using the .NET provider?

matt

Another good habit to get into when dealing with connection strings is to include the ApplicationName parameter. See johnnycoder.com/blog/2006/10/24/… — Stuart Ainsworth
– Stuart Ainsworth, Commented Oct 20, 2009 at 22:26

Aaron Bertrand · Accepted Answer · 2009-10-20 14:40:34Z

1

Did you try using LOCALHOST\SQLSERVER2008 or 127.0.0.1\SQLSERVER2008 or \SQLSERVER2008? Also why is there a period in your database name? You will likely have to escape that (or preferably get rid of it by changing the name)... even if it doesn't solve this issue, it will cause others if you leave it that way.

answered Oct 20, 2009 at 14:40

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

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

1 Comment

user154366 Over a year ago

It is for a named instance of SQL Server .\SQLSERVER2008 Osql -E -S .\SQLSERVER2008 - Named instance installed on my pc. Osql -E - default instance installed

Raj More · Accepted Answer · 2009-10-20 14:40:04Z

0

Configure your server for remote connections

http://support.microsoft.com/kb/914277

answered Oct 20, 2009 at 14:40

Raj More

48.2k34 gold badges139 silver badges199 bronze badges

1 Comment

Aaron Bertrand Over a year ago

Yes, an essential step obviously. Could also be the firewall, depending on where the web site is running from.

CervEd · Accepted Answer · 2022-04-28 16:13:16Z

0

Add the port (default 1433) to the connection string.

Ie: localhost\SQLSERVER2008,1433

answered Apr 28, 2022 at 16:13

CervEd

4,5101 gold badge39 silver badges35 bronze badges

Collectives™ on Stack Overflow

Sql Connection String to named instance

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related