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

Adding Login User

I have created a database and user X can login with no problems. When i attempt to login with user Y it wont allow me. Is there a setting in 2008 SQl to add or allow a user to access the database? I found way to create login for 2005 but 2008 might have different setings.

Thanks,
ep
0
Epic7
Asked:
Epic7
  • 2
1 Solution
 
ZberteocCommented:
First you have to create the login by expanding server node > Security and right click on Logins > New Login and give it a password or windows authentication. AFter that ou have to set up the user mapping. By doing this the login is also created in the database as a user and given permissions. This is done in the same window where you create the logins, in the left panel you select User Mapping and then in the right upper panel you check the databases you want to give the user access and in the lower right panel you check the permissions, db_owner for full permission or db_datareader for read only.
0
 
ZberteocCommented:
If the login exists you will have to select it from Security > Logins > right click on th elogin and then on Properties.
0
 
Epic7Author Commented:
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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