Can't connect to the backend DB during re-install of Public from Private

I'm having a great deal of difficultyconnecting to SQL 2005 sp1 during the running of the deployment tool on the FE.. The error message indicates that I have to install the Backward compatible tool on the FE... Did that and upgraded SQL to SP1... Still a no-workie..Exactly what SQLs are compatible with the Public version of OCS... It worked fine with the Private version and SQL2005...What is FE and OCS ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

FE= front end server from the LCS or OCS

OCS=Office Communications Server

Cant connect remotely to SQL Express on Virtual Private Server

I've just bought a Virtual Private Server Account because I want to host a number of different ASP.NET sites, each backed by their own SQL database. I've downloaded SQLEXPRE.EXE and SQLServer2005_SSMEE-x64.msi to the server and installed the database engine and Management Studio Express on the VPS.

My problem is that I cannot access the SQLEXPRESS on my server from my local machine. The Management Studio Express cannot get logged in. I've used "Surface Area Configuration Manager" to allow "Local and remote connections" using TCP/IP only. I've used SQL Server Configuration Manager" to enable the TCP/IP protocol. After making these changes I've stopped and started the SQL server - and even rebooted the machine. I've created a login "Remote User" for this access. I've added sqlservr.exe as an exception to the firewall.

What else do I need to do? Is there a simpleton's guide to completing this task?

Did you start the sql server browsing service?

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277