Connecting with sql server use folliwing coding.
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=AUHTRIPSVR2"
catalog="your database name"
datasource="your sql server name"
make these two change and connect with sql server.
quote:Originally posted by nidgep
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.