I have created a Maintenance task in SQL Server 2008 Management Studio.
I followed a walkthrough that seems to me to be entirely correct even if it was for 2005.
But when I try to test the task with Execute command, i receive the following error:
 SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ServerName\Admin', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
On the server I logged in as ServerName\LocalAdminName and connected to the Management Studio with "localhost"
Do I have to login with a Domain User instead and if so, how do I allow that user to access Management Studio/All the databases? I tried to login with my User Account which is a Domain Admin account, but I was then unable to connect to localhost in Management Studio...
Also: The server has been renamed when it was found necessary to join it to the domain (was not initially planned) and I notice that the server name has not changed under
ServerName is still the old servername, and not the new name... I would have thought this would change by itself?