Remote Access To Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Remote Access To Database

Author

Topic

rajeshkumar77
Starting Member

46 Posts

Posted - 2001-12-06 : 02:46:17

Hi
I am using Sql Server 2000 on win2kserver
I have a doubt.
Is it possible to access my database by the Remote user using ip address and port no ?
If it is possible please tell me the mechanism behind it.
What are the possible ways to connect to that Database and to access the data
and on what purpose this will use.
thanxinadvance
this doubt is somewhat strange
ok bye
Yours
Rajesh

Andraax
Aged Yak Warrior

790 Posts

Posted - 2001-12-06 : 05:42:35

Hello Rajesh,

You can connect by using TCP port 1433 (by default).

rajeshkumar77
Starting Member

46 Posts

Posted - 2001-12-06 : 21:33:39

Dear Andraax

Can u please tell me how can i connect to remote database using TCP Port 1433

do i need to use query analyzer or enterprise manager to connect to remote database

if possible please tell me

Thanks in advance

Yours

Rajesh

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-06 : 21:44:48

quote:

do i need to use query analyzer or enterprise manager to connect to remote database

Yes. Seeing as the default port is 1433, all you probably need to do is put the address/name of the server in to your connection dialog on these tools.

Damian

Tim
Starting Member

392 Posts

Posted - 2001-12-06 : 23:58:50

i conenct remotely to the sql server at my web hosting service provider.

I just registered the server in EM providing the server address and authentication details.

It works fine, although a bit slow to display all the databases.

-------------------------------
Visit nr's cursor wonderland

rajeshkumar77
Starting Member

46 Posts

Posted - 2001-12-07 : 06:53:11

Dear Tim

In Enterprise Manager, Can u please specify option which is used to connect the remote server

Thankyou VeryMuch

Yours
Rajesh

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-07 : 07:41:03

Hi

Did you try "New Server Registration" ?
I suggest you spend some time reading the "Books Online" documentation. There is lots of good stuff there.

Damian

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources