ASP.NET Identity for Win 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had a working WebService on my WinXp machine. I was using Windows
Authentication for database access. The App and Database are on same machine.
MachineName\ASPNET has execute permissions to the stored procedures.

I moved the app to a Win2003 serverwhich also has SQLServer 2000 installed.
Now the Sqlconnection.Open() method fails. I granted machineName\ASPNET and
MachineName\IIS_WPG exec permission to the procedure.

What am I doing wriong?
 
Win 2003 doesn't use this identity but the NETWORK SERVICE (unless IIS6 runs
in IIS5 compatiblity mode) or the identity used for the app-pool assigned to
your web app.

I had a working WebService on my WinXp machine. I was using Windows
Authentication for database access. The App and Database are on same
machine.
MachineName\ASPNET has execute permissions to the stored procedures.

I moved the app to a Win2003 serverwhich also has SQLServer 2000 installed.
Now the Sqlconnection.Open() method fails. I granted machineName\ASPNET and
MachineName\IIS_WPG exec permission to the procedure.

What am I doing wriong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Word Document Issue 2
SQl Server Permission prob in asp.net ap 1
ASP.NET SQL Server logon permission denied 2
ASP.NET 2.0 Write File (IIS 6.0/Windows 2003) 1
Error in accessing Excel sheets. 1
Public ASP.NET app and SQL Server security - best practices? 4
Moving Web App from 1 PC to 3 Servers! 1
ASPNET (NETWORK SERVICE) identity cannot run SP that drop table 6

Back
Top