April 1, 2010 at 11:20 am
rainleta (4/1/2010)
CirquedeSQLeil (3/31/2010)
rainleta (3/31/2010)
Another finding:I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find and use the port in the connection.
It seems the SQL Browser doesn't work at all. Is there any way to diagnose and repair?
When you say you enabled the dynamic port, did you remove the static port mapping?
I don't know what static port mapping is. I simply go to the SQL Server Configuration Manager, open the TCP/IP protocols properties, IP addresses tab, set TCPALL, TCP Dynamics to 0, TCP Port is blank. Then reboot the services.
What port is SQL server listening on currently?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2010 at 11:41 am
Did you enable named pipes?
I noticed that if you use the Browser it connects with Named Pipes, even if you have an alias.
April 1, 2010 at 12:03 pm
CirquedeSQLeil (4/1/2010)
rainleta (4/1/2010)
CirquedeSQLeil (3/31/2010)
rainleta (3/31/2010)
Another finding:I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find and use the port in the connection.
It seems the SQL Browser doesn't work at all. Is there any way to diagnose and repair?
When you say you enabled the dynamic port, did you remove the static port mapping?
I don't know what static port mapping is. I simply go to the SQL Server Configuration Manager, open the TCP/IP protocols properties, IP addresses tab, set TCPALL, TCP Dynamics to 0, TCP Port is blank. Then reboot the services.
What port is SQL server listening on currently?
It is a random number, from Configuration manager, the port is 49202. I can use server,49202 to connect.
April 1, 2010 at 12:04 pm
Hawkeye_DBA (4/1/2010)
Did you enable named pipes?I noticed that if you use the Browser it connects with Named Pipes, even if you have an alias.
I turn off/on the name pipes, but it makes no differences. I don't have alias.
April 1, 2010 at 12:12 pm
Hawkeye_DBA (4/1/2010)
Did you enable named pipes?I noticed that if you use the Browser it connects with Named Pipes, even if you have an alias.
SQL Browser does require named pipes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2010 at 12:13 pm
Please provide error messages and screen shots of your tcp ip settings.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2010 at 12:31 pm
Is your server responding on UDP 1434 as well? That's typically what the Browser is on by default. It translates the port.
April 1, 2010 at 3:13 pm
CirquedeSQLeil (4/1/2010)
Please provide error messages and screen shots of your tcp ip settings.
Here you go.
April 1, 2010 at 3:16 pm
Steve Jones - Editor (4/1/2010)
Is your server responding on UDP 1434 as well? That's typically what the Browser is on by default. It translates the port.
From netstat on the server, UDP 1434 is listening
TCP 127.0.0.1:1434 WOOD:0 LISTENING
TCP [::1]:1434 WOOD:0 LISTENING
UDP 0.0.0.0:1434 *:*
UDP [::]:1434 *:*
And I can use PortQry to see its status from client.
April 1, 2010 at 3:18 pm
Is this a default instance or a named instance?
It also looks like you are still using port 1533 - thus it is still a static port configuration.
Here is an article for reading.
http://support.microsoft.com/kb/823938
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2010 at 3:34 pm
CirquedeSQLeil (4/1/2010)
Is this a default instance or a named instance?It also looks like you are still using port 1533 - thus it is still a static port configuration.
Here is an article for reading.
It looks like the port is not enabled however (Active is set to "yes" however Enabled is set to "No")
April 1, 2010 at 3:41 pm
Yes. All the IPs are disabled. I only have IPALL.
Before I tried the dynamic port, I used 1533 and changed all the IPs to 1533. But it still doesn't work unless I use server,1533.
April 1, 2010 at 3:42 pm
BTW, I am using default instance. You can see it from the connection dialog.
April 1, 2010 at 3:54 pm
In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for the default instance you must specify the port.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2010 at 3:57 pm
So on the Protocol tab you have
-Enabled Yes
-Keep Alive 30000 (example value)
-Listen All Yes
Have you changed the values under IPAll and set
-TCP Dynamic Ports to nothing (leave blank)
-TCP Port 1533
Viewing 15 posts - 16 through 30 (of 34 total)
You must be logged in to reply to this topic. Login to reply