asked on

SQL Server login Errors

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??

ch70357

Try this for the connection string:

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

Lucas

ASKER

It's prompting me to select a data source.

I'm using this connect string to refresh the links

rockiroads

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?

rockiroads

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

Lucas

ASKER

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

Lucas

ASKER

I solved me problem.

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

ASKER CERTIFIED SOLUTION

PashaMod

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial