SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


odbc connection has two instance of the same server, trying to get rid of one


odbc connection has two instance of the same server, trying to get rid of one

Author
Message
newbie-578801
newbie-578801
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
Attachments
error.jpg (21 views, 23.00 KB)
JDixon-385826
JDixon-385826
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 Visits: 209
two questions first.

Did you add the mssql server instance to active directory?

Does it work if you choose the other instance?
ChiragNS
ChiragNS
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3355 Visits: 1865
Hi

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

"Keep Trying"
newbie-578801
newbie-578801
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
JDixon-385826
JDixon-385826
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 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)
newbie-578801
newbie-578801
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
Attachments
odbc.jpg (32 views, 74.00 KB)
JDixon-385826
JDixon-385826
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 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.
Coyote Blue
Coyote Blue
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 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...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search