Dear athulkm123,
This is a very common issue, usually occurs when the Temp\2 folder goes missing.Check the environment value for Temp and TMP.
C:\Users\%USERNAME%>set t
TEMP=C:\Users\%USERNAME%\AppData\Local\Temp\2
TMP=C:\Users\%USERNAME%\AppData\Local\Temp\2
Make sure the directory listed exist and your id has appropriate permission to write to that directory. Alternatively, through the control panel (Control Panel-> System and Security-> System -> Advanced system settings), you can change the default directories that are assigned to TEMP and TMP.
In other cases, this issue is resolved by navigating to %appdata% and creating the Temp\2 directory. In other cases, this is resolved with a server restart (where the SQL is located)
Sincerely,
Varnavas Eleftheriou
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.