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 12»»

How can I get SQL Browser Service running Expand / Collapse
Author
Message
Posted Friday, March 16, 2012 3:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
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
Posted Friday, March 16, 2012 4:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Friday, March 16, 2012 7:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
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
Posted Friday, March 16, 2012 7:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Friday, March 16, 2012 8:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
Koen Verbeeck (3/16/2012)
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


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
Posted Friday, March 16, 2012 2:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
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
Posted Monday, March 19, 2012 12:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Thursday, March 22, 2012 11:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
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!

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
Posted Friday, March 23, 2012 12:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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
Posted Friday, March 23, 2012 1:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 2:28 AM
Points: 125, Visits: 237
Koen Verbeeck (3/23/2012)
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.


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?



-
Post #1271431
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse