Ok, here is the situation:
A VB Project calls a CR v8 report. Logged on as a regular user on the PC and in the VB application gives me the “Cannot Open SQL Server” error when I call for the project. However, if I`m logged on as Admin then it works fine. This is obviously a Permissions issue, but wich permits to modify? and where??? I`ve set the users rights to Administrator and it works perfectly, but when I switch it back to User rigths it gives me the error again. Even when rights are set to Advanced user, same error…
This PC has WinXP PRO and is the only one giving me problems. All the other computers have Win2000 and works perfectly. The database resides in a Win2000 SBS.
Any help towards where and how could I change permissions to correct this problem?
Thanks for the help!