No ASPNET User in SQL 2000 Server

[IndyGill]

Hi

I have just built a development machine which is a Windows 2000 OS with SQL 2000 Server and Visual Studio .Net.

However I have noticed a problem with the SQL server. I thought that a ASPNET user is created under SQL Server, however this is not tehcase. Can I just create this user again? or is there a file I can call that will do this for me. If I can create the user myself what privalegs do i need to give it?

Many thanks in advance

 

[jfrost10]

You can add the ASPNET user to sql server manually. You just go to add a user like normal, but just select the aspnet user (it should be available as a choice).

As far as priviledges, it depends on how your application is set up. We grant aspnet access to all the stored procs in our sql server, but NEVER to the actual tables. But that fits our application scheme.

D'Arcy

 

[culshaja]

Unlike ASP, ASP.Net does not pass through the NT user if using challenge and response. What you need to do is modify the web.confg file and add the following line:

<identity impersonate=&quot;true&quot; />

This will either provide access to SQL Server either as the NT user who is talking to the web application or the IUSR_Machinename user depending on the security setting on the virtual directory or web server.

James James Culshaw
jculshaw@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305