无法安装PrescriptionContoso数据库 [英] Unable to install the PrescriptionContoso database

问题描述

我一直在试用LightSwitch，并且已经在Vision Clinic演练中达到了连接到数据库的步骤。当我尝试安装PrescriptionContoso数据库时，我收到以下消息： -

I have been trying out LightSwitch and have reached the Connect to a Database step in the Vision Clinic walkthrough. When I try and install the PrescriptionContoso database I get the following message:-

C：\Temp> sqlcmd -S。\SQLExpress -i attachContoso.sql

将数据库上下文更改为"master"。

文件激活失败。物理文件名"C：\ TEMP \PRESCRIPTIONCONTOSO_log.LDF"可能不正确。

创建了新的日志文件'C：\ TEMP \PRESCRIPTIONCONTOSO_log.LDF'。

C:\Temp>sqlcmd -S .\SQLExpress -i attachContoso.sql
Changed database context to 'master'.
File activation failure. The physical file name "C:\TEMP\PRESCRIPTIONCONTOSO_log.LDF" may be incorrect.
New log file 'C:\TEMP\PRESCRIPTIONCONTOSO_log.LDF' was created.

附加到数据源的步骤不行。我得到

The steps to attach to the data source do not work. I get

 数据库'C：\Temp \PrescriptionContoso.mdf"不存在或您无权查看它。你想创建吗？

 The database 'C:\Temp\PrescriptionContoso.mdf" does not exist or you do not have permission to see it. Would you like to create it?

我安装了VS2010。

I have VS2010 installed.

TIA

推荐答案

你好Jan，

当您解压缩Vision Clinic示例时，是否将其解压缩到C：\ Temp文件夹？ SQL脚本以及演练中的一些步骤假定数据库位于C：\ Temp。

When you unzipped the Vision Clinic sample, did you extract it to the C:\Temp folder? The SQL script as well as some steps in the walkthrough assume that the database is in C:\Temp.

希望这有帮助，

这篇关于无法安装PrescriptionContoso数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！