|
Home > Archive > Commerce Server Solution Sites > February 2004 > Login failed for user '(null)'. Reason: Not associated with a trusted
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
|
|
| Ken Teong 2004-02-07, 9:39 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
| |
| Max Akbar 2004-02-07, 9:39 am |
| Most likely it's that you are using IUSR account for your IIS and that
account doesn't have any access to your SQL. Just for testing purposes in
your IIS server open Commerce Server manager and set all connection strings
with a sql account like sa or some other account that has dbo permissions to
your database.
Good luck,
-Max
"Ken Teong" <kenteong@hotmail.com> wrote in message
news:74b6d3da.0402052006.2707ad5a@posting.google.com...
> 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
| |
| Ken Teong 2004-02-08, 12:35 pm |
| Thanks Max.
I changed the connection string to use SQL authentication instead,
i.e. to use sa account, from Commerce Server Manager Properties, but I
get the following error message now,
Source:Microsoft OLE DB Provider for SQL ServerDescription:Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Hope that it would give you better idea what go wrong with my system.
TIA,
Ken Teong
"Max Akbar" <maximum2000@hotmail.com> wrote in message news:<#7vTrrG7DHA.3704@tk2msftngp13.phx.gbl>...[color=blue]
> Most likely it's that you are using IUSR account for your IIS and that
> account doesn't have any access to your SQL. Just for testing purposes in
> your IIS server open Commerce Server manager and set all connection strings
> with a sql account like sa or some other account that has dbo permissions to
> your database.
>
> Good luck,
> -Max
>
>
>
> "Ken Teong" <kenteong@hotmail.com> wrote in message
> news:74b6d3da.0402052006.2707ad5a@posting.google.com...
| |
| Max Akbar 2004-02-08, 1:35 pm |
| You will need to do this with all your resources that have a connection
string this include the global resources as well. One thing to note is that
in your profiles global resource you will need to navigate down to
DataSource and change that connection string as well.
Good luck,
-Max
"Ken Teong" <kenteong@hotmail.com> wrote in message
news:74b6d3da.0402081800.2bfcb8c8@posting.google.com...
> Thanks Max.
>
> I changed the connection string to use SQL authentication instead,
> i.e. to use sa account, from Commerce Server Manager Properties, but I
> get the following error message now,
>
> Source:Microsoft OLE DB Provider for SQL ServerDescription:Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> Hope that it would give you better idea what go wrong with my system.
>
> TIA,
> Ken Teong
>
>
> "Max Akbar" <maximum2000@hotmail.com> wrote in message
news:<#7vTrrG7DHA.3704@tk2msftngp13.phx.gbl>...[color=blue]
in[color=blue]
strings[color=blue]
permissions to[color=blue]
| |
| Ken Teong 2004-02-10, 1:36 pm |
| Thanks Max. I managed to get the site up after changed all the
connection string including the last one you mentioned. It works by
using SQL security (i.e. sa account), but I would like to use windows
authentication instead, how would I set it?
I've tried to change all connection string back to NT integrated
security and changed machine.config's processmodel tag to use domain
account. I also changed IIS security to use windows authentication.
But I get the same error now.
Any idea?
"Max Akbar" <maximum2000@hotmail.com> wrote in message news:<ORpROLr7DHA.1632@TK2MSFTNGP12.phx.gbl>...[color=blue]
> You will need to do this with all your resources that have a connection
> string this include the global resources as well. One thing to note is that
> in your profiles global resource you will need to navigate down to
> DataSource and change that connection string as well.
>
> Good luck,
> -Max
>
> "Ken Teong" <kenteong@hotmail.com> wrote in message
> news:74b6d3da.0402081800.2bfcb8c8@posting.google.com...
> news:<#7vTrrG7DHA.3704@tk2msftngp13.phx.gbl>...
> in
> strings
> permissions to
| |
| Ken Teong 2004-02-10, 8:35 pm |
| hi Max,
I have explored further by changing the application pool of IIS to use
domain account too. and by doing this, it solves the earlier error but
I get a new error message, i.e.
"Source:Microsoft OLE DB Provider for SQL ServerDescription:SELECT
permission denied on object 'sysobjects', database
'Retail2002_commerce', owner 'dbo'. "
I believe this is SQL security related. I have checked that the domain
account used has SELECT right to sysobjects table since it is in
public role.
Any idea?
TIA,
Ken Teong
kenteong@hotmail.com (Ken Teong) wrote in message news:<74b6d3da.0402101820.39d4e60d@posting.google.com>...[color=blue]
> Thanks Max. I managed to get the site up after changed all the
> connection string including the last one you mentioned. It works by
> using SQL security (i.e. sa account), but I would like to use windows
> authentication instead, how would I set it?
>
> I've tried to change all connection string back to NT integrated
> security and changed machine.config's processmodel tag to use domain
> account. I also changed IIS security to use windows authentication.
> But I get the same error now.
>
> Any idea?
>
>
> "Max Akbar" <maximum2000@hotmail.com> wrote in message news:<ORpROLr7DHA.1632@TK2MSFTNGP12.phx.gbl>...
> news:<#7vTrrG7DHA.3704@tk2msftngp13.phx.gbl>...
> in
> strings
> permissions to
| |
| Max Akbar 2004-02-10, 11:36 pm |
| Commerce Server has a whole set of security instruction that you can follow
but for now to make your site work make the domain account dbo in
Retail2002_commerce, MSCS_CatalogScratch and MSCS_Admin. Once this works
then follow the help file "Securing Your Site" instruction on how to make
your site secure.
Good luck,
-Max
"Ken Teong" <kenteong@hotmail.com> wrote in message
news:74b6d3da.0402110119.7e858e7f@posting.google.com...
> hi Max,
>
> I have explored further by changing the application pool of IIS to use
> domain account too. and by doing this, it solves the earlier error but
> I get a new error message, i.e.
>
> "Source:Microsoft OLE DB Provider for SQL ServerDescription:SELECT
> permission denied on object 'sysobjects', database
> 'Retail2002_commerce', owner 'dbo'. "
>
> I believe this is SQL security related. I have checked that the domain
> account used has SELECT right to sysobjects table since it is in
> public role.
>
> Any idea?
>
> TIA,
> Ken Teong
>
>
> kenteong@hotmail.com (Ken Teong) wrote in message
news:<74b6d3da.0402101820.39d4e60d@posting.google.com>...[color=blue]
news:<ORpROLr7DHA.1632@TK2MSFTNGP12.phx.gbl>...[color=blue]
connection[color=blue]
that[color=blue]
I[color=blue]
system.[color=blue]
that[color=blue]
purposes[color=blue]
connection[color=blue]
two[color=blue]
(SQL[color=blue]
trusted[color=blue]
| |
| Ken Teong 2004-02-11, 12:36 pm |
| hi Max,
I've already made the domain account db_owner of Retail2002_commerce,
MSCS_CatalogScratch and MSCS_Admin and I got the same error, i.e.
"SELECT permission denied on object 'sysobjects', database
'Retail2002_commerce', owner 'dbo'."
TIA,
Ken Teong
"Max Akbar" <maximum2000@hotmail.com> wrote in message news:<ORW1s4J8DHA.3448@TK2MSFTNGP09.phx.gbl>...[color=blue]
> Commerce Server has a whole set of security instruction that you can follow
> but for now to make your site work make the domain account dbo in
> Retail2002_commerce, MSCS_CatalogScratch and MSCS_Admin. Once this works
> then follow the help file "Securing Your Site" instruction on how to make
> your site secure.
>
> Good luck,
> -Max
>
>
> "Ken Teong" <kenteong@hotmail.com> wrote in message
> news:74b6d3da.0402110119.7e858e7f@posting.google.com...
> news:<74b6d3da.0402101820.39d4e60d@posting.google.com>...
> news:<ORpROLr7DHA.1632@TK2MSFTNGP12.phx.gbl>...
> connection
> that
> I
> system.
> news:<#7vTrrG7DHA.3704@tk2msftngp13.phx.gbl>...
> that
> purposes
> in
> connection
> strings
> permissions to
> two
> (SQL
> trusted
| |
| Max Akbar 2004-02-11, 1:37 pm |
| Run sql profile and see what account is trying to access the sql object as
you may not have the right account set for access.
Regards,
-Max
"Ken Teong" <kenteong@hotmail.com> wrote in message
news:74b6d3da.0402111744.3743381f@posting.google.com...
> hi Max,
>
> I've already made the domain account db_owner of Retail2002_commerce,
> MSCS_CatalogScratch and MSCS_Admin and I got the same error, i.e.
>
> "SELECT permission denied on object 'sysobjects', database
> 'Retail2002_commerce', owner 'dbo'."
>
> TIA,
> Ken Teong
>
>
> "Max Akbar" <maximum2000@hotmail.com> wrote in message
news:<ORW1s4J8DHA.3448@TK2MSFTNGP09.phx.gbl>...[color=blue]
follow[color=blue]
make[color=blue]
windows[color=blue]
note is[color=blue]
instead,[color=blue]
but[color=blue]
SQL[color=blue]
and[color=blue]
[color=blue]
with[color=blue]
as[color=blue]
the[color=blue]
a[color=blue]
one[color=blue]
|
|
|
|
|