Connectivity problems in users' machines

[rushdib]

Hi,
I am new to SQL Server. I am trying to connect some tables on users' pcs through ODBC connection. As a developer, I can connect to the server. But the user cannot connect on their user name. Do I have to set their names on the SQL Server? Do I have to install SQL Server client on their machines as well?

Thank You

 

[tlbroadbent]

1) All users will need a login on SQL Server. You can use Windows or SQL Authentication. With Windows Authentication, if the users are logged into the networrk they can login to SQL Server. They won't need another password.

With SQL Authentication, you can provide a single login and password for everyone, which is an acceptable practice for read-only data. Or you can set up SQL logins with passwords.

You or the DBA will need to grant appropriate permissions to the databases, tables, view and procedures.

2) Users don't need the SQL Client tools installed on their PCs. I advise against doing that! They do need the appropriate MDAC components installed. MDAC can be downloaded from Microsoft. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.