BizTalk Server General - Installing BizTalk Server 2006 and SQL Server 2005

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > April 2006 > Installing BizTalk Server 2006 and SQL Server 2005





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 Installing BizTalk Server 2006 and SQL Server 2005
mike48075@hotmail.com

2006-04-18, 12:46 am

Is it necessary to install MS BizTalk Server 2006 and MS SQL Server
2005 on the same machine?

Are SQL Server client tools (that come with BizTalk 2006) needed to
access databases on another machine?

Is it possible to use SQL Server 2005 client tools to access a SQL
Server 2000 database?

Tomas Restrepo \(MVP\)

2006-04-18, 12:46 am

Hi Mike,

> Is it necessary to install MS BizTalk Server 2006 and MS SQL Server
> 2005 on the same machine?


Nope. BizTalk can work with its databases on separate machines (in fact,
this is usually the recommended setup for performance reasons).

> Are SQL Server client tools (that come with BizTalk 2006) needed to
> access databases on another machine?


The BizTalk 2006 prerequisite cabs include all the necessary client tools
needed to install, included the ADOMD.NET updates and so on.

> Is it possible to use SQL Server 2005 client tools to access a SQL
> Server 2000 database?


I think so.


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


TimS

2006-04-18, 12:46 am

Hi Mike/Tomas, you can use SQL Server 2005 tools to access MS SQL Server 2000
databases. I do it all the time.

Tim

"Tomas Restrepo (MVP)" wrote:

> Hi Mike,
>
>
> Nope. BizTalk can work with its databases on separate machines (in fact,
> this is usually the recommended setup for performance reasons).
>
>
> The BizTalk 2006 prerequisite cabs include all the necessary client tools
> needed to install, included the ADOMD.NET updates and so on.
>
>
> I think so.
>
>
> --
> Tomas Restrepo
> tomasr@mvps.org
> http://www.winterdom.com/
>
>
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com