Re: Install onto SQL Server
In the standalone installation (from CD for standalone V 6.6.8) onto SQL server I get the following message:
[SQL-DMO] Service Control Error: The specified service does not exist as an installed service
This despite trying both the sa login and the "use my NT account" options, the latter should work as my SQL Server is set up as Windows authentication.
I noticed that at this point in the installation (Migration options) that the NBNData database was not amongst my SQL Server databases (in fact it was nowhere to be found, I expected an empty copy somewhere) - so I copied it in from my backup.
I have carried out the following:
1. attached the database I copied in
2. enabled the NBNUser login:
EXEC sp_change_users_login 'Update_One', 'NBNUser', 'NBNUser'
- from which I got the message
Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 87
Terminating this procedure. The User name 'NBNUser' is absent or invalid.
3. tried a different sa setup by adding a password using
EXEC sp_password null, '<password>', 'sa'
Am now going to try the network installation CD - but if this is the correct route then a bit more clarity is needed on the CD labelling