July 26th, 2002, 08:03 AM
connecting sql server remotely - urgent
i have MSsql server 2000 in my server.I have MSsql server 7 installed in my local machine which has access to internet.I would like to take a database backup from my server remotely.
In order to do that i tried to connect MsSql server from my local machine using ip number sql server user name and password.But it is not successfull.Do i need to have the same MsSql server 2000 in my local machine.
Could any one suggest me a way to achieve this.
Your help will be much appreciated.Thanks in advance.