sql server does not exist or access denied. connectionopen connect

balakumarn

unread,

Oct 9, 2009, 12:40:22 AM10/9/09

to

Hai
Anybody help me

I installed sql server 2000 on a client machine in a domain. Then i access
the sql server using odbc i got an error like
'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."

please reply.

Rick Byham, MSFT

unread,

Oct 9, 2009, 11:55:13 AM10/9/09

to

This is a very general error that indicates the client can't find the
instance of SQL Server. Many things could cause it. The most common
problems:
A mistyped SQL Server name in the connection string.
SQL Server is not started on the server.
The SQL Server is not listening on named pipes or TCP. Use the Server
Network Utility to configure those.

And lots of Windows networking issues such as:
Unable to resolve the server name to an IP address. If using TCP, can you
ping?
The client name resolution has cached an old IP address. Execute ipconfig
/flushdns on the client.
A firewall on the server is blocking the connection.
--
Rick Byham, MSFT
(Implies no warranty or rights)

"balakumarn" <u55333@uwe> wrote in message news:9d514ce7e5d2e@uwe...

Balakumar N via SQLMonster.com

unread,

Oct 10, 2009, 12:33:33 AM10/10/09

to

Thanks Friend

I solve this issue using named pipes. But using TCP is not
working how can I solve this problem.

when i ping from another client machine is pining correctly
but I am try to configure odbc using the TCP get same error.('[DBNETLIB]

[ConnectionOpen (Connect()).]SQL Server does not exist or access

denied.")

Rick Byham, MSFT wrote:
>This is a very general error that indicates the client can't find the
>instance of SQL Server. Many things could cause it. The most common
>problems:
>A mistyped SQL Server name in the connection string.
>SQL Server is not started on the server.
>The SQL Server is not listening on named pipes or TCP. Use the Server
>Network Utility to configure those.
>
>And lots of Windows networking issues such as:
>Unable to resolve the server name to an IP address. If using TCP, can you
>ping?
>The client name resolution has cached an old IP address. Execute ipconfig
>/flushdns on the client.
>A firewall on the server is blocking the connection.

>> Hai
>> Anybody help me
>[quoted text clipped - 6 lines]
>>
>> please reply.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-connectivity/200910/1

Erland Sommarskog

unread,

Oct 10, 2009, 5:26:50 AM10/10/09

to

Balakumar N via SQLMonster.com (u55333@uwe) writes:
> I solve this issue using named pipes. But using TCP is not
> working how can I solve this problem.
>
> when i ping from another client machine is pining correctly
> but I am try to configure odbc using the TCP get same error.('[DBNETLIB]
> [ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.")

Take a look at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q328306

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx