ASPNET user

[Denis Brkljacic]

Hello,


Please if you can help. I have 2 servers, first one is WEB server with .NET
Framework 1.1 and IIS 5.0, second one is MS SQL server with no .NET
Framework installed.

ASPNET user originally exists on WEB server NET Framework 1.1 installation
have added this user). We would now want to add that user on MSSQL server,
grant him access to some database as this is described in the article:

HOW TO: Configure SQL Server Security for .NET Applications

The problem is that MSSQL server is another machine in the network, not in
the same domain. How can we add ASPNET user?


Please, if somebody can help.


Regards,

Denis

 

[Matt Hawley]

Denis,

I've never done this, but I've seen it shown to me many, many times. Basically, you need to create an ASPNET user on the SQL Server, and then grant that local user access to the database. The best method, is to create a brand new user, and use impersonation (via the web.config) to run your application under. Create that same user on the SQL server and grant them access.

In both cases, you'll use SSPI for your database connection, making it secure.

HTH,

Matt Hawley, MCAD .NET
http://www.eworldui.net

Hello,


Please if you can help. I have 2 servers, first one is WEB server with .NET
Framework 1.1 and IIS 5.0, second one is MS SQL server with no .NET
Framework installed.

ASPNET user originally exists on WEB server NET Framework 1.1 installation
have added this user). We would now want to add that user on MSSQL server,
grant him access to some database as this is described in the article:

HOW TO: Configure SQL Server Security for .NET Applications

The problem is that MSSQL server is another machine in the network, not in
the same domain. How can we add ASPNET user?


Please, if somebody can help.


Regards,

Denis