Type of User Login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Type of User Login

Author

Topic

luka
Starting Member

8 Posts

Posted - 2015-03-09 : 23:59:29

Hello, i do not have much experience in SQL administration and would need some help from you members of this forum. I am studying SQL administration and do not know what type of user login i should use for the following scenario. Here it is.

"I use a contained database named Invoice database within a domain.I need to create a user who can log on to the Invoice database.I also need to ensure that i can port the database to different database servers within domain without additional user account configuration.What type of user should i create? Here are available answers.

#SQL user without login
#SQL user with login
#Domain user

Thank you so much for you help.
Luka

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-10 : 10:47:31

See the discussion here:
https://msdn.microsoft.com/en-CA/library/ff929071.aspx

Basically you have three choices:

Contained database user with password -- a SQL user without a login
Contained database users with passwords are authenticated by the database.
Windows principals - a Domain user
Authorized Windows users and members of authorized Windows groups can connect directly to the database and do not need logins in the master database. The database trusts the authentication by Windows.
Users based on logins in the master database - a SQL user with a login
can be granted access to a contained database, but that would create a dependency on the SQL Server instance.

Since you need to "port the database to different database servers within domain", which one do you think fits?