我试图在服务器上配置ssrs,当我尝试创建ReportServer和ReportServerTempDB时,会得到以下错误:
System.Data.SqlClient.SqlException:文件"D:\microsoft server\data\ReportServer.mdf“的目录查找失败,操作系统错误3(系统找不到指定的路径)。
我已经尝试通过右键单击对象资源管理器中的服务器,然后是Properties>Database设置,然后在这里设置路径来更改默认的数据目录,但是我仍然得到了错误。
发布于 2014-12-01 16:34:59
看起来您没有写入您指定的文件夹的权限。
您需要确保正在运行的服务帐户Server对要写入的文件夹路径具有写权限。
编辑:
使用以下步骤:
//SqlExpress
1.Click the Windows Start button, and then click Run. The Run dialog box appears.
2.Type Services.msc into the Open field, and then click OK. The Services
panel appears:
3.Right-click the SQL Server (SqlEx[ress) service, and then click Properties from the shortcut menu. The SQL Server (SqlExpress) Properties (Local Computer) dialog box appears:
4.On the Log On tab, select Local System account for the Log on as option.
5.Press Apply and then press OK on the dialog box that appears.
6.Click on the General tab and then press Stop the stop the service, and Start to restart the SqlExpress service.
7.Press OK and close the services Console.
8.Launch SqlExpress and attempt to now restore the database.https://stackoverflow.com/questions/27232751
复制相似问题