SQLServer port change

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQLServer port change

SQLServer port change

Rate Topic

Display Mode

Topic Options

Author

Message

durai nagarajan

Posted Wednesday, October 24, 2012 8:26 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:05 AM
Points: 856, Visits: 2,115

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

Lowell

Posted Wednesday, October 24, 2012 8:47 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:41 PM
Points: 11,648, Visits: 27,760

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1376523

durai nagarajan

Posted Wednesday, October 24, 2012 8:55 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:05 AM
Points: 856, Visits: 2,115

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 »

Permissions