not able to access the SQL server database in the server

Question

Client machines are not able to access the SQL server database in the server. When the server is restarted everything's fine? What could be the reason?

We are using server 2003 and sql server is the database.

Is space in the hard disk or memory an issue?

Answer 1

Client machines are not able to access the SQL server database in the server. When the server is restarted everything's fine? What could be the reason?

We are using server 2003 and sql server is the database.

Is space in the hard disk or memory an issue?

Check the SQL Server error log for related messages.  It could be a memory issue if you have other applications running on the SQL Server, in which case you should consider setting max server memory.

---

Dan Guzman, SQL Server MVP, http://www.dbdelta.com

Answer 2

Hello,

You have written "Client machines are not able to access the SQL server database in the server".

Please, could you provide more informations about your problem ?

- the full and exact error message that the client machines are displaying when the connections are failing

- the languages and the provider (ODBC,OLEDB,SqlClient,... and which version ) used by the applications to connect the SQL Server databases

- are you sure that you have not more connections than the allowed count by the number of licensed users for your SQL Server or your Windows Server?

- have you programs which are bugging and forgetting to close connections ? ( if the application is forgetting to close the connections when it is closing, SQL Server is closing them after a time which may be upto 15 minutes )

- full version of your Windows Server and your SQL Server ( the full edition of your SQL Server should be useful as SQL Server Express cannot use more than a GB of memory , which could be not enough if you have many users )

The advices from Dan are useful.

We are waiting for your feedback to try to help you more efficiently

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

Thanks for your response

If SQL can use on 1GB of memory, then this is my issue. But we have only 10 users accessing SQL Server.

and the error in the client is the SQL server could not be opened ODBC error

Answer 4

If SQL can use on 1GB of memory, then this is my issue. But we have only 10 users accessing SQL Server.

and the error in the client is the SQL server could not be opened ODBC error

Do you have any related messages on the server side in the SQL Server error log?  What is the full exact text of the client error message?

You can limit SQL Server memory to 1GB with the script below.  But be aware that we are only guessing this is the cause of the error without more information.

EXEC sp_configure 'show advanced', 1;
RECONFIGURE;
EXEC sp_configure 'max server memory', 1024;
RECONFIGURE;

---

Dan Guzman, SQL Server MVP, http://www.dbdelta.com