|
Home > Archive > BizTalk Server > August 2005 > Biztalk 2006 SSO Default Configuration Failed
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 |
Biztalk 2006 SSO Default Configuration Failed
|
|
|
| Hi, I´m trying to install Biztalk 2006 and I get the following errors during
the default configuration process:
1) Enterprise SSO Failed
2) Biztalk Runtime Failed
Double-clicking the errors I get the following descriptions:
1)
TITLE: Microsoft BizTalk Server 2006 Configuration Wizard
------------------------------
Failed to connect to the SQL database SSODB on MY-MACHINE (An error occurred
while attempting to access the SSO database.
). (SSO)
For help, click:
http://go.microsoft.com/fwlink/even...vtSrc=SSO&EvtID
2)
TITLE: Microsoft BizTalk Server 2006 Configuration Wizard
------------------------------
Creation of Adapter EDI Configuration Store entries failed.
Could not contact the SSO server '244-BZT2006'. Check that the SSO service
is running on that server.
My machine: Windows Server 2003 Standard SP1, SQL 2000, and all
pre-requisites installed.
I'm using an account with administrative privileges for the account that
Biztalk Services will run under.
I´m quite new with Biztalk!
Any help?
| |
| Steve Jamieson [MSFT] 2005-08-23, 5:52 pm |
| Hi Lito -
You may have hit this known problem -
[vbcol=seagreen]
However, this apparently returns the name of the SQL Server at the time it
was configured – and not the current value - go figure! Thus, the SQL
Server name that we are getting from SQL is old – I guess it was changed on
these machines – so config is getting confused, it can’t create the
required local accounts.
To workaround it -
“To workaround this problem, change your SQL @@servername to match your
computer name. Instructions in SQL “Books Online”
Also, there will be a ConfigLog(<date> ).log file in your %temp% directory,
that might also give you further information.
I hope that helps.
--------------------[vbcol=seagreen]
during[vbcol=seagreen]
occurred[vbcol=seagreen]
r+2006&ProdVer=3.5.1070.0&EvtSrc=SSO&EvtID[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
|
| Hi Steve!
That was the problem!
I´ve changed the value of the @@servername variable using the sp_dropserver
and sp_addserver SPs:
1) exec sp_dropserver 'servername1'
2) exec sp_addserver 'my-machine', 'local'
3) restart sql server service
Thanks a lot!!
"Steve Jamieson [MSFT]" <stevejam@online.microsoft.com> wrote in message
news:4vzHFPAqFHA.472@TK2MSFTNGXA01.phx.gbl...
> Hi Lito -
>
> You may have hit this known problem -
>
> However, this apparently returns the name of the SQL Server at the time it
> was configured - and not the current value - go figure! Thus, the SQL
> Server name that we are getting from SQL is old - I guess it was changed
on
> these machines - so config is getting confused, it can't create the
> required local accounts.
>
> To workaround it -
>
> "To workaround this problem, change your SQL @@servername to match your
> computer name. Instructions in SQL "Books Online"
>
> Also, there will be a ConfigLog(<date> ).log file in your %temp% directory,
> that might also give you further information.
>
> I hope that helps.
>
>
> --------------------
> during
> occurred
>
> r+2006&ProdVer=3.5.1070.0&EvtSrc=SSO&EvtID
service[vbcol=seagreen]
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBusiness Server Team
>
|
|
|
|
|