dec789
asked on
How to add a new user to a Data base with out going through the "New User" window?
Is there a way to add a user to a SQL server data base without going through the Enterprise Manager's New User window? Can I some how do this in "code" or a "stored procedure"? I'm very new with SQL Server as you can probably tell from my question.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Guy Hengel [angelIII / a3]
http://msdn.microsoft.com/en-us/library/ms173463.aspx
hmmm...just noticed that you posted zone 2005, but 2000 as a tag...which one is it?
Also, for best practices, you should use the create user statement if it is 2005, but sp_adduser will work with both.
Also, for best practices, you should use the create user statement if it is 2005, but sp_adduser will work with both.
ASKER
I'm sorry chapmandew, Where exactly do I enter this code? In the Query Analyzer?
ASKER
I'm using SQL Server 2000 but there was no option for that when I submitted the question.
in a new query editor window in query analyzer....make sure it is in the database context that you want to create the user...you have to already have a login created to map the user to. logins are associated w/ logins into the instance, users are associated w/ the database.
ASKER
AngelIII this reference is to SQL Server 2005 Books Online (September 2007).
Do you think it also works with SQL Server 2000? Which is what I'm using.
Do you think it also works with SQL Server 2000? Which is what I'm using.
Nope, create user is for 2005 only.
no. for sql 2000, you will indeed need the syntax suggested by chapmandev
ASKER
Thank you so much chapmandew. sorry the version I'm using is so out ot date the we will be moving to SQL Server 2005 shortly. The company I work for is slow adapt new technologies.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
