Trying to configure DataCollector data to remote SQL System DSN

• rsteckly

  Say Hey Kid

  Points: 664

  More actions

  August 20, 2009 at 3:13 pm

  #72865

  Hi,

  I'm trying to setup remote monitoring of a production server using perfmon. I defined a system dsn pointing to the IP of another, remote SQL Server. I created a new database and made it the default database for the ODBC connection. All the connection tests were fine.

  I then went into the DataCollector and defined the output as SQL, choosing the SystemDSN I had defined earlier.

  When I go to start the data collector, it throws an error saying SQLAllocConnect failed with %1. I'm wondering if I need to create some tables in the blank database I created or if it is a connection issue? It seems unlikely to be a connection issue given that I'm able to connect when setting up the DSN.

  Ideas?

  Thanks,

  Ron

  P.S. This is Windows Server 2008 and SQL Server 2008.

• mEmENT0m0RI

  SSC Veteran

  Points: 254

  More actions

  October 23, 2009 at 3:02 pm

  #1070268

  Change ODBC DSN setting to not use SQL native.

  HTH