SQL服务器连接问题 [英] SQL server connection problem
问题描述
刚刚安装了SQL Server 2000并使用我的客户端，我无法找到服务器上的
。我使用SQL查询分析器进行搜索，但没有找到服务器
。错误信息如下
服务器：Msg17，级别16，state1
[微软] [ODBC SQL服务器驱动程序] [DBnetlib] SQL服务器不存在
或拒绝访问。
问候
Daniel
just installed SQL server 2000 and using my client , i can''t locate
the server. I used SQL query analyzer to search but no servers were
found. Error message is as below
Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist
or denied access.
Regards
Daniel
推荐答案
Am 13 Nov 2005 08:14:32 -0800 schrieb Da ********* @ gmail.com ：
Am 13 Nov 2005 08:14:32 -0800 schrieb Da*********@gmail.com:
刚刚安装了SQL Server 2000并使用我的客户端，我无法找到服务器。我使用SQL查询分析器进行搜索，但没有找到服务器。错误信息如下
服务器：Msg17，级别16，state1
[Microsoft] [ODBC SQL服务器驱动程序] [DBnetlib] SQL服务器不存在
或拒绝访问。
问候
Daniel
just installed SQL server 2000 and using my client , i can''t locate
the server. I used SQL query analyzer to search but no servers were
found. Error message is as below
Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist
or denied access.
Regards
Daniel
检查服务器上的SQL-Server客户端配置，如果TCP是
已启用。如果您在安装SQL Server时没有指定它，那么出于安全原因，TCP将被禁用
！
您应该在程序列表中找到此工具，如果没有，请搜索
" SVRNETCN.exe" （应该在C：\ Program\Microsoft SQL
Server \\\\\\\\\\\\\\\\\\\\\\\\\\\ />
helmut
Check your SQL-Server client configuration on the server, if TCP is
enabled. If you did not specify it when installing SQL Server, then TCP is
disabled for security reasons!
You should find this tool in your program list, if not, search for
"SVRNETCN.exe" (should be in C:\Programs\Microsoft SQL
Server\80\Tools\Binn\)
bye,
helmut
（Da ********* @ gmail.com）写道：
(Da*********@gmail.com) writes:
刚刚安装SQL Server 2000并使用我的客户端，我无法找到服务器。我使用SQL查询分析器进行搜索，但没有找到服务器。错误信息如下
服务器：Msg17，级别16，state1
[Microsoft] [ODBC SQL服务器驱动程序] [DBnetlib] SQL服务器不存在
或拒绝访问。
just installed SQL server 2000 and using my client , i can''t locate
the server. I used SQL query analyzer to search but no servers were
found. Error message is as below
Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist
or denied access.
这意味着ODBC无法找到SQL Server。可能的原因有很多。
。最简单的是SQL Server没有运行。
由于其他可能的原因，请检查
http://support.microsoft.com/default...;EN-US;q328306 。
-
Erland Sommarskog，SQL Server MVP， es **** @ sommarskog.se
SQL Server 2005联机丛书
http://www.microsoft.com/technet/pro...ads/books.mspx
书籍在线获取SQL Server 2000
http：// www.microsoft.com/sql/prodinf...ons/books.mspx
Which means that ODBC cannot find the SQL Server. There are a number
of possible reasons. The most trivial is that SQL Server is not running.
For other possible reasons check
http://support.microsoft.com/default...;EN-US;q328306.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
您好，只想验证我是否可以登录SQL服务器来自
服务器本身。这是否意味着它真的是一个端口或协议问题
？我在家时会检查配置。谢谢
问候
Daniel
helmut woess写道：
Hi, just want to verify that I can login to the SQL server from the
server itself. So does it mean it is really a port or protocol problem
? I''ll check the configuration when i''m at home. Thanks
Regards
Daniel
helmut woess wrote:
Am 13 November 2005 08:14 ：32 -0800 schrieb Da*********@gmail.com ：
Am 13 Nov 2005 08:14:32 -0800 schrieb Da*********@gmail.com:
刚刚安装了SQL Server 2000并使用我的客户端，我无法找到服务器。我使用SQL查询分析器进行搜索，但没有找到服务器。错误信息如下
服务器：Msg17，级别16，state1
[Microsoft] [ODBC SQL服务器驱动程序] [DBnetlib] SQL服务器不存在
或拒绝访问。
问候
Daniel
just installed SQL server 2000 and using my client , i can''t locate
the server. I used SQL query analyzer to search but no servers were
found. Error message is as below
Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist
or denied access.
Regards
Daniel
如果启用了TCP，请检查服务器上的SQL-Server客户端配置。如果在安装SQL Server时没有指定它，则出于安全原因禁用TCP！
您应该在程序列表中找到此工具，如果没有，请搜索
SVRNETCN。 exe文件" （应该在C：\ Program\Microsoft SQL
Server \\\ Tools \ Binn \）
再见，
helmut
Check your SQL-Server client configuration on the server, if TCP is
enabled. If you did not specify it when installing SQL Server, then TCP is
disabled for security reasons!
You should find this tool in your program list, if not, search for
"SVRNETCN.exe" (should be in C:\Programs\Microsoft SQL
Server\80\Tools\Binn\)
bye,
helmut
这篇关于SQL服务器连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
