Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

odbc connection has two instance of the same server, trying to get rid of one Expand / Collapse
Author
Message
Posted Thursday, December 13, 2007 8:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 18, 2007 10:20 PM
Points: 3, Visits: 12
I am trying to create a odbc connection from my pc to a sql server eg. SVR16, but when i check drop down list to select the server i see to profiles, svr16 and SVR16.

When i select one to complete creating the connection, it give me the following error

connection fail
sql state: 01000
sql error: 10061
[ODBC Sql Driver][tcp/ip sockets]ConnectOpen(Connect())
Connection fail
sql state: 08001
sql error: 17
[ODBC Sql Driver][tcp/ip sockets]Sql server does not exist or access denied)


How can i get rid of the the one instance and have only one....please help


  Post Attachments 
error.jpg (4 views, 23.38 KB)
Post #433136
Posted Thursday, December 13, 2007 11:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
two questions first.

Did you add the mssql server instance to active directory?

Does it work if you choose the other instance?
Post #433159
Posted Thursday, December 13, 2007 11:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 1, 2014 6:55 AM
Points: 2,366, Visits: 1,845
Hi

is the sql instance (either of the two) that u want to connect to up and running.



"Keep Trying"
Post #433162
Posted Monday, December 17, 2007 1:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 18, 2007 10:20 PM
Points: 3, Visits: 12
what actually happened is this. i had tried to create a odbc connection to this server (SVR16), with the descriptive name svr16.

then i removed it, and then when i tried to create again under data sources (odbc) administrative tools, and i see the other svr16 (lower case)

when i select either of them when trying to create a connection both of them don't work
Post #433794
Posted Monday, December 17, 2007 8:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
makes sense. The list is showing you what you have typed in not what is avaliable. Run CMD PING [server name], assuming the server name and the instance name are the same. Then try using the IP address that you will get from pinging to try to connect. Else you can try to add the server name in the HOST file but lets see if the IP address works first.

Also Can you open this instance of SQL Server using ISQL (QA)? (Using the same login and server source if possible)

Post #433905
Posted Tuesday, December 18, 2007 3:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 18, 2007 10:20 PM
Points: 3, Visits: 12
i though i should include this picture to give a good view of the problem. you will see that under the list of sql servers, it lists spb-svr16 twice. The one in lower case is not actually the server name but the name used to refer to the data source when i had created the odbc connection earlier. i am trying to remove the one in lower case so that i can have only one spb-svr16, which i believe will solve my problem. attached is the picture.

thanks again


  Post Attachments 
odbc.jpg (12 views, 74.30 KB)
Post #434574
Posted Tuesday, December 18, 2007 7:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
Case does not matter when picking the server. Try it with the IP address instead of the server name to verify it works. Also As I stated before can you connect in QA?

The list that the ODBC connection setup has does not mean that it is forsure the MSSQL Instance name. In other words my server name may be Server1 and the MSSQL Instance name be SQLServer\inst1. This type of ODBC connection with a named instance also will only work if it is listed in DNS so it can resolve. Also MSSQL Server must be configured to allow named pipes.

Does this make sense? Please verify that you can connect with QA and also please try to use the IP address to verify that you are at least hitting the SQL Server instance.

Then let us know the result.
Post #434604
Posted Thursday, January 31, 2008 7:31 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 8, 2009 6:13 PM
Points: 134, Visits: 44
Dunno if this is resolved yet but...
Is this mssql2005 or mssql2000?
I am guessing this db is hosted remote;;; and there is some configurations you have to go through in mssql2005 (Surface Configuration; Aliases, etc) to allow remote connections. You may want to check that. Also, as a test, try setting up an odbc on the server that is hosting the DB. Use localhost.

What port are you trying to connect over? In the ODBC if you click the 'Client Connections' tab; HOW is it trying to connect? TCP/Ip; Named Pipes, Both... ?

Just some things that have tripped me up as I learn...
Post #450274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse