Link to home
Start Free TrialLog in
Avatar of impipr2
impipr2

asked on

only an administrator can access odbc database

Client had win2k server running SQL 2000. I installed 2003 server on a new pc, then sql 2000. Created all the user accounts. Backed up the database from the old PC, restored onto the new. I cannot set up the odbc connection, it gives an error 28000 (Login failed for user 'dispatch'), unles the user is in the administrator group, then it works fine. Both old and new SQL servers using window (only) authentication. I am not a SQL programmer, I didn't write the code. I need the users to be able to connect as just users
Avatar of arbert
arbert

So do you really have a windows user called dispatch or is the application trying to login using SQL Authentication?
Avatar of impipr2

ASKER

Yes, that is a valid user. They can log onto Terminal services properly and/or access/write the server shares
Avatar of impipr2

ASKER

To clarify: when I am setting up ODBC for a non administrator,  I click add, then SQL server. I fill in the name and description, select the correct server in the drop down. Select windows authentication, then next.

Now on "change the default database to:" This database is not listed. Master, msdb, northwind, etc... They are there, but my database is not.

If I chage the user to an administrator, they can connect to it just fine.
ASKER CERTIFIED SOLUTION
Avatar of AustinSeven
AustinSeven

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial