Skip to content


smartconnect cannot login

puisan asked 10 years ago
The smartconnect database is being restored due to reformat of database server. After the database is restored and created the SmartCOnnect SQL login user id, user still unable to login to smartconnect application. The event viewer log is stated

"could not excecute query for the windows login user id"

Any idea on how can this being resolved?
Chris Hanson replied 10 years ago

You could try checking to make sure that the SmartConnect sql user is the database owner of the database named SmartConnect. To ensure the account had enough rights you could make it a sysadmin if it isn't already and try again.

It shouldn't be using a windows account to connect, but it does check the [Users] table in the SmartConnect database to make sure your current windows account has access inside of the interface.

If those don't help you could get a support tech to take a look at it if you contact if you need this resolved promptly.


If you would like to submit an answer or comment, please sign in to the eOne portal.