Timeout Expired , The timeout period elapsed prior to completion of the operation or the server is not responding

Hi there,

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 : -

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

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\MusuemInventory.mdf).

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.

Open in new window

timout-expired.JPG
Cannot-open-database.JPG
melwongAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mironCommented:
Please do apply SQL Server 2005 SP2 asap.

Did you try to connect to server and see if you can reach database GUA using administrative account. I wonder if the issue is sa account or database itself. Though SQL Server 2005 has a number of security features that need to be kept in mind when similar errors occur. See this link for more info.

-- cheers
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
melwongAuthor Commented:
I just read through the link that u provided : -
Matt Neerincx [MSFT] said:  
State=16 means that the incoming user does not have permissions to log into the target database.  So for example say you create a user FOO and set FOO's default database to master, but FOO does not have permissions to log into master.
This can also happen if for example the default database for user FOO is not online (for example the database is marked suspect).
So to check on this theory, try logging the user into some other database and then try using the USE DATABASE command to switch to the target database, you will get a better error message as to the root cause of the failure.

The question is how to "USE DATABASE" command work to switch to target database ?
can you explain more for that ?
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

melwongAuthor Commented:
I am running Ms Sql Server 2005 (32bit) in the OS (64bit), is that rise any incompatibility ?
0
mironCommented:
SQL Server 2005 SP2 should help.
"...
The question is how to "USE DATABASE" command work to switch to target database ?
can you explain more for that ?
..."
just run it using sa., replace word "DATABASE" with name of the database we are troubleshooting.

"I am running Ms Sql Server 2005 (32bit) in the OS (64bit), is that rise any incompatibility ?"
with SP2 applied Ms Sql Server 2005 (32bit) in the OS (64bit) runs free of issues.

-- cheers
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you poste here the code for stored procedure Proc_CMS_QueryProvider_SelectAll?
0
mironCommented:
any progress?
-- cheers
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.