Re: Can my ASP.NET dev workstation see remote SQL server?
From: Timo (timo_at_anonymous.com)
Date: 03/11/04
- Next message: Timo: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Previous message: Mike: "AD Startup script - Integrated Auth SQL 2000"
- In reply to: Jose Marcenaro: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Next in thread: Kevin McDonnell [MSFT]: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Reply: Kevin McDonnell [MSFT]: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Reply: Jose Marcenaro: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 11 Mar 2004 12:38:45 -0500
I follow step #1 below (it seems preferable to editing the live IIS server).
On my local PC, I edit the userName element replacing the value with
DOMAIN\USERNAME
This domain user has been granted login on the remote SQL server, has been
granted dbaccess, and has been added as a member of a role which can access
the relevant tables.When I try to run my ASP.NET page, I get the following
error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
I don't know what our network admin has done when setting up my PC, which
has XP Pro on it; he is used to Win2K. He knows only a little more than I do
about Windows authentication, which has me worried :-) Why does the error
message have 'null' for the username? Because SQL does not recognize it and
so refuses to repeat the name?
Thanks
Timo
"Jose Marcenaro" <josem@nospam.da-vinci.com.ar> wrote in message
news:eDZZXh4BEHA.3568@tk2msftngp13.phx.gbl...
> You certainly can
> A couple of ways to do it (one OR the other)
>
> 1) Edit machine.config (C:\WINNT\Microsoft.NET\Framework\v......\Config)
and
> change the userName / password of the <processModel ..> element as
described
> in the same file
> That way you can run the ASP.NET working process on the identity of a
domain
> account that may be allowed access to the SQL Server
>
> 2) For your Web application (on the IIS console), replace the default
> anonymous user (IUSR_xxxxxxx) with a domain user / password and allow
access
> to that user in the SQL Server. You should also set <identity
> impersonate=true> in your Web.config
>
> Regards
> Jose.
>
> "Timo" <timo@anonymous.com> escribió en el mensaje
> news:uPs3ZS4BEHA.624@TK2MSFTNGP10.phx.gbl...
> > I would like to develop my ASP.NET application against a SQL 2000
database
> > residing on another server, rather than against the SQL server installed
> > locally. We're using Windows integrated security. When I'm using
Visual
> > Studio the ASP.NET user belongs to my XP machine's local domain, which
is
> > not recognized by the remote SQL server as belong to its domain. It is
> > possible to set up the SQL Server, my local XP machine, or my web.config
> > file so that when I develop an app in Visual Studio (Debug -> Start), I
> can
> > access the remote SQL database?
> > Thanks !
> >
> >
>
>
- Next message: Timo: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Previous message: Mike: "AD Startup script - Integrated Auth SQL 2000"
- In reply to: Jose Marcenaro: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Next in thread: Kevin McDonnell [MSFT]: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Reply: Kevin McDonnell [MSFT]: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Reply: Jose Marcenaro: "Re: Can my ASP.NET dev workstation see remote SQL server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
