sql-server-2008 - 无法将 "AdventureWorks2008"示例数据库附加到 SQL Server 2008 中的命名实例

Question

首先，“Northwind”和“AdventureWorksDW2008”数据库附加没有问题，但“AdventureWorks2008”失败并出现以下错误。

//Msg 5120, Level 16, State 105, Line 1
 Unable to open the physical file 
"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents".
 Operating system error 2: "2(The system cannot find the file specified.)".
 Msg 5105, Level 16, State 14, Line 1
 A file activation error occurred. The physical file name 
 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents' 
 may be incorrect. Diagnose and correct additional errors, and retry the operation.
 Msg 1813, Level 16, State 2, Line 1
 Could not open new database 'AdventureWorks2008'. CREATE DATABASE is aborted.

我在安装期间没有使用默认数据库实例“MSSQLSERVER”。

那么它在哪里找到这个路径“C:...\MSSQL10.MSSQLSERVER...\Documents”？

Answer 1

进入sql server配置管理器sql server 服务 SQL Server(MSSQLSERVER)将“登录为”更改为“本地系统”