1 Topic by dan

  • dan
  • New member
  • Offline
  • Registered: 08-10-2014
  • Posts: 4

Topic: Help needed moving NBNData Database to new server

Hi,

I have a customer who has Recorder 6 and I am migrating them to new servers.  I do not have any knowledge of Recorder 6 as it was implemented by the previous IT company.  So far with the information in this forum I have managed to move the NBNData database to the new SQL 2012 server, I have created a NBNUser on the SQL server and pointed the workstation to the new server.  When I run Recorder 6 I get the message:

"EOleException: Login failed for user NBNUser"

Where do I change the username and password on the workstation?

Thanks

Dan

2 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Help needed moving NBNData Database to new server

This erro usually seems to occur because the NBNUser login on the new database is not the same entity on the old one.

We have fixed it in the past by running the following query in SQLS management studio

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

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

3 Reply by dan (edited by dan 14-10-2014 09:54:35)

  • dan
  • New member
  • Offline
  • Registered: 08-10-2014
  • Posts: 4

Re: Help needed moving NBNData Database to new server

I have run that query and I still get the same error.

It looks like I will need to use

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'

to recreate the login, is there a default password for the NBNUser account? if not how do I change the password on the client?

4 Reply by dan

  • dan
  • New member
  • Offline
  • Registered: 08-10-2014
  • Posts: 4

Re: Help needed moving NBNData Database to new server

Sorted!!!!  I worked out the password then ran the following

use NBNData
EXEC sp_change_users_login 'Auto_Fix','NBNUser',NULL ,'NBNPassword'

Everything is working now

5 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Help needed moving NBNData Database to new server

Well thanks, you have taught me something today.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

6 Reply by dan

  • dan
  • New member
  • Offline
  • Registered: 08-10-2014
  • Posts: 4

Re: Help needed moving NBNData Database to new server

No Problem, it is all part of the fun of running the latest SQL Version

7 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: Help needed moving NBNData Database to new server

I wish!

We have been trying to get SQL12 running for well over a year but keep having to roll back to SQL2000. Another desperate attempt is looming in a couple of weeks' time.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website