I have SQL2000 installed on a server for test purposes. When I use any application on that server I can connec to the databases fine. If I go to another machine, I can create an ODBC datasource fine, but when I try and log in with the same application I get the following error.
Does anyone have some trouble shooting steps for me?
Database Error encountered:
Native Error: 15247 (0x00003b8f)
SQL State: 
SQL Error: [[Microsoft][ODBC SQL Server Driver][SQL Server]User
does not have permission to perform this action.]
Source file [.\odbd.cpp]
line number: 7947
Function Call: [::SQLExecDirector(m_hStatement, (unsigned char
Software Build: [126.96.36.1990]