Hi

Can anyone tell me the best way to manage SQL Server logins from a web page?

I need to manage several logins, each will have their own level of permissions in order to manage a website using ASP
and SQL Server.

Also is the preferred method of connecting the site to SQL Server using the IIS user (ISR_ServerName) or is their a better way?

Thanks in advance to anyone who may have some advice or links to resources etc.

Connecting with sql server use folliwing coding.


set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=AUHTRIPSVR2"
cn.Open


catalog="your database name"
datasource="your sql server name"
make these two change and connect with sql server.

Mateen

Hi

Sorry this is not what I meant. I know how to connect to the database.
what I wanted to know was a methodology of which is the best way of handling the security regarding the logins where the web site is managed completely through ASP by members of the admin team where each member of the admin team may have different permissions within the database.

then use a different connection for those people who are using it again with different permissions.