Suddenly can not establish connection with
From: michi (wwwmike_at_gmx.ch)
Date: 10/19/04
- Next message: Ton: "Getting full security log"
- Previous message: Charles: "When should add "Network Library = dbnetlib/dbmssocn" in connection string"
- Messages sorted by: [ date ] [ thread ]
Date: 18 Oct 2004 22:59:11 -0700
Hello there
Since yesterday on my local server I could not establish any
connection to my sqlserver 2000 with my asp.net code. I have about 10
sites running over 1 year. But today out of a sudded the connection
string failed today.
This is the code I am always using
*************
'Open DB Connection
Dim cnn As New SqlConnection
cnn = New SqlConnection("Server=localhost;Database=myDB;UID=myUID;PWD=myPW;")
cnn.open '<-- error happens here
*************
***Error Message (German Version)*************
System.Data.SqlClient.SqlException: SQL Server ist nicht vorhanden,
oder der Zugriff wurde verweigert.
Some facts)
English Translation: SQL Server not available or connection denied.
*****************
Some facts
1) I can compile without error.
2) The code runs perfectly the server hosted at www.easerve.com, only
my localhost makes problem
3)If I use this new connection string, it works again on my localhost
4) When I am using this code then everthing works fine again
workstation id=SQUADRON;packet size=4096;user id=myUSER;data
source=SQUADRON;persist security info=True;initial
catalog=myDB;password=myPassword
6) I installed Windows XP SP2 one week ago
7) I did not play around with any db,directory or any security
settings
Why does my old code not work anymore.
Thanks for helping
Michael :)
- Next message: Ton: "Getting full security log"
- Previous message: Charles: "When should add "Network Library = dbnetlib/dbmssocn" in connection string"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
