Enable remote connection to SQL 2005

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

FoodMart 2005 Error: Dimension was not found in cube when string is parsed

If you happened to face the above error while trying to install the FoodMart sample Microsoft 2005 Analysis cube, then you may probably have the same problem as I had.

Go to FoodMart 2005's H/R Cube, go to Calculations, change to Script View, then comment of starting from below line

/* CREATE MEMBER CURRENTCUBE.[MEASURES].cellsecurity
.
..
..
end scope; */

This will then skip the error.

Microsoft SQL version check

As there are many patches in pertaining to the Microsoft products, it is sometime difficult to identify which version of patches has been applied to which client.

One of the method is by performing a query on the server using below T-SQL query;

select @@version

There will be full versioning details of the SQL server like below;

Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 3)