March 16, 2012 at 3:38 am
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?
-
March 16, 2012 at 4:59 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2012 at 7:50 am
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?
-
March 16, 2012 at 7:55 am
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2012 at 8:22 am
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?
-
March 16, 2012 at 2:57 pm
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
-
March 19, 2012 at 12:44 am
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 22, 2012 at 11:15 pm
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?
-
March 23, 2012 at 12:33 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2012 at 1:36 am
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?
:angry:
-
March 23, 2012 at 1:43 am
If TCP/IP is disabled it doesn't really matter.
It's just localhost, you should be able to connect just fine.
There must be something wrong, the problem is finding it.
Did you install SQL Server as the default instance or as named instances?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2012 at 2:17 am
I solved one problem. I can now see the cube in SSMS under Analysis Server. You know what the problem was? I was not running SSMS as Administrator. I shut SSMS down and reloaded, this time running as Admin, and I was able to see the cube under Analysis Server connection. 😀
But, I still can't connect to Analysis Services from Excel.:crazy:
The error I get "The Data Connection Wizard cannot obtain a list of databases from the specified datasource". I tried localhost, local, server name....all same.
-
March 23, 2012 at 2:28 am
ps. However, I am able to connect to SSMS databases from Excel (using From Other Sources->From SQL Server).
-
March 23, 2012 at 2:34 am
The fact that you're apparently not an SSAS admin can probably cause issues with you trying to connect from Excel.
Log into SSAS using SSMS and add yourself as one of the admins.
Right-click on the server node, select properties, go to the security tab and add yourself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2012 at 2:43 am
Wow. You are correct.
:kiss:
-
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply