Hope someone can advise here...
Since doing a bit of maintenance on our SQL server yesterday, I'm getting this error when trying to log in to FMS with the 'sysman' account.
FMS School (Pre Academy).jpg
Cutting a long story short... The SIMS and FMS databases needed to be moved due to lack of HD space.
This was done successfully, or so I thought!
We have two FMS databases... One prior to becoming an academy and one since becoming an academy. Both were working perfectly well before the move and now only the academy database works.
All of the other SIMS databases work fine.
When logging into SQL Management Studio, I can see the users for that database and also the logins that tally up with them.
I have tried logging on to the database in question with a standard user account and I get 'Invalid user id/password or database name error'
Have also tried manually resetting the user password within Management Studio and still get the 'Invalid user id message.
Trying to give as much information as I can without waffling.
Hope someone can point me in the right direction...
Have you tried deattaching and reattaching the affected database?
That's odd... I had the very same error last week with this. @PhilNeal...something we can get support to look at? My fix was a detach reattach. There is also a script that I can post up which captures all you SQL login det,ails so you don't have to recreate them. PM me if you need anything
I've got the same problem at one of my schools - I'm so glad I'm not the only one!
If I take a copy of the data and load in the office it works fine.
Call logged with Capita.....
Am I missing something, what you've described is (or similar to) the sims install store procedure - as far as I can make out. This creates the SQL users in the MASTER database and links to them to the database - you sometimes have issues if you have a very old database, say called fms, then to deattach\restore it as say, fmsold. Running the install procedure updates the sql logins so they become fmsold_username, rather then fms_username. Do I understand right?
It is kind of. It is more a fix for those who forget to do a DBAttach if moving a database between servers; but you can apply it to the "Atomic" error - where the recomendation is to do the Dettach Re-attach.
Then just run exec sims.db_p_install.
There are currently 1 users browsing this thread. (0 members and 1 guests)