.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to install TDP Agent and its configuration on the SQL instances?

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi,   How to install TDP Agent and its configuration on the SQL instances? any helpful link? Great thanksHelen

View Complete Post

More Related Resource Links

Install on New Windows7 - Getting Invalid SQL Server Agent credentials

Hi: I have a Developer License for MSSQL Server 2008.  Have just upgraded to Windows 7 Professional Edition.  When installing MS SQL Server, the setup shows that I have an instance of SQL Server Express already installed.  I am given a choice between Default Instance and Named Instance.  First time I chose named instance and then used the name of my machine - RBS1.  I received the following message:  The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service. Went back and tried Default instance and got same answer.  Can't proceed to install.  Any help in this greatly appreciated. roger  

When trying to install SQL 2008 Reporting 'Install the native mode default configuration' is greye

Whilst troubleshooting an earlier issue with SQL 2008 R1 I needed to install SQL without reporting, I then went through the SQL add feature to add Reporting once SQL was working.  The issue I am getting is that the option I need for SCOM R2 'Install the native mode default configuration' is greyed out and the only choice I have is 'Install, but do not configure the report server' which apparently happens when you don't install reporting at the same time as installing the SQL database engine.  In order for SCOM reporting to install I need manually configure SQL reporting to how it is configured when you install in native mode.  Can anyone help with a document on how to configure this manually ? thanks

failed to create configuration database on Sharepoint 2010 beta install under Windows 7

sharepoint configuration wizard at final step issued message as follows:

failed to create the configuration database.

an exception of type system.io.filenotfoundexception ws thrown.  additional exception informaion. could not load file or assemble 'microsoft.identity.model. version=,culture=neutral, publickeytoken=31bf3856ad364e35' or one of it's dependencies. the system cannot find the file specified.

the only option was to 'finish' the wizard and exit without a successful install.

can anyone help me with diagnosing this problem.

i am running windows 7 on a dell machine and installed all the software requirements for sharepoint install. with the exception of a hotfix for sql server which when i followed the lin appeared to be updated to a more recently posted hotfix.  i downloaded this and installed successfully.


PowerShell Agent.JobStep for SSIS with one or more configuration file??


Is it possible to script adding a sql agent job for an SSIS package that uses one or more configuration files?  I've spent the better part of the day searching forums and blogs for any examples, but all I can find is just default TSQL or stored proc jobs.  I have most of the script written to pull the appropriate information in, I just do not see how I can specify the configuration files for the job step.  And yes, I've even tried going through Visual Studio accessing that api to see if i can dig out the appropriate object/property to no avail...

Any help would be incredibly appreciated as this would make a huge step forward for our deployment process :)

---- UPDATE ----

I know this sounds odd, but I'm mostly asking because I can't even access a sql 2008 server right now to see what gets put into the step normally for the SSIS Package..I'm assuming all it's really doing in that step is a dtsexec with the appropriate switches, if this is the case, then I can probably just build the command out to pass in multiple configurations...?

Multiple Instances of User Control


I have a user control that I place on a page severl times.  When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl.  So I get duplication of an insert that I do.  Is there a way to make sure these events are isolated so this doesn't happen.


SqlServer - Windows Account to install Application from Gallery


Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application

I selected umbraco cms and got this wizard:

I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.

I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.

My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?

Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.

ASP.NET Configuration not opening


I recently upgraded to VS 2010 and downgraded to SQL Server 2005. Now when I go Website > ASP.NET Configuration nothing happens.

It's likely this has to do with the fact that when I was installing SQL Server I got the 'ASP.net Version Registration requirement' warning, as well as the 'Failed to find the ASP.net Version Registration requirement with MS IIS'.

Anyone know what I need to get ASP.NET Configuration working?

VWDE 2010 Won't Install Ajax Control Toolkit on XP Pro


To my displeasure I cannot find VWD2005 which at one time would generate a complete web.config for Ajax so I downloaded and installed VWDE 2010 to a clean install of XP Pro.

I've created a new tab on the toolbar for the controls but after I select the Ajax dll to add the controls to the toolbar it grinds away and then goes poof and closes down the task leaving VWD look as if I had never even created the tab in the toolbar. 


Any advice here?

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

An endpoint configuration section for contract 'xxx' could not be loaded because more than one end



I'm trying to test calling a webservice, I've found several free ones on http://webserviceshare.com, but none of them work for me.  Some of them give example calling code in C# which I've translated to VB.NET, they're typically just two to four lines, I don't think I've translated them incorrectly.

On that I've tried is US Zip Validator.  I added a Service Reference to http://www.webservicemart.com/uszip.asmx?WSDL, called ZipService.

I then call it like so:

            Dim myZipService As ZipService.USZipSoapClient = New ZipService.USZipSoapClient()
            Dim myCity As String = myZipService.ValidateZip("27707")

I get the following error on the first line of code:

"An endpoint configuration section for contract 'ZipService.USZipSoap' could not be loaded because more than one endpoint configuration for that contract was found. Please indicate the preferred endpoint configuration section by name."

A page with information on this web service (including C# source code) is at:


Modifying connection String in Web config using Install Wizard



Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors,  heres part of my code where the errors are

using System;
using System.Configuration;
using System.Configuration.Install;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.DirectoryServices;

 void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
            // Retrieve "Friendly Site Name" from IIS for TargetSite
            DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit

How to install the Css Friendly Control Adapter Source Code


Hi guys really new to ASP.NET I was trying to install the CSS Friendly control adapter but for some reason the instructions on the website seems outdated. I downloaded all the files (Source Code, DLL, Browser) I believe I need to add the DLL file to my website's Bin folder and the Browser file to the APP_Browsers folder is this correct? After I place this files how to I get it working? what do I have to do?

Also if I want to create a new DLL file from the Source code how do I do these? I opened the web-site with Visual Studio 2008 and I can see all the files in the solution explorer? But how do I compile this to a DLL file? I tried doing a build solution but all I get is an .sln file???

Any help would be greatly appreciated

Thanks in advance


Patterns in Practice: Convention Over Configuration


We look at some techniques you can adopt to reduce the amount of housekeeping code you write so you can focus on the essence of the application.

Jeremy Miller

MSDN Magazine February 2009

Test Run: Configuration Testing With Virtual Server, Part 2


Because Virtual Server is built upon a set of COM modules, you can automate the creation and testing of virtual machines. Here we use Windows PowerShell to run the tests.

Dr. James McCaffrey and Paul Despe

MSDN Magazine December 2008

Test Run: Configuration Testing With Virtual Server, Part 1


This time James McCaffrey sets up a virtual environment to use for configuration testing to introduce you to software configuration testing with Microsoft Virtual Server

Dr. James McCaffrey

MSDN Magazine September 2008

Netting C++: Configuration with XML


Stanley B. Lippman explores the use of C++/CLI as a pure Microsoft .NET Framework-compliant language.

Stanley B. Lippman

MSDN Magazine August 2007

Configure This: Parameterize Your Apps Using XML Configuration In The .NET Framework 2.0


There are a number of ways to configure an application in the .NET Framework 2.0. This article explores the classes of the revamped System.Configuration namespace and explains how to use XML configuration files for your app configuration settings.

Bryan Porter

MSDN Magazine June 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend