[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

server: msg 17, level 16, state 1

Posted on 2006-04-15
12
Medium Priority
?
1,816 Views
Last Modified: 2008-02-01
I have installed two instance of sql in win2k3 system. I can connected to both instance from query analyser from the sql server ( local system ) but i can connected only to the first instance ( default ) from a client machine through lan. when i try to connect to second instance from client machine i get  this error

Unable to connect to server URANUS\TEST_INSTANCE_2:

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.

Can any body pls guide me what has to be done to resolve this issue.

Regards

Toney
0
Comment
Question by:Toneys
  • 6
  • 6
12 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 16459665
On your server
=========
Computer Management ---> Services And Application --> Sql Server Configuration Manager---> URANUS\TEST_INSTANCE_2 --> Network Configuration -- > enable TCPIP

On your Client
=========
Create new Odbc and check inside network configuration check TCPIp
0
 

Author Comment

by:Toneys
ID: 16459846
tcpip is enabled for URANUS\TEST_INSTANCE_2 but still i cannot connect to URANUS\TEST_INSTANCE_2. I enabled named pipe and tried to connect to URANUS\TEST_INSTANCE_2. with named pipe it is working but its not working with tcpip how to resolve this problem.
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16459991
At the server site check
===============
Computer Management ---> Services And Application --> Sql Server Configuration Manager---> URANUS\TEST_INSTANCE_2 -->Sql Client Configuration -- > double click TCPIP  and then check the default port





At your client machine for testing
=======================

Control Panel --->Administrative Tools--->Data Source-->Add -->Sql Server

specify server name then next in client configuration network library select TCP/IP Uncheck dynamically determine port and specify the port you have at the server site.then see if it is connecting

try the same with check and see if it is connecting
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:Toneys
ID: 16460097
I tried it but i am getting this errors

Connection failed
SQLState: ‘01000’
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]ConnectionOpen 9Connect()).
Connection failed:
SQLState: ‘08001’
SQLState Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]SQL Server does not esist or access denied
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16460145
it could FIREWALL:
i think check what is the default port for you second instance may be it is blocked by the firewall at the client machine.
0
 

Author Comment

by:Toneys
ID: 16460285
i tried interchanging the port no for default and second instance ( uranus port no 1433 was changed to 65000 and uranus/test_instance_2 was changed 65000 to 1433 ) but still i am getting the same error.
0
 

Author Comment

by:Toneys
ID: 16460297
firewall is not enabled on my system.
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16460379
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 16460389
in the above link they say
=================
You may not be able to connect to an instance of SQL Server 2000 Service Pack 2 or earlier that is installed on a Windows Server 2003 computer through the TCP/IP port


so you should have SQL Server 2000 Service Pack 3 or higher.
0
 

Author Comment

by:Toneys
ID: 16460419
i have installed sql server 2000 with sp3
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 16460429
what happend then does it work?
0
 

Author Comment

by:Toneys
ID: 16460482
Thanks imran now i am able to connect to both instances using tcp/ip. the problem i think was while installing sql sp3 my colleque didn't notice that the default option has been checked. later i installed the mssql sp3 and unchecked the default option and selected the new instance name ( test_instance_2 )
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question