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)
 Register SQL Server remotely without alias?

Author  Topic 

fasttrack
Starting Member

12 Posts

Posted - 2006-08-03 : 12:58:41
I woluld like to solve my problem:

clients are on different network from SQL server. Clients connect to DB server by router (windows server 2003).

Clients ping DB server,

clients open telnet connection to db server.

Problem:

I try to register SQL server on Clients, but It fails: database does not exist or not perinssion (something like that).

So I open network utility I set up an alias with the ip address of server and ports and I registered the server.(I had to set port, otherwise registering fails).



Do you know how to registered SQL server on client without using alias????

thank

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-03 : 13:20:41
are these named instances? If so, you might have UDP port 1434 blocked (which is probably still a good idea).

the alias might be your only solution in this case.



-ec
Go to Top of Page
   

- Advertisement -