CODEWITHSUNDEEP
c#sql-serverexceptionado.netwindows-authentication
Greg
Greg

Reputation: 163

Integrated windows authentication to SQL Server

I have an application that uses a database on SQL Server and I want users to connect to that server using integrated windows authentication. The connection string is:

SqlConnection scn = new SqlConnection("Data Source='server name';Initial Catalog=temp;Trusted_Connection=true;Integrated Security=SSPI");

When I run the application from my pc it works just fine and it recognizes my user name. But when I run it from the server then it gives me the following error:

Login failed for user 'domain\server Name$'.

As I understand it doesn't recognize the user name and thinks that the user name is the server name.

Any idea how to fix it?

Upvotes: 2

Views: 6785

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294467

The application correctly connects as the server machine account. Processes running as LocalSystem or as Network Service authenticate over the network as the machine, domain\machine$, this is by design, intentional and desired.

You can grant domain\server$ login rights into SQL as needed. Or you can change the application to run under a different account (I assume the application is a service?).

Upvotes: 3

Oded
Oded

Reputation: 499382

Use runas to have the application run with the correct credentials.

Upvotes: 0

Related Questions