Difference between revisions of "Setup SQL Server"

From WireCAD Online Help
Jump to: navigation, search
 
(31 intermediate revisions by 3 users not shown)
Line 3: Line 3:
 
|perms=All
 
|perms=All
 
|level=All
 
|level=All
−
|desc=Install SQL Server.}}<br>
+
|desc=Install SQL Server.}}
  
 
__TOC__
 
__TOC__
  
  
−
It is not within the scope of this manual to provide an in depth discussion of SQL Server. We will touch on the basics required for use with WireCAD.
+
<br/><br/>It is not within the scope of this manual to provide an in depth discussion of SQL Server. We will touch on the basics required for use with WireCAD. Basics
−
Basics
+
 
 +
The WireCAD distribution includes SQL Server database files for the Global Equipment database. You will need to attach these to the the running server. You will then configure WireCAD to look at the SQL Server for the Global Equipment database. WireCAD projects will create a new database (catalog) for every new project. You will need to set up permissions for each user to allow them dbcreator privileges. This is the default for localhosts but not remote servers.
  
−
The WireCAD distribution includes SQL Server database files for the Global Equipment database. You will need to attach these to the the running server. You will then configure WireCAD to look at the SQL Server for the Global Equipment database. WireCAD projects will create a new database (catalog) for every new project.
 
−
You will need to set up permissions for each user to allow them dbcreator privileges. This is the default for localhosts but not remote servers.
 
−
 
 
There is no further requirement to attach databases once the Global Equipment database.
 
There is no further requirement to attach databases once the Global Equipment database.
−
+
 
−
SQL Server can be set up on a server or on a local machine.  
+
SQL Server can be set up on a server or on a local machine.
  
 
== Where to Download SQL Server ==
 
== Where to Download SQL Server ==
  
−
WireCAD requires the 2005 version and can use the Express versions which can be found here:
+
WireCAD requires a minimum of SQL Server 2012 (will also work with later versions) and can use the Express versions which can be found here:
−
+
 
 +
<br/>[https://www.microsoft.com/en-us/download/details.aspx?id=43351 https://www.microsoft.com/en-us/download/details.aspx?id=43351]
 +
<br>Download either:
 +
SQLEXPR_x64_ENU.exe or
 +
 +
SQLEXPR_x86_ENU.exe
 +
 
 +
Be sure to download SQL Server Management Studio Express as well. Both are free.<br/>
 +
On the same page download:
 +
 +
SQLManagementStudio_x64_ENU.exe or
 +
 +
SQLManagementStudio_x86_ENU.exe
  
−
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22625
 
−
 
−
Be sure to download SQL Server Management Studio Express as well. Both are free.<br>
 
−
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
 
−
 
 
SQL Server does not provide a graphical user interface so you will want to download the management studio listed above.
 
SQL Server does not provide a graphical user interface so you will want to download the management studio listed above.
  
−
{{Note| If you are installing SQL server on Windows 7 64bit, please see specific instructions at the bottom of the page.}}
+
{{Note| If you are installing SQL Server Management Studio on Windows 7 64bit, please see specific instructions at the bottom of the page.}}
  
 
== Setting Up the WireCAD Global Databases on SQL Server ==
 
== Setting Up the WireCAD Global Databases on SQL Server ==
  
−
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%"
+
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" width="100%"
 
|-
 
|-
−
! Step !! Description
+
! Step
 +
! Description
 
|-
 
|-
−
|Install SQL Server. You will be prompted for an instance name. Instance names allow you to have multiple SQL Servers running on the same machine. In addition you will be prompted for a security mode (Windows or SQL), Windows uses your Windows users and groups, SQL ignores these and allows you to manages different users and groups from within SQL Server.
+
| Install SQL Server. You will be prompted for an instance name. Instance names allow you to have multiple SQL Servers running on the same machine. In addition you will be prompted for a security mode (Windows or SQL), Windows uses your Windows users and groups, SQL ignores these and allows you to manages different users and groups from within SQL Server.
−
||I recommend using Windows security if you are installing on a local machine. If you are installing on a server select SQL security. You will then need to define a default WireCAD user that all WireCAD users will log in under.  
+
| I recommend using Windows security if you are installing on a local machine. If you are installing on a server select SQL security. You will then need to define a default WireCAD user that all WireCAD users will log in under.
 
|-
 
|-
−
|Install SQL Server Management Studio(SQLSMS).
+
| Install SQL Server Management Studio(SQLSMS).
−
||  
+
|  
 
|-
 
|-
−
|Launch SQLSMS and log in to the server. If the server is on your local machine you can use the shorthand .\INSTANCENAME for the host.
+
| Launch SQLSMS and log in to the server. If the server is on your local machine you can use the shorthand .\INSTANCENAME for the host.
−
||  
+
|  
 
|-
 
|-
−
|Click the '''Security''' Node and '''Add Login''' if you selected SQL Security ||[[File:Ssms_new_login.png‎|thumb|New Login Menu]] {{note|We recommend that you configure SQL Server for SQL authentication and that you create a single login for all WireCAD users. We have found this to require the least amount of administration.}}
+
| Click the '''Security''' Node and '''Add Login''' if you selected SQL Security
 +
| [[File:Ssms new login.png|New Login Menu]] {{note|We recommend that you configure SQL Server for SQL authentication and that you create a single login for all WireCAD users. We have found this to require the least amount of administration.}}
 
|-
 
|-
−
|Next right-click the instance name in the Object Browser and click '''Attach Database'''||[[File:Ssms attach db mnu.png|thumb|Attach Database Menu]] [[File:Ssms attach db dlg.png|thumb|Attach Database]]  
+
| Next right-click the instance name in the Object Browser and click '''Attach Database'''
 +
| [[File:Ssms attach db mnu.png|Attach Database Menu]]
 
|-
 
|-
−
|Attach The WireCAD Global Equipment Database || {{note|The following assumes that you are installing WireCAD on a local machine. If you are installing on a server you will want to copy the global database files to the server before you attach them to the server.}}
+
| Attach The WireCAD Global Equipment Database
 +
| {{note|The following assumes that you are installing WireCAD on a local machine. If you are installing on a server you will want to copy the global database files to the server before you attach them to the server.}}[[File:Ssms attach db dlg.png|Attach Database]]
 +
<br/>Click the '''[Add]''' button on the Attach Databases form and browse to:
  
 +
'''XP:'''<br/>C:\Documents and Settings\All Users\Shared Docs\WireCAD\WireCADx\WireCAD_Global_Equipment.MDF
  
 +
'''VISTA/7:'''<br/>Public\Public Documents\WireCAD\WireCADx\WireCAD_Global_Equipment.MDF
 +
 +
The form will add WireCAD_Global_Equipment_log.LDF file automatically. You will need [Remove] that record.
 +
 +
Click [OK] to attach the database.
  
−
Click the '''[Add]''' button on the Attach Databases form and browse to:
 
−
 
−
'''XP:'''<br>
 
−
C:\Documents and Settings\All Users\Shared Docs\WireCAD\WireCAD6\WireCAD_Global_Equipment.MDF
 
−
 
−
'''VISTA/7:'''<br>
 
−
Public\Public Documents\WireCAD\WireCAD6\WireCAD_Global_Equipment.MDF
 
−
 
−
The form will look for and add the WireCAD_Global_Equipment_log.LDF file. If it can not find it you will have to add it manually.
 
−
 
−
Click OK to attach the database.
 
 
|-
 
|-
−
|Change the default file save location.||
+
| Change the default file save location.
−
{{note|MS SQL Server will place database files in the C:\Program Files\MSSQL Server directories by default. This is not good practice as most backup software ignores the Program Files directory. To remedy this, right-click the Server Name in the Object Explorer and click Properties. Under the Database Settings node modify the Default Database Locations settings. }}[[File:DefaultDatabaseSaveLocation.png|Default File Location|thumb]]
+
|  
 +
{{note|MS SQL Server will place database files in the C:\Program Files\MSSQL Server directories by default. This is not good practice as most backup software ignores the Program Files directory. To remedy this, right-click the Server Name in the Object Explorer and click Properties. Under the Database Settings node modify the Default Database Locations settings. }}[[File:DefaultDatabaseSaveLocation.png|Default File Location]]
  
 
|-
 
|-
−
|You will now need to configure each WireCAD client to look at the SQL Server||
+
| You will now need to configure each WireCAD client to look at the SQL Server
−
# Launch WireCAD.
+
|  
−
# Click''' Project>Application Setup''' and follow the steps for SQL Server.
+
#Launch WireCAD.
 +
#Click'''Project>Application Setup''' and follow the steps for SQL Server.
 +
 
 
|}
 
|}
  
−
== Specific Instructions For Installing On Windows 7 64bit ==
+
== Specific Instructions For Installing SQL Management Studio On Windows 7 64bit ==
  
−
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%"
+
{| class="wikitable" style="color:black; background-color:#ffffcc;" cellpadding="10" width="100%"
 
|-
 
|-
−
! Step !! Description
+
! Step
 +
! Description
 
|-
 
|-
−
|1. Place your SQL Server Management Studio Installer in your user downloads folder. '''Example:My Computer>(Your Hard Drive)>Users>(your username)>downloads''' || You can place this installer in a different folder but you will need to know the FULL path to find this. '''Example: C:\Users\BobsPC\My Documents\Applications\........''' [[File:Downloads_Folder.png|thumb|Downloads Folder]]
+
| 1. Place your SQL Server Management Studio Installer in your user downloads folder.
 +
'''Example:My Computer>(Your Hard Drive)>Users>(your username)>downloads'''
 +
 
 +
| You can place this installer in a different folder but you will need to know the FULL path to find this.
 +
'''Example: C:\Users\BobsPC\My Documents\Applications\........''' [[File:Downloads Folder1.png|Downloads Folder]]
 +
 
 
|-
 
|-
−
|2. Once your installer/exe is placed where you would like it, rename it to something simple. '''Example:SQL Managment or Managment Studio'''|| You dont have to rename however it will help simplify things in the next couple steps.
+
| 2. Once your installer/exe is placed where you would like it, rename it to something simple.
 +
'''Example:SQL Management or Management Studio'''
 +
 
 +
| You don't have to rename however it will help simplify things in the next couple steps. [[File:Rename File.png|Rename File]]
 
|-
 
|-
−
|3. Click the ''"Start"'' button and type '''CMD''' in the search bar. || At the top of the search window, you should see the '''CMD''' Icon under the programs tree.
+
| 3. Click the ''"Start"'' button and type '''CMD''' in the search bar.
 +
| At the top of the search window, you should see the '''CMD''' Icon under the programs tree. [[File:Cmd prompt.png|Command Prompt]]
 
|-
 
|-
−
|4. '''RIGHT CLICK AND RUN AS ADMINISTRATOR'''|| It is very important to run as an administrator to complete the install successfully.
+
| 4. '''RIGHT CLICK AND RUN AS ADMINISTRATOR'''
 +
| It is very important to run as an administrator to complete the install successfully. [[File:Run as admin.png|Run As Administrator]]
 
|-
 
|-
−
|5. With the command prompt open, type the '''Full''' path for your installer including the file name. '''Example: C:\Users\BobsPC\Downloads\SQL Managment.msi''' || Regardless of what you rename the file to, the file extension will remain '''.msi''' and you '''MUST''' put it in the command prompt.
+
| 5. With the command prompt open, type the '''Full''' path for your installer including the file name. '''Example: C:\Users\BobsPC\Downloads\SQLMANAGMENT.msi'''
 +
| Regardless of what you rename the file to, the file extension will remain '''.msi''' and you '''MUST''' put it in the command prompt. You also need to make sure there are no spaces in your file name. [[File:Full File Path.png|Full File Path]]
 
|-
 
|-
−
|6. Press enter and if you have typed the folder path correctly, the installer will run as intended. || If you receive an error in the ''CMD'' prompt, you need to double check your folder path and try again.
+
| 6. Press enter and if you have typed the folder path correctly, the installer will run as intended.
 +
| If you receive an error in the ''CMD'' prompt, you will need to double check your folder path and try again. [[File:Warning.jpg]]
 
|}
 
|}

Latest revision as of 15:20, 3 December 2018

Command Line Shortcut: none

User Permissions Level: All
Product Level: All
Install SQL Server.




It is not within the scope of this manual to provide an in depth discussion of SQL Server. We will touch on the basics required for use with WireCAD. Basics

The WireCAD distribution includes SQL Server database files for the Global Equipment database. You will need to attach these to the the running server. You will then configure WireCAD to look at the SQL Server for the Global Equipment database. WireCAD projects will create a new database (catalog) for every new project. You will need to set up permissions for each user to allow them dbcreator privileges. This is the default for localhosts but not remote servers.

There is no further requirement to attach databases once the Global Equipment database.

SQL Server can be set up on a server or on a local machine.

Where to Download SQL Server

WireCAD requires a minimum of SQL Server 2012 (will also work with later versions) and can use the Express versions which can be found here:


https://www.microsoft.com/en-us/download/details.aspx?id=43351
Download either: SQLEXPR_x64_ENU.exe or

SQLEXPR_x86_ENU.exe

Be sure to download SQL Server Management Studio Express as well. Both are free.
On the same page download:

SQLManagementStudio_x64_ENU.exe or

SQLManagementStudio_x86_ENU.exe

SQL Server does not provide a graphical user interface so you will want to download the management studio listed above.

Bulbgraph.png Note: If you are installing SQL Server Management Studio on Windows 7 64bit, please see specific instructions at the bottom of the page.

Setting Up the WireCAD Global Databases on SQL Server

Step Description
Install SQL Server. You will be prompted for an instance name. Instance names allow you to have multiple SQL Servers running on the same machine. In addition you will be prompted for a security mode (Windows or SQL), Windows uses your Windows users and groups, SQL ignores these and allows you to manages different users and groups from within SQL Server. I recommend using Windows security if you are installing on a local machine. If you are installing on a server select SQL security. You will then need to define a default WireCAD user that all WireCAD users will log in under.
Install SQL Server Management Studio(SQLSMS).
Launch SQLSMS and log in to the server. If the server is on your local machine you can use the shorthand .\INSTANCENAME for the host.
Click the Security Node and Add Login if you selected SQL Security New Login Menu ----
Bulbgraph.png Note: We recommend that you configure SQL Server for SQL authentication and that you create a single login for all WireCAD users. We have found this to require the least amount of administration.
Next right-click the instance name in the Object Browser and click Attach Database Attach Database Menu
Attach The WireCAD Global Equipment Database ----
Bulbgraph.png Note: The following assumes that you are installing WireCAD on a local machine. If you are installing on a server you will want to copy the global database files to the server before you attach them to the server.
Attach Database


Click the [Add] button on the Attach Databases form and browse to:

XP:
C:\Documents and Settings\All Users\Shared Docs\WireCAD\WireCADx\WireCAD_Global_Equipment.MDF

VISTA/7:
Public\Public Documents\WireCAD\WireCADx\WireCAD_Global_Equipment.MDF

The form will add WireCAD_Global_Equipment_log.LDF file automatically. You will need [Remove] that record.

Click [OK] to attach the database.

Change the default file save location.
Bulbgraph.png Note: MS SQL Server will place database files in the C:\Program Files\MSSQL Server directories by default. This is not good practice as most backup software ignores the Program Files directory. To remedy this, right-click the Server Name in the Object Explorer and click Properties. Under the Database Settings node modify the Default Database Locations settings.
Default File Location
You will now need to configure each WireCAD client to look at the SQL Server
  1. Launch WireCAD.
  2. ClickProject>Application Setup and follow the steps for SQL Server.

Specific Instructions For Installing SQL Management Studio On Windows 7 64bit

Step Description
1. Place your SQL Server Management Studio Installer in your user downloads folder.

Example:My Computer>(Your Hard Drive)>Users>(your username)>downloads

You can place this installer in a different folder but you will need to know the FULL path to find this.

Example: C:\Users\BobsPC\My Documents\Applications\........ Downloads Folder

2. Once your installer/exe is placed where you would like it, rename it to something simple.

Example:SQL Management or Management Studio

You don't have to rename however it will help simplify things in the next couple steps. Rename File
3. Click the "Start" button and type CMD in the search bar. At the top of the search window, you should see the CMD Icon under the programs tree. Command Prompt
4. RIGHT CLICK AND RUN AS ADMINISTRATOR It is very important to run as an administrator to complete the install successfully. Run As Administrator
5. With the command prompt open, type the Full path for your installer including the file name. Example: C:\Users\BobsPC\Downloads\SQLMANAGMENT.msi Regardless of what you rename the file to, the file extension will remain .msi and you MUST put it in the command prompt. You also need to make sure there are no spaces in your file name. Full File Path
6. Press enter and if you have typed the folder path correctly, the installer will run as intended. If you receive an error in the CMD prompt, you will need to double check your folder path and try again. Warning.jpg
Retrieved from "https://www.wirecad.com/wiki/index.php?title=Setup_SQL_Server&oldid=3034"