March 6, 2017 at 11:27 pm
Dear ALL
1) I want to deploy my SSRS reports on my local-pc But when i try to deploy its show error..When i check Reporting server configuration manager (see attachment),it shows error of Unable to connect Server,WMI provider,invalid namespace...
I have installed SQL 2008 R2 SP1 Express(64-bit) (see snapshot for full SQL details) in my system.
Please help me out..
2) Also SQL Server agent not able to start in SQL services...Even i try to do still via property of sql agent then gives this error. (see attachment).
These are the issues i am facing..
Kindly help..In any query please ask..
Thanks
Sidra
March 7, 2017 at 7:18 am
Why use Express Edition? It is not able to have SQL Agent operate. Not sure about SSRS, but it might not be capable of that either. On the other hand, SQL Server Developer Edition can do everything the Enterprise version can, but it's not properly licensed if you allow more than one user to access it.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 7, 2017 at 7:42 am
projectengineering - Monday, March 6, 2017 11:27 PMDear ALL1) I want to deploy my SSRS reports on my local-pc But when i try to deploy its show error..When i check Reporting server configuration manager (see attachment),it shows error of Unable to connect Server,WMI provider,invalid namespace...
I have installed SQL 2008 R2 SP1 Express(64-bit) (see snapshot for full SQL details) in my system.
Please help me out..
2) Also SQL Server agent not able to start in SQL services...Even i try to do still via property of sql agent then gives this error. (see attachment).These are the issues i am facing..
Kindly help..In any query please ask..
Thanks
Sidra
1. Reporting services isn't listed in the services for configuration manager so I would guess you haven't configured it yet?.
Check this directory: C:\Program Files (x86)\Microsoft SQL Server\100\Shared
and see if you have a file named: sqlmgmproviderxpsp2up.mof
If you do, open your command prompt as administrator and run this:
mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
and then restart the winmgmt service
2. You should do like the message says - Check the Windows event logs. That should tell you what the problem is with the service.
Sue
March 24, 2017 at 12:37 am
Thanks sir for your reply...I have run same command it run allright..but still same issue is there..I have Express edition in my system..I think that is the issue..
Can you tell me can i upgrade from express to standard sql version without uninstalling sql as most of my software are depending on sql services???:unsure:
March 24, 2017 at 8:20 am
projectengineering - Friday, March 24, 2017 12:37 AMThanks sir for your reply...I have run same command it run allright..but still same issue is there..I have Express edition in my system..I think that is the issue..Can you tell me can i upgrade from express to standard sql version without uninstalling sql as most of my software are depending on sql services???:unsure:
I just looked more at your screenshots - it looks like it is not Express with Advanced Services? In that case you wouldn't have SSRS.
You can upgrade from Express to Standard but if you upgrade to 2008R2 standard, you would be running in a version that is nearly out of support. If you were to be on a higher service pack, you'd have more options. You could go to 2008R2 or 2012 on SP1. Here is the supported upgrade matrix - you would want to check the other versions drop down at the top to see what upgrade paths require which versions :
Supported Version and Edition Upgrades
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply