I using KenicoCMS software to manage website , installed MS SQL Server 2005 and restored all the files from bak db . Firstly it can works but afterward i facing the following errors : -
ry]: Query: Proc_CMS_QueryProvider_Sel
ectAll: caused exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
And i checking the db log file viewer it show this error : -
[Login failed for 'sa']
[error 18456 severity 14 state 16]
I sent to the support and reply as this but not works :-
Following error occurs when application is trying to access your database:
Error: 18456, Severity: 14, State: 16.
It indicates that the session database could not be determined which may mean that the database is offline or the user does not have permissions to access the database. You can verify the name and location of the mdf file and make sure that the user has permissions to read and write the file (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
Hope can help for this .
MS Sql Server 2005 Info :
Microsoft SQL Server Management Studio - 9.00.1399.00
Microsoft Analysis Services Client Tools - 2005.090.1399.00
Microsoft Data Access Components (MDAC) - 2000.086.3959.00 (srv03_sp2_rtm.070216-1710
Microsoft MSXML - 2.6 3.0 6.0
Microsoft Internet Explorer - 7.0.5730.13
Microsoft .NET Framework - 2.0.50727.42
Operating System - 5.2.3790
Window Server 2003 Info :
Microsoft Windows Server 2003 R2 Enterprise x64 Edition Service Pack 2
[DataConnection.ExecuteQuery]: Query: Proc_CMS_QueryProvider_SelectAll: caused exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.