Connectionstring doesn't work.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I have made an application on my own computer, and at the time of creation there were no problems at all.

I runned this connection string on my local computer, and it worked perfectly.

private SqlConnection connection = new SqlConnection("Data Source=LT004512\\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=SSPI;");

However, when i edited the connection string to the following (becouse it had to run on an other computer), my program didn't start.

private SqlConnection connection = new SqlConnection("Data Source=VG-VJGZTEST\\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=SSPI;");

No big deal i thought at first, but it also didn't work at the cliënt server.

For some reason, it only worked at the local host, and it looks like it can't get a connection.

Does anyone know what steps i have to take to counter this problem.

Posted 6-Apr-11 0:47am

Amateurgrammer

Add a Solution

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amund Gjersøe · Answer 1 · 2011-04-06T01:23:00

Solution 4

I'm guessing you haven't enabled TCP/IP in SQL Server Network Configuration on the server.

SQL Server Network Configuration is found using Microsoft SQL Server 2008 -> Configuration Tools -> Sql Server Configuration Manager

Posted 6-Apr-11 1:23am

Amund Gjersøe

Updated 6-Apr-11 1:25am

v2

Comments

Kim Togo 6-Apr-11 9:52am

I think you are right. See my answer.

Prasad_Kulkarni · Answer 2 · 2011-04-06T00:57:00

Solution 2

hey mate,
as u said it should work properly..
may be the problem is in other computer's database..
check it once again properly..
it will definately work..
if it work'd properly on your local computer..
there should be some manual error..

Posted 6-Apr-11 0:57am

Prasad_Kulkarni

Updated 6-Apr-11 0:58am

v2

Abhinav S · Answer 3 · 2011-04-06T00:56:00

Solution 1

In your case, try using the IP address - that should work.

It is never a good idea to hard code the computer name / ip address in your datasource.
This should be configurable via a config file or something.
The reason is that you dont want to compile your code every time the database server changes.

Posted 6-Apr-11 0:56am

Abhinav S

Updated 6-Apr-11 0:58am

v2

kannan 2 · Answer 4 · 2011-04-06T00:58:00

Solution 3

hi try this
private SqlConnection connection = new SqlConnection(@"Data Source=VG-VJGZTEST\\SQLEXPRESS;Initial Catalog=databasename;Integrated Security=SSPI;");

Posted 6-Apr-11 0:58am

kannan 2

Updated 6-Apr-11 1:06am

v2

a1mimo · Answer 5 · 2011-04-06T02:35:00

Solution 5

look if you have enabled named pipes and TCP/IP in your sql server configuration manager or not

TCP/IP makes you able to connect using IP in your connection string

named pipes makes you able to connect using computer name in your connection string

I Hope I Helped
:)

Posted 6-Apr-11 2:35am

a1mimo

Kim Togo · Answer 6 · 2011-04-06T03:53:00

Solution 6

Try take a look at Enable Remote Connection on SQL Server 2008 Express[^] and see if this help.

Posted 6-Apr-11 3:53am

Kim Togo

Wendelius · Answer 7 · 2011-04-06T08:44:00

Solution 8

There are several possibilities for this starting from firewall problems, wrong IP port, disabled network protocols etc. Since you didn't mention the actual error you get, perhaps this list would help yo: http://msdn.microsoft.com/en-us/library/ms733742.aspx[^]

Posted 6-Apr-11 8:44am

Wendelius

Rojeh · Answer 8 · 2011-04-06T03:59:00

Solution 7

what is the operating system you are working on?

Posted 6-Apr-11 3:59am

Rojeh