|
Home > Archive > BizTalk Server Setup > February 2005 > BizTalk with MSDE
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]
|
|
|
| Hi,
I am not sure how to set up BizTalk with MSDE. Apparently the partner
edition can be used with MSDE - but how to install MSDE and how to configure
BizTalk to use it? I have only ever configured BizTalk to use SQL Server
Developer/Standard edition.
Thanks
| |
| Goutham[MSFT] 2005-01-28, 5:49 pm |
| Xerox,
MSDE needs to be installed separately, i believe it ships with Visual
studio, or you can find it on microsoft download site. here is the link to
MSDE 2000A.
http://www.microsoft.com/downloads/...44d1-a0bc-479f-
bafa-e4b278eb9147&DisplayLang=en
Once you install MSDE, install BizTalk and the only thing you may need to
worry about is enabling TCP/IP and Named pipes for MSDE. here are the
instructions from the installation giude.
------------------------------------------
Configuration fails when using Microsoft SQL Server 2000 Desktop Engine
(MSDE) instance
If you use an MSDE instance for BizTalk databases, you must enable TCP/IP
and namepipe protocols to configure BizTalk Server 2004 successfully.
Otherwise, connections to BizTalk Server 2004 Web services will fail.
To enable TCP/IP and namepipe protocols, in SQL Enterprise Manager,
right-click MSDE, click Properties, and then select Network Configuration
or run the following utility at the command prompt:
\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
------------------------------------------
Please reply if you have problems
regards
-g
This posting is provided "AS IS" with no warranties, and confers no rights.
"Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
| |
|
| Thanks for your guidance
"Goutham[MSFT]" <goutham@online.microsoft.com> wrote in message
news:FD5hVnVBFHA.3048@cpmsftngxa10.phx.gbl...
> Xerox,
> MSDE needs to be installed separately, i believe it ships with Visual
> studio, or you can find it on microsoft download site. here is the link to
> MSDE 2000A.
>
>
http://www.microsoft.com/downloads/...44d1-a0bc-479f-
> bafa-e4b278eb9147&DisplayLang=en
>
> Once you install MSDE, install BizTalk and the only thing you may need to
> worry about is enabling TCP/IP and Named pipes for MSDE. here are the
> instructions from the installation giude.
> ------------------------------------------
> Configuration fails when using Microsoft SQL Server 2000 Desktop Engine
> (MSDE) instance
> If you use an MSDE instance for BizTalk databases, you must enable TCP/IP
> and namepipe protocols to configure BizTalk Server 2004 successfully.
> Otherwise, connections to BizTalk Server 2004 Web services will fail.
>
> To enable TCP/IP and namepipe protocols, in SQL Enterprise Manager,
> right-click MSDE, click Properties, and then select Network Configuration
> or run the following utility at the command prompt:
>
> \Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
> ------------------------------------------
>
> Please reply if you have problems
> regards
> -g
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
| |
| Heinz Wehner 2005-02-03, 5:49 pm |
| Goutham,
do you know how to re-run the configuration of BTS2004 after having
enabled the TCP/IP and Named Pipes protocols for MSDE2000?
Heinz Wehner
(Karlsruhe, Germany)
On Fri, 28 Jan 2005 16:52:53 GMT, goutham@online.microsoft.com
(Goutham[MSFT]) wrote:
> Xerox,
> MSDE needs to be installed separately, i believe it ships with Visual
> studio, or you can find it on microsoft download site. here is the link to
> MSDE 2000A.
>
> http://www.microsoft.com/downloads/...&DisplayLang=en
>
> Once you install MSDE, install BizTalk and the only thing you may need to
> worry about is enabling TCP/IP and Named pipes for MSDE. here are the
> instructions from the installation giude.
> ------------------------------------------
> Configuration fails when using Microsoft SQL Server 2000 Desktop Engine
> (MSDE) instance
> If you use an MSDE instance for BizTalk databases, you must enable TCP/IP
> and namepipe protocols to configure BizTalk Server 2004 successfully.
> Otherwise, connections to BizTalk Server 2004 Web services will fail.
>
> To enable TCP/IP and namepipe protocols, in SQL Enterprise Manager,
> right-click MSDE, click Properties, and then select Network Configuration
> or run the following utility at the command prompt:
>
> \Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
> ------------------------------------------
>
> Please reply if you have problems
> regards
> -g
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
| |
| Goutham[MSFT] 2005-02-07, 5:54 pm |
| Heinz,
When you say "how to rerun configuration", i assume you are asking how you
can invoke the configuration program?
just run configframework.exe in the biztalk program directory. If this is
not what you are looking for, please let me know.
thank
-g
This posting is provided "AS IS" with no warranties, and confers no rights.
"Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
| |
| Heinz Wehner 2005-02-14, 5:50 pm |
| Goutham,
> When you say "how to rerun configuration", I assume you are asking
> how you can invoke the configuration program?
Yes, that's correct. I'm hoping that this will fix what couldn't be
done at installation time: creation of BizTalk databases, installation
of BizTalk NT services and so forth.
> Just run ConfigFramework.exe in the BizTalk program directory.
> If this is not what you are looking for, please let me know.
This is definitely what I was looking for. I was able to succesfully
step through all pages of the configuration assistant, save the
entered data and start the configuration process. Unfortunately, this
process was rolled back at the point where it failed to start the NT
service for Single Sign On (ENTSSO).
The question now is if I can overcome this hurdle. I'm running on
Windows XP Home (!) rather than on Windows Server 2003 and there's
also no SSO server running, neither on the XP system nor in my home
network. How to configure SSO to complete the configuration process?
Is that at all possible?
BTW, the databases used by BizTalk have been created with MSDE 2000.
This confirms that BizTalk can be run on MSDE 2000 provided TCP/IP and
Named Pipes are enabled. A fully-fledged SQL Server 2000 (or higher)
is not required.
Regards,
Heinz
> On Thu, 03 Feb 2005 18:25:15 +0100,
> Heinz Wehner <hwehner@hotmail.com> wrote:
>
> Goutham,
>
> do you know how to re-run the configuration of BTS2004 after having
> enabled the TCP/IP and Named Pipes protocols for MSDE2000?
>
> Heinz Wehner
> (Karlsruhe, Germany)
>
>
> On Fri, 28 Jan 2005 16:52:53 GMT,
> goutham@online.microsoft.com (Goutham[MSFT]) wrote:
>
> Xerox,
>
> MSDE needs to be installed separately, I believe it ships with Visual
> studio, or you can find it on Microsoft download site. here is the link to
> MSDE 2000A.
>
> http://www.microsoft.com/downloads/...&DisplayLang=en
>
> Once you install MSDE, install BizTalk and the only thing you may need to
> worry about is enabling TCP/IP and Named Pipes for MSDE. here are the
> instructions from the installation giude.
>
> ------------------------------------------
> Configuration fails when using Microsoft SQL Server 2000 Desktop Engine
> (MSDE) instance:
>
> If you use an MSDE instance for BizTalk databases, you must enable TCP/IP
> and Named Pipes protocols to configure BizTalk Server 2004 successfully.
> Otherwise, connections to BizTalk Server 2004 Web services will fail.
>
> To enable TCP/IP and Named Pipes protocols, in SQL Enterprise Manager,
> right-click MSDE, click Properties, and then select Network Configuration
> or run the following utility at the command prompt:
>
> \Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
> ------------------------------------------
>
> Please reply if you have problems.
>
> Regards
> -g
| |
| Goutham[MSFT] 2005-02-15, 5:50 pm |
| Heinz,
The SSO server mentioned in the configuration is the Enterprise Single Sign
On module that is shipped with BizTalk.
Do you see any events in the event log?
Additionally, in the C:\Documents and Settings\<YOUR USER NAME>\Local
Settings\Temp directory, you will find a log of the configuration named as
Config(XXXXXXXX).log. Can you attach the latest log of the configuration
for us to take a look at?
Meanwhile i shall ask around.
BTW, if you even want to attempt to run the configuration again, you should
make sure you delete all the user databases that are created by BizTalk
from your MSDE.
Regards,
-g
This posting is provided "AS IS" with no warranties, and confers no rights.
"Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
| |
|
|
|
|
|