I need to create SQl user admin in sql management studio 2005, Please advise

Ihab
Ihab used Ask the Experts™
on
I enter to logins
I create new login
I choose SQL server athentication
What is the default database I choose?
Mappings?
server role?
...
Please advise
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
Open SSMS
Connect to server as SYSADMIN
Create new login
Choose SQL server authentication
What is the default database I choose? - leave it master but does not really matter as sysadmin can access them all
Mappings? - see above
server role? - YES - choose SYSADMIN here.
David ToddSenior Database Administrator
Commented:
Hi,

For sysadmin and other privileged roles, I prefer to use tempdb as default database. That guards against junk getting into the master database.

Just the other day I ran a script in master that was meant for another database, and had to delete the stuff it created there.

HTH
  David

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