Options > Settings > User > Management > Parts.ĮPLAN by default come ready to use a MS access database, I think officially SQL is now the officially supported parts manager database format since V2.5. EPLAN will automatically generate the new relational database with all the necessary tables and properties with just a few simple clicks. Despite what you may be thinking, we don’t actually create the db using the SQL tools, we actually create the new database using EPLAN. So if you are a first time user, you will have a server, but we still need to create a database.įor this example I want to create an example database named ACME, the ubiquitous company name made famous by Wile E. This is what my interface looks like, yours will be slightly different, you should see at least the server name at the top of the list.
EPLAN TEMPLATE SOFTWARE
I am using the default sa or “system admin” login because I created the server, if someone else installed the SQL software for you, or if you are connecting to a network service, you will have your own login name & password.Įnter your credentials, If you have a problem at this step, it’s most likely your credentials.Ĭongratulations, you have just confirmed that you have access to the server. I would imagine that Windows Authentication works, but I have never tried it. When I installed the SQL server I chose the authentication recommended in the EPLAN quick start guide which is SQL Authentication. If you do not have this information in hand, go find someone that has this information, ask them for the server name, your login name and your password. Please note that the server name and the authentication credentials were created previously during the installation of the SQL application. When the application launches you will be greeted with a dialog that looks like the dialog below. Start > Programs > Microsoft SQL Server xxx > SQL Server Management Studio Open the SQL Server Management Studio studio manager application, if you have the option to run as admin please use this option. Verify that you can connect to the server You can now skip the material below and go directly to Creating the EPLAN Database in SQL. If you work for a company that has an IT department you will probably be connecting to a SQL server on your company network, ask them for the server name, your login name and password. However, for the first time user, you can spend hours trying unsuccessfully to create your first database with EPLAN only to find out there is nothing wrong with EPLAN, the problem is that you don’t have proper access to the SQL server. Most of what follows here describes connecting to the local SQL Express server and this is not necessary at all once you know that you have the proper server name, login name and password. Thankfully getting SQL installed and running is the really the most difficult part about using it, creating a database for use with EPLAN is rather simple. Intended Audience: EPLAN P8 users with SQL or SQL Express