1 Topic by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Topic: New Server

We've just acquired a new server which has Windows Server 2012 64 bit loaded. I have a copy of SQL Server 2012, but it is not loaded yet.
The only Recorder 6 Network disc I can find is Version 6.13.
Is there any way I can get Recorder 6 loaded and upgrade to the latest?
Our Live version is on another server running Windows Server 2003 and using SQL Server 2005.

Any advice would be most welcome.

Dave

2 Reply by RobLarge

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

Re: New Server

From experience it may not be as simple as it should, but if you install SQLServer, then Recorder, then upgrade Recorder (but not the dictionaries), it should be OK. Check recorder works, then backup the old database and restore to the new one. We had to use an intermediary copy of SQL Server 2008 Express to convert our database, but we were moving from SQL2000, not sure if you will have the same problem.

Good luck

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

3 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: New Server

Thanks Rob, I'll try that method.
Dave

4 Reply by MikeWeideli

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

Re: New Server

I would suggest you install R6 version 6.17.2. This is available for download at www.Recorder6.info/Network.zip Once R6 is running you can attach the existing database and then run the upgrade to latest version of R6.  I think an  SQL Server 2005 database  will attach directly to SQL Server 2012 instance.

Mike Weideli

MikeWeideli's Website

5 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: New Server

Hi,
Sorry no feedback on progress but we have been snowed under with other work. I have just got back to it and have been attempting to put Rec 6 on the server (Windows Server 2012) for a couple of days. Created an SQL Server 2008 Express instance OK, but the recorder installation process wouldn’t recognise it. Eventually allowed the process to create it’s own instance and had Rec 6.14 up and running. Tried to upgrade but failed because MS5.dll was not found, even though it is sitting there in the same folder.
Decided to follow Mikes suggestion and downloaded the 6.17.2 software with the aim of using the Server 2008 instance, but as soon as I try, the application closes with the following error:
ERegistryException
Failed to get data for 'LoginMode'.
I’m beginning to lose track of everything I’ve tried and where it all is, so any advice would be most welcome.

Cheers,
Dave

6 Reply by MikeWeideli

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

Re: New Server

I have no way of trying things Windows Server 2012, so can only make some suggestions which come about from standalone installs on various operating systems. You certainly should be able to use the SQL Server 2008 instance. You could try running the R6 install in Windows 7 compatibility mode.  This has proved the solution with Windows 8 and also installing the workstations on servers.

Mike Weideli

MikeWeideli's Website

7 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: New Server

Hi Mike,

Thanks for the advice, running in Windows 7 compatibility mode worked a treat. I just cant get connected now. I keep getting an EOle Exception Error of SQL Server does not exist or access denied. I've tried most things that I've found on the forum but no joy as yet.

Dave

8 Reply by MikeWeideli

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

Re: New Server

I need to understand more about what you have done so far. If it is easier phone me on 01635 820904.

Mike Weideli

MikeWeideli's Website

9 Reply by MikeWeideli

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

Re: New Server

Can you try running the following script in Management Studio.  The error message doesn't indicate that this is the problem, but it will not do any harm to make sure NBNUser is correctly set.

Mike

IF NOT EXISTS(SELECT * FROM Master.dbo.SysLogins WHERE Name='NBNUser')
          CREATE LOGIN NBNUser WITH PASSWORD='NBNPassword', CHECK_POLICY=OFF

EXEC sp_addsrvrolemember 'NBNUser', 'dbCreator'

EXEC sp_addsrvrolemember 'NBNUser', 'diskAdmin'

USE NBNData

IF NOT EXISTS(SELECT * FROM SysUsers WHERE Name='NBNUser')
    CREATE USER [NBNUser] FOR LOGIN [NBNUser] WITH DEFAULT_SCHEMA=[NBNUser]
GO

EXEC sp_addrolemember 'db_backupoperator', 'NBNUser'
EXEC sp_addrolemember 'db_datareader', 'NBNUser'
EXEC sp_addrolemember 'db_datawriter', 'NBNUser'
EXEC sp_addrolemember 'db_ddladmin', 'NBNUser'
EXEC sp_addrolemember 'db_owner', 'NBNUser'

EXEC sp_change_users_login 'Update_One', 'NBNUser', 'NBNUser

Mike Weideli

MikeWeideli's Website

10 Reply by MikeWeideli

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

Re: New Server

Have you checked the protocols and allow remote connection 

http://forums.nbn.org.uk/viewtopic.php?id=4514

Mike Weideli

MikeWeideli's Website