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
 General SQL Server Forums
 New to SQL Server Programming
 Using Domain User password to access SQLServerDB

Author  Topic 

avadhutkhavare
Starting Member

1 Post

Posted - 2011-06-20 : 05:55:33
Hi,

1. I am working on C# client application which is on one machine.
2. I have a service on another machine (Actually interacts with DB).

I want to connect to SQLServer (Express 2008) using Domain username/password. My client application has a login dialog box where user can enter Domain Username/Domain Password.

I am passing this login credentials to service and at service i want to connect to my database using this domain user.

I want to access DB using username/password supplied by my client application. Is this possible??

Also Following is not possible as per my knowledge:
- Use of integrated windows domain connection string to access DB.
- My service is running using local system account.

Thanks in advance!

Regards,
Avadhut

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-20 : 11:07:16
Service needs to run as a domain account that is trusted for delegation.
Go to Top of Page
   

- Advertisement -