Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am configuring a SQL Server Express 2008R2 instance, and I want the current logged in user to be able to access SQLEXPRESS.

Which one should I add at the Database engine configuration step of the installation?

share|improve this question

migrated from stackoverflow.com Dec 13 '11 at 8:03

This question came from our site for professional and enthusiast programmers.

    
Neither of those are related to the current logged in user. –  Damien_The_Unbeliever Dec 13 '11 at 7:25
    
BTW: dba.stackexchange.com exists and the question would have been perfectly on topic there - I wonder why it has not been migrated there –  the-wabbit Dec 13 '11 at 9:58

1 Answer 1

The current user will be able to log in in any case, as long as your SQL server configuration allows it (i.e. has an appropriate system login defined and a database user mapped to it with sufficient privileges). As the user installing MS SQL server is at least the local machine administrator, she will have the sysadmin role upon completion of the installation, so the "login problem" should be your least concern.

The point in being able to choose a user for the SQL service to run lies in selecting the security context for the service itself - mainly of interest if your server-based logic needs access to files on the local file system or within the network.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.