Difference between revisions of "Setup SQL Server"
Wirecadadmin (Talk | contribs) |
Wirecadadmin (Talk | contribs) |
||
Line 31: | Line 31: | ||
== 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" cellspacing="0"; border="1"; width="100%" | ||
Line 52: | Line 49: | ||
|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|thumb|Attach Database Menu]] [[File:Ssms attach db dlg.png|thumb|Attach Database]] | ||
|- | |- | ||
− | |Attach The WireCAD Global Equipment Database||Click the '''[Add]''' button on the Attach Databases form and browse to: | + | |Attach The WireCAD Global Equipment Database<br> |
+ | {{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.}}||Click the '''[Add]''' button on the Attach Databases form and browse to: | ||
'''XP:'''<br> | '''XP:'''<br> |
Revision as of 19:19, 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.