How can I get SQL Browser Service running

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How can I get SQL Browser Service running

16 posts, Page 1 of 2

1 2 »»

How can I get SQL Browser Service running

Rate Topic

Display Mode

Topic Options

Author

Message

xenophilia

Posted Friday, March 16, 2012 3:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

I'm running sql server 2008 enterprise. SQL Server Configuration Manager shows all services running with the exception of SQL Browser Service. If I right click on it the 'Start' option on the menu is not available.

The reason I need it running is because I'm trying to connect to Analysis Services from Excel (both reside on same server) and am currently getting error "Could not connect to the redirector. Ensure that the SQLBrowser service is running on 'name-of' server"

How can I get SQL Browser Service running?

-

Post #1268097

Koen Verbeeck

Posted Friday, March 16, 2012 4:59 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

You normally don't need SQL Browser to connect to SSAS.
Probably the default port is changed, so that's why you cannot connect to SSAS. Try giving the IP address and the port instead of the servername.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1268144

xenophilia

Posted Friday, March 16, 2012 7:50 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

Thanks for taking my question Koen. I also read about this during initial research of problem, but ....

(1) I installed sql server on this machine myself (I am learning) and accepted only default settings ie. didn't set the port name and IP address.

(2) The data connection wizard in Excel does not have any fields where one can provide an IP and port number. It asks only for server name and logon credentials (windows authentication or name/password). I provide server name and use windows authentication.

Can you see other possibilities?

-

Post #1268243

Koen Verbeeck

Posted Friday, March 16, 2012 7:55 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

That's odd. If you installed everything local, Excel should find SSAS just fine.
Can you log into SSAS using Management Studio?

ps: to use TCP to connect to SSAS, you just replace the hostname with the following:
TCP:ipAddress,portnumber

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1268247

xenophilia

Posted Friday, March 16, 2012 8:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

Koen Verbeeck (3/16/2012)

Yes, I've been able to connect to Analysis Services from SSMS.

Will you please tell me how to find ipAddress and portnumber?

-

Post #1268272

xenophilia

Posted Friday, March 16, 2012 2:57 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

Could the problems of (1) SQL Server Browser not being startable and (2) not being able to connect to analysis services from Excel, be related to the logon types I have selected for all the different services?
eg.
SQL Server Integration ->LocalSystem
SQL Full-Text Filter Daemon -> NT AUTHORITY\LOCAL SERVICE
SQL Server -> LocalSystem
SQL Server Analysis Services -> LocalSystem
SQL Server Reporting Services -> LocalSystem
SQL Server Browser -> NT AUTHORITY\LOCAL SERVICE
SQL Server Agent -> LocalSystem

-

Post #1268552

Koen Verbeeck

Posted Monday, March 19, 2012 12:44 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

I don't think so.
So every service is installed on localhost, and you're trying to connect to SSAS with Excel, also on your localhost?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1268802

xenophilia

Posted Thursday, March 22, 2012 11:15 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

Koen, yes, exactly.
I decided to install a second instance of SSMS.....and now SQL Server Browser is running.....YET
the problem with Excel not connecting to Analysis Services is same. Also, SSMS's Object Explorer is not detecting the cube I created in SSAS. even though I am connected to the correct (local) instance of Analysis Services Server.
This is completely blocking me from further progress in learning how to tie together the creation of a cube to querying (MDX) and reporting (Excel).
Please help! Crying

Earlier you said "Try giving the IP address and the port instead of the servername. " Will you please give me guidance on where to find this info?

-

Post #1271380

Koen Verbeeck

Posted Friday, March 23, 2012 12:33 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

Regarding the cube:
did you deploy the cube? If you right-click on the SSAS database, select properties and go to the Deployment tab, what's listed for database in the target section?

To find the IP Address and port used:
open SQL Server Configuration Manager. Go to SQL Server Network Configuration/ Protocols for MSSQLSERVER (or whatever your instance is called) and check the properties of the TCP/IP protocol.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1271406

xenophilia

Posted Friday, March 23, 2012 1:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 20, 2012 2:37 PM
Points: 125, Visits: 234

Koen Verbeeck (3/23/2012)

The cube was processed and the project deployed successfully. localhost is listed for database in target section.

I found TCP/IP disabled for the localhost instance, so I enabled and went to Properties where multiple ip addresses are listed. IP1 is fe80::a5b4:4a44:cbbe:29a9%13 IP1 TCP port: 1433.
How do I enter that in place of the server name?

Angry

Post #1271431

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions