[SIMS] New Sims Install User Names missing in Master DB

[bgall]

I did a new sims and fms install on Windows Server 2008 R2. Everything went ok, e.g no errors. I now restored the sims database from a backup but I cannot log in.
At get the error, invalid user name/password. Are username and passwords stored in the Master DB. How can I transfer them accross?

[bgall]

Thanks, but that didn't do the trick. First command executed fine. Running exec sims.db_p_grant didn't get any acknowlegment at the end.

[edutech4schools]

Do you still have access to the old sims system?

[bgall]

I can connect using sqlcmd to the sims database either from the server or from my laptop

[bgall]

Yes, the old system is still running. Building this system in it's own environment and only roll out once everything is working.

[edutech4schools]

can you detatch the old database using sims dbattach and attach to the new server. This is the preferred method.

Sorry if its how you did it the first time but just covering all bases.

[bgall]

Thanks to everyone. When I did the whole procedure again. Detaching old Database using dbatach, copying it over and re-ataching it using dbatach it somehow did the trick this time round. Tried it twice before. Sims application will always be a mistery. Thanks very mcuh

[Rawns]

For future reference, run this SQL command from a cmd prompt before you detach the database from your old system. it will transfer all logins from the master database first:

SIMS

osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec sims.sims.db_p_transfer_login"

FMS

osql -S%COMPUTERNAME%\SIMS2008 -Usa -Psa_password_here -n -Q"exec ccsfms.sims.db_p_transfer_login"

[matt40k]

Cheers, was just looking for that... saved me having to install SQL Studio

[jimothy]

I had to run the following query in SQL Studio to allow me to login and the sysman account:

exec sims.db_p_reset_sysman_password

[vikpaw]

I had to run the following query in SQL Studio to allow me to login and the sysman account:

exec sims.db_p_reset_sysman_password

That's handy, but the best you can do then, is to go into system manager and reset other people's accounts. That's still a huge pain dishing out those horrid initial passwords to all.

[jimothy]

That's handy, but the best you can do then, is to go into system manager and reset other people's accounts. That's still a huge pain dishing out those horrid initial passwords to all.

True, but I was only using it for copying data from a few fields which had been mistakenly deleted. We also use AD Trusted Auto so we don't have to dish out all the extra usernames and passwords.

[matt40k]

@vikpaw - Good opportunity to brush up on those ctl+C\ctl-V skills

[vikpaw]

@vikpaw - Good opportunity to brush up on those ctl+C\ctl-V skills

- i need the practise, since i seemed to bork that up on my new OP Smartdesk install.

Maybe the new system manager will have an email to user option .... [ if only the MD of SIMS read these forums.... ] </sigh>