Connecting to SQL Server

I posted this in the Microsoft Access forum and they mentioned that this forum might be a better place for this question.


I have an access database that I connect to an sql server database. When I use my computer I can connect to the sql server, however when I connect to the server using someone elses machine I get the connection failed error. Currently I am the only one given permission to access the data folder that the sql server data sits in. I'm sure if we just allowed everyone to have access to the Sql Server data files the program would work fine, I would prefer not to do this. Is there a way to create the dsn file and store a password and username with the file? This way no matter what computer I open the file on it would still work without having to give permissions to each user to access the data folder. Also this is a third party program that I am trying to access their data. And the system adminstrator had to add me as a system admin on the server machine for me to access the data. I'm trying to find out if perhaps there is a possibilty that the SQL server may not be set up correctly or maybe I just don't flat out understand how to connect to a database and I need to do some more research in understanding it.

Thank you for any help

What exactly is the error?
How is it connecting to the database?
Can you post the ConnectionString?

Easiest thing to do is create a new Login in SQL Server, then use that logins Username/Password in the connectionstring.

The error that I get is Connection failed:

SQLState:'28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'username'

I'm using a DSN connection that I have saved on a shared drive that everone can have access to.

the connection string is:
ODBC;Description=junk3;DRIVER=SQL Server;SERVER=SERVER\TIMEFORCE;APP=Microsoft Office 2003;WSID=username;DATABASE=qqest;Network=DBMSSOCN ;Trusted_Connection=Yes;TABLE=dbo.Job

I pulled the connection string off one of the tables in the properties section in design view.

I agree with creating a new user, however I don't know how to maintain the username and password across multiple systems with different user names and passwords.