CODEWITHSUNDEEP
sql-serverasp.net-mvcvisual-studio-2010connection-string
Sithelo
Sithelo

Reputation: 307

How to fix the web.config connection string which always default to SQL Server Express

I am using VS 2010 and SQL Server 2008 R2. My challenge is how to fix the web.config which has default SQLEXPRESS.

My database is on SQL Server 2008 R2. I would like my connection string to point to SQL Server R2. This server is on my local machine however SQLEXPRESS was installed when I installed VS 2010.

Upvotes: 0

Views: 302

Answers (1)

Amiram Korach
Amiram Korach

Reputation: 13296

When you use SqlExpress your connection string looks like:

Data Source=.\SqlExpress

Replace it with:

Data Source=localhost

If your instance has a name (not the default instance, you need to define it in setup):

Data Source=localhost\instanceName

Upvotes: 1

Related Questions