Make a new AutoPLANT project on a database that is on a diff domain

Posted on by

This database is ONLY to be used by Electrical so that any things we do only hoses us.

Make a new database. Now  the way to use SQL Server to log into a dB on another machine is to use the more complicated name for the database. myServerName.myDomainName.myDomainNameSuffix. Here is an example. When you start SQL Server you the popup asks for 4 peeices of info

  1. Server name – so if you computer is abc123 and your domain is mycompanydomain and its suffix is .local… then the computer name is abc123.mycompanydomain.local
  2. Authentication in this case is SQL Server Authentication (someone made an accoubt called “ELBS” with “password” as the password
  3. Login: ELBS
  4. Password: password

Now right mouse click on “Databases” once you are in and choose “New Database”

Lets name ours MyAutoPLANTdB – accept all default options.

STOP — because this is Windows – permissions matter. So – the user for this needs config unless you are a sysadmin user. Make a new users if you have to under Security->Logins – but the info below assumes there is one

In the database using SQL Server Management Studio …

  • expand the user … lets say “Bob” – so right mouse click Properties on Security->Logins->bob
  • Click User Mapping on the left
  • select the database and ensure the “Map” is checked at the top RH section
  • also in the top, type “dbo” in the Default Schema
  • then in the bottom, click the following options and
    • db_datareader
    • db_datawriter
    • db_owner (this might negate the need for the 2 above – but it works)
    • public
  • click OK to accept

The database part is now complete.

Make a directory to hold your roots. In our case, it is X:\ELECTRICAL TESTING\ELECTRICAL TESTING1 ROOT\

  1. Now use the blank dB and put an AutoPLANT project (or projects) into it.
  2.  Root Location (already exists) X:\ELECTRICAL TESTING\ELECTRICAL TESTING1 ROOT\
  3. Database Type: SQL Server
  4. Multi Project Mode: ON or checked
  5. Schema Location: Project Database
  6. Mixed Metric
  7. Use Central Project Mode
  8. Project Name ELEC TEST1
  9. Server: abc123.mycompanydomain.local
  10. database: MyAutoPLANTdB
  11. user: ELBS
  12. pass: password
  13. Allow Saving Password – checked (THIS IS THE KICKER!!!!)
  14. database name: 12313_ElecAutoPLANT

I have already tested it – it does work