CODEWITHSUNDEEP
c#windows-servicessql-server-express
Chris Cooper
Chris Cooper

Reputation: 899

Connecting to SQLExpress from a service

We've got a service running as Local system. Should it be possible to use Integrated Security to connect to an SQLExpress instance from this service? It tries to login as "NT AUTHORITY/ANONYMOUS LOGON" and fails to connect.

Connection string is 

Data Source=.\SQLExpress;Initial Catalog=Example;Integrated Security=true

What do I need to setup on SQLExpress to handle this?

Upvotes: 2

Views: 320

Answers (2)

Colin Mackay
Colin Mackay

Reputation: 19185

I would suggest running the service in an account dedicated for that service. THat way you can shape its security, thus limiting the damage if the service is compromised. It also means you know exactly what account to give to SQL Server and you can shape the security in there too.

Upvotes: 2

Dave Swersky
Dave Swersky

Reputation: 34820

If you modify the service to run under a different local or AD account (Control Panel/Administration Tools/Services), then grant that same AD account access to the database, it should be able to access the database using Windows security.

Upvotes: 2

Related Questions