smimatt - Monday, May 2, 2011 2:55 PM:
Innovator has been installed and the login window pops up. The error below, "The SELECT permission was denied on the object 'LANGUAGE', database 'InnovatorSolutions', schema 'dbo'." shows up at attempted login.
Using Windows Server 2008 R2 Standard.
Would appreciate some insight.
smimatt - Wednesday, May 4, 2011 6:07 PM:
By the way, the software was installed several times per the installation instructions. If someone could provide any direction as to whether it was something not configured correctly, it would be helpful. I'm trying set up this tool so that we can evaluate it's feasibility at our company.
authentic - Monday, August 15, 2011 3:59 AM:
2132888Tiger4:
Moncler name came from the abbreviation in Monestier de Clermon. Our Moncler Outlet specializes in the production of outdoor sports equipment. We provide the Cheap Moncler Jackets you will just love. Our Moncler Jackets Outlet is secured and trusted by the world. Our products reach a large variety, including vests for all ages, such as the Kids Moncler Jackets which looks wonderful on the little boys and girls. Also, come and take a look, you will find the one Moncler Jackets For Women made just for you. Moncler went through a long history to reach its place today. Our Moncler Jackets Men and Moncler Shirt Women are up to date with the latest fashion trends. At the same time, Moncler Vest Men and the Moncler Vest Womens is made from the best materials and can keep you away from the harms of the bitter cold this coming winter. If you are a person extremely afraid of the cold like me, I would recommend you the Moncler Scarf which will keep your neck cosy and warm in the snow. Another one of my favorites is the Women Moncler Long Down Jacket which can give you the mysterious look as you stroll down the path in the white snow.
Ronan - Thursday, May 5, 2011 10:25 AM:
Have you tried running the three usual db access rights queries on your database? In SQLServer Management Studio, right-click your database, click Run Query, then run each line (the second one might return an error, this isn't a problem)
sp_change_users_login
'Update_One','innovator','innovator'
sp_grantdbaccess 'innovator','innovator'
sp_addrolemember 'db_owner','innovator'
smimatt - Friday, May 6, 2011 2:39 PM:
Thanks for the reply. The access rights were done manually, but we did run the queries just to be sure, and it didn't help. Some additional noteworthy information, when using the login username and password through the SQL server, the database could be accessed. The permission error shown above only occurs when logging in through the Innovator application in Explorer. By the way, this error pops up regardless of what password is entered, correct or not.
We (my IT support and I. -I'm relaying this information) reinstalled several times and have found that the error below also comes up (see below). So we are wondering if we are not configuring it correctly and this could be the cause.
Ronan - Friday, May 6, 2011 3:04 PM:
Right, your problem is that your currently logged in Windows identity lacks DB rights. Two possibilities at setup time (first screenshot):
- Don't use "Windows authentication credentials of current user" but the simpler "Server authentication using the Login ID and password below". Be sure to put the right DB admin login/password (typically "sa"), which should be usable to access your SQL Server instance in SQL Management Studio.
- You could also keep using "Windows authentication credentials of current user" and adjust the rights of this guy, but it's more complicated.
smimatt - Friday, May 6, 2011 4:27 PM:
- We have done it both ways, but I need to verify what DB admin was used. The error has occurred when using the server authentication option.
- In the Database Login Options section, we are not quite sure what to put there. Does this need to be a prexisting Login ID? It looks like the error on the second image is from the innovator login ID being created. Is this the ID that should be used when logging in to Innovator as the administrator?
Ronan - Friday, May 6, 2011 4:59 PM:
"In the Database Login Options section, we are not quite sure what to put there. Does this need to be a prexisting Login ID? It looks like the error on the second image is from the innovator login ID being created. Is this the ID that should be used when logging in to Innovator as the administrator?"
>> No! :) This should be a preexisting SQLServer administrator ID, the one you use in the SQLServer login screen (when you don't use windows authentication to login but classic administrator login/password). It is the user that will be used by Innovator to connect to the SQL database. Seems clearer to you?
smimatt - Friday, May 6, 2011 5:45 PM:
That did it! The installation guide was kind of unclear and steered us away from using the SQL Server ID. It seemed like it was intended to create a new admin ID. Obviously I was wrong.
Now on to figuring out the setup! Thanks for your help. I owe you.
