Re: Web Applicaiton using Trusted Connections to SQL on different machine?

• Previous message: Scott: "IIS Integrated Windows Security"
• In reply to: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Next in thread: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Reply: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 11 Jul 2005 10:16:36 -0700

Thank you for your reply.

I'm not sure if this is really .Net Related though. I get the Error if I
use ASP.NET code to make the connection, or if i just use ASP code to make
the connection.

My ASP code looks like this:

     Set enm = Server.CreateObject("adodb.connection")
     enm.Open "Driver={SQL
Server};Server=SERVER;Trusted_Connection=yes;Database=Northwind;"
     Set rsUser = enm.Execute("SELECT * FROM customers")
     Set enm = Nothing
I get the Error on the .Execute

Thanks,

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:e2EDQO7gFHA.3656@TK2MSFTNGP09.phx.gbl...
> Scott Townsend wrote:
>> I'm trying to get my Webserver to talk to my SQL Server and allow
>> Trusted Connections.
>>
>> If my SQL server and Web Server are on the same box I can get it to
>> work. There needs to be a User on the SQL Server that in running the
>> Web Application (in my case the ASPNET or Network Services account).
>>
>> So on the SQL and Web on the same box I can do this as the ASPNET or
>> Network Services Accounts are local the Server and can be added to
>> the SQL Server's Logins. Though the local Server accounts cannot be
>> added to a remote SQL Server machine. I need to have a Domain
>> Account to do this.
>>
>> I've Setup a separate Application Pool with a an Identity of a Domain
>> User. Given the Domain User Local Admin Perms on the Web Server and
>> Access to the SQL Server Databases that it needs.
>>
>> Though when I go to run the Application I do not see the Identity of
>> the new Domain user in the list of Tasks for the w3wp.exe. I still
>> see the local IWAM account.
>>
>> What am I doing Wrong?
>>
> Well, your latest mistake <grin> is posting to a classic ASP group (I'm
> reading this in .inetserver.asp.db) when you should be posting to a dotnet
> group such as microsoft.public.dotnet.framework.aspnet.
>
> As for what you are doing wrong in your .Net app, I really can't say for
> sure. Here are some KB articles that may help:
> http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLC,GGLC:1969-53,GGLC:en&q=site:support%2Emicrosoft%2Ecom+%22SQL+Server%22+trusted+connection+ASP%2ENet
>
> If you don't find your answer there, post more information to the dotnet
> newsgroup where you are more likely to find someone who can help (I'm just
> beginning with .Net myself, so my ability to help is limited)
>
> Bob Barrows
>
> --
> 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"
>

• Previous message: Scott: "IIS Integrated Windows Security"
• In reply to: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Next in thread: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Reply: Bob Barrows [MVP]: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]