February 6, 2008 at 7:32 am
Hi,
I am a relatively new SQL Server newbie, although I have used SQL database driven applications for some time.
I have created a database on my server. I now want to allow different users to log in either locally or remotely using a username and password. How do I create a new user and give him a password? Can't seem to figure it out!
Thanks:)
February 6, 2008 at 8:11 am
You need to create a login on the SQL Server instance, meaning go to the security tab in SSMS and then logins. Grant access to Windows accounts or set up names/passwords.
You then need to create a user in the database that maps to that login. You would also need to assign rights, though typically you should assign rights to a role and assign users to that role.
February 6, 2008 at 8:52 am
I have Microsoft SQL Server Management Studio Express but cannot see the security tab anywhere...
(edit) I found the Security tab in Server>Properties but there is no place for a new user to go in. Only bit about logins is Login Auditing
February 6, 2008 at 9:25 am
Open up Object explorer (F8 if it's not already open). Expand the server name, and under databases, should be the word "security". Expand that and you should see "logins": right-click on that, and pick new login....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 6, 2008 at 9:26 am
Hi,
Sorry I seen that just there. I have somehow managed to create a new user, but cannot work out how to give that user a password?
February 6, 2008 at 9:33 am
If it's a windows user - you can't set a password. Windows users use Windows authentication, so SQL doesn't get involved with passwords. If you need to set a password, then you need to set them up as a SQL user, which means you need to make sure the server is running in "mixed mode authentication".
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply