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 Administration (2000)
 Registering databses-same IP-different ports

Author  Topic 

achintya
Starting Member

1 Post

Posted - 2006-06-01 : 03:27:14
Hi,

I want to register 2 SQL server databases which points to same IP address but are accessing different ports. Please guide as to how shell I accomplish it?

You can mail me at achintya.gupta@india.birlasoft.com

This is an urgent requirement. I would be highly grateful if you guys could keep it on high priority.

Thanks and Regards,
Achintya

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-01 : 03:32:11
Specify as <IP Address>,<Port No>


KH

Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-01 : 03:47:21
register database where?

if you mean sql server instances, use the client network utility (client side) and server network utility (server side)

--------------------
keeping it simple...
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 2006-06-09 : 05:38:45
I think he meant let SQL server listening to 2 port instead of only 1 (by default)
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-06-12 : 03:13:13
then go to server network utility and add the port numbers, separated by comma

--------------------
keeping it simple...
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-06-12 : 07:22:10
I Think its best to register the different servers twice in the network utility. using TCP/IP

We manage about 6 servers, and have them all registered on my machine. However, it not a good practice to connect remotely over the internet.

Afrika
Go to Top of Page
   

- Advertisement -