Windows Server

Cignul9 · Guest

Yeah this one was tough. Microsoft documentation seems to just assume
it will work and I couldn't find a newsgroup post that explained how to
do it. The problem everyone has is that when you install the
Ultrasound part it complains that it can't connect to the database (I
think it was "Ultrasound: Database Deployment Error"). I finally
figured it out and thought I share how I did it here.

Here are the basic steps that worked for me. Now, I installed all this
on a Windows 2000 server and I'm assuming you're working with one
machine for both the client and server piece of Ultrasound, but the
last steps describe how you break out the client to another box (in my
case Windows XP).

1. Download and extract Ultrasound
(http://www.microsoft.com/downloads/details.aspx?FamilyID=61acb9b9-c354-4f98-a823-24cc0da73b50&DisplayLang=en).
2. Download, extract and install MSDE2000A.exe
(http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/MSDE2000A.exe)
(Run "<path>\setup.exe" SAPWD="s3curP@ss").
3. Apply the SQL 2000 Service Pack 3 for MSDE
(http://download.microsoft.com/download/8/7/5/875e38ea-e582-4ee2-9485-b459cd9c0082/sql2kdesksp3.exe).
4. Install .NET Framework from Windows Update
(http://windowsupdate.microsoft.com/), but do NOT apply the .NET
Framework service pack after you reboot. If you already have SP1 on
your .NET Framework, you can uninstall .NET and reinstall it from
Windows Update. The reason you don't install SP1 on the Framework is
because it breaks the authentication screen of the Cassini web server
you get when you install Microsoft SQL Web Data Administrator, but I
hear there's an alternate version that doesn't use .NET at all, but
rather runs on IIS. If you go that route, I hope you'll post up and
tell us how it went.
5. Download and install Microsoft SQL Web Data Administrator
(http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en).
This link might install the version that integrates with IIS. I
haven't tried that one, but it should work nicely. If you use try
the one I installed it needs the .NET Framework installed as I've
described in the fourth step. Start the service on a port other than
80 if you've already got a web server installed. You don't
actually need this tool for an Ultrasound install, but it's free and
will adequately allow you to look at your MSDE without needing to buy a
3rd party app or use that gawd-awful osql command line tool.
6. Install Ultrasound, but when it asks you for your database
server/instance enter "(local)" with the parentheses but without
the quotes.
OR
7. Before you install Ultrasound run SVRNETCN.exe (it's an MSDE
utility; the default path to it is C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SVRNETCN.exe) and add TCP/IP to the "Enabled
protocols" list. Then when you install Ultrasound you can enter your
server name in the database server dialog. You can actually do both;
that is enable TCP/IP but still use "(local)" to connect you to the
database on the local server. If you do, then on the server the client
piece of Ultrasound will not use a network socket to connect to the
database, but you can still install the Ultrasound client on another
machine (like your workstation) and point it to the MSDE server.

Hopefully this is short, but clear. Ultrasound rocks! I don't know
how DFS would be doable without it.

	Windows Server Forum Index -> DFS and FRS	All times are GMT
Page 1 of 1