just a note - remember that even if you use different usernames that point to different default dbs, EM will still
display the whole browselist of databases - even ones NOT authorized for that username - so if you are trying to
streamline the length of the sidebar - it may not give you the result you desire.
-Mark
-----Original Message-----
From: Jeff Beer [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 2:58 PM
To: CF-Talk
Subject: RE: SQL Enterprise Manager
That is sooo sweet! Thanks - I was thinking that only aliased the
server, and wouldn't allow multiple definitions to the same IP. Life is
now much easier :-)
-----Original Message-----
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 3:08 PM
To: CF-Talk
Subject: RE: SQL Enterprise Manager
Use the Client Network Utility to create aliases for each connection.
HTH,
Scott
-----Original Message-----
From: Jeff Beer [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 3:06 PM
To: CF-Talk
Subject: OT: SQL Enterprise Manager
Sorry for the OT post - I'm stumped.
Using Enterprise Manager for MS SQL Server 2k, how can I register a
server twice so I can use different DBs with different login
credentials? It's a major pain having to disconnect and reconnect,
using different credentials, over and over and over throughout the day.
I have logins to the individual databases - no blanket access to the
machine.
TIA,
Jeff
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
