Thursday, March 8, 2012

cant register to server from client

When I register to SQL server 2000 on another machine, I
get message " SQL server doesn't exist or access is
denied. Connection open". The pinging of the two machines
is OK. And I checked the protocols of both machines were
the same. Tell me how to rectify this problem. ThanksAre you trying to register by IP or by Name? There is an entry for the
server in the Client Configuration Utility? There is an entry for the server
in the DNS or in your hosts file?
regards,
Srgio Monteiro - Brasil
www.sqlpass.org
"Lie" <anonymous@.discussions.microsoft.com> escreveu na mensagem
news:378201c3dcc8$bbe0d5f0$3101280a@.phx.gbl...
quote:

> When I register to SQL server 2000 on another machine, I
> get message " SQL server doesn't exist or access is
> denied. Connection open". The pinging of the two machines
> is OK. And I checked the protocols of both machines were
> the same. Tell me how to rectify this problem. Thanks
|||You need to retrieve the actual OS error to troubleshoot this problem.
Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.
Example:
ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@.@.version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment