has anyone had the opportunity to try the sql web admin tool? if so, i have one question.
How can i use this to connect to a remote sql/msde server?
in the server textbox on the login screen i try 'machine name'\'instance name', along with the sa username and password. This does not work however.
am i just entering the wrong value , or do i need to change the code of the .connect method to allow for remote connections?
TIA.
-C-By "does not work", do you mean you are getting an error?
I have been successful using Web Data Administrator to connect to a remote database. The remote database must have mixed authentication (SQL Server and Windows). and you must be using a valid login and password. I accessed the server using the IP address.
As an additional point, I was VPN authenticated on the remote network before connecting.
Terri
