How do I setup a remote MSSQL server ?

[mdscorp]

I want to get a new server with plesk, my server provider tells me is not possible to set it up so plesk can use a remote mssql server instead of a local one.
Has anybody set it up like this ?

thanks

 

[Gris@]

Plesk can use remote MSSQL server but you will not be able to backup it via Plesk.