Difference between revisions of "Setup SQL Server"
Wirecadadmin (Talk | contribs) |
Wirecadadmin (Talk | contribs) |
||
| Line 33: | Line 33: | ||
| − | + | {{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 in Step 6 below to the server before you attach them to the 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" cellspacing="0"; border="1"; width="100%" | ||
| Line 48: | Line 48: | ||
|| | || | ||
|- | |- | ||
| − | |Click the '''Security''' Node and '''Add Login''' if you selected SQL Security || | + | |Click the '''Security''' Node and '''Add Login''' if you selected SQL Security || {{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: | + | |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]] |
|- | |- | ||
| | | | ||
| Line 65: | Line 65: | ||
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. | 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. | |
| − | + | # 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. | |
| − | + | ||
| − | + | ||
Revision as of 19:05, 28 December 2010
| Command Line Shortcut: none User Permissions Level: All |
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 the 2005 version and can use the Express versions which can be found here:
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
Be sure to download SQL Server Management Studio Express as well. Both are free.
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.
Setting Up the WireCAD Global Databases on SQL Server
 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 in Step 6 below to the server before you attach them to the 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 | ----
| |
| Next right-click the instance name in the Object Browser and click Attach Database | ||
Click the [Add] button on the Attach Databases form and browse to:
XP: C:\Documents and Settings\All Users\Shared Docs\WireCAD\WireCAD6\WireCAD_Global_Equipment.MDF
VISTA/7 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.
- 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.
