integrated Secure

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

I want to set integrated Secure in my connect string to SQL Server

I set the connect string as:

workstation id=xxx;packet size=4096;integrated security=SSPI;initial
catalog=vvv;persist security info=False

and I have execute sp_grantlogin 'ServerName\ASPNET' in Sql Query Analyzer

But when I execute my web application, it result an error at line:

¦bsqlDataAdapter1.Fill(dataset1);

The error message is 'NT AUTHORITY\NETWORK SERVICE'

How can I solve this problem?
 
It would seem that the worker process is authenticating with the Network Service Login. That's what I've noticed on 2003 Server. You may need to run the process using different credentials.

-Calvin Luttrell
ProjectThunder.com, Inc.
Areas we service
 
Thank,
But I can't understand what you say.
Can you give me more detail information.
Please.

"Calvin Luttrell" <[email protected]>
???????:u#[email protected]...
It would seem that the worker process is authenticating with the Network
Service Login. That's what I've noticed on 2003 Server. You may need to run
the process using different credentials.

-Calvin Luttrell
ProjectThunder.com, Inc.
Areas we service
 
Thank
But I have still some question
1. Why I can't find the 'NT AUTHORITY\NETWORK SERVICE' in my Windows 2003
account?
2. Must I must give the database db owner to 'NT AUTHORITY\NETWORK SERVICE'
? Can I give 'NT AUTHORITY\NETWORK SERVICE' a lower role?



"Calvin Luttrell" <[email protected]>
???????:u#[email protected]...
It would seem that the worker process is authenticating with the Network
Service Login. That's what I've noticed on 2003 Server. You may need to run
the process using different credentials.

-Calvin Luttrell
ProjectThunder.com, Inc.
Areas we service
 
Win2k3 runs ASP.NET using the NETWORK SERVICE account as it correctly
identifies. Not ASPNET as you are working with.

I have answered this question in ultra detail over here for both IIS 5.0 and
6.0 -
http://groups-beta.google.com/group...ed+Security"+&+"Sahil+Malik"#ff792cd97beb4dcf

Let me know if you have any further questions.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/




It would seem that the worker process is authenticating with the Network
Service Login. That's what I've noticed on 2003 Server. You may need to run
the process using different credentials.

-Calvin Luttrell
ProjectThunder.com, Inc.
Areas we service
 
Back
Top