Saturday, December 18, 2010

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

Thursday, December 16, 2010

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

Wednesday, December 15, 2010

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.

clip_image002

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”

image

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"

Sunday, December 05, 2010

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. “

image

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

Saturday, December 04, 2010

Uninstall SQL Server 2008 Cluster

 

Here goes the SQL Server 2008 un-installation screenshots.

image

image

image

image

image

image

image

image

image