|
Home > Archive > Commerce Server General > March 2004 > Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conne
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conne
|
|
| Ken Teong 2004-02-07, 9:37 am |
| Hi,
I tried to unpackage Retail2002 site into an environment with two
machine, one as web server (CS2002) and another as db server (SQL
2000). I faced no problem to unpackage the pup file as well as
accessing and configuring setting using BizDesk application.
However, when I tried to launch the retail2002 site, I get the
following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL
Server connection.
I have problem doing the same if I have everything setup in one
machine, i.e both web server (CS) and db in one machine.
Any help?
TIA,
Ken Teong
| |
| Andy Xu[MSFT] 2004-03-04, 3:36 pm |
| Hello, Ken,
from the error message, it looks like the IIS process identity whcih your retail2002 site is running under does not have permission to connect to SQL server. The runtime site (retail2002) allowes the anonymous
access, so you need to check the IIS setting of that web site., go to start menu --> run --> input "inetmgr" --> open "default web site", right click retail2002 node and open the properties page.
Now it depends on what version of IIS you are using. If you are using IIS5, go to "Directory Security" tab, click "Edit" and then edit the "account used for anonynous access". If you are using IIS6, get the application
pool name from web site's properties page and open the properties page of that application pool and configure the application pool identity.
The identity you configure should have access to commerce databases. refer to "Securing your site" --> "Securing your databases" in commerce server 2002 documentation for best practice of secure
deployment. If your case (separate machine for web server and db server), you probably want to use a domain account as IIS process identity.
The reason your bizdesk works is because bizdesk web site disallows the anonymous access so logoned user is probably the domain account, who is probably already having access to commerce databases.
HTH,
-- Andy
--------------------
From: kenteong@hotmail.com (Ken Teong)
Newsgroups: microsoft.public.commerceserver.general
Subject: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Date: 5 Feb 2004 20:04:36 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <74b6d3da.0402052004.58deb6f4@posting.google.com>
NNTP-Posting-Host: 203.121.62.133
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1076040277 18826 127.0.0.1 (6 Feb 2004 04:04:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 6 Feb 2004 04:04:37 +0000 (UTC)
Path: cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!
postnews1.google.com!not-for-mail
Xref: cpmsftngxa07.phx.gbl microsoft.public.commerceserver.general:13117
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
I tried to unpackage Retail2002 site into an environment with two
machine, one as web server (CS2002) and another as db server (SQL
2000). I faced no problem to unpackage the pup file as well as
accessing and configuring setting using BizDesk application.
However, when I tried to launch the retail2002 site, I get the
following error:
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL
Server connection.
I have problem doing the same if I have everything setup in one
machine, i.e both web server (CS) and db in one machine.
Any help?
TIA,
Ken Teong
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
|
|
|
|
|