Discussion Locked

How can i connect to remote SQL Server?

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to connect to remote SQL Sever locatted at my corporate head office. I had all the permissions to do all operation on the server. I have internet connection. I have to create database on that server.
My OS is Window-NT.
How can i do this?

7 replies

by rsutton

Have you installed SQL Client utilities on your PC? If not do so then try to register it with either the name or IP Address of the server. If it won't see it try to ping it.

by mukul_gandhi

I think if u can do telnet to SQL server m/c from ur PC, it is possible to operate on database directly. But with SQL Server client utility on ur PC(even if ur connected to Internet), u might not be able to operate on database directly. Usability of2nd option depends whether ur corporate head office has any restrictions for accessing database server through firewalls.

regards
-mukul

by headbangerphil

just loaded SQL into NT, had trouble with the dual authentication process, so we returned to preferences and set authentication to SQL only, it worked, give it a try, perhaps you'll get same results.. hbp

This discussion is closed to new replies.