473,850 Members | 2,117 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL server connection problem

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

Nov 23 '05 #1
17 9245
Am 13 Nov 2005 08:14:32 -0800 schrieb Da*********@gma il.com:
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


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.e xe" (should be in C:\Programs\Mic rosoft SQL
Server\80\Tools \Binn\)

bye,
helmut
Nov 23 '05 #2
(Da*********@gm ail.com) writes:
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.


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****@sommarsk og.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
Nov 23 '05 #3
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 Nov 2005 08:14:32 -0800 schrieb Da*********@gma il.com:
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


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.e xe" (should be in C:\Programs\Mic rosoft SQL
Server\80\Tools \Binn\)

bye,
helmut


Nov 23 '05 #4
Hi, does ODBC indicates database driver or protocol issue from your
knowledges ? Thanks

Regards
Daniel

Nov 23 '05 #5
(Da*********@gm ail.com) writes:
Hi, does ODBC indicates database driver or protocol issue from your
knowledges ? Thanks


As I said, the message means that the SQL Server could not be found. Which
could be because it is not running, because it does not listening on
the protocol you are trying to use etc. Please refer to the KB article
I gave you a link to.

If you cannot work it out, you will need to provide more details, as
connection problems can have so many reasons, that it's not meaningful
to give a guess without access to the environment.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.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
Nov 23 '05 #6
Hi, i managed to make it connected by specifying alias in the server.
I'm not sure why ? but after connected i still can't login , another
error came out

Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][TCP/IP sockets] SQL server
does not exist or denied access.
Regards
Daniel

Nov 23 '05 #7
(Da*********@gm ail.com) writes:
Hi, i managed to make it connected by specifying alias in the server.
I'm not sure why ? but after connected i still can't login , another
error came out

Server : Msg17,level 16, state1
[Microsoft][ODBC SQL server driver][TCP/IP sockets] SQL server
does not exist or denied access.


That's the same message as in you original post, save for the last
bracket. You still fail connect.

For further assistance, please anser these questions:

Have you verified that SQL Server is running?

Is SQL Server on the same machine you try to connect from?

Which protocols are SQL Server configured for? (You can view this
in the Server Network Utility).

If you changed which protocols SQL Servers uses, did you restart SQL Server
after this?

Is there a firewall on the SQL Server machine?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.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
Nov 23 '05 #8
Yes I've check in my server the SQL service is running. No i tried to
connect from another machine. Server is Win2003 standard server and
client is Win2000 prof. Both netlib uses TCP/IP and port 1433. I
configure both named pipe to be the same. Each can ping each other
either by IP or host name. I never change any protocol, uses the
default TCP/IP. As far as i know there is no firewall between them,
unless there is the windows internal firewall security ? is it
possible? . Btw what is alias for ? by using alias i can find the
server host name but not IP . Thanks

Regards
Daniel

Nov 23 '05 #9
(Da*********@gm ail.com) writes:
Yes I've check in my server the SQL service is running. No i tried to
connect from another machine. Server is Win2003 standard server and
client is Win2000 prof. Both netlib uses TCP/IP and port 1433. I
configure both named pipe to be the same. Each can ping each other
either by IP or host name. I never change any protocol, uses the
default TCP/IP. As far as i know there is no firewall between them,
unless there is the windows internal firewall security ? is it
possible? .
I Windows Firewall is running on the machine with SQL Server, you will need
to configure the firewall to permit connections to SQL Server.
Btw what is alias for ? by using alias i can find the
server host name but not IP . Thanks


Aliases are good when connection by name does not work, and you don't want
to use IP-address and port number all the time.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.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
Nov 23 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
2040
by: Fortepianissimo | last post by:
Here is the situation: I want my server started up upon connection. When the first connection comes in, the server is not running. The client realizes the fact, and then starts up the server and tries to connect again. This of course all happens on the same machine (local connection only). The connections can come in as fast as 30+/sec, so the server is threaded (using SocketServer.ThreadingTCPServer). Further, the server initialization...
4
1701
by: Frodo | last post by:
I have a problem establishing a link between Visual Studio.NET 2003 and SQL Server 2000. Both are installed on a Windows Server 2003, standard version. Visual Studio.NET Issues =================== From Visual Studio.NET 2003 I attempt to ‘Connect to a database’ The ‘Data Link Properties’ dialog box appears.
12
1314
by: RKay | last post by:
I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string to test if a connection can be made to the local server. I can call that web service from any box on my network, and with the correct connection string, I can establish a connection to the database. However, when I copy the exact same service...
0
3929
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2 development client. Bur Its gives me following error message. I searched lots of things on net and tried on remote server but i didnt got suceess. Can any one tell me how to set TCP\IP connection protocol on server for particular instance. Becuase I think
3
2021
by: Vinod R.Shenoy | last post by:
Hi All, Came across a post wherin you had helped somebody with a similar problem and was wondering if you could help us out with it. Our problem is , We have a development SQL Server 2000 (running on Win2K SP4) machine that we want to run on a Windows 2003 server machine and access it via our internal LAN. We have opened the firewall to allow our applications
0
8849
by: Kris Mattheus | last post by:
A little background: I've been using web services successfully for a while now. My web server is a Windows CE 4.2 device and my client is a windows C# application created with Visual Studio 2003. My web server has both NTLM and Basic authentication. By providing the Credentials for my web service call, my application can access the web service without any problems. The problem: I recently created a new application with Visual Studio...
12
2270
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my office. The original code's backend is using the SQL Server 2000 and I am testing to use it on the Express edition. And I run into the following problem.
1
5133
by: sherifbk | last post by:
Problem description ============== - I have 4 clients and 1 server (SQL server) - 3 clients are Monitoring console 1 client is operation console - Monitoring console collects some data from the control unit and store them into the Sql server - The operation console then retrieve this data from the sql for reporting and statistics purposes - I am using ODBC connection - The problem is that the operation console is not able to...
39
5889
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;
5
6330
by: marshmallowww | last post by:
I have an Access 2000 mde application which uses ADO and pass through queries to communicate with SQL Server 7, 2000 or 2005. Some of my customers, especially those with SQL Server 2005, have had pass-through queries fail due to intermittent connection failures. I can easily restablish a connection for ADO. My problem is with pass-through queries.
0
9741
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11011
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10666
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10351
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5735
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5929
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4546
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4140
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.