Upgrade DB to RDP 2.2 fails

[Andy Ogan]

I've been trying to get our RDP 2.1 setup upgraded to RDP 2.2 for some time now, and have run into a brick wall. During the upgrade process, the Database upgrade does not success, saying that "Setup was unable to run DBInstaller to update the eXpress database .. Cancelliing setup ..."

Some research has suggested that this is related to permissions on the SQL Database. I have checked that the account this upgrade is running under has db_owner permissions on the database, and I have done all previous upgrades of RDP under this account with the same SQL server, same instance, same DB.

I have tried uninstalling RDP completely, starting over on the RDP server end, tried multiple times to reinstall/upgrade, and nothing. Same error at the same point in time, every time.

All Windows Server 2003 setup, RDP 2.1 is the old version, going to 2.2. What makes it worse is 2.1 doesn't seem to want to reinstall to go back and try again another day, so I'm without an RDP server today and until I get a fix...

Any suggestions? Any way that I can possibly run the dbinstaller.exe manually? I don't see it in raw form on the CD anywhere...

Thanks in advance

[Andy Ogan]

I'm guessing after playing with this some more is that the problem deals with named instances of SQL Server. There isn't an option for dynamic TCP/IP ports during the RDP installation, and the instance name seems to get dropped from . Since that occurs, the SQL server cannot be found, and therefore, it does not/cannot run DBInstaller.exe.

Hopefully this gets fixed, or I find a workaround... this has killed my RDP setup for the time being.

[Astro2]

Hi
Try this

1. download MS "SQL Server Web Data Administrator" from http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
2. install it on RDP server
3. launch it
4. insert login/password (DOMAIN\Administrator)
5. if nothing appears, see http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=4358 (search clientScriptsLocation) for a fix. There's a problem if you're using .NET 1.1
6. when you've logged in, add the user Administrator (or the group Administrators) to the users that can connect to MSDE

Armando

[Andy Ogan]

I found that if I waited with an ODBC connection window open with the correct setup information ready during the install and punch it in right at the 31% mark, it works. It seems the install sets up the ODBC connection, does something else, then runs DBInstaller.exe, which of course pulls off of the ODBC connection.

Sad this is, I've duplicated this in my lab now...

Thanks!