How to report on a SQL Server on a non-standard port?

Article:TECH116102  |  Created: 2009-01-19  |  Updated: 2009-01-08  |  Article URL http://www.symantec.com/docs/TECH116102
Article Type
Technical Solution


Issue



How to connect and report on a SQL Server running behind a DMZ on a non-standard port?


Solution



Step 1. Create an alias from the Bindview Information Server to connect to the SQL Server on non-standard port. Please follow the steps below:

1. Open SQL Server Configuration Manager tool.
2. Under the SQL Server Native Client folder, right click on the “Aliases” item and select the “New Aliases” item. When doing this the “Alias – New” dialog box will be displayed.
3. In the new alias dialog box, you can create an alias where you can specify the Alias name, Server name, port number. The port number should be the non-
standard port the target SQL Server is configured.

Step 2. Use the 'Add SQL Server from File' option in the Bv Control for SQL Server configuration wizard to import that SQL Server.

1. Open RMS Console and run the BV Control for SQL Server configuration wizard.
2. In the first screen, you click Add SQL Servers from File to specify a list of SQL servers that the product has not detected.
3. To add servers from a file, you navigate to the file (containing the list of SQL servers) on your computer and click Open. The SQL servers appear in the Available SQL Severs list. The file must be a plain text file. The formats (extensions) supported are CSV, DAT, and TXT. The format of the file must be:
Domain name, Alias name
4. Run through the configuration wizard and enter the correct credentials for the alias that are actually the credentials for connecting to the target server.




Technical Information
http://www.databasejournal.com/features/mssql/article.php/3689846/Using-Non-Standard-Port-for-SQL-Server.htm




Legacy ID



2009082003235253


Article URL http://www.symantec.com/docs/TECH116102


Terms of use for this information are found in Legal Notices