current position:Home>SQL. Why not attach it, as shown in the figure

SQL. Why not attach it, as shown in the figure

2022-02-02 23:48:33 CSDN Q & A

img


No disk selection




Refer to the answer 1:

Generally, it is a security problem that makes it impossible to access the corresponding hard disk ,mssqlserver Run as a local system account , And then check mdf File permissions .

img




Refer to the answer 2:



Refer to the answer 3:

Hello ,
You can try the following methods to solve :
In all programs -->SQL Server 200x--> Configuration tool -->"SQL Server Configuration Manager"--> Click on "SQL Server 200x service "--> Right click ‘ attribute ’-->' Login tab '--> Right click your user ( Such as sa) attribute --> Built in account selection "Local System", Click restart .




Refer to the answer 4:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.
https://en.primo.wiki/2022/02/202202022348314875.html

Random recommended