This is very strange. Did you have a Track-It! 2019 installation that was removed before this fresh install? Perhaps there is already an existing administrator login on the SQL server for Track-It! because of a prior install. I would reach out to support and see if they can help. You can find options to contact them at support.trackit.com.
thanks for your answer.
Yes there was a half installation because the first try fails with any error.
The customer deleted all files and installed it again. The second try works without errors but the TI credentials seems to be corrupt AND the BCM "Admin" has a password although it should be blank at the beginning.
Meanwhile I realized that the customer uses a Win Server 2008 R2 and therefore I give him the advice to reinstall TI on a fresh server.
So never mind.
Ah, that failed install probably created the SQL account and then the new install tried to use that SQL account that was for another instance. Sounds like you have it sorted out now.
1 of 1 people found this helpful
I think this is the message you get?
I'm sure I've had this issue last year. It took me a while to figure it out, but I believe the best way to resolve this is resetting the account against the master database:
Alter LOGIN [ADMINISTRATOR] WITH PASSWORD=N'welcome', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
You might have to restart IIS as part of this process, but I'm pretty sure that gets it up and running.
Log back in the system using Administrator and welcome and you should hopefully see the GROUP displayed.
thanks for the tip.
At BCM you can simply go into the DB and reset the password in the corresponding table. I did not worked with an SQL statement yet.
Could you explain to me how to apply that?
SSMS - new query on the TI database?!
Do I have to replace "[master]" and is "N'welcome'" really correct?
3 of 3 people found this helpful
The difference is that the BCM accounts are held in the database and are not SQL accounts, if you are referring to the accounts that can log in to the bcm console, for example.
But do not get these accounts confused with the SQL accounts for BCM, as the BCM SQL account (bcmdbuser) should have a password.
Unlike Track-It! 11.x, Track-It! 20xx creates SQL Logins for all technicians and this is why you cannot reset within the PERSONNEL table. Therefore you are resetting the SQL Account and not an account in the Database instance.
I guess you could reset under LOGINS in SECURITY.
Creating a query is simply clicking on New Query and selecting the correct DB from the menu. If you select the DB from the Table and then choose New Query, it should default to that table:
Paste the query in and then click Execute.
To answer your final question, no you don't have to replace master, and N'welcome' is correct in order to reset the password to welcome.
Wow, nice :-D
Thanks for this very detailed answer.
You're very welcome Philipp. Send my regards to Heiko and the team. Ricky