Unable to connect To the SQL server using the given connection String (using C# windows Application)

Question

I am helping my friend in his college final year project, Its an C# application in a client machine and it uses SQL server in the windows server 2008 environment.

VM ware environment:

3 clients(windows 7) and 1 SQL database (in windows 2008)

The connection between he server and the client is working, the port 1433 for SQL is open and its listening.

When I try to run the program am getting the following error.

Error Message when i run the SQL code in the application on button-click

This is the connection string which am using.

cn = new SqlConnection(@"Data Source=192.168.1.2,1433;Initial Catalog=Test;Integrated Security=True");

And i have also tried to refer this website for connection strings, but i don't know how it works.

http://www.connectionstrings.com/sql-server-2008

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN; Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

I am getting an error. Tried to give a simple username and password in the SQL server and tried it, still the same issue. please check the image. The Username and password which i used is the System login(windows authentication)

Error message when i use the username and password

I just want to access the SQL server in the Windows 2008 machine.

Where should i check the credentials for this connection string ?

Thank you soo much for reading this patiently.

blog.sqlauthority.com/2009/05/21/… .....it's a fairly common problem with tons of not only Google results but also SO results. — Arran
– Arran, Commented Sep 12, 2013 at 9:40

Rajesh Subramanian · Accepted Answer · 2013-09-12 09:48:25Z

1

You can go to Connectionstrings.com to get more information on connection strings and its usages.

answered Sep 12, 2013 at 9:48

Rajesh Subramanian

6,4855 gold badges33 silver badges42 bronze badges

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

1 Comment

Geeky Bird Over a year ago

Thannkzz Rajesh, i did it successfully :), well good news is this project got 1st Grade.

Plymouth223 · Accepted Answer · 2013-09-12 09:43:26Z

0

Try removing the port from your connection string (1433 is the default SQL port):

cn = new SqlConnection(@"Data Source=192.168.1.2;Initial Catalog=Test;Integrated Security=True");

For a connection using sql authentication (which would eliminate trust issues between machines) use the following (replacing xxxx and yyyy with the appropriate user name and password):

cn = new SqlConnection(@"Data Source=192.168.1.2;Initial Catalog=Test;Integrated Security=False; User=xxxx; Password=yyyy");

answered Sep 12, 2013 at 9:43

Plymouth223

1,9351 gold badge12 silver badges22 bronze badges

1 Comment

Geeky Bird Over a year ago

Thannkzz Plymouth223, i did it successfully :), well good news is this project got 1st Grade.

Collectives™ on Stack Overflow

Unable to connect To the SQL server using the given connection String (using C# windows Application)

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related