IIS 7 , 2008 R2 and SQL 2008

  • Thread starter Thread starter Marek G.
  • Start date Start date
M

Marek G.

Hi all,
sorry for my bad English . I have questation about impersonatilion . I have
asp.net which remotely connect to SQL 2008 . I want use the credentional
from client which open asp.net page , which connect to sql server:-) . But
after I try it , the login to the sql serveris anonymous , why ????
thanx
marek
 
Hi all,
sorry for my bad English . I have questation about impersonatilion . I have
asp.net which remotely connect to SQL 2008 . I want use the credentional
from client which open asp.net page , which connect to sql server:-) . But
after I try it , the login to the sql serveris anonymous , why ????
thanx
marek
Click to expand...

Hi Marek,

it sounds like you need to use impersonation.
Take a look the following link on MSDN

How To: Connect to SQL Server Using Windows Authentication in ASP.NET
2.0
http://msdn.microsoft.com/en-us/library/ms998292.aspx

Hope this helps
 
I have integrated logon to iis and asp.net server , and enable asp.net
impersonate :-( .... Have another idea ?
 
Back
Top