This technote describes how to create a new SQL database and user in SQL Server 2005 for an AutoPLANT project.
First off, you need to have Microsoft SQL Server 2005 installed and SQL Server Management Studio available to create databases.
You now have a new user and database in SQL Server 2005 for use with AutoPLANT.
In order to connect to the new database, you must create a new AutoPLANT project through Project Administrator. This can be found at the desktop menu: Start > All Programs > Bentley > Plant XM > Project Tools > Project Administrator. When creating the project, the wizard will prompt you to select the database.
Do not check Multi Project Mode. We do not use this. We like to keep a separate database for each project. If multi project mode were to be selected, it would put all our projects in the database. This is a pain to trouble shoot or even send to other companies.
In the next screen, be sure to select "central project mode". This ensures that we store all information for that project in the database. Otherwise, local MS Access database will be created for each DWG in the project.
After selecting Next, you will be prompted to fill out project information. Upon completing that step, the project will be created. The last step in the project creation process is to connect to the database. The connect screen for SQL looks as follows, if the server name is OWL.
Don't forget the "Allow Saving Password" check. Once all the information is filled out, press the "Test Connection" button to confirm a proper link to the database.
Product TechNotes and FAQs
Plant TechNotes And FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!