Today I have faced little funny error, which I haven’t faced earlier.
While installing the SQL server 2008 R2 on Windows Server 2008 R2 X64, I got the below error at the 80% of the SQL Installation. Even you click on OK, it says that database engine doesn’t install properly.
When I saw the Services , SQL Server service is running fine but SQL agent is not running. Getting an error while starting it.
I have tried uninstalling/installing and rebooting the machine ,nothing works, it breaks my head for an hour, after 1 hour I found that it is blocking at the group policies level.
Explanation:
For security reasons in some projects/servers, Windows team/Clients will enable the group policies at the domain level. Same thing happened here.
So I have checked the 3 places where the SQL server service (which the SQL server services needs to run) in the Group policies and I found that service was not added as part of the installation.
Group polices are blocking SQL server installation to add them in the below policies, So I have added it manually and re-ran the installation.
Resolution:
Go to Run àgpedit.mscàit will open the below window, go to the path which I showed in the below screen shot.
In the User Rights Assignment à Go to the each one of the below polices and click on Properties and add the user id (your SQL service account). Make sure that your service account is alos added as a Windows server admin as well.
Atlast issue is resolved and SQL server was installed successfully JJ…
This post may help me or someone in future instead of bothering/breaking their heads for hours….
No comments:
Post a Comment