Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server service pack for browser Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 3:16 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 1,749, Visits: 3,155
In windows control-panel , uninstall and change a program, I see SQl server 2008 service pack 2 is installed, but also see there is a separate SQL server 2008 service pack 2 browser.

I am going to apply service pack 3 to fix a SQL browser issue, I was told the SP3 will fix that.

My question is by running SP3 will also upgrade SQl browser, correct?


Thanks much
Post #1465399
Posted Wednesday, June 19, 2013 3:22 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:21 PM
Points: 5,975, Visits: 12,883
its all part of the same service pack so yes it will

---------------------------------------------------------------------

Post #1465400
Posted Wednesday, June 19, 2013 3:29 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:42 AM
Points: 1,749, Visits: 3,155
Thanks much,

A question about SQL browser, we have a cluster.
On node1 it installed two instances, one production, one QA.

The browser recently keeps stops, causing front end sharepoint not available.
I have to restart the SQL browser service which will fix that.
Not sure if this is also a problem of network because before it was running fine for a long time
I have done a research that SP3 will fix that.

Now I am looking at the instances on Node1. Both instances - the TCP/IP port is leave blank, I guess they are both using default port.

Is that a correct configuration?
Do we have to set one of the instance's TCP port to a different number, or we don't have to?

THanks
Post #1465406
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse