October 26, 2007 at 1:38 pm
Our service provider just setup a SQL Server farm for us and we are moving several databases to an instance on this farm. The application folks have found that you must specify the port number in the connection string to connect to the named instance. This is expected, correct? There is no way around specifying the port number? We are worried that if the application is redeloyed, we may forget about this port issue.
October 27, 2007 at 10:22 am
You can connect to the named instance as
servername\instancename,portnumber
Default the TCP\IP port number is 1433
Regards..Vidhya Sagar
SQL-Articles
October 29, 2007 at 8:17 am
You may be able to avoid using the port number if you upgrade MDAC to 2.6 or later. See http://support.microsoft.com/kb/265808 for more info
Francis
November 2, 2007 at 12:19 am
You need not need to do this if yopu have your client configuration referring to the particular port in the application server. I will create an alais of the server and use it in the application config file.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply