-
Title
How do I change the port number Spotlight uses to connect to the SQL Server? -
Description
Spotlight on SQL Server
I am not using the default port with SQL Server. How do I get Spotlight on SQL Server to connect with a different port? -
Resolution
You can use the 'Client Network Utility' that comes with SQL Server.
Open the 'Client Network Utility' by going to 'Start | Programs | Microsoft SQL Server | Client Network Utility'
Click on the 'Alias' tab.
Click the 'Add' button.
Server alias - Specify a unique name for the server running an instance of SQL Server that listens on the TCP/IP Sockets network library.
Select 'TCP/IP' as the Network Library.
Server name - Specify the instance of SQL Server that listens for TCP/IP Sockets clients.
Uncheck the 'Dynamically determine port' checkbox and enter the port your SQL Server is running on.
When connecting from Spotlight please use the Alias name you created as the 'Address' in the Connection Manager.
* If you do not have the 'Client Network Utility', please install it from the SQL Server CDs.