• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2378
  • Last Modified:

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
0
melwong
Asked:
melwong
  • 4
  • 2
1 Solution
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now