ASP to SQL Server via Windows authentication

ASP to SQL Server via Windows authentication

am 19.01.2006 22:38:40 von curious_Lee

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 :)

Re: ASP to SQL Server via Windows authentication

am 19.01.2006 23:06:33 von reb01501

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"

Re: ASP to SQL Server via Windows authentication

am 19.01.2006 23:23:00 von curious_Lee

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]" wrote in message
news:ueZzZSUHGHA.1032@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"
>