Comments
Sort by recent activity
Thanks for the answer, where do I configure it? I did have a look at the config file editor and loaded the Redgate.sqlmonitor.engine.alerting.base.service.exe.settings but I could not see where the value is to amend. / comments
Thanks for the answer, where do I configure it? I did have a look at the config file editor and loaded the Redgate.sqlmonitor.engine.alerting.base.service.exe.settings but I could not see where th...
Forget my last question, I found it! / comments
Forget my last question, I found it!
I had resolved this but was unable to delete the post before it had been approved and posted. However the issue was simply that the SQL Monitor server had not been allowed to relay external mail on the Exchange server. / comments
I had resolved this but was unable to delete the post before it had been approved and posted. However the issue was simply that the SQL Monitor server had not been allowed to relay external mail on...
I have worked around this by creating a new share on the server hosting the images and adding the SQLCloneAgent account with full control. The original location was using a DFS name so I am wondering if that was causing the issue. Regards / comments
I have worked around this by creating a new share on the server hosting the images and adding the SQLCloneAgent account with full control. The original location was using a DFS name so I am wonderi...
Hi DarrylC, This is issue no longer occurs when I update as the product has been fixed. But what I believe the original issue was that the port was unavailable until I stopped the ipmonitor web service. Then it released port 8080 to allow the upgrade. But over the last year or so I have not had to do this so I assumed this issue was fixed. Regards / comments
Hi DarrylC, This is issue no longer occurs when I update as the product has been fixed. But what I believe the original issue was that the port was unavailable until I stopped the ipmonitor web ser...
Thanks Alex, that would make perfect sense now. I previously used a different account to upgrade but now I have to use a dedicated "admin" account which I had not used before. Stopping SQL Monitor service before I do the upgrade make sense now. Thank you! / comments
Thanks Alex, that would make perfect sense now. I previously used a different account to upgrade but now I have to use a dedicated "admin" account which I had not used before. Stopping SQL Monitor ...
Thanks praveen_d that could be it. The clone was on a server which runs a daily index optimise job for all databases so I will update it to exclude any clone databases. Thank you. / comments
Thanks praveen_d that could be it. The clone was on a server which runs a daily index optimise job for all databases so I will update it to exclude any clone databases.Thank you.
The script is supposed to delete all the users so the image created has no permissions. The script runs fine in SSMS because it uses my account. But SQL Clone is creating what I assume is a temporary account called SqlClone_LowPriv_1l5. So when the script runs it fails because it cannot remove SqlClone_LowPriv_1l5. This is what appears in the log: The server principal "SqlClone_LowPriv_1l5" is not able to access the database "SqlCloneTemp_4hojwsno" under the current security context. My aim is to run a modification script to remove permissions and various table backups on the production database. Then I have a nice clean image of the database to then clone. Thanks. / comments
The script is supposed to delete all the users so the image created has no permissions. The script runs fine in SSMS because it uses my account. But SQL Clone is creating what I assume is a tempora...
Thanks Mark R. I had to amend my TSQL to include this line: AND LEFT(name, 8) <> 'SqlClone' So it excludes the temp user. Cheers. Still learning about SQL Clone.... / comments
Thanks Mark R. I had to amend my TSQL to include this line:AND LEFT(name, 8) <> 'SqlClone'So it excludes the temp user. Cheers.Still learning about SQL Clone....
Looks like my modification script had errors in it. I re ran the image creation without any modification script and it was fine. Thanks. / comments
Looks like my modification script had errors in it. I re ran the image creation without any modification script and it was fine. Thanks.