MVC3 changing default connection string error

Question

I created an MVC3 Internet application and changed the default connection string to work with .\SQLSERVER instead of the default .\SQLEXPRESS and get following 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

I tried creating an empty MVC3 application as well, which has no connection string by default and added mine with the same result. The SQLSERVER instance is running and I can connect to it from management studio using windows authentication. Any connection string that I use gives same error, I cannot figure it out:

<connectionStrings>
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="data source=.\SQLSERVER;" providerName="System.Data.SqlClient" />
</connectionStrings>

Are you able to connect from SQL Management Studio?

Paweł Staniec
– Paweł Staniec

2011-12-22 16:07:31 +00:00
Commented Dec 22, 2011 at 16:07 — Paweł Staniec
– Paweł Staniec, Commented Dec 22, 2011 at 16:07
@torm, yes i can, with no problem at all.

mishap
– mishap

2011-12-22 16:09:58 +00:00
Commented Dec 22, 2011 at 16:09 — mishap
– mishap, Commented Dec 22, 2011 at 16:09
Were you able to resolve your problem ?

Paweł Staniec
– Paweł Staniec

2011-12-27 18:30:07 +00:00
Commented Dec 27, 2011 at 18:30 — Paweł Staniec
– Paweł Staniec, Commented Dec 27, 2011 at 18:30

score 1 · Accepted Answer · 2011-12-22 16:27:15Z

1

To connect to your local default instance (i.e. SQLSERVER service name), for Data Source=..., use one of the following:

127.0.0.1
localhost
(local)
.

EDIT

Your connection string should resemble this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

edited Dec 22, 2011 at 16:27

answered Dec 22, 2011 at 15:43

user596075

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

2 Comments

user596075 Over a year ago

@Chuchelo are you sure you have SQL Server installed and a default instance service started and listening?

user596075 Over a year ago

@Chuchelo see my edit, your connection string should resemble this. I notice in your original post/question it isn't full. Can you try that?

Darin Dimitrov · Accepted Answer · 2011-12-22 15:37:57Z

0

Checkout the different connection strings you can use with SQL Server. For example if you have a SQL Server installed on your local machine you could use the following connection string:

Data Source=127.0.0.1;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Obviously you will need to adjust the name of the database, the username and password to connect to.

If you want to use Windows Authentication to connect to the server:

Data Source=127.0.0.1;Initial Catalog=myDataBase;Integrated Security=SSPI;

answered Dec 22, 2011 at 15:37

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

1 Comment

mishap Over a year ago

tried all what you suggested and same error. It seems that I just cannot connect to the sql server and the problem is not in the type of connection or username or password. Maybe its due to Entity Framework ? Btw I'm running the project from VS without IIS application setup. I'm new to this, so not sure if it matters.

Milimetric · Accepted Answer · 2011-12-22 15:49:19Z

0

Your connection string needs to look something like this:

<add name="NameOfConnection" connectionString="Data Source=localhost;Initial Catalog=OMSCING;Trusted_Connection=Yes" providerName="System.Data.SqlClient" />

Where you can replace localhost with a hostname or leave it like that if the server's local.

answered Dec 22, 2011 at 15:49

Milimetric

13.5k4 gold badges49 silver badges57 bronze badges

2 Comments

mishap Over a year ago

still same issue, probably the issue is not with connection string, but I just cannot figure out where.

Milimetric Over a year ago

connecting locally would mean you have all the configuration done correctly... what about connecting remotely? Try opening port 1433 and connecting from another computer.

mishap · Accepted Answer · 2011-12-23 18:07:06Z

0

Perhaps I had to mention that I was using EF with code first approach, but the problems was due to the name of the connection string which should be the same name as your Context which you derive from DbContext, e.g.:

<connectionStrings>
<remove name="ApplicationServices"/> 

<add name="MyContext" 
     connectionString="data source=localhost; Initial Catalog=CoolCars;Integrated Security=True;" providerName="System.Data.SqlClient" />
</connectionStrings>

as well make sure you remove the default machine.config connection string which is for .\SQLEXPRESS

answered Dec 23, 2011 at 18:07

mishap

8,56514 gold badges63 silver badges93 bronze badges

Collectives™ on Stack Overflow

MVC3 changing default connection string error

4 Answers 4

2 Comments

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related