SQL Server login Errors

Posted on 2006-05-26
Last Modified: 2011-09-20
I'm completely stumped.  This only happens on some user's PCs.

I have a DB that connects to  SQL server.   Here is the connect string:

ConnectString = ("ODBC;DRIVER=SQL SERVER;Server=TMG100;persist security info=yes;Database=ECats2;Uid=User;Pwd=999")

On my PC this db connects fine.  However i get a messed up error message on other computers saying this:
Connection Failed:
SQLState: '01S00'
SQL Server Error:0
[Microsoft][ODBC SQL Server Drive] Invalid connection string attribute
Connection failed:
SQLState: '08004'
SQL Server Erro: 4062
Server Rejected the connection; Access to selected database has been denied.

TMG100 is a test server.  I'm using the same string to connect to the production server and it works for everyone.  WIERD!!!

Any ideas??

Question by:lucas911
    LVL 4

    Expert Comment

    Try this for the connection string:

    Provider=SQLOLEDB;Data Source=TMG100;User ID=User;Password=999;Initial Catalog=ECats2
    LVL 13

    Author Comment

    It's prompting me to select a data source.

    I'm using this connect string to refresh the links
    LVL 65

    Expert Comment

    Do the users who get this error, do they have permissions to access/read the database?
    as this is a test, perhaps its not setup for everyone

    Has the data source been setup properly on their PC?
    LVL 65

    Expert Comment

    You may of created some users then did a restore perhaps, meaning users created after that backup no longer exist.

    LVL 13

    Author Comment

    Everyone uses the same login and password to access this DB.  I'll have to check if the datasource is setup properly.
    LVL 13

    Author Comment

    I solved me problem.

    I just had to change my default DB to point to the DB i connect to.  Problem solved....

    Accepted Solution

    Closed, 500 points refunded.
    Community Support Moderator

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    746 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

    18 Experts available now in Live!

    Get 1:1 Help Now