I am trying to log perfmon log (Windows Server 2008) to SQL Server 2005 (Windows Server 2003) using dsn (SQL Server authentication).
On start perfmon counter i am getting error:
"Call to SQLAllocConnect failed with
[Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for
user ''. The user is not associated
with a trusted SQL Server
connection.."
Please help.
Best Answer
Make sure that Perfmon is attempting to connect via a domain account, and not a local account (unless the SQL Server is installed locally).
You can also try giving the computer's domain account rights within SQL Server. In the SQL Server add a new login for DOMAIN\ComputerName$. The $ is important, so don't leave that out.