Database Locking up

Posted on 2004-11-18
Last Modified: 2010-05-18
We just upgraded our network from peer-to-peer to server-client network.  There are 5 workstations all running Win XP Pro.  The server is running Small Business Server 2003.  Everything seems to be working fine except for a database.  When a user tries to access the database, it runs smoothly, but its when another user tries to access the database simultaneously, we run into problems.  It seems like the database locks up when there are more than one user.  I called Tech support for the software and they told me to include a registry key:


This registry key involves indexes and he said it might be the cause of the problem.  I don't want to play with registry settings just yet.  He also told me that it might be a security setting on Server 2003.  Can someone please help?  
The server runs into a switch 10/100mbps which goes to each workstation connected at 100mbps.  
Question by:modriven
    LVL 1

    Expert Comment

    Which database are we talking about here?
    Oracle, Access,SQLServer....... please clarify?


    Author Comment

    LVL 16

    Expert Comment

    It could well be just down to the way your application is written. Was it an Access app that has been upsized or something like that?
    LVL 7

    Accepted Solution

    Just a couple of things to try.

    Check the database properties to confirm single user access is not set:
    - Start enterprise manager and navigate to the problem database
    - right click on database and select properries,
    - a new window will appear - goto the Options table and check the Access section.

    Check the logs within SQLServer for the time when the problem is occurring.
    - Start enterprise manager
    - navigate to Management/SQL Server Logs/
    and check the log that covers the timeframe in question. If possible, examing the seqeunce of events from the time the SQLServer service starts till the lockup is generated. The info you get from here may help target further investigations.

    Check the settings at the clients end. You've just moved from peer-to-peer to Client/server. Presumably the db has moved. Have all client installations been modified to use the new server?  Is the security model used consistant for each client (ie is there a mix of Windows vs SQL Server authentication) - this may point to an issue with your network security model.

    Scott Pettman


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now