How to modify the user and the server folder in SQLServer 2014

Question

How to modify the user and the server folder in SQLServer 2014

Navigation

#1 by (0 votes)

0

I would like to know how to modify the user and the password of the server and it is possible to modify the place where the server is saved after installing the SQL server 2014 in windows 10. I have already looked at several sites but not I found a solution.

sql-server

asked by anonymous 26.01.2016 / 16:14

1 answer

Register multiple elements with several associated images in a DB at once only in php Correct where clause with like null operator that finds data with nulls parameters

score 0 · Answer 1

To change the password , you can do the following:

ALTER USER WITH password="".

Or use SQL Management Studio to select the user you want to change, click Properties, and change the password by the form.

To change the location datafile :

1) Check where the datafile you want is located.

2)StoptheSQLServerservice.ItisveryimportantthatSQLServerisstoppedsoasnottocorruptyourdata.BySQLManagementStudioyoucandowiththesauser.

DonotconfusewiththedefaultSQLfolderwiththelocationwherethedatafilesareeffectively.ThepathdescribedbelowisthedefaultpathwhereSQLServerwillcreatethedatabaseifyoudonotspecifythelocation.

3)Copythedatafile(s)thatwillbemovedtothenewplace.Choosetocopyratherthanmove,forsafety.Oncemigratedyoucandelete.

4)StartSQLServer.

5)Putyourdatabaseasoffline.

6)DetachtheSQLServerdatabase.

7)AttachthedatabasetoSQLServer

8)ClicktheaddbuttonandselecttheMDFfileforyourdatafile.It'sveryimportantthatthenewdatafilelocationhasprivilegessoyoucandothis.

9)CheckinthedatabasepropertyiftheDatafileiscorrect.

Study Indication

If you want to take more advantage of the study and at each step before clicking the OK button, click the Script button on the taskbar, the command that will be executed with the OK button will be displayed to you, script for the next migration.