Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServer port change Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 8:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 14, 2016 12:20 AM
Points: 1,060, Visits: 2,709
Hello,

i have tried and tested port number changes with luck now luckily going to production linked server is not working to a server where it is default port of 1433.

how to achieve succesful port change with linked server connections.

thanks in advance.



Regards
Durai Nagarajan
Post #1376514
Posted Wednesday, October 24, 2012 8:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:51 AM
Points: 13,971, Visits: 36,265
well there is two pieces of the puzzle.

IF the linked server is using dynamic ports, you need to have the SQl Browser Service running on the linked server. If it's not

running, or you know you've already configured that other instance to listen on a specific port, you just make sure to specify the port when creating the linked server:

EXEC master.dbo.sp_addlinkedserver 
@server = N'My2012LinkedServer',
@provider=N'SQLNCLI',
@srvproduct = N'',
@datasrc=N'DEV223\SQL2012,14330'

--Or
EXEC master.dbo.sp_addlinkedserver
@server = N'My2012LinkedServer',
@provider=N'SQLNCLI',
@srvproduct = N'',
@datasrc='192.168.0.55,14330'

you can use the SQL Configuration manager to change from dynamic to static ports:


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1376523
Posted Wednesday, October 24, 2012 8:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 14, 2016 12:20 AM
Points: 1,060, Visits: 2,709
thanks hope this will work from the server where i have changed the port number

i'll try and getback, thanks again.



Regards
Durai Nagarajan
Post #1376530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse