Blog - SQL Server Troubleshooting

Announcements   ||   Administration   ||   Development   ||   Security   ||   Troubleshooting   ||   Offers  ||   Weekly SQL Server Tips

(back to Blog's main page)

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 message:

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:
SQLServerSQLAgentUser$[ComputerName]$[InstanceName]

Then, make sure that the service account meets the requirements described on the following MSDN Article...(read more)

Published 22nd August 2016
3 minute read

The multi-part identifier could not be found

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)

Published 18th August 2016
5 minute read

Error converting data type varchar to float

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...)

Published 16th August 2016
1 minute read