DSN Access

[Mighty]

Apologies for what will probably be an easy question. I have a DSN setup to access a SQL Server DB on a remote machine and use that in a VBScript that I run from my machine. This script also runs from another IT machine.

However, when I try to replicate it on another machine it won't access the database. I am putting this down to access to the DB. How do I grant read only access to user accounts/groups to the database?

Mighty

 

[simian336]

You have tested the DSN from ODBC Data Source Administrator and it connects?

In your vbscript you are using the same User/Password on ODBC connection string that you used on the other computer?

Simi

 

[Mighty]

I m not specifying a username and password in the script. The DSN on my client machine is set up using NT Authentication. I think the issue is that I am using a domain admin account to run the script.

Do I just set up a new account on the SQL Server with read access and specify that account in the connection string in my code?

Mighty

 

[simian336]

That should work.

Simi