Home Forums SQL Server 2008 Security (SS2K8) users not able to access database RE: users not able to access database

  • March 14, 2013 at 8:22 am

    #1597031

    ok if it's a user who exists in a windows group, and doesn't have an individual login in SQL, then it's the issue Gazareth identified;

    I assume the user are connecting with an application; that application has built a connection string with either a misspelled or non existent database in the connection string;

    An example connection string:

    Dim mySqlConnectionFormat As String = "data source=DEV223;

    initial catalog=SandBox;

    Trusted_Connection=True;

    Timeout=600;

    Workstation ID=GhostInTheMachine;

    Application Name=HaxxorPadPlusPlus;"

    so Following what Gazareth said, you need to track down how the connection is built, and get the app to fix it, i'm thinking.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!