• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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

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
0
Ihab
Asked:
Ihab
2 Solutions
 
lcohanDatabase AnalystCommented:
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.
0
 
David ToddSenior DBACommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now