December 13, 2007 at 8:55 pm
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
December 13, 2007 at 11:00 pm
two questions first.
Did you add the mssql server instance to active directory?
Does it work if you choose the other instance?
December 13, 2007 at 11:07 pm
Hi
is the sql instance (either of the two) that u want to connect to up and running.
"Keep Trying"
December 17, 2007 at 1:05 am
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
December 17, 2007 at 8:34 am
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)
December 18, 2007 at 3:40 pm
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
December 18, 2007 at 7:30 pm
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.
January 31, 2008 at 7:31 pm
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...
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply