|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 24th, 2004, 08:21 AM
|
|||
|
|||
|
Connect to 2 DBs on Same Server w/t Different Details
Hi,
I have two databases on a remote server. To access them I need two seperate sets of details so as soon as I regsiter one SQL server, when I try to regsiter another (Enterprise Manager) I get an error saying that one under this name has already been registered. Anyway around this at all? Many thanks, Janusz
|
|
#2
March 25th, 2004, 02:58 AM
|
||||
|
||||
|
if they are on the same instance of sql server 2000, you should be able to access all databases (or at least see them depending on permissions) on that instanse of sql server through the database folder
only one registration is needed to communicate with one server (being a software instance of sql server), only if you have 2 (software) instantses on 1 physical machinen then you need 2 registrations (altough i would recommend to avoid that at much as possible)
|
|
#3
March 27th, 2004, 12:01 AM
|
|||
|
|||
|
Use the Client Network Utility to create one or more aliases to your server. You can then make more than one registration to the same server in EM.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Connect to 2 DBs on Same Server w/t Different Details |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
