Groups | Blog | Home
all groups > sql server clients > november 2003 >

sql server clients : [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not Exist or Access denied


anonymous NO[at]SPAM discussions.microsoft.com
11/4/2003 10:52:49 PM
Ladies and Gentlemen,
I am using a connection string like :

'Provider=SQLOLEDB.1;Password=password;Persist Security
Info=True;User ID=sa;Initial Catalog=DataDemo;Data
Source=SERVERNAME';Network Library=DBMSSOCN;Use Procedure
for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=SERVERNAME;Use Encryption for
Data=False;Tag with column collation when possible=False'

And I am having the following error:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not
Exist or Access denied.

I am running SQL Server 2003, SP3 and my client is a
Delphi Application. MDAC 2.7 is installed on the client.
TCP/IP is used.

Any help?
Thanks.

Sue Hoegemeier
11/5/2003 9:19:01 AM
The error can be caused by a lot of different things. Try
the following troubleshooting article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306

-Sue

On Tue, 4 Nov 2003 22:52:49 -0800,
[quoted text, click to view]
AddThis Social Bookmark Button