Thanks for the suggestion. I'm going to spend a bit more time on this today and try to get a better idea of how long it will take.

It's probably worth changing the SQL Agent account temporarily to see if it will run under a different account; I would suggest changing it to the virtual account installed alongside...

Is this for a new installation? If so, have you changed the service account after completing the installation, or did you specify the one you are using during the installation?...

Microsoft have just recently announced that SQL 2014 and SQL 2016 when it is released will allow use of the developer edition of SQL Server completely free.

Developer edition is functionally...

Did you actually try to make the changes to the sa account?

Although it may let you access the dialogue to make the changes, when you try to apply them it...

Have you looked at the Windows event viewer? Usually if there is an error like this there will be something there which may provide more info as to why the...

Ok, thanks.

Hello.

Thank you, I appreciate the responses, although they don't really address my question.

I'm not expecting to see the page file being used, as I don't believe there is...

This is incorrect. SQL 2012 Enterprise edition was not offered with CAL licensing. You can check this using the Licensing reference guide at: http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

If you have...

Have a look at the permissions to the directory where the SQLAgent.exe is stored.

Default is: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn

I've had similar problems where there have been issues around that.

It looks as though the server supports NUMA, but I haven't configured anything around that. I don't really have any experience of NUMA actually, and it wasn't something that...

I have had a look over the stats for some of the indexes, though at the moment it's not hugely relevant to why I was doing this. The database in...

Thanks. I managed to resolve the issue by importing my csv list into a table, then filtering sys.indexes to remove system indexes and any indexes included in my table, then...