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

LVL 13
LucasMS Dynamics DeveloperAsked:
Who is Participating?
PashaModConnect With a Mentor Commented:
Closed, 500 points refunded.
Community Support Moderator
Try this for the connection string:

Provider=SQLOLEDB;Data Source=TMG100;User ID=User;Password=999;Initial Catalog=ECats2
LucasMS Dynamics DeveloperAuthor Commented:
It's prompting me to select a data source.

I'm using this connect string to refresh the links
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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?
You may of created some users then did a restore perhaps, meaning users created after that backup no longer exist.

LucasMS Dynamics DeveloperAuthor Commented:
Everyone uses the same login and password to access this DB.  I'll have to check if the datasource is setup properly.
LucasMS Dynamics DeveloperAuthor Commented:
I solved me problem.

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

From novice to tech pro — start learning today.