使用 SQL Server Management Studio 附加(打开)mdf 文件数据库 [英] Attach (open) mdf file database with SQL Server Management Studio

问题描述

你能帮我如何打开用 VisualStudio 2010 创建的数据库的 *.MDF 文件到 SQL Server Management Studio 中吗?

Can you help me how can I open *.MDF file of database created with VisualStudio 2010, into SQL Server Management Studio?

我自己尝试附加，但由于(我猜)某些安全原因我无法导航到该文件.

Tried to attach by myself, but I cannot navigate to that file for (I guess) some security reason.

推荐答案

我遇到了同样的问题.

系统配置:-带有window 7 sp1服务器和客户端的单系统安装在同一系统上

system configuration:-single system with window 7 sp1 server and client both are installed on same system

我试图访问窗口桌面.正如某些答案所说，您的 Sqlserver 服务没有对​​该目录的完全访问权限.这是完全正确的.

I was trying to access the window desktop. As some the answer say that your Sqlserver service don't have full access to the directory. This is totally right.

我做了几个简单的步骤就解决了这个问题

I solved this problem by doing a few simple steps

1. 转到所有程序->microsoft sql server 2008 -> 配置工具，然后选择 sql server 配置管理器.
2. 选择服务并转到属性.在构建帐户对话框中选择本地系统，然后选择确定按钮.

图片中的第 3 步和第 4 步是访问文件夹的演示

Steps 3 and 4 in image are demo with accessing the folder

这篇关于使用 SQL Server Management Studio 附加(打开)mdf 文件数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！