I have had time to dig around on the net today and have found the answer, thanks for the help.

This is the "fix" (thanks to Microsoft support):

In Security Settings/Local...

Thanks

However, when I enter a user I receive the message "Error executing stored procedure: Specified user cannot log in"

I have tried with various users with differnt sorts of access (domain...

Hi, the grant execute does not seem to work for this scenario.

I have tried a few other things but yet no success...

I have tried

1)adding the domain user that is...

Thanks to both of you. The answer was to add the user to the sql user group and the service will then be active.

Hi

I posted a similar question but have found the solution. The user that the service is running under must have rights within the database. You need to create...

Just read the previous help request and it seems I am not alone.. I will read the answers to this topic first.

That worked fine.. Thanks very much.

In a warehouse you should also think about if you need your log files. Our warehouse is updated on a nightly basis and then a backup is taken of...

That worked fine. Thanks