SQL Server Analysis Services Issues and Solutions

While browsing the cube in BIDS the following error message is displayed.

No connection could be made because the target machine actively refused it 127.0.0.1:2383

Solution: Build and Deploy the cube.

How to identify SQL Server Database file location

If you want to know where exactly the database files or stored for each database using T-SQL. You can use the following query
This will work on Both SQL Server 2005 and Sql Server 2008


SELECT name AS [Database Name], physical_name AS [File Location]
FROM sys.master_files


DBCC commands

• dbcc useroptions -- This command is used to display the current user settings for that connection
• 
  

select * from sys.dm_exec_sessions

This displays all the user sessions connected to the sql server and different options made with the session.