1 Topic by ser

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

Topic: problem accessing NBNData

I have just populated a new copy of Recorder, by backing up our existing copy of Recorder, and restoring that backup into the new copy.

SQL Management Studio reports everything has worked fine, the database is there with data, however running Recorder reports:

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

Any ideas what the problem is?

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by ser

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

Re: problem accessing NBNData

I think I've located the error, but not the solution!

NBNUser is not mapped to NBNData, but trying to change its properties generates the error:

Create failed for User 'NBNUser'
...
User, group, or role 'NBNUser' already exists in the database.

I wasn't trying to create a new user, but update an existing one ... help!

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

3 Reply by ser

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

Re: problem accessing NBNData

I have managed to get NBNUser to recognise the NBNData database, but changing the ownership of NBNData, which was set to 'sa' to 'NBNUser', Recorder now works ;)

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website