SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)
If you are trying to start SQL Server Agent and you get the below error
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
...then this is what you can try:
Go to computer management - local users and groups, and add the service account with which you want SQL Server Agent service to start in the below Windows group:
Then, make sure that the service account meets the requirements described on the following MSDN Article...(read more)
3 minute read
When you get the below error message, at first you might be puzzled:
"The multi-part identifier [object_name] could not be found"
However, don't worry. It is rather a spelling mistake in your query that caused the above error.
Consider the below example...(read more)
5 minute read
Under certain conditions, if you try to convert or cast a variable to
Float you might get the below error message:
"Error converting data type varchar to float."
Most probably you are getting this error message because the variable you are trying to convert is "not qualified" for the conversion.
In order to better understand, consider the following example...(read more...)
1 minute read