I am not able to change the password in SQL config manager... When i access it from SQL server management studio it opens without asking for a password or credentials?

I checked in windows\system32 and i only have 1 .msc for sqlservermanager10 - when i open this it is the version i was looking at earlier. Version details : Version:...

I accessed it from the R2 management console.

Is it possible i am stuck in some sort of limbo between the 2 versions... following the upgrade?

I have just looked at what is showing under programs. I am showing SQL Server 2008 and also SQL server 2008 R2.

Ok.... i have now noticed that SQL server agent does not appear in SQL Server Configuration manager...

I can see 4 other services including SQL Server main service, but no agent...

Hi,

As per the document the domain account being used is part of the sysadmin group for the SQL server.

So does not appear to be permissions?

Regards

Alan

The password was changed recently but this has been updated and is correct.

Other than read\write access to the log file location. What other permissions should i check. Registry? ...

will do. I will post anything additional that is significant or if i manage to find a resolution.

No Worries, i know that feeling....

In the meantime i have took an existing server which is currently not utilised and installed SQL 2008 R2 from scratch.

All appears to be working...

I will check the event logs after a reboot and feedback anything worthwhile. As I mentioned when I first posted this issue, I believe this issue was apparent prior to...

I did run the SQL advisor prior to upgrade and no issues were identified.

Also, the main database engine appears to be running without issues, and users are able to access...

I was not aware we were running Dr Watson, is this pre-installed and runs automatically?

We use Trend Micro Officescan as our anti-virus solution.

Hi,

I have took a look at the SQL install log and found the following towards the end:

2012-03-28 18:13:32 Slp: Error result: -2068119551

2012-03-28 18:13:32 Slp: Result facility code: 1211

2012-03-28 18:13:32 Slp:...

Hi Brandie,

Thank you for the link.

In fact the server does not have a virtual name, but the error shown in the article is the same...

It does mention entering a host...

I have now tried to run from the command prompt with the following command:

sqlagent.exe -c -v

I now get the following error:

2012-03-29 12:54:43 - ! [246] Startup error: Unable to read...