Web publishing: Database not available the following problem

[cvkaiser]

Hi all,

I have the following problem with File Maker Server 9.03: when I go to my web publishing site in the browser I can see my database, but when I want to open it by clicking on it I get the message "Database not available!" I can open the same database through FileMakerPro and in the administration of FMS everything seems to be OK.

The mainboard of my MacBookPro has just been exchanged because of a problem - maybe it has to do something with a connection between the internal computer address or something? Befor it worked liek a charme.

Thanks in advance for your help.

[Steven H. Blackwell]

Be sure that the Privilege Set attached to the Account you are using has the fmiwp bit checked.

Steven

[cvkaiser]

Hi Steven,

thank you very much for your reply and your help - can you tell me a bit more... I´m not so skilled with the FMS and not sure where I can find these bit that should be checked...

Thanks - Christoph

[mr_vodka]

File --> Manage Accounts & Privs --> Extended Privs

[cvkaiser]

Hi John, thanks for your reply... unfortunatly I´m not sure to which "File" you are reffering and where I can find it. Do you mean the database file itself or a special page in the Administration Console? Sorry for being so uneducated in this terms....

Best regards - Christoph

[Fitch]

Since you say it worked before, this might not be quite so simple. But here are the two places Steven and John are suggesting you look:

- in FMS Admin, click on Databases. You should see your file listed, and in the IWP column there should be a checkmark.

- in the file itself, if you open it up with FM Pro, go to Accounts & Privileges and click on the Privilege Sets tab. Edit one of the privilege sets and look at the Extended Privileges checkboxes. Make sure that the IWP checkbox is active, and make sure that it's active for the account you're trying to use.

If IWP appears to be set up correctly, then I would restart FMS and for good measure restart the machine it's running on.

[cvkaiser]

Hi Fitch,

thank you very much for your detailed information - I looked on every part of your suggestions and everything seems to be OK. I have also restarted and no difference... maybe I just should reinstall FMS again and it should work...

Best regards - Christoph

[Fitch]

I agree, reinstall is probably your best option. Please report back, I'd like to know if that does fix it.