Solved

Call to SQLAllocConnect failed with %1.

Posted on 2012-04-11
1
2,101 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

Why spend so long doing email signature updates?

Do you spend loads of your time carrying out email signature updates? Not very interesting are they? Don’t let signature updates get you down. Let Exclaimer Cloud - Signatures for Office 365 make managing email signatures a breeze.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.

762 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now