I've got three DB's on one server - all for different clients. I
usually switch back and forth all day long, and typing the username/pass
combos over and over was getting dull - they use good passwords :)
This is much easier!
-----Original Message-----
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 4:24 PM
To: CF-Talk
Subject: RE: SQL Enterprise Manager
Jeff,
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]
