Solved

Call to SQLAllocConnect failed with %1.

Posted on 2012-04-11
1
2,191 Views
Last Modified: 2012-04-17
I have setup the Sql 2008 Data Collection, and there are 3 default collection sets, yet when I try to setup the data collectors on a remote server (log perf counters to sql), I get:

WHen attempting to start the Data Collector Set the
following system error occured:

Call to SQLAllocConnect failed with %1.

My goal is to collect performance statistics from all my Windows 2008 machines in the PDW of the sql 2008 server.
0
Comment
Question by:ExpertHelp79
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 37833314
Most likely you have some permissions/authorization issues - please see below:

http://social.msdn.microsoft.com/Forums/en-GB/wptk_v4/thread/1517d7ca-3cd2-45bd-bc39-0aeae9948fc2

Briefly - what you need if possible (recommended by me as I did same in my prod environment) a (same) NT Login that will have SQL admin rights on all these boxes and use that one to collect data from all these servers into a central/unique performance data warehouse DB.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question