User management

From: Daniel Rakojevic (anonymous_at_discussions.microsoft.com)
Date: 11/14/03 

Date: Fri, 14 Nov 2003 04:02:59 -0800

Hi!

I am programming a ASP-portal.

Now i want to implement a user management with rights and
roles.

I have IIS 5.0 running on Machine1 and
Sql Server 2000 running on Machine 2
(it uses both Windows Integrated and SQL Server security )

So i have only the IUSR_Machine1 as an user in my Sql
Server.

How can i manage the user management of my portal with the
SQL Server user management ?

I want to make for every portaluser a SQL Server account.

How to login from the ASP-site, because i is even the
IUSR_Machine1 who is
accessing the SQL Server ?

I hope my plan is possible !

Greetings,

Daniel Rakojevic

Relevant Pages

  • SQL Express User/ Role database to SQL Server
    ... my development PC with all the user management taken care of in the ... PC that runs SQL server. ... This is the Connection string for the application DB: ... I really have tried a few posts that recommend changes to the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Problem connecting to Linked server
    ... enable remote connections for the Database ... the SQL Server Browser service running. ... as a liked server to machine1. ... But I am not able to access machine2\Instance1's database ...
    (microsoft.public.sqlserver.clients)
  • Re: Registration problem
    ... I tried to ping the machine1 by doing this: ... I tried to register SQL Server using that IP. ... No success. ...
    (microsoft.public.sqlserver.setup)
  • Problem connecting to Linked server
    ... as a liked server to machine1. ... This I achieve by executing the ... using my SQL Server Management studio. ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.clients)
  • Attach database
    ... I have copied a .mdf file from machine1 ... Can I attach it to a SQL Server which is running on a different machine ...
    (microsoft.public.sqlserver.programming)
Loading