ASP to SQL Server via Windows authentication

Hi. We've got a classic ASP app that needs to connect to a SQL Server 2000
db via Windows (domain) authentication. How is this done? I've found
articles on ASP.NET but not ASP. Some code examples can really help (what
the connection string should be, etc.) Help please :)
curious_Lee [ Do, 19 Januar 2006 22:38 ] [ ID #1149018 ]

Re: ASP to SQL Server via Windows authentication

curious_Lee wrote:
> Hi. We've got a classic ASP app that needs to connect to a SQL Server
> 2000 db via Windows (domain) authentication. How is this done? I've
> found articles on ASP.NET but not ASP. Some code examples can really
> help (what the connection string should be, etc.) Help please :)


This is your resource: www.aspfaq.com

Specifically:
http://www.aspfaq.com/show.asp?id=2126
and
http://www.aspfaq.com/show.asp?id=2138
--
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"
reb01501 [ Do, 19 Januar 2006 23:06 ] [ ID #1149019 ]

Re: ASP to SQL Server via Windows authentication

Thanks, Bob. One additional wrinkle added: We've created a special domain
account we'd like to use for doing the domain authenticated connection to
SQL Server; is this possible?

"Bob Barrows [MVP]" <reb01501 [at] NOyahoo.SPAMcom> wrote in message
news:ueZzZSUHGHA.1032 [at] TK2MSFTNGP11.phx.gbl...
> curious_Lee wrote:
>> Hi. We've got a classic ASP app that needs to connect to a SQL Server
>> 2000 db via Windows (domain) authentication. How is this done? I've
>> found articles on ASP.NET but not ASP. Some code examples can really
>> help (what the connection string should be, etc.) Help please :)
>
>
> This is your resource: www.aspfaq.com
>
> Specifically:
> http://www.aspfaq.com/show.asp?id=2126
> and
> http://www.aspfaq.com/show.asp?id=2138
> --
> 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"
>
curious_Lee [ Do, 19 Januar 2006 23:23 ] [ ID #1149020 ]
Webserver » microsoft.public.inetserver.asp.db » ASP to SQL Server via Windows authentication

Vorheriges Thema: newbie select last item entered to a DB question
Nächstes Thema: Accessing MS Access DB in different site