Viewing 15 posts - 1 through 15 (of 67 total)
Some details :
I am configuring SCSM report on SQL SSRS server. For the multimart Data Source I selected Microsoft Analysis Services - as data source type and connection string given...
August 11, 2021 at 10:09 am
Thanks for response. I tried with SYS Admin access but same. Actually I restored the databases from SQL 2012 to a SQL 2014 server. Including report databases and the encryption...
August 11, 2021 at 10:06 am
Thanks guys, so I don't think there would be any limitations other than using this on production.
I hope even the database sizes, memory , CPU / high availability features would...
September 2, 2020 at 3:22 pm
Thank you Jeff ! and all others!
The issue is fixed by granting access to the GMSA to the folders where the files were extracted and where the backup files were...
August 28, 2020 at 11:42 am
Finally it turns out that permissions to the folder were required, permissions to the SQL server service account. Once this was granted
EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1 ==> Command worked !
Thanks all for...
August 28, 2020 at 11:38 am
Hi,
My command is : EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1
And I have one file in the directory, but the out is : (0 rows affected)
I am running this on SQL Server 2017 version.
Any...
August 27, 2020 at 5:38 pm
This same bat file ran successfully through Windows task scheduler job. That is the extractor bat file.
You mean to say ==> : E:\Extractor64 -F "E:\Test\%NewestFile%" -E D:\TestBackups\test.bak ?
August 27, 2020 at 12:52 pm
Thank you all for the suggestions/ inputs , really appreciate it.
Previously, I was using my own account to create the task scheduler job and it was running successfully. Now, management...
August 27, 2020 at 12:38 pm
Thanks for the suggestion Brian, I also suspect that the GMSA needs to be added to Log on as batch Job and needs to be in the Administrator group. I...
August 26, 2020 at 6:16 pm
Hi Brian, thanks for the response.
tns ping works from SQL SERVER box to the oracle server that is mentioned in the tns names file.
i think I can create a linked...
August 24, 2020 at 9:39 pm
Thanks Andy, let me try this method you suggested , keep posted
July 17, 2020 at 7:59 pm
Thanks for replying back, I'll take a look at the suggestion
June 17, 2020 at 12:19 pm
Thanks for all the help, I'll try this out.
June 15, 2020 at 3:20 pm
Viewing 15 posts - 1 through 15 (of 67 total)