Form Authentication w/ a Trusted SQL Server Connection?
-
Can someone include the steps that would allow me to connect to a remote SQL Server using a Trusted Connection in IIS? Please include an example of the connect string if possible. Also to note, I am using Form Authentication on the website. Currently we have the connection string encrypted in the registry use a sql server account and want to get away from the model. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)
-
Can someone include the steps that would allow me to connect to a remote SQL Server using a Trusted Connection in IIS? Please include an example of the connect string if possible. Also to note, I am using Form Authentication on the website. Currently we have the connection string encrypted in the registry use a sql server account and want to get away from the model. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)
-Dr_X- wrote:
Currently we have the connection string encrypted in the registry use a sql server account and want to get away from the model.
Hi Michael, Do you mean you want to quit storing the encrypted connection in the registry or no longer want to use the sql server account? Anyway, there are a couple of articles that you might be interested in: http://msdn.microsoft.com/library/en-us/dnpag2/html/PAGHT000010.asp?frame=true[^] http://msdn.microsoft.com/library/en-us/dnpag2/html/PAGHT000008.asp?frame=true[^] With the second option you can use with the Form Authentication, but you need to make sure that ASP.NET process identity has access to the DB.
-
-Dr_X- wrote:
Currently we have the connection string encrypted in the registry use a sql server account and want to get away from the model.
Hi Michael, Do you mean you want to quit storing the encrypted connection in the registry or no longer want to use the sql server account? Anyway, there are a couple of articles that you might be interested in: http://msdn.microsoft.com/library/en-us/dnpag2/html/PAGHT000010.asp?frame=true[^] http://msdn.microsoft.com/library/en-us/dnpag2/html/PAGHT000008.asp?frame=true[^] With the second option you can use with the Form Authentication, but you need to make sure that ASP.NET process identity has access to the DB.
Thanks, I will have time to give the 2nd one listed a try next week. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)