cansib
asked on
SQL 2000 - Simple managing users question
I am not a SQL guy at all. Unfortunately, our DB Admin is on vacation for the next 2 weeks, but the show must go on. So I have a couple of different client software that connect to databases on one of our SQL servers. So, say I have DB1 and DB2. I have a user that's already using DB1, but not DB2. So I look under DB2 and see a spot to add a user. I add the user with the appropriate permissions, but there's no place to set the password. So I look under help and it says you go to Security and set the password. So, wouldn't that be the password that they are already using on DB1? So when I add the user to DB2, do they just use the same password they were using for DB1 or am I missing something here? Thanks!
Mark
Mark
chapmandew
is it a domain user?
ASKER
Yes, this is a domain user. But this is SQL. Thanks.
Right, so if it is a domain user, you don't need to enter any pwd information. You just select the user and add it to the system. You only need to enter pwd for SQL User accounts (under mixed authentication). Does that make sense?
ASKER
So, do you do this in Active Directory or in SQL Enterprise Manager? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great! Thanks!