Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Instance Reference
Message
 
 
To
21/09/2009 15:22:08
Greg Rowe
Memphis Police Department
Memphis, Tennessee, United States
General information
Forum:
Microsoft SQL Server
Category:
Installation
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01425486
Message ID:
01425557
Views:
60
A named instance is configured by default to use a dynamic port assignment and such ports can be blocked by a firewall. See http://msdn.microsoft.com/en-us/library/ms345327.aspx

>I have remote users who cannot access a new SQL instance that is running in a three node Windows 2003 server cluster. I and other users can access the SQL instance newname.domainname.ad\instancename. The external users successfully access the current DB server via an external IP address which is not running a SQL instance. However, the users unsuccessfully access the new SQL DB using a fully qualified server name with and without the instance name. Also, the users unsuccessfully access the new SQL DB using the external IP address with and without the instance name.
>
>Additionally, I want the network routers to redirect the existing oldname.domainname.ad to redirected to newname.domainname.ad\instancename. Otherwise I will have to go to 600 workstations and update the ODBC connections.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform