Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickSCH
Starting Member
2 Posts |
 Posted - 2010-05-18 : 15:02:57
|
| Hello,I am trying to troubleshoot a major connectivity issue and the DBA is not available.We have a SQL Server Instance under the name SUSMNRAP069\HFM. How can I figure out what port the "HFM" instance is running?We are trying to configure application software with a database under this instance, but using the "\" in SUSMNRAP069\HFM to connect to the server is not supported. They say we need to use SUSMNRAP069:"port" and that this port is different than the default port 1433 in which SQL Server is running.Any help is greatly appreciated. Sorry if my question is completely off the wall. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-05-18 : 15:21:54
|
| You can see the port in the SQL Server Error Log (it gets mentioned at startup) or use SQL Server Configuration Manager to view it. It's also available in the registry, but I don't have the key memorized and don't have the time to search for it at the moment.Please note that the database server should be using a static port if you are going to reference it in your connection string. A dynamic port is what is used if you don't change it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
NickSCH
Starting Member
2 Posts |
Posted - 2010-05-18 : 16:05:06
|
| Thanks for pointing me in the right direction. I was able to discover that the DBA did not tell me SQL server was running on port 2459. I was able to find this in the log. |
|
|
|
|
|
|
Finding Port for SQL Server (Not Service Port)