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
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.