Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 20th, 2003, 03:09 AM
Authorized User
 
Join Date: Jun 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server Logins

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.
 
Old June 20th, 2003, 08:46 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


Quote:
quote:Originally posted by nidgep
 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.
 
Old June 20th, 2003, 09:05 AM
Authorized User
 
Join Date: Jun 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Reg. SQL Server does not exist error Arsi SQL Server 2000 1 June 11th, 2008 11:20 AM
restoring deleted logins in sql 2005 v-manraj SQL Server 2005 2 September 26th, 2007 03:52 PM
Recovering accidentally deleted logins in sql serv v-manraj SQL Server 2000 0 September 25th, 2007 02:55 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
DB Restore User Logins onto different server plandis98 SQL Server 2000 1 November 25th, 2004 10:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.