error occured while connecting sql server on the network

Question

0.00/5 (No votes)

See more:

I give the following coding

Public con As New SqlConnection("Data Source=192.170.1.90,1433;Network Library=dbmssocn;Initial Catalog=phoneix;User Id=sa;Password=welcome;Integrated Security=SSPI")

This error occured when I connecting sql server

A network related or instance error will occured
a connection attempt failed because the connected party did not properly respond or establishing hosted is failed

Please help me solve this problem

Posted 18-Jan-12 2:10am

devausha

Add a Solution

Comments

phil.o 18-Jan-12 9:51am

Problem could be on the SQL Server itself.
Lauch SQL Server configuration tool and check that TCP/IP is activated for the instance you're trying to connect to.
Check also that incoming connections on port 1433 are not firewalled.

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

Om Prakash Pant · Answer 1 · 2012-01-18T02:20:00

Solution 1

This means that your vb.net application cannot connect to the SQL server. check the connection string (IP, username etc.) & the SQL server is configured to accept remote connections over IP

Check the different options for connecting to sql server:

http://www.connectionstrings.com/sql-server-2005[^]

http://www.connectionstrings.com/sql-server-2008[^]

Posted 18-Jan-12 2:20am

Om Prakash Pant

Comments

devausha 18-Jan-12 8:24am

I try all the methods in the above Link,but it is not working

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2012-01-18T02:55:00

1. Go to 'C:\Windows\System32\drivers\etc'.
2. Open hosts with Notepad program.
3. Uncomment this line: '127.0.0.1 localhost' or add it if it's not on the host entry.

That's it! Save the changes you've made and refresh your browser.

Hope this helps!

* NOTE - Make sure you have a full access on 'hosts' file.

Right click on 'hosts' file then click 'Properties'.
On 'Security' tab click 'Edit..' button.
Select the user that you are currently using.
Under 'Permissions for Users' box, tick 'Full control' on 'Allow' column.
And then click 'OK' button to apply the changes.