Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday 22 May 2017

How to Change SQL Services run through Different Service Account on SQL Server other than Default

How to Change SQL Services run through Service Account on SQL Server


service account it should meet below criteria



  • Service account should be password protected



  • Service account should be full control over Data folder which SQL Service is installed on local drive path



if again it is not working follow below for

we can go below


  • it should be local admin of server



  • it should be part of SQL Server sysadmin privileges



Demo:

Here SQL 2012 C O N V TEST is running on default account as

NT Service\M S SQL$SQL 2012 C O N V TEST

we need to change it to USER PC / USER



Here make sure/add  it should be full control on DATA folder on which SQL Server is installed


Now we are going to change SQL Service account as see below


you should make sure password is mandatory other wise you will get error



if you not give password/ account does not have password then will face below error


after we changed service account successfully see below



keep blogging and enjoy!!!!!!!!!!!!!






















Monday 1 May 2017

How to resolve .bak files does not shown in the folder while restore in SQL Server


How to resolve .bak files does not shown in the folder while restore in SQL Server


you can see now we are going to restore standard edition 2012 from express edition 2012

Source
Express edition 2012



Destination:

SQL 2012 Standard edition 


now we are going to select .bak files from SQL 2012 Express edition

but it did not shown up as see below


but actually bak files existing on specified location



when we go to properties of folder it showed express edition service account which SQL Server running

it causes it did not show while choose file from SQL Standard edition


solution

we should need to give all permission on Restoring server Service account of which SQL server running our cases SQL Standard edition service account


Now we choose standard edition service account and give all permission on backup folder


now give all permission of standard edition service account


Now it shown bak files as see below


so restore database activity is done