March 11, 2008 at 10:32 am
Our server has both a default and named instance of sql 2005 installed. Each uses a dedicated port and the "Sql Browser" is disabled. Using the Configuration Manager I can create an alias for the named instance and can access that instance from my local sql 2005 install using the alias. But when I try to register the instance in Management Studio the process times out. This makes sense -- unless I missed it, the normal server registration doesn't allow one to enter a port value.
Question: Assuming the Sql Browser is disabled and without using an alias, is it possible to register a named instance in a remote copy of sql 2005?
barkingdog
March 11, 2008 at 10:35 am
You can put in the port using the following syntax:
IPAddress,Port
or
Name,Port
As in
127.0.0.1,1542
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 11, 2008 at 3:12 pm
Works great. Thanks.
barkingdog
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply