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

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 07/08/05 

Date: Fri, 8 Jul 2005 07:53:01 -0400

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"

Relevant Pages

  • Re: MSSQL HEllo bug
    ... Microsoft claims that the default for SQL Server 2000 is a domain user NOT ... domain account as the service account during the installation phase. ... exists OR simply click the LocalSystem radio button to save themselves the ...
    (NT-Bugtraq)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)