SQL 2000 - Simple managing users question

cansib
cansib used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2008
Awarded 2008

Commented:
is it a domain user?

Author

Commented:
Yes, this is a domain user.  But this is SQL.  Thanks.
Awarded 2008
Awarded 2008

Commented:
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?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
So, do you do this in Active Directory or in SQL Enterprise Manager?  Thanks!
.Net Developer
Commented:
The user in a database is mapped to a SQL Server Login.  These can be, depending on your SQL Server security config, a Windows domain user that has been mapped to a SQL Login (Windows authentication) or a standard SQL Server Login (SQL Server authentication).  Either way if the user already exists in DB1 then they have a login.  In Enterprise Manager, look in "Security" and expend the Logins node.  Find your user and right click him/her then choose Properties.  In this box you will see a tab for "Database Access".  Here you can map the user to any database you want.
Awarded 2008
Awarded 2008
Commented:
SQL Enterprise manager...goto security, then add login.  

Author

Commented:
Great!  Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial