ASP using SQL Server with Integrated Security

Hello all,

I am new to classic ASP , i am basically a .NET developer. But i got a issue
to solve at work which relates to ASP.

We have a classic ASP app which has Sql server credentials in connection
string. Since this is not secure , we are thinking of making it as Integrated
security.

I would like to know how Integrated security actually works in classic ASP.
In ASP.NET , if we use Integrated security , we have to use impersonation ,
configure ASPNET user account in sql server.

what are steps we need to take to accomplish this task in classic ASP.

Please Help ..
Any help is appreciated.
Thanks

Re: ASP using SQL Server with Integrated Security

dallas_princess wrote:
> Hello all,
>
> I am new to classic ASP , i am basically a .NET developer. But i got
> a issue to solve at work which relates to ASP.
>
> We have a classic ASP app which has Sql server credentials in
> connection string. Since this is not secure , we are thinking of
> making it as Integrated security.
>
> I would like to know how Integrated security actually works in
> classic ASP. In ASP.NET , if we use Integrated security , we have to
> use impersonation , configure ASPNET user account in sql server.
>
> what are steps we need to take to accomplish this task in classic ASP.
>

Does this answer your question?
http://databases.aspfaq.com/database/what-should-my-connecti on-string-look-like.html
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: ASP using SQL Server with Integrated Security

You Bet !!

Thanks !

"Bob Barrows [MVP]" wrote:

> dallas_princess wrote:
> > Hello all,
> >
> > I am new to classic ASP , i am basically a .NET developer. But i got
> > a issue to solve at work which relates to ASP.
> >
> > We have a classic ASP app which has Sql server credentials in
> > connection string. Since this is not secure , we are thinking of
> > making it as Integrated security.
> >
> > I would like to know how Integrated security actually works in
> > classic ASP. In ASP.NET , if we use Integrated security , we have to
> > use impersonation , configure ASPNET user account in sql server.
> >
> > what are steps we need to take to accomplish this task in classic ASP.
> >
>
> Does this answer your question?
> http://databases.aspfaq.com/database/what-should-my-connecti on-string-look-like.html
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>