Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Db connection problems

Status
Not open for further replies.

qwert231

Programmer
Sep 4, 2001
756
US
I get this message (pretty self explainatory):
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

When trying to connect to a DB with this code:
Code:
Dim objConn As New SqlConnection("Password=******;User ID=******;Initial Catalog=DP2;Data Source=Dell2400")
objConn.Open()
' This is where I get the error.

I know this connection string works from the sever (in a DMZ) to the SQL server because I tested it in a UDL file. What could be wrong? (Especially since I am not relying on ASP.Nets user account but a working SQL account?)

 
instead of "Data Source=Dell2400", try using the IP of the machine, i.e. "Data Source=127.0.0.1"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top