Skip to main content
Install

Attach and detach SQL databases with SQL server management studio

Attach or detach a SQL database to the SQL instance for Accounting CS, Workpapers CS, and Practice CS using SQL Server Management Studio. This article explains the steps for SQL Server Management Studio. The steps may differ if you have the full version of SQL. If you haven't installed SQL Server Management Studio, consult your firm's qualified IT professional.
Follow these steps to attach or detach a SQL database.
  1. Open SQL Server Management Studio.
  2. Select the desired instance for attachment or detachment.
  3. Select
    Connect
    .
  4. Then, follow either of the procedures below.
Detach a database in management studio
To detach a database:
  1. Expand the
    Databases
     folder by clicking the "+" button next to it under the instance.
  2. Right-click the database you want to detach.
  3. Select
    Tasks
    , then select
    Detach
    .
  4. Mark the
    Drop
     checkbox.
  5. Select
    OK
    .
Attach a database in management studio
To attach a database:
  1. Right-click the
    Databases
     folder under the instance, then select
    Attach
    .
  2. Select
    Add
    .
  3. Select the database file you want to attach and click OK.
  4. Verify the correct database is selected and select
    OK
    .
    note
    If you see a message about a missing LDF file, remove the file and proceed. SQL will recreate the LDF file.
  5. Open your CS program (Accounting CS, Workpapers CS, or Practice CS).
    note
    If the database doesn't appear on the login screen, the database owner may not have transferred during attachment. To fix this:
    • Run the installation for your CS program.
    • Skip to step 2 of the CS installation.
    • Select the option to use an existing instance.
    • Select the instance you just attached.

This article applies to:

  • Product: Workpapers CS
  • Subject: Install,Setup,SQL