SQL Server 2005 cannot access the specified path or file on the server _mssql2005

Source: Internet
Author: User
Tags microsoft sql server mssql
Just installed SQL Server 2005 system, the additional database is the following prompts
C:\Program Files\Microsoft SQL Server\mssql.1\mssql\data
The specified path or file could not be accessed on the server. Make sure that you have the necessary security permissions and that the path or file exists. If you are sure that the service account you are using can access a specific file, type the full path to the file in the file name control in the Locate dialog box.

Then there is the box to locate the database file, there is no letter in it, you can't choose the database.


Depressed half of the afternoon, remember that there had been this problem, no record down, the result again made a mistake.



In Baidu know the answer found above

① Open SQL Server Configuration Manager
② Click on the "SQL Server2005 service" on the left, select SQL Server (instance), right key property
③ login tab, there is a built-in account to be changed to local system
④ Restart Service
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.