473,323 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by .NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G
Jul 21 '05 #1
10 4707
This is my uninformed understanding - I could be completely wrong about
this! :-)

Seems to me that ASP.NET is running as Server1\ASPNET which is an account
local to the webserver. It's access token probably only has "anonymous"
rights to network resources, which isn't sufficient to login to SQL Server
on the remote box. The ASPNET account you have on server2, is
Server2\ASPNET, which isn't the same.

Cheers
Ken
"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:eS**************@TK2MSFTNGP12.phx.gbl...
Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by
.NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with
a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result
with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist
security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G

Jul 21 '05 #2
DC,

Are you in an AD realm? If not - you will not be able to hop your
identities across the machines, but still have a few other options.

(its been a while since i've tackled the problem - but i'll do my best from
memory).

1: You can enable Basic Authentication instead of NTLM - while this is not
very secure - it will allow your credentials you supplied to the web site to
be passed (clear text) to the server which contains the sql database - just
grant the authenticated account access to the DB.

2. Setup impersonation on your web site, using the Identity node in the
web.config - keep NTLM on your site, and grant your identity that you
impersonate access to the database (this also requires additional setup to
the asp.net processModel - or elevating the ASPNET account to be able to do
identity impersonation), if you are in an AD realm you can let the web
application impersonate the NTLM user - otherwise you can specificy a
specific proxy account in the identity node - and encrypt it using the
aspnet_setreg.exe.

3. I find it unlikely that syncing your passwords would work in any
scanrio - while this would have worked back in NT - I don't believe windows
is still dumb enough to fall for it.
This should give you enough information to poke around and get it right.

Good Luck!

"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:eS**************@TK2MSFTNGP12.phx.gbl...
Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by
.NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with
a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result
with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist
security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G

Jul 21 '05 #3

The webserver ASPNET account may not be properly mapped with Server2(SQL).
Just delete the ASPNET acocunt in sql server, and create a Nt Account like
Server1\AspNet (Not a SQL serve account).

if nothing is working create a new Account in Webserver and assign to Worker
process account and refer the same account in Sql Server too.

Regards,
Govind.
"DC Gringo" wrote:
Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by .NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G

Jul 21 '05 #4
The most common answer is to run your web app under a domain account and
give that domain account access to SQL Server.

I have tried to use this "mapping of a local account" before. It only works
if both the account name and the password are the same on both machines.
Since the ASPNET account's password is managed by IIS, and changed on a
regular basis, it would be an unusual event to sync the ASPNET account.

Good Luck
--- Nick

"Govind" <Go****@discussions.microsoft.com> wrote in message
news:AD**********************************@microsof t.com...

The webserver ASPNET account may not be properly mapped with Server2(SQL).
Just delete the ASPNET acocunt in sql server, and create a Nt Account like
Server1\AspNet (Not a SQL serve account).

if nothing is working create a new Account in Webserver and assign to Worker process account and refer the same account in Sql Server too.

Regards,
Govind.
"DC Gringo" wrote:
Using latest SP Win2k and .NET versions, I have a .NET application running on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by ..NET Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result with Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist security info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G

Jul 21 '05 #5
On Tue, 31 Aug 2004 22:30:17 -0400, "DC Gringo"
<dc******@visiontechnology.net> wrote:
Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by .NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Might look at:

PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User
'(Null)'":
http://support.microsoft.com/default...b;en-us;307002

Jeff


IIS is set to Windows Integrated Authentication...although same result with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>


Jul 21 '05 #6
Nick,

I have been using the "mapping of a local account" without a problem for
quite awhile now. Why do you say that they ASPNET account's password would
be changed on a regular basis?

I have manually set the ASPNET account's password on our web server and
hardcoded it (in clear text) in the machine.config (granted this may not be
the most secure thing), but why would IIS ever change it?

I have also created a local ASPNET user on our SQL box with matching
password. Works fine.

I chose not to go with a domain account simply because I did not fully
understand (and still don't) what all permissions I would need to apply to
that account on our webserver to mimick the default ASPNET user.

Greg
"Nick Malik" <ni*******@hotmail.nospam.com> wrote in message
news:JFeZc.103692$mD.57229@attbi_s02...
The most common answer is to run your web app under a domain account and
give that domain account access to SQL Server.

I have tried to use this "mapping of a local account" before. It only works if both the account name and the password are the same on both machines.
Since the ASPNET account's password is managed by IIS, and changed on a
regular basis, it would be an unusual event to sync the ASPNET account.

Good Luck
--- Nick

"Govind" <Go****@discussions.microsoft.com> wrote in message
news:AD**********************************@microsof t.com...

The webserver ASPNET account may not be properly mapped with Server2(SQL).
Just delete the ASPNET acocunt in sql server, and create a Nt Account like Server1\AspNet (Not a SQL serve account).

if nothing is working create a new Account in Webserver and assign to

Worker
process account and refer the same account in Sql Server too.

Regards,
Govind.
"DC Gringo" wrote:
Using latest SP Win2k and .NET versions, I have a .NET application

running on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by .NET Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result with Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet size=4096;integrated security=SSPI;data source=""myserver"";persist security info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G


Jul 21 '05 #7
"Synching passwords" (aka pass-through authentication) worked before we went
to AD and continues to work in mixed-mode AD for us.

Here is link on the subject, all this one doesn't mention pass-through.
Cannot find the msdn article that did. :(
http://msdn.microsoft.com/library/de...pplication.asp

I am not using a domain account simply because I wasn't sure what
permissions to assign to it on the web server to mimick the default ASPNET
user. I just found this link, with which I might revisit the problem:

http://msdn.microsoft.com/library/de...lListsACLs.asp

Greg

"Jediah L." <ri**@nospam.nospam> wrote in message
news:e2**************@TK2MSFTNGP11.phx.gbl...
DC,

Are you in an AD realm? If not - you will not be able to hop your
identities across the machines, but still have a few other options.

(its been a while since i've tackled the problem - but i'll do my best from memory).

1: You can enable Basic Authentication instead of NTLM - while this is not
very secure - it will allow your credentials you supplied to the web site to be passed (clear text) to the server which contains the sql database - just grant the authenticated account access to the DB.

2. Setup impersonation on your web site, using the Identity node in the
web.config - keep NTLM on your site, and grant your identity that you
impersonate access to the database (this also requires additional setup to
the asp.net processModel - or elevating the ASPNET account to be able to do identity impersonation), if you are in an AD realm you can let the web
application impersonate the NTLM user - otherwise you can specificy a
specific proxy account in the identity node - and encrypt it using the
aspnet_setreg.exe.

3. I find it unlikely that syncing your passwords would work in any
scanrio - while this would have worked back in NT - I don't believe windows is still dumb enough to fall for it.
This should give you enough information to poke around and get it right.

Good Luck!

"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:eS**************@TK2MSFTNGP12.phx.gbl...
Using latest SP Win2k and .NET versions, I have a .NET application running on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by
.NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result
with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist
security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G


Jul 21 '05 #8
I misspoke and I offer my apologies. ASPNET password is not known to the
end user, but it is not managed by IIS either.
You do have to change it so that you will know what it is.

You do agree, though, that the username and password for the local accounts
must be the same on both machines, yes?

The correct steps for creating a local account to run ASP.NET are described
here:
http://msdn.microsoft.com/library/de...l/secmod15.asp
Including all the details of what privileges are required at a minimum.

A good blog that provides a FAQ for ASP NET security is:
http://blogs.bartdesmet.net/bart/arc...004/07/31.aspx

HTH,
--- Nick

"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Nick,

I have been using the "mapping of a local account" without a problem for
quite awhile now. Why do you say that they ASPNET account's password would be changed on a regular basis?

I have manually set the ASPNET account's password on our web server and
hardcoded it (in clear text) in the machine.config (granted this may not be the most secure thing), but why would IIS ever change it?

I have also created a local ASPNET user on our SQL box with matching
password. Works fine.

I chose not to go with a domain account simply because I did not fully
understand (and still don't) what all permissions I would need to apply to
that account on our webserver to mimick the default ASPNET user.

Greg
"Nick Malik" <ni*******@hotmail.nospam.com> wrote in message
news:JFeZc.103692$mD.57229@attbi_s02...
The most common answer is to run your web app under a domain account and
give that domain account access to SQL Server.

I have tried to use this "mapping of a local account" before. It only

works
if both the account name and the password are the same on both machines.
Since the ASPNET account's password is managed by IIS, and changed on a
regular basis, it would be an unusual event to sync the ASPNET account.

Good Luck
--- Nick

"Govind" <Go****@discussions.microsoft.com> wrote in message
news:AD**********************************@microsof t.com...

The webserver ASPNET account may not be properly mapped with Server2(SQL). Just delete the ASPNET acocunt in sql server, and create a Nt Account like Server1\AspNet (Not a SQL serve account).

if nothing is working create a new Account in Webserver and assign to

Worker
process account and refer the same account in Sql Server too.

Regards,
Govind.
"DC Gringo" wrote:

> Using latest SP Win2k and .NET versions, I have a .NET application

running
> on server1 with a SQL Server database running on server2. I have the > Windows user account passwords sync'd for server1\aspnet (installed by
.NET
> Framework and server2\aspnet (created by me--this machine has no
..NET > Framework on it). The aspnet user on the database server (server2) has > access to the database.
>
> I still get: Login failed for user '(null)'. Reason: Not associated

with a
> trusted SQL Server connection.
>
> IIS is set to Windows Integrated Authentication...although same
result with
> Anonymous, with and without IIS controlling password that I enter.
>
> -----------------------------------
> Here's my connection string:
>
> Me.SqlConnection1.ConnectionString = "workstation

id=""CIL-094"";packet > size=4096;integrated security=SSPI;data source=""myserver"";persist

security
> info=False;initial catalog=mydb;"
>
>
> -----------------------------------
> Here's my web.config:
>
> <?xml version="1.0" encoding="utf-8" ?>
> <configuration>
> <system.web>
>
> <compilation defaultLanguage="vb" debug="true" />
> <customErrors mode="Off" >
> <error statusCode="404" redirect="~/errors/missingPage.aspx" />
> </customErrors>
> <authentication mode="Windows" />
>
> <authorization>
> <allow users="*" /> </authorization>
>
> <trace enabled="true" requestLimit="10" pageOutput="true"
> traceMode="SortByTime" localOnly="true"/>
>
> <sessionState
> mode="InProc"
> stateConnectionString="tcpip=127.0.0.1:42424"
> sqlConnectionString="data source=127.0.0.1;"
> cookieless="false"
> timeout="20"
> />
>
> <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
> </system.web>
> </configuration>
>
> --
> _____
> DC G
>
>
>



Jul 21 '05 #9
> You do agree, though, that the username and password for the local
accounts
must be the same on both machines, yes?
Most definately.
http://msdn.microsoft.com/library/de...l/secmod15.asp Great link!

Thanks,
Greg

"Nick Malik" <ni*******@hotmail.nospam.com> wrote in message
news:DNDZc.276086$eM2.75113@attbi_s51...I misspoke and I offer my apologies. ASPNET password is not known to the
end user, but it is not managed by IIS either.
You do have to change it so that you will know what it is.

You do agree, though, that the username and password for the local
accounts
must be the same on both machines, yes?

The correct steps for creating a local account to run ASP.NET are
described
here:
http://msdn.microsoft.com/library/de...l/secmod15.asp
Including all the details of what privileges are required at a minimum.

A good blog that provides a FAQ for ASP NET security is:
http://blogs.bartdesmet.net/bart/arc...004/07/31.aspx

HTH,
--- Nick

"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
Nick,

I have been using the "mapping of a local account" without a problem for
quite awhile now. Why do you say that they ASPNET account's password

would
be changed on a regular basis?

I have manually set the ASPNET account's password on our web server and
hardcoded it (in clear text) in the machine.config (granted this may not

be
the most secure thing), but why would IIS ever change it?

I have also created a local ASPNET user on our SQL box with matching
password. Works fine.

I chose not to go with a domain account simply because I did not fully
understand (and still don't) what all permissions I would need to apply
to
that account on our webserver to mimick the default ASPNET user.

Greg
"Nick Malik" <ni*******@hotmail.nospam.com> wrote in message
news:JFeZc.103692$mD.57229@attbi_s02...
> The most common answer is to run your web app under a domain account
> and
> give that domain account access to SQL Server.
>
> I have tried to use this "mapping of a local account" before. It only

works
> if both the account name and the password are the same on both
> machines.
> Since the ASPNET account's password is managed by IIS, and changed on a
> regular basis, it would be an unusual event to sync the ASPNET account.
>
> Good Luck
> --- Nick
>
> "Govind" <Go****@discussions.microsoft.com> wrote in message
> news:AD**********************************@microsof t.com...
> >
> > The webserver ASPNET account may not be properly mapped with

Server2(SQL).
> > Just delete the ASPNET acocunt in sql server, and create a Nt Account

like
> > Server1\AspNet (Not a SQL serve account).
> >
> > if nothing is working create a new Account in Webserver and assign to
> Worker
> > process account and refer the same account in Sql Server too.
> >
> > Regards,
> > Govind.
> >
> >
> > "DC Gringo" wrote:
> >
> > > Using latest SP Win2k and .NET versions, I have a .NET application
> running
> > > on server1 with a SQL Server database running on server2. I have the > > > Windows user account passwords sync'd for server1\aspnet (installed by > .NET
> > > Framework and server2\aspnet (created by me--this machine has no .NET > > > Framework on it). The aspnet user on the database server (server2)

has
> > > access to the database.
> > >
> > > I still get: Login failed for user '(null)'. Reason: Not
> > > associated
> with a
> > > trusted SQL Server connection.
> > >
> > > IIS is set to Windows Integrated Authentication...although same result > with
> > > Anonymous, with and without IIS controlling password that I enter.
> > >
> > > -----------------------------------
> > > Here's my connection string:
> > >
> > > Me.SqlConnection1.ConnectionString = "workstation

id=""CIL-094"";packet
> > > size=4096;integrated security=SSPI;data source=""myserver"";persist
> security
> > > info=False;initial catalog=mydb;"
> > >
> > >
> > > -----------------------------------
> > > Here's my web.config:
> > >
> > > <?xml version="1.0" encoding="utf-8" ?>
> > > <configuration>
> > > <system.web>
> > >
> > > <compilation defaultLanguage="vb" debug="true" />
> > > <customErrors mode="Off" >
> > > <error statusCode="404" redirect="~/errors/missingPage.aspx" />
> > > </customErrors>
> > > <authentication mode="Windows" />
> > >
> > > <authorization>
> > > <allow users="*" /> </authorization>
> > >
> > > <trace enabled="true" requestLimit="10" pageOutput="true"
> > > traceMode="SortByTime" localOnly="true"/>
> > >
> > > <sessionState
> > > mode="InProc"
> > > stateConnectionString="tcpip=127.0.0.1:42424"
> > > sqlConnectionString="data source=127.0.0.1;"
> > > cookieless="false"
> > > timeout="20"
> > > />
> > >
> > > <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
> > > </system.web>
> > > </configuration>
> > >
> > > --
> > > _____
> > > DC G
> > >
> > >
> > >
>
>



Jul 21 '05 #10
Joe
If the AD group is not configured properly for access on the SQL server then
you could get this problem. For instance, if the ad group has system
administrator access at root level, but not for individual databases.

"DC Gringo" wrote:
Using latest SP Win2k and .NET versions, I have a .NET application running
on server1 with a SQL Server database running on server2. I have the
Windows user account passwords sync'd for server1\aspnet (installed by .NET
Framework and server2\aspnet (created by me--this machine has no .NET
Framework on it). The aspnet user on the database server (server2) has
access to the database.

I still get: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.

IIS is set to Windows Integrated Authentication...although same result with
Anonymous, with and without IIS controlling password that I enter.

-----------------------------------
Here's my connection string:

Me.SqlConnection1.ConnectionString = "workstation id=""CIL-094"";packet
size=4096;integrated security=SSPI;data source=""myserver"";persist security
info=False;initial catalog=mydb;"
-----------------------------------
Here's my web.config:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>

<compilation defaultLanguage="vb" debug="true" />
<customErrors mode="Off" >
<error statusCode="404" redirect="~/errors/missingPage.aspx" />
</customErrors>
<authentication mode="Windows" />

<authorization>
<allow users="*" /> </authorization>

<trace enabled="true" requestLimit="10" pageOutput="true"
traceMode="SortByTime" localOnly="true"/>

<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;"
cookieless="false"
timeout="20"
/>

<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>

--
_____
DC G

Jul 21 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: TBone | last post by:
Anyone, I have a user "john" whose machine is part of the "job" domain. He is trying to establish an odbc connection to an MS SQL 2000 server on the "school" domain. He uses Windows...
1
by: Mark | last post by:
We are using impersonation so that a user on our domain will login into our SQL Server using their own domain login and/or associated domain groups. To do this, we've added: <authentication...
0
by: Frederik | last post by:
Bonjour , J'ai développé une petite application web sur winxp IIS5.0 avec Sql Server Developper edition. Tout fonctionne parfaitement. Par contre ca ne fonctionne pas lorsque je fais rouler l'app...
2
by: Frederik | last post by:
Hi, First sorry for my english I'm french. I developped a web app that work good under XPDEVSERVER machine (iis5) and SqlServerDevelopper Edition. I get problem when I moved this app to an...
4
by: rrober07 | last post by:
Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...
1
by: jerminator | last post by:
Ok I need some help. Up until Tuesday my application was working fine. It is an asp.net application written in VB. It is very data heavy and makes multiple calls to a database. The application...
1
by: tleper | last post by:
hi, there are two win2003 servers in the same workgroup. one has mssql 2000 server and other one has asp.net 2.0 web application connecting that mssql server. mssql server Authentication is SQL...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.