December 19, 2013 at 10:01 am
When I right click on the databases and select the start power shell option it giving me the following error message.
Warning : Couldn't obtain SQL Server Service information. An attempt to connect to WMI on 'Ram-PC' failed with the following error: An exception occurred in SMO while trying to manage a service. --> Failed to retrieve data for this reques.
Please let me know the causes. Do I need to start any WMI service.
How can you automate SQL Server through this Power shell
December 19, 2013 at 12:04 pm
Some of the WMI errors are due to security settings. Check this web page for details.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 20, 2013 at 7:37 am
Thanks. The link you posted here is not working it is giving the message "Runtime Error". How can I solve this issue?
December 20, 2013 at 7:58 am
Wow, not sure why that's not working. It's Microsoft's link, so I can't fix it. I think this is the same one.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
December 20, 2013 at 9:52 am
Hi Grant, this link is working fine now but I didn't see COM Security tab in the My Computer Properties dialog box to check the Launch and Activation Permissions section
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply