SOLVED Cannot detect SMS Type because either SiteServer, SqlServer or SiteServerName is empty

[Harinda]

Hi Prajwal. When I install sccm 2012 r2 I get error saying "attempted to perform an unauthorized operation" when giving sql 2012 server name.Could you help me to fix this
Thanks

 

[Prajwal Desai]

In the screenshot i see the SQL server name is dc01.local while in the log file I see "Creating SQL connection to database master on server dc01.hdnit.local." During the setup did you change the SQL Server name FQDN ?

 

[Harinda]

In the screenshot i see the SQL server name is dc01.local while in the log file I see "Creating SQL connection to database master on server dc01.hdnit.local." During the setup did you change the SQL Server name FQDN ?

Hi Prajwal,
Thank you for the reply. As it giving me errors I tried giving dc01.hdnit.local.then it says I have to use sqlserver 2008 with sp2 or sql server 2012 with sp1. I am using sql server 2012.Not sure whether it has sp1.So I downloaded sp1 and tried to install it.Then it says there are no sql instances to be updated.
I attached all the screen shots for your ref.

Thanks for your help again
Harinda

 

[Prajwal Desai]

Can you uninstall the SQL 2012 and install back SQL 2012 with SP1 ?. Something is wrong with SQL service pack.

 

[Harinda]

Hi Prajwal
I uninstal sql server and installed sql server2012 with sp1. Now I am getting attached error message.Could you instruct me to get this work
Thanks
Harinda

 

[Harinda]

Hi Prajwal
After enabling tcp ip and giving dynamic port = 0 in sql server config manager it worked

Thanks

 

[Prajwal Desai]

Thanks for sharing the solution. Marking this thread as Solved.