?
Solved

Call to SQLAllocConnect failed with %1.

Posted on 2012-04-11
1
Medium Priority
?
2,628 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 40

Accepted Solution

by:
lcohan earned 2000 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

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This is a comprehensive review of a bundled Toolkit designed for use by IT Professionals and End Users to help Microsoft Outlook fans manipulate Outlook files and repair some common problems. Enjoy...
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

568 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