Symantec Protection for SharePoint Servers Error: Cannot open database "WSS_Content_Projects" requested by the login. The login failed.

Products

• Protection for SharePoint Servers

Issue/Introduction

Symantec Scan engine 5.2.4 installed on Windows 2008 server with Symantec Protection for SharePoint Servers 5.1.3 on SharePoint server/MOSS 2007 and SQL Server 2008 back-end server.  The Symantec Protection for SharePoint Servers service is using a domain account with full rights to the SharePoint server and 2008 SQL server.  There are no issues uploading or downloading files to the SharePoint server, until you attempt perform a manual scan.

Whenever you attempt to run a manual scan you recieve the following error in the Symantec SharePoint Services log:

2010-06-30 15:42:13,"",9999,"3","Cannot open database "WSS_Content_Projects" requested by the login. The login failed.
Login failed for user 'MPHI\SRV_SP_SPSS'."," at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at d9.a(SPWebApplication A_0, SharePointdata A_1, RequestdataTypes A_2, String A_3)",".Net SqlClient Data Provider","Symantec Antivirus"
 

 

Cause

This issue is caused by some changes that were made in SQL Server 2008.  Starting in SQL Server 2008 the local administrator account is no longer given read/write rights to the SQL content. 

Resolution

To resolve this issue please use the following steps:

1) Login to the SQL Administrator tool on the SQL 2008 back-end server.
2) Create a login for the SPSS service account.
3) Make the SPSS service account login a user for each content database.
4) Add the SPSS service account user to the db_reader and db_writer roles.