Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-02-26
2
Medium Priority
?
377 Views
Last Modified: 2014-03-02
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
Comment
Question by:Ihab
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 750 total points
ID: 39890128
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
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 750 total points
ID: 39896927
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question