Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Problems with SQL Browser Service

Author  Topic 

eluska53
Starting Member

2 Posts

Posted - 2008-02-08 : 14:43:12
I am using SQL Server 2005 developer edition and Visual Studio 2005. I am working on local computer and when I define a cube I am using data sources to which I can connect without any problem using "Test connection". However, when I want to perform calculation or browse a cube I get a message of either I am as a user do not have permission to access source database (in reality I do have this permission) or source database does not exist (in reality it exists). I check the SQL Server Browse Service and it is not running and the option of starting it is disabled (Start mode is undefined and only properties option can be used). I already have enabled the TCP/IP and Named Pipes protocols but I still cannot browse cube data.
Any help SUPER welcome.
Elka

eluska53
Starting Member

2 Posts

Posted - 2008-02-08 : 15:41:47
I already started the Browser service but I still cannot browse cube data. Any help
Elka
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-08 : 22:20:05
Is the cube created? You can't connect to relational db or cube? AS uses windows authentication by the way.
Go to Top of Page
   

- Advertisement -