Re: Installation problem

Morten,
I tried all that but no luck..I requested to reimage my server.
my sql server is on the same box as biztalk. and I am local admin on that
box..

Some where it went wrong. i dont want to waste more time on this so I am
creating fresh image.

Thanks for your help

"Morten" wrote:

On Sep 22, 4:11 pm, FQ <F...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
yes, user is part of Biztalk admin group and also has sysadmin access in sql.
dont understand whats wrong.

I checked the sql log most of the times it says user logged in successfully
but only couple of times it says user failed to log in

Error: 18456, Severity: 14, State: 16.

"Steve Harclerode" wrote:
Have you added the user to the BizTalk Server Administrators group? Being an
administrator on the system is not enough.

- Steve

"FQ" <F...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:907DAEAE-9A53-4E27-977A-56371F3BEA8C@xxxxxxxxxxxxxxxx
Hi,
I am trying to configure biztalk and got the following error :

'Group' configuration is always failing and complaining that 'cannot
create
biztalkmgmtdb. system.sql.sqlclient threw an error'.

i checked the sql logs and it shows that the error is

Error: 18456, Severity: 14, State: 16.
2008-09-19 15:36:41.17 Logon Login failed for user
'domain\useracct'.
[CLIENT: <local machine>]

this user is administrator on the system and sysadmin permissions on the
DB.

my initial installation is working fine but then i had a issue with
machine.config to fix that I started reinstallation.

please let me know if you have faced this issue before.

Thanks

Hi FQ

I have had the same problem when configuring BAM. Even though
everything was setup and configured like it should be:
(User being sa, local admin on BizTalk server, part of SSO
Adminitrators and BizTalk Administrators, MSDTC setup etc. etc.) I
still needed the user running the BizTalk configuration to be local
admin on the SQL Server as well, otherwise I got the exact same error
"Error: 18456, Severity: 14, State: 16."
I my case (BAM config) I noticed that 3 of the 4 DB's were actually
created and the error didn't occur until the configuration started on
the 4th!

I have a virtual environment that I use for educational purposes, so I
do the same tasks over and over, and so far it seems random! as to
when I experience the error and when I can do the configuration
without being local admin on SQL.

So if you are/have:
-sa on SQL
-Local Admin on BizTalk
-MSDTC configured on both SQL and BizTalk.
-Member of BizTalk Admin (and SSO Admin, but I presume that SSO is
already configured properly)

You could try making the user local admin on SQL as well.

Morten la Cour




.

Relevant Pages

  • Re: BizTalk server Topology & scalibilty
    ... BizTalk itself is 'stateless' and so can run on any machine that has access ... host instances is unrelated to the distribution of databases across SQL. ... could have all dbs installed on a single SQL server, or each on its own SQL ... > configuration of hosts. ...
    (microsoft.public.biztalk.server)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... I have problem to pass the SSO setup during the configuration process. ... > and trying to configure this server 2nd. ... > the SSO server needs to be the first server configured in a BizTalk group. ... Do you mean that your SQL Server is on different box from the ...
    (microsoft.public.biztalk.general)
  • Re: Installation problem
    ... I checked the sql log most of the times it says user logged in successfully ... (User being sa, local admin on BizTalk server, part of SSO ... created and the error didn't occur until the configuration started on ...
    (microsoft.public.biztalk.general)
  • RE: BizTalk server Topology & scalibilty
    ... within the BizTalk engine across multiple engines on different servers. ... Hugo points out BizTalk is stateless, that is to say all state is maintained ... only in the SQL server databases (unless one inadvertently starts creating ... > this configuration) servers running SQL in cluster. ...
    (microsoft.public.biztalk.server)
  • BizTalk server Topology & scalibilty
    ... Looking through the BizTalk documentation and books I see recommended ... Single server: Single server runs ALL BizTalk and SQL operations ... A single server runs SQL while another runs all BizTalk ... this configuration) servers running SQL in cluster. ...
    (microsoft.public.biztalk.server)
Quantcast