Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log onto the PC running SQL Server.

  2. Install the Crows Nest update using the file "CrowsNestSetup.msi". When installing, ensure DB Utility is selected on the Custom Setup step (see following picpics below)

  3. Open the application "Crows Nest DB Utility.”

  4. Fill in the "Server" and "Database" fields. The "Refresh List" buttons can be used to find SQL Servers on the network and query Database names from the selected server.

  5. Either check the "User current Windows login" option or enter credentials for another account with permission to modify the database.

  6. Click the button titled "Update Database"

  7. Answer "Yes" when prompted to Backup the Database

  8. Use the folder selection window that opens to select a backup location. Backing up to a User's folder such as the Desktop or My Documents won't work unless specific permissions are granted to the folder. In most network situations, creating a folder in the root folder of the local drive will work.  To configure a specific folder with permissions, first figure out which account is configured to run the SQL Server service. You can see this by viewing "Services" in Windows, finding the service for the SQL Server instance, and reading the account listed in the "Log On As" column. With most SQL Server versions using the default options for installation will create a new user account to run the service. (Example: MSSQL$ServerInstanceName). A default folder should be created with the correct permissions when the SQL Server instance is installed and can typically be found here: C:\Program Files\Microsoft SQL Server<Instance Name>\MSSQL\Backup

  9. After the Backup has completed, click "OK" to continue to update the database.

  10. If you use multiple databases, repeat steps 4 through 9 for each database.

  11. Close the DB Utility application. Next, move to Installing Update on Client PCs below.

...

When a user attempts to connect to a database it will check to see if a client has connected with a newer version or if a database update has been run with a newer client version. If either of these conditions are true, it will see if there is a file path for the install file stored in "Install File Location" setting under Settings-->Options-->General Tab (see following pic). If it finds a valid file path there it will prompt the user to run it. Make sure the path can be reached by all clients by using a network UNC path or a mapped drive location shared by all clients.

...

Manual Update

Install the file "CrowsNestSetup.msi" on each client PC manually. There are ways to distribute an install file to multiple PCs on a network from a single location. Consult your IT professionals for options.

...