|
<< Click to Display Table of Contents >> How To: Setup a SQL Server |
  
|
|
<< Click to Display Table of Contents >> How To: Setup a 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.
The WireCAD distribution includes SQL Server database files for the Global Equipment database. You will need to attach these to 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.
SQL Server can be set up on a server or on a local machine. WireCAD requires the 2005 version or newer and can use the Express versions.
SQL Server does not provide a graphical user interface so you will want to download the SQL Server Management Studio Express as well. Both are free.
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.
1.Install SQL Server. You can download from the following links:
https://www.microsoft.com/en-us/download/details.aspx?id=21844
Be sure to download SQL Server Management Studio Express as well. Both are free.
2.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.
3.Install SQL Server Management Studio(SQLSMS).
4.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.
5.Setup a proper login for WireCAD. You may elect to use Windows logins or not. It is beyond the scope of this manual to describe the pros and cons of each authentication method.
6.Attach the WireCADGlobalDatabase.mdf file to the server.
7.You will now need to configure each WireCAD client to look at the SQL Server
8.Launch WireCAD.
9.Click Application Menu > Application Setup and follow the steps for SQL Server.
See Also
www.wirecad.com/wiki search SQL Server
msdn.microsoft.com search SQL Server