Others: How to attach Database file from SQL Management Studio

From AutoCount Resource Center
Jump to navigation Jump to search

Question: How to Attach raw database from SQL Management Studio?



Answer:

1. Locate and put your raw database into C:\AutoCount Data.

2. Grant access right for Everyone for Data file and Log file.


Attach sql db.png



3. Grant Permission for everyone.


Attach sql db1.png



4. Login into SQL Management Studio using SQL Server Authentication (username is ‘SA’).


Attach sql db2.png



5. Once login, right- click on the database folder icon and click on ‘Attach’.


Attach sql db3.png



6. Click on the ‘Add…’ button and locate the raw database file. And Click on ‘OK


Attach sql db4.png



7. Click on ‘Ok’ to attach the database.


Attach sql db5.png



The raw database has been successfully attached to the SQL Server.


Attach sql db6.png



By: Michelle 171103, KM 180409, P180416




Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations