Lunarpages Web Hosting Forum

Author Topic: MSSQL-Give one user rights to two DBs  (Read 1840 times)

Offline bhan

  • Newbie
  • *
  • Posts: 1
MSSQL-Give one user rights to two DBs
« on: October 09, 2007, 01:55:25 PM »
I'm trying to set up a second MS SQL database and I want to use the same user account to access both DBs, but when I try to add the user to the second DB it says the user already exists. Is there a way around this problem, or am I stuck using a unique account for every database I set up?