Yesterday everything was working fine from my CW application today I cannot connect
My User/Pswd have not changed
MS SQL Manager works fine. Any Ideas.
are you running from the same user account that you usually do? (and same level of elevation)
I think you might be right.
I was tinkering with the permissions and all my stored procedures work (Execute)
But any screen where I am using the table directly to NetTalk web Browse a table I get the Error.
I have “Select” granted for the table, do you know if I need any other settings?
I am only using the browse to Select, No Updates allowed in the APP (Only with Stored Procedures)
Membership is db_DataReader
I have tried with insert/update/delete checked also no change
I logged into SQL Mgr w/ user/pswd and I can do selects, just not in the CW app
So I tried to connect w/ a simple clarion app / browse and get the same error.
I tried logging in using the ODBC 32-bit manager and get the same error
Frustrating.
Try using a full admin account (sa or whatever). Then prune permissions until it stops working.
Have you set the table to read-only before or while opening it?
Finally figured it out.
After uninstalling, reinstalling, restoring…
using SQLServerManager16.msc I enable TCP/IP
3 Likes