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]

Reply via email to