Howdy,
This time, i had to rebuild my lab and when i was installing the SCCM 2012 R2 server, it kept throwing an error "Attempted to perform an unauthorized operation" once, I enter sql server name and click Next.
I looked at many other blogs, where they have mentioned either to check domain connectivity or change the location of the setup files( save locally and start install)
The first one made more sense to me as we could be authenticating with the SQL Server while connecting.
So, what i did is i ran a network monitor and tried to run the setup again. What i found is that, we try to negotiate while opening and SMB connection from SCCM to SQL but at one point, we fail to authenticate and would end up Closing the connection.
Here are the logs from the SCCM Setup:
1/20/2015 4:09:55 PM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database master on server sql01.Contoso.com.
1/20/2015 4:09:55 PM: ConfigMgrSetupWizard Error: 1 : Exception message: [Attempted to perform an unauthorized operation.], Exception details: [System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
Looking at the server, everything seemed ok ( from sql and sccm )
1. All the ports are open within the domain ( Allowed in windows Firewall)
2. Nothing in between to block ( they are running on hyper v same Host Server)
This was a road block!!
Then, i tried to access the Admin share of SQL Server from SCCM Server and it says access denied!!
But, it also helped me understand that the time on SCCM was not syncing up with my PDC and was way past the correct time as it would throw an error related to Time.
I used w32tm command to resync the time but somehow it would always revert back to its original time.
I then reconfigured the time to synchorize with my PDC once the time synched, the setup successsed without issues.
Reference: https://technet.microsoft.com/en-us/library/w32tm.aspx
This time, i had to rebuild my lab and when i was installing the SCCM 2012 R2 server, it kept throwing an error "Attempted to perform an unauthorized operation" once, I enter sql server name and click Next.
I looked at many other blogs, where they have mentioned either to check domain connectivity or change the location of the setup files( save locally and start install)
The first one made more sense to me as we could be authenticating with the SQL Server while connecting.
So, what i did is i ran a network monitor and tried to run the setup again. What i found is that, we try to negotiate while opening and SMB connection from SCCM to SQL but at one point, we fail to authenticate and would end up Closing the connection.
Here are the logs from the SCCM Setup:
1/20/2015 4:09:55 PM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database master on server sql01.Contoso.com.
1/20/2015 4:09:55 PM: ConfigMgrSetupWizard Error: 1 : Exception message: [Attempted to perform an unauthorized operation.], Exception details: [System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
Looking at the server, everything seemed ok ( from sql and sccm )
1. All the ports are open within the domain ( Allowed in windows Firewall)
2. Nothing in between to block ( they are running on hyper v same Host Server)
This was a road block!!
Then, i tried to access the Admin share of SQL Server from SCCM Server and it says access denied!!
But, it also helped me understand that the time on SCCM was not syncing up with my PDC and was way past the correct time as it would throw an error related to Time.
I used w32tm command to resync the time but somehow it would always revert back to its original time.
I then reconfigured the time to synchorize with my PDC once the time synched, the setup successsed without issues.
Reference: https://technet.microsoft.com/en-us/library/w32tm.aspx
No comments:
Post a Comment