Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-01-24 : 14:06:36
|
I seem to have some issues connecting to a SQL 2k pc that has multiple installs (3) of SQL 2k.Instance 1: DL00Instance 2: DL00/testinstanceInstance 3: DL00/devinstanceEach instance is its own installation on the same computer and the ODBC only sees the 1st instance which is also the computer name (DL00). I know for a fact that the odbc connection is seeing the computer because it says that it failed to login and if you try to odbc while the machine is off it gives a failed to find server error. Basicly the odbc connection seems to only see the original install of SQL Server 2k and I dont know how to point it to one of the other installs.This is not my setup and it is not a production db. I just need to connect to instance 2 Any help is greatly thanked.DanielSQL Server DBAEdited by - sqlserverdba_dan on 01/24/2002 14:33:30 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-24 : 14:31:56
|
| How are you trying to connect? In your post you use '/' but you should actually be using '\'.Not sure if that is your problem though.-Chad |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-01-24 : 14:40:02
|
quote:
How are you trying to connect? In your post you use '/' but you should actually be using '\'.Not sure if that is your problem though.-Chad
From the ODBC datasources in the control panel:I click ADDChoose SQL Server as the datasourceName: aDescription: aserver you want to connect to: DL00/testinstance Only DL00 comes up in the drop down list and the services for it arent even started so I type the /testinstance into the box for the server.I just dont know too much about this whole multiple instances of SQL on 1 computer...DanielSQL Server DBA |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-24 : 15:18:28
|
| Try:DL00\testinstanceThat should work.-Chad |
|
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-24 : 15:28:20
|
| If Chad's info didn't help try this Q article on microsoft.com: Q265808. I don't know what MDAC you're running or what type of O/S your trying to connect with so I'm starting from previous versions first.JamesH. |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-01-24 : 15:29:26
|
quote:
Try:DL00\testinstanceThat should work.-Chad
Looks like I found the problem. The drivers on the machine I was using were out of date. For some reason they still auto populated the Datasource drop down box even though it wouldnt work...I updated the drivers and now all 3 instances show up.ThanksDanielSQL Server DBA |
|
|
|
|
|
|
ODBC to SQL 2k on 1 pc that has multiple SQL 2k