intervisual
Jul 11th, 2000, 06:56 AM
Hi All,
Ok this is driving me mad... we are setting up some ASP code that access a SQL DB. However all the examples we have seen shows the ASP pages accessing SQL via the SA login and a plain text passowrd... Erm this dosent appear to be a sane way of asscessing SQL ! How can it be done without having a plain text password and login id? Idealy we need to use the NT login to determine the access rights with SQL. This is to allow some people to update information via the web (depending on login) and other users to just read the information.
Thanks all in advance......
Rob
Ok this is driving me mad... we are setting up some ASP code that access a SQL DB. However all the examples we have seen shows the ASP pages accessing SQL via the SA login and a plain text passowrd... Erm this dosent appear to be a sane way of asscessing SQL ! How can it be done without having a plain text password and login id? Idealy we need to use the NT login to determine the access rights with SQL. This is to allow some people to update information via the web (depending on login) and other users to just read the information.
Thanks all in advance......
Rob