Do Db users have to be set up as server users as well?

[Imakeoil]

I am running into some trouble creating a user for one of my dbs. The user account will be used to pull data out of the db into excel, so they don't need to login directly to the server. I was reading the BOL on creating database users which states 'The topic assumes that a corresponding sql server login already exists'. Is that a requirement? And if it is how do I stop the user from actually logging into the server?

Thank you

 

[djj55]

If the SQL Server is in mixed mode authentication the you can create a SQL Server user that Excel can use to connect.

My stance is that security on any Microsoft product is confusing at best.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[mrdenny]

SQL Server Authentication is pretty straight forward.

If you are on a domain, the user should have a domain account. Simply create a login within the SQL Server which is tied to their domain account.

If you are not in a Windows domain, create a user in Windows on the SQL Server that has the same username and password as the login the user users on their workstation, then create an account in SQL Server that is mapped to this local Windows account.

If you prefer to use a SQL Login (Windows logins are always recommended) then create a SQL Login which has no requirements of a matching Windows login.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog