Installing the SQL version of Pro 7

Modified on: 2017-08-04 10:58:37 -0400

FIRST: You must have purchased the SQL version of DM Pro in order to continue.

Contact Sales if you are interested: 800-836-2999

Design Manager for SQL Server Installation Instructions

STOP! Do NOT install DM until you read these instructions!

A. Install the database on your SQL Server. 

Design Manager (DM) requires SQL Server 2008/2008R2 or 2012 running with Windows Authentication. Note that Windows XP workstations cannot access the server using the 2012 native client, 2008/2008R2 must be used if Windows XP workstations will access the server.

STEP 1: Copy the DMP70EmptySQL2008DB.bak file from the folder entitled “SQLStarterDB” on the Design Manager Installation CD to the local drive of the SQL Server Computer.

STEP 2: Open the SQL Server 2008/2012 Management Studio and log onto the SQL Server.

STEP 3: Right-click on the Databases Folder and choose Restore Database.

STEP 4: In “To Database” type “DMP70.” Click on “From Device.” Click the browse button (…) next to the “From Device” option.

STEP 5: Click on “Add.” Choose the DMP70EmptySQL2008DB.bak file that you saved in STEP 1.

STEP 6: Click the Restore box in the column on the grid and then Click OK

B. Install the SQL Server Native Client 10

Each Workstation, Terminal or Citrix Server that will be running Design Manager must have the SQL Server Native Client 10.0 installed. This is available on your SQL Server install CD or on Microsoft’s website:

Microsoft SQL Server 2008 Native Client

Microsoft SQL Server 2008 Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.

Audience(s): Customer, Partner, Developer

X86 Package (sqlncli.msi) - 4549 KB
X64 Package (sqlncli.msi) - 7963 KB
IA64 Package (sqlncli.msi) - 11112 KB

You will want to put the TS server in Install mode. Command Prompt – type: change user /install

C. Install Design Manager

  • Install DM to a network share that all of your Workstations or Terminal Servers have access. If you are running DM exclusively on a Terminal or Citrix Server, this may just be the local drive of the Terminal Server.

  • The Terminal (Citrix) Server should never be the same machine as the SQL Server.

  • The DM Install directory should never reside on the SQL Server.

  • Install to one workstation or the Terminal Server first and then go to step D, you can install other workstations later. For specific DM Install Instructions, for workstation setup, and for Terminal Server setup, see the manual.

D. Configure Design Manager to Access the SQL Server

STEP 1: After installing DM on a workstation or on a Terminal Server, an icon should appear on the machine’s desktop. Before continuing, make sure that the SQL Server Native Client 10.0 from step B has been installed on this workstation or server*.

STEP 2: Double-click on the DM Pro 7 icon to run it. Do NOT Type in the product code at this time, just click the “Continue” button.

STEP 3: At the top of the DM Window, choose File and then choose Live Update. Answer Yes to continue and No to the backup option.

STEP 4: Complete the Live Update by following the prompts. When the update completes the program will be restarted.

STEP 5: Type in the Product Code found on the back of the DM CD case. A message will appear that states that you need to configure DM for the SQL Server. Click OK to clear the message.

STEP 6: Browse to the shared DM folder (DM Installation Directory). Find the program, dmp7sqlconfig.exe and double-click to open it.

STEP 7: Type the Name of the SQL Server machine into the SQL Server / Instance box.

STEP 8: Check the box at the bottom of the window called “When user run DM, override registry setting for SQL configuration.”

STEP 9: Click Test Connection. If the test succeeds, click Save Configuration and then exit the program.

*Note: The SQL Server 2012 Native Client cannot be loaded on to Windows XP. If a mix of Windows XP and newer workstations are to access an SQL 2012 server, the SQL 2008 Native Client must be used on all workstations. If no XP machines are present, the OLE DB Provider can be set to SQLNCLI11 to use the 2012 Native Client.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.