dnohr - Friday, February 11, 2011 4:32 PM:
When trying to login using 'admin' and "innovator" as user name and password, I get an error that says:
The SELECT permission was denied on the object 'LANGUAGE', database 'InnovatorSolutions',Scheme 'dbo'.
I'm assuming this is an issue with the SQL server setup. I didn't change anything, all permissions are as the installation process left them.
Any ideas on what could be going on?
PatrickW - Monday, February 14, 2011 9:16 AM:
You will probably need to set the data ownership. Currently it seems not to be the innovator db user.
In the SQL Management Console execute:
- exec sp_change_users_login database, 'innovator', 'innovator'
- exec sp_grantdbaccess 'innovator','innovator'
- exec sp_addrolemember 'db_owner','innovator'
If you used another innovator user name and/or password, adjust accordingly.
