- Thank you received: 0
Install License on Windows/Sql Server Cluster
- rmerritt
- Topic Author
- Visitor
-
9 years 4 months ago #10796
by rmerritt
Replied by rmerritt on topic Re: Install License on Windows/Sql Server Cluster
Thanks, but not only did I grant full control to 'everyone' on both the 'Intellisoft' and 'PGNP' folders, but also to the account which runs the packages through SSIS. Still same error message. It seems I have covered the permissions issue.
Is this happening because running it through the 'Execute Package' utility runs on the hardware machine, whereas the SSMS submission runs on the clustered machine name? Are you checking two different names when running on a cluster? This is very serious for us and we will need to find another way to get this done if the PGNP driver will not work on a cluster. Thanks for the help.
Is this happening because running it through the 'Execute Package' utility runs on the hardware machine, whereas the SSMS submission runs on the clustered machine name? Are you checking two different names when running on a cluster? This is very serious for us and we will need to find another way to get this done if the PGNP driver will not work on a cluster. Thanks for the help.
Please Log in or Create an account to join the conversation.
- Moderator
-
- Offline
- New Member
Less
More
9 years 4 months ago #10822
by Moderator
Replied by Moderator on topic Re: Install License on Windows/Sql Server Cluster
We found that this issue was caused by the VSN case-sensitive comparison. The function that returns the VSN in some contexts returned upper case name, and in other context a mixed case. The issue is fixed in builds after 3206.
Please Log in or Create an account to join the conversation.
- rmerritt
- Topic Author
- Visitor
-
9 years 3 months ago #10826
by rmerritt
Replied by rmerritt on topic Re: Install License on Windows/Sql Server Cluster
Thanks so much for working closely with me and resolving this issue quickly! Our dev and test environments aren't clustered and had other names so we didn't catch this until we had committed to put it into production. Our bad!
It seems we had two problems:
1) There was a File Server Virtual Server (cluster role) on the cluster with the same name as the Sql Server Virtual Server, except capitalized.
2) The Sql Server Virtual Server didn't get into the license file upon installation, so PGNP support added it manually and sent it back to me. We were getting an error saying the server name wasn't in the file, and the name which was missing was our clustered Virtual Server name.
# 1 required the program change from PGNP.
# 2 however, I might have a suggestion. I believe this may have happened because when I installed the PGNP driver, I was logged on to the hardware machine.
I believe I should have been logged onto the Cluster Virtual Server (role) which runs the clustered instance of Sql Server so that names goes into the license file.
This is the name which will be looked up when the jobs run under Sql Server, running on that Virtual Server.
I may be wrong as we still don't have a clustered test environment, but it seems possible that this was our problem with the license file error message.
Konstantin, thanks a million for the help! You got us up and running in less than two days, and we haven't had a problem again with PGNP!
It seems we had two problems:
1) There was a File Server Virtual Server (cluster role) on the cluster with the same name as the Sql Server Virtual Server, except capitalized.
2) The Sql Server Virtual Server didn't get into the license file upon installation, so PGNP support added it manually and sent it back to me. We were getting an error saying the server name wasn't in the file, and the name which was missing was our clustered Virtual Server name.
# 1 required the program change from PGNP.
# 2 however, I might have a suggestion. I believe this may have happened because when I installed the PGNP driver, I was logged on to the hardware machine.
I believe I should have been logged onto the Cluster Virtual Server (role) which runs the clustered instance of Sql Server so that names goes into the license file.
This is the name which will be looked up when the jobs run under Sql Server, running on that Virtual Server.
I may be wrong as we still don't have a clustered test environment, but it seems possible that this was our problem with the license file error message.
Konstantin, thanks a million for the help! You got us up and running in less than two days, and we haven't had a problem again with PGNP!
Please Log in or Create an account to join the conversation.
Time to create page: 0.154 seconds