Re: Domain/workgroup Server Configuration Issues

Todd,

We have an architecture with a BT 2006 server and 3 CS 2007 servers in a
workgroup (CS 2007 cannot be on a domain controller and we don't have
spare machines for that) separated from a SQL cluster that is on a domain.
When I try to configure the Enterprise SSO with the db on the cluster I
receive the following error:
"The SQL Server 'x.x.x.x' cannot be used with the SSO Administrator
account 'SSO Administrators'. Local accounts cannot be used with the
clustered SQL Servers"

When I try to configure the Enterprise Single Sign-On Service account, I
receive the following error when specifying the domain account from the
SQL cluster (I have tried using both local and domain accounts):
"Failed to validate the service logon information for account:
domain\biztalkuser (SSO) Additional information: (0x80070534) No mapping
between account names and security IDs was done. (Win32) <Exception
Message="The account name is invalid or does not exist, or the password is
invalid for the account name specified." Source="ConfigHelper"
HelpID="HelpIdValidateServiceLogon"/> (SSO)"

CS 2007 interacts with the dbs fine in this configuration. Is there a
good solution that doesn't require the BT/CS group to be on a domain? Or
should we consider moving the BT server to the domain with the SQL boxes?
I'm open to suggestions.

AFAIK, biztalk needs to be a part of the domain used for the biztalk
accounts and the sql server.


--
Tomas Restrepo
tomasr@xxxxxxxx
http://www.winterdom.com/


.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.setup)