August 19, 2008 at 6:33 am
i have the folloing case:
installed SQL Server 2005 SP2 on a PC joined to the domain, i used a domain user account for the services domain1\user1.
when am trying to use the SQL configuration manager or the SQL surface area manager am getting two errors:
1- cannot connect to WMI provider, u dont have permissions.
2- cannot locat remote server.
i tryed the follwoing scripts but it didnt helped:
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose
restart
then
C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"
then restart
what should i do?
..>>..
MobashA
August 21, 2008 at 1:24 am
i cuoldnt make work with out making the user in the administrator group on the PC running SQL server, this is not right there should be a solution am still searching but i really could use some help...
..>>..
MobashA
August 21, 2008 at 1:33 am
you should remove the wmi error and then use your MOF command it will work. I also had the same problem.
Zombi
August 21, 2008 at 3:29 am
i have downloaded the WMI Diagnosis utility, and troubleshooting the WMI problems, and i will try as u have said.
thanks
..>>..
MobashA
August 21, 2008 at 8:19 am
I DIDNT WORKED...nither SQL Configuration manager nor SQL Surface Area configuration!!!!
..>>..
MobashA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply