Installing SQL Server Express 2005 via Remote Desktop

Hi,

Does anyone know if it's at all possible to install SQL Server Express 2005 over a Remote Desktop on a Windows XP machine.

I know there are problems running SQL over Remote Desktop, in that it won't start up a User Instance, but I wasn't sure if we can install over Remote Desktop.

If it's not possible, can anyone point me to an official document stating this fact?

Thanks

Sam

Yes, this is most certainly possible. If you encounter an error during install, please share the logs (%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log)so we can take a look.|||

Hi Jeff,

I've just been able to confirm that installing SQL via Remote Desktop is possible.

Our application requires user instances, and so after installation I then tried running our application via Remote Desktop. However, it came up with an exception "Failed to generate a user instance of SQL Server..."

I then went directly onto the remote machine and ran our application, and it worked perfectly fine.

So remote installation was fine, but running remotely with user instances is a problem.

Thanks
Sam