NetSuite support is of the opinion that this needs...
# suiteanalyticss
scottvonduhn
10/28/2019, 8:06 PMNetSuite support is of the opinion that this needs to go to Microsoft support, and Microsoft is of the opinion that it is an issue with the ODBC driver supplied by NetSuite. I am in support ping pong hell at the moment. Has anyone else seen or dealt with this error, or have an idea of how to resolve it?
k
KevinJ of Kansas
10/28/2019, 8:22 PMI am guessing that you will stay pretty solidly in ping pong hell. I swear there's a windows role/user/whatever permission that controls your ability to publish/edit/view the certificate store - when I've run into this in the past, I was deep in the internet/windows help trying to figure it out before I found the right answer. I don't, unfortunately, recall what it was (My issue was not with NetSuite, but another ERP)
s
scottvonduhn
10/28/2019, 8:29 PMWe have literally granted every permission EXCEPT Administrator, and it still didn't work. And making everyone who runs reports and queries Administrators on our financial database server is probably not going to happen.
scottvonduhn
10/28/2019, 8:34 PMWell, one revelation ... if the user logs into the machine once, they can then login into SQL Server and runs queries with no errors. However, once the server restarts, they get the error again, unless/until they log in to the machine directly one more time. It doesn't seem like that should ever be necessary, and I have no idea why that would change anything.
k
KevinJ of Kansas
10/28/2019, 9:04 PMIt's gotta be something about the local certificate store