Secure SqlConnection in Web apps

[Adam Getchell]

I have an ASP.NET application on IIS6 that will access a SQL2000 database. I would like to use integrated security, ie a connect string similiar to

ConnectionString = "workstation id=WEBSERVER;packet size=4096;integrated security=SSPI;data source=\"SQLSERVER\\INSTANCE\";persist security info=False;initial catalog=Northwind"

Naturally this fails running as-is

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

I've tried setting the Default Web Application pool to run under a domain service account, and then granting permissions to the database for that account. However, that results in a "Service Unavailable

Any quick pointers to doing this the right way? I am currently reading through "Building Secure Microsoft ASP.NET Applications"

Thanks

--Adam

[Piyush Govil]

hi

just try to use like thi

"Data Source=SQlServerName;Initial Catalog=pubs;Integrated Security=SSPI;"
- or
"Server=SQlServerName;Database=pubs;Trusted_Connec tion=True;

Hope this will help u somewhat !

Thank
Piyush