1 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

We have just had a computer upgrade - this was our Linux server, so I wasn't expecting any Recorder issues, however, now ALL our copies of Recorder have the same problem.

On starting Recorder for the first time - it says "Updating Recorder Settings" then gets the error message:

An error occurred whilst starting the application.
EOIeException: Cannot open database "NBNData" requested by the login. The login failed

I have tried accessing the Recorder database through the Access database and this was fine, as was direct via the SQL Server Management Tools - I don't know what settings need correcting .... HELP!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Problem starting Recorder

I think you may just need to run the following in NBNUser.

exec sp_change_users_login 'update_one', 'nbnuser', 'nbnuser'

Mike Weideli

MikeWeideli's Website

3 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

I know I'm being thick but where 'in NBNUser' ?

Craig Slawson
Staffordshire Ecological Record

ser's Website

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Problem starting Recorder

It needs to be run as a  query in SQL Server Management Studio.  You can probably also run it in Access as a pass through  query.

Mike Weideli

MikeWeideli's Website

5 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Mike,

I can run it in NBNData, but not NBNUser - but that made no difference, still get the same error message

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

6 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Mike,

An update, I thought the Access database portal was working, but I was wrong - I have just tried to relink the tables to get the error:

Connection failed:
SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to select database has been denied

Does this help?

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

7 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Further info

I have just tried to rebuild the ODBC link in Administrative Tools - in the list of available database for 'Change the default database to:' only 'master', 'msdb' & 'tempdb' are listed under the Recorder Instance - NBNData is no longer available to be selected!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

8 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Further investigation reveals the NBNData table has disappeared, I'm presently trying to get it restored by our computer support - however, if this is not possible I have an NBNData.bak from 13th Feb - how do I extract the data from this?

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

9 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Problem starting Recorder

Sorry my mistake, I meant NBNdata not NBNUser.

To restore the database from the backup without having Recorder running the best way will be to use Management Studio.  You will need to attach an NBNData database, but doesn't matter which one - one for the installation CD will do.  You should  then be able to right click on this in Managament Studio and use the restore to restore your backup.

I can provide more detailed information on the above if you need  it.

Mike Weideli

MikeWeideli's Website

10 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Thanks Mike,

I'll get back to if the computer restore fails, cos obviously that will be more up-to-date (i.e. should be Friday's backup)

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

11 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem starting Recorder

Mike,

I have solved the problem - it was caused by the installers changing the name of the Linux server when they replaced it, so I have had to delete ALL my existing users (excluding NBNUser) and replace them with the new servername - all running OK, just got to work out why the database got deleted!

Cheers

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website