Download Microsoft SQL Server 2005 Service Pack 4 RTM

 

Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download.

SQL Server 2005 SP4 includes SQL Server 2005 SP3 cumulative update 1 to 11, customer requested fixes, along with instances of the SQL Server 2005 SP4 database Engine support for DAC operations.

It can be downloaded from

Microsoft SQL Server 2005 Service Pack 4 RTM

SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

 

Error:
SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

Cause:
When we take the database OFFLINE this error raised.

Reference: http://support.microsoft.com/kb/917828

The server principal is not able to access the database under the current security context.

 

I reproduced the error below;

Issue 1:

Msg 916, Level 14, State 1, Line 1 The server principal "Test_Login" is not able to access the database "testdb" under the current security context.

1. Created database ‘testdb’

2. Created the login ‘Test_Login’. The login not granted access on the database ‘testdb’

3. On logging on ‘Test_Login’, tried accesing the database ‘testdb’ and got the error.

From the error message, when the server principal ( login) does not have access on the database the error occurs.

Resolution 1:
Grant the database access for the login. For example;

Use testdb go Create User Test_Login for Login Test_Login go

Issue 2:

The database is in “Restricted Mode”

Try the query below, to access the database in different user context

Use testdb go execute as user='test_login' go

Msg 916, Level 14, State 1, Line 1
The server principal "Test_Login" is not able to access the database "testdb" under the current security context.

Reference : 
"The server principal LoginName is not able to access the database DatabaseName under the current security context"

TSM TDPSQL Backup failed

 

Recently when i tried TSM TDPSQL backup with the new server on SQL Server 2008 failed with the error below.

“ TSM TDP SQL Error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Process Exit Code 1914. The step failed. “

Resolution:
After investigation, installed the TSM TDP SQL version 5.5.4.0 from 5.5.0. This resolved the issue.

Uninstall SQL Server 2008 Cluster

 

Here goes the SQL Server 2008 un-installation screenshots.