08-09-2016 09:29 AM - edited 08-09-2016 09:37 AM
Hello,
I have some trouble understanding the significance between defining the different user/password combinations during the MS SQL installation, as well as during the RapidStart 11.2.0 installation. I have outlined three scenarios below that I have been experimenting with but have trouble knowing the difference between.
For reference, I have three Windows accounts available: "Administrator", "infodba" and "dba"
To summarize, I don't understand how dba/dba, sa/sa, infodba/infodba, tc_user/password interact with each other or the SQL database.
I hope my question is clear enough! Can anyone give a simple explanation?
Thank you.
Solved! Go to Solution.
08-09-2016 01:46 PM
In general, Teamcenter wants to use a single dedicated database account to connect to database, create tables modify the contents of the tables etc. It is a good practice not to use Database administrator account (i.e sa in MSSQL, system/sys etc in Oracle) as Teamcenter's database account.
I have not seen the installation screens for the versions that you are referrring... My guess is that tc_user/infodba are Teamcenter database account while sa/dba are MSSQL database administrator accounts.
08-10-2016 02:46 AM - edited 08-10-2016 02:51 AM
Thank you very much for your reply.
So I guess the difference between the accounts is like you said; one account for accessing the SQL database through Windows (i.e. the Windows "dba" account I mentioned at the top of the OP) and one different account (unrelated to Windows accounts) to access the database through Teamcenter.
Although going back to installing RapidStart 11.2.0, I have attached two screenshots to show what I mean.
Default values of the MS SQL Screen during installation.
These are the default values during installation when selecting to use a MSSQL DB. "sa" is already predefined as a default username for the database user... No matter what I put in this field (as long as the user exists in the database), I am presented with the next screenshot.
This window shows up when pressing "Next" after inputting the values for an MS SQL Server during installation.
Once done filling in the fields in the installer, I am presented with this window telling me the values the installer will use. The installer seems to create a default database user and password (tc_user), despite what I entered into the fields in the installer. It is mainly this which I am confused about, since I would expect the values in this window to correspond with the database user I defined in the installer. Like I mentioned earlier, no matter what user I input during the installation (given that the user exists), it doesn't seem to make a difference on the installation as a whole. Is this an error in the installer or an error with my understanding?
08-10-2016 04:59 AM - edited 08-10-2016 05:00 AM
I think I have figured it out, it was mainly due to my lack of attention during the MS SQL installation process.
When the MS SQL Installer asks for a password when choosing Mixed Mode Authentication, it asks to define the password for the system administrator (sa) account. Consequently, during the Teamcenter RapidStart installation, the Database System User is predefined as "sa", so in the password field i should write the password for "sa" that I defined during the MS SQL Installation process. Logically, inputting the credentials for "sa" during the TcRS install which I defined in the MS SQL Install worked.
I guess Teamcenter needs to know the credentials for the "sa" account in order to log in to the database and create its own default database user that Teamcenter will use (tc_user). I realized that this step corresponds to the manual steps of creating a database with a user using the database template file when installing a non-rapidstart Teamcenter installation.
I think I understand it now, but if I have misunderstood please correct me.
08-10-2016 09:30 AM
You are correct.