Familiar with CS 2002 and connection strings setup in config files. I can't
find where CS 2007 stores these. In CS Manager I've tested all DB connection
strings successfully.

What  else do I need to setup?

Thanks,

[ Post a follow-up to this message ]

Hi Dave,

Commerce Server 2007 and 2002 uses Windows authentication by default. The
IIS application pool identity will be the account to login and access
Commerce SQL Database. Therefore the problem shouldn't be on the connection
string since it's not using SQL authentication.

The error should be caused by Network Service account doesn't have
permission to access the SQL DB. It should be resolved by the following
steps:

1. Change the application pool identity from the default ("Network
Service") to a domain account you want to use with your Commerce
application.

2. Add the domain account to the web server local IIS_WPG group on the
Commerce server machine.

3. Grant the domain account (used in steps1) proper Database permissions on
the remote SQL server.

Of course, if the SQL is on the local machine, you can also grant Network
Service account with the database permission directly.

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

 ========================================
==========

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscript...t/default.aspx.

 ========================================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]

Hi Dave,

Have you get any progress or update on this issue?

Thanks.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

 ========================================
==========

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscript...t/default.aspx.

 ========================================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

[ Post a follow-up to this message ]