Red Gate forums :: View topic - Aardvark 2 Issues
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Aardvark
Aardvark forum

Aardvark 2 Issues

Search in Aardvark forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Jason
Guest





PostPosted: Mon Feb 23, 2004 10:06 am    Post subject: Aardvark 2 Issues Reply with quote

Hi,

We tried to upgrade our SQL server from W2k to W2k3 over the weekend, but
have had several problems getting the front end web app talking to the SQL
server. Our web server is IIS5 running on W2k server. Our old SQL server is
on W2k, and the new server is W2k3.

The problem seems to be related to the ODBC connection. All the settings are
correct, and the connection tests okay, however, when pointed to this
server, Aardvark just refuses to run, "freezing" when you try log in.

When I start the COM objects, I get the following message in the web
server's event log:

MS DTC is unable to communicate with MSDTC on a remote system. No common RPC
protocol is supported between the two systems. Please Ensure that one or
more of the following RPC protocols are common to both systems: TCP/IP, SPX
or NetBEUI. Error Specifics: iomgrclt.cpp:203, CmdLine:
c:winntsystem32msdtc.exe PID 544

Both machines run ONLY TCP/IP, and both machines have the service started.
The built in firewall on the SQL server is disabled.

As a last resort, I have resorted to running everything under the domain
admin account, which has full access to the Aardvark database, and has been
configured as you say in the tech document. When I changed the ODBC
connection from the new server back to the old, Aardvark immediately started
working again.

Any help would be greatly appreciated, as we need to remove the old SQL
server as soon as we can.

Thanks,

Jason


Back to top
Brian Donahue



Joined: 23 Aug 2004
Posts: 6640

PostPosted: Fri Feb 27, 2004 3:26 pm    Post subject: Re: Aardvark 2 Issues Reply with quote

Hi Jason,

Welcome to wonderfully secure Windows Server 2003. I think I know what
the problem here is. By default, Windows 03 does not install the component
that allows COM+ to utilize DTC.

Under add/remove programs/windows components/application server/ enable
network COM+ and Enable Network DTC access.

Please let us know if this takes care of it.

Regards,

Brian Doanhue
Red Gate Technical Support

"Jason" <jasons@advaoptical.com> wrote in message
news:r5opQze%23DHA.1744@server53...
> Hi,
>
> We tried to upgrade our SQL server from W2k to W2k3 over the weekend, but
> have had several problems getting the front end web app talking to the SQL
> server. Our web server is IIS5 running on W2k server. Our old SQL server
is
> on W2k, and the new server is W2k3.
>
> The problem seems to be related to the ODBC connection. All the settings
are
> correct, and the connection tests okay, however, when pointed to this
> server, Aardvark just refuses to run, "freezing" when you try log in.
>
> When I start the COM objects, I get the following message in the web
> server's event log:
>
> MS DTC is unable to communicate with MSDTC on a remote system. No common
RPC
> protocol is supported between the two systems. Please Ensure that one or
> more of the following RPC protocols are common to both systems: TCP/IP,
SPX
> or NetBEUI. Error Specifics: iomgrclt.cpp:203, CmdLine:
> c:winntsystem32msdtc.exe PID 544
>
> Both machines run ONLY TCP/IP, and both machines have the service started.
> The built in firewall on the SQL server is disabled.
>
> As a last resort, I have resorted to running everything under the domain
> admin account, which has full access to the Aardvark database, and has
been
> configured as you say in the tech document. When I changed the ODBC
> connection from the new server back to the old, Aardvark immediately
started
> working again.
>
> Any help would be greatly appreciated, as we need to remove the old SQL
> server as soon as we can.
>
> Thanks,
>
> Jason
>
>


Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group