Ok, after 6 hours of struggle and ‘googling’ I could finally get this work. The problem was due to some account name conflict. Here are the steps I followed to set it right
1) Un-installed the SQLserver
3) Re-installed it back with following changes
- In the server configuration section, I changed the account name
details to “NT AUTHORITY/LOCALSERVICE” (during the installation process)
Please remember to set it as “NT AUTHORITY/NETWORKSERVICE” if LOCAL SERVICE is not allowed.