Problem to connect network sqlserver

Question

0.00/5 (No votes)

See more:

I am already asked this question, but still now i cannot connected to network sql server

I give the following coding and check it. But it is not connected

VB

' Public con As New SqlConnection("Data Source=SQLSERVER\SQLEXPRESS;Initial Catalog=phoneix;Integrated Security=True")
   'Public con As New SqlConnection("Server=SQLSERVER\\SQLEXPRESS,10000;SSPI=True;Initial Catalog=phoneix;User Id=sa;Password=welcome")
   'Public con As New SqlConnection("Integrated Security=SSPI;Initial Catalog=phoneix;Data Source=SQLSERVER\SQLPRESS;User Id=sa;Password=welcome")
   Public con As New SqlConnection("Data Source=192.170.1.53,1433;Network=TCP/IP;Initial Catalog=phoneix;Integrated Security=SSPI;user Id=sa;Password=welcome")
   ' Public con As New SqlConnection("Data Source=192.170.1.53,1433;Network=TCP/IP;Initial Catalog=phoneix;User Id=sa;Password=welcome;Trusted Connection=False")

And i have check the server is on the remote connections.
But the server is not connected. The following error will occured,
The type initializer for 'WindowsApplication1.Module1' threw an exception.

Is there any change made to sql server,Please anybody have solution for this help me
Please help anybody help for this problem

Thanks in advance

Posted 6-Jan-12 23:29pm

devausha

Updated 6-Jan-12 23:41pm

v4

Add a Solution

Comments

Simon_Whale 7-Jan-12 19:15pm

Can you connect to the database from SQL Server management studio?

4 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)

uspatel · Answer 1 · 2012-01-07T00:00:00

Solution 3

Try these steps and see if any error message occurs
open visual studio
->Server explorer
->Add connection
->new connection
->change to sql server
->Provide server name 92.170.1.53
->Test connection and see if any error occurs share that error

else

after successfull connection
right click on server explorere database connection ->properties

see Connection String
copy it and use.......

hope it will helps.

Posted 7-Jan-12 0:00am

uspatel

Comments

Sridhar Patnayak 7-Jan-12 6:03am

Good solution - 5

uspatel 7-Jan-12 6:13am

thanks......

devausha 7-Jan-12 7:03am

I have tried but it is not connected

Please reply what can i do

Sridhar Patnayak · Answer 2 · 2012-01-06T23:33:00

Solution 1

Dear devausha,

Check your connection string with
http://www.connectionstrings.com/sql-server-2005[^]

Thanks

Posted 6-Jan-12 23:33pm

Sridhar Patnayak

Comments

devausha 7-Jan-12 5:48am

I checked all of the connection string but it is not working

Mehdi Gholam · Answer 3 · 2012-01-06T23:47:00

Solution 2

Your connect string should be :

VB

Public con As New SqlConnection("Data Source=192.170.1.53;Initial Catalog=phoneix;Integrated Security=SSPI;")

Posted 6-Jan-12 23:47pm

Mehdi Gholam

Member 11885857 · Answer 4 · 2015-08-04T09:50:00

Solution 4

Public con As SqlConnection = New SqlConnection("Data Source=192.168.174.128,1433;Network Library=DBMSSOCN;Initial Catalog=mydatabase;User ID=sa;Password=************;")

Posted 4-Aug-15 9:50am

Member 11885857

Comments

Nelek 4-Aug-15 17:13pm

3 years late :)