[sims] FMS level 5 Access has gone from all my users HELP

[alextreadwell]

we have recently upgraded our sims server (about a month ago) to server 2008R2 running SQL 2008 it all seemed fine until the bursar came in today and found that he didn't have the correct access rights so phoned me and asked me to add them I tryed and I don't have access no one does!! I have phoned our help desk but they have no idea how to get them back waiting on capita at the moment has any one had this before or know a fix ? I run the password transfer script as part of my back up so do see how this has happened any Ideas??

[Rawns]

Have you tried using the default login of 'sysman' & 'password'? If that lets you in, you can set up your FMS main user and give them permissions to create the logins & permissions again.

[matt40k]

'password'

 

Your mean 'finance'

[Rawns]

Indeed I do...

[alextreadwell]

Hi thasnks for the responces but I tried that straight away with no luck any ideas welcome as the LA is dragging its heals at the moment.

[matt40k]

What's your LA?

[bossman]

@Rawns:

 

What version of SQL are you running with?

[bossman]

@Rawns:

 

Can you log in as the SA user and map the other users?

 

When you upgraded the server did you detach both the Sims and FMS databases and then re-attach or was it just a straight server upgrade?

[vikpaw]

@Bossman - i think you mean to address your response to @AlexTreadwell who is the OP.

 

- tried to have a quick look at my fms db but couldn't see where the users were

 

am making a test setup in next day or so, and may play with it more - i was going to suggest a hack but problem is it wouldn't be supported.

[Rawns]

I think you can run this command on the SQL server which will reset the sysman password back to it's default...

 

osql -Sserver_name\instance_name -U sa -P sa_password -n -Q"exec ccsfms.sims.db_p_reset_sysman_password"

 

For example:

 

osql -S127.0.0.1\SIMS2008 -U sa -P abcd1234 -n -Q"exec ccsfms.sims.db_p_reset_sysman_password"

 

EDIT: You can use the above. Just tested it on my own FMS system and it's reset the password back to 'finance'. Give that a bash.

Edited March 30, 2011 by Rawns

[alextreadwell]

Thanks for all your replies the data has been looked at by capita and It apears to ok ie all the users have level 5 access at their end ??? I can get access as sysman all my users can login but when I try to add new user or change permissions as sysman or any user it greys out all the buttons ie the plus and minus and change passord / access rights. so only the user can change their own password. going to try installing it all again on a different server see if it changes anything, I detached the database and I have also tried attaching a backed up database as well with no change its driving me mad.

[splattthecat]

Have seen this before, and I think this stems back to a problem with he original migration from SQLAnywhere to Microsoft SQL Server. Only the user the migration was run as was given true level 5 access at the time, and there was a patch that needed to be applied to fix the other users, but that patch is probably well out of date by now. If you know the user the migration was run as you can log in as that user and reset the level 5 access by editing the users and access rights.

[alextreadwell]

Thanks I remembered this and yes I think do know the user that did the migration a user that has been disabled and I have no Idea of there password can I reset a users password I do know how to reset the sysman password also can I enable a disabled account? I have SQL management studio installed and can see all the users have level 5 access but the the change password / access rights are still greyed out it very strange?? any Ideas welcome need to have it back up to do end of year very soon

[matt40k]

Personally, log it with your LA and get them to log it with Capita. It's what you pay for, it's pretty serious so it should be sorted within 10 working days (I think).

[NorthernSands]

But might not Capita turn round and say "unsupported server OS"? Server 2008 R2 was only supported from the, just released, Spring update.

 

I know FMS is very particular about how you update SQL, move the DB around etc. The common thing is for it to 'drop' the SQL logins. This sounds similar.

 

@AlexTreadwell: Did you use the FMS DBAttach, or the SIMS DBAttach?

[alextreadwell]

hi yes I did the db atach for FMS and I also have tried a backup of the data base with sql dump ( I run the transfer logins script before it backs up) it doesn't seem to be a data base error as capita and my la have the database and say its working fine. I will have a look at upgradeing to the spring update as it has been released over the last few days Thanks

[NorthernSands]

it doesn't seem to be a data base error as capita and my la have the database and say its working fine

 

Fair point.

 

It could well be 'environmental' then. As in, something about the server environment that's causing it. We currently have a problem where we can't add any new addresses for existing student's, staff, etc..., SIMS crashes. Take the DB and put it on my workstation; works fine.

 

Try lifting a copy of the DB off and trying it on another 'server'. I would, however, try the Spring update first, as you say.

[matt40k]

Windows Server 2008 R2 has been supported since... forget but it's been a while. SQL 2008 R2 has only just been been supported.

[alextreadwell]

I have moved it to another server and no joy (2003) I took it home last night and set it up on my home PC windows 7 32bit and wndows 7 64 bit and no better is there a step by step install guide just to make doubley sure that I am doing it right I am starting to doubt my self here as I have tryed everything I can think of and find any where, just checked and the spring release has not been made available but I did down load the new spring disk last night at home and upgraded the Database when I installed from the new disk ISO but it still didn't work I keep looking back to the BDE install and something doesn't seem right I have no idapi file on the C drive ( this maybe right) as its an updated BDE version, also the registry is not looking right (the is no borland key in local machine software) has any one got any info on how this should be set up or how to manually set it up so I can check??

[vikpaw]

Shouldn't fmsinst.exe do all that for you. or, fmsapplicationsetup

[NorthernSands]

Shouldn't fmsinst.exe do all that for you. or, fmsapplicationsetup

 

Not fmsapplicationsetup.exe on it's own. I thought it was just simsinst.exe that your ran, and just tick the FMS option. This is what installs all the extras. Best thing to use is a copy of the setups folder from the SIMS server.

[vikpaw]

Windows Server 2008 R2 has been supported since... forget but it's been a while. SQL 2008 R2 has only just been been supported.

 

Autumn 2010

[NorthernSands]

Autumn 2010

 

I stand corrected.

[vikpaw]

No but it's useful to know, in this period of transition and roaming support. I'm going to do a blank install of FMS tomorrow on to Windows 2008 R2.

Incidentally, service pack 1 (for windows server 2008 R2) is defo not supported, so beware.

Edited April 6, 2011 by vikpaw
clarity

[alextreadwell]

it is SP1 but when reinstalled installed on other OS 32 bit and 64bit still not working I know the BDE bit is suppost to install when you run the FMSaplicationsetup and it looked like it did unfortunatly it looks like it might not have I did manage to grab the installer files but left them on my hard drive this moring think I will try reinstalling it in the morning but I don't think its added teh config properly. I could be chasing a wild goose but I am at a loss what to do next Thanks for teh advice