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

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

Could not connect using SQLDMO to SQL Instance ACQ01I

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello, On mom I have an alert very frequent 13.000 times / in 30 days : "could not connect using SQLDMO to SQL Instance xxx". Is afecting only some clusters instances (normal servers are not beeing afected). I'm using mom 2005 ver 5.0.2911.0 and windows server 2003 sp2, sql server 2005 sp3. I have compared 2 instances : one with alert with other without the altert and I could see no difrences. DMO Looks well installed. - How to debug that DMO is working fine ? - How to change the dmo security ? - Why is afecting only some instances and not all ?

View Complete Post

More Related Resource Links

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Problem with MOM using DMO to connect to SQL 2000 instance

Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

can only connect to instance via port number

I can connect to an instance by specifying the port but not by the instance name. Becuase of this, no replication is occuring. Please see porqry and sqlcmd output below ...   d:\>portqry -n MDLEXPSV02 -p udp -e 1434 Querying target system called:  MDLEXPSV02 Attempting to resolve name to IP address... Name resolved to querying... UDP port 1434 (ms-sql-m service): LISTENING or FILTERED Sending SQL Server query to UDP port 1434... Server's response: ServerName MDLEXPSV02 InstanceName SQLEXPRESS IsClustered No Version 9.00.4035.00 tcp 1184 np \\MDLEXPSV02\pipe\MSSQL$SQLEXPRESS\sql\query      ?  ?P'   % ==== End of SQL Server query response ==== UDP port 1434 is LISTENING d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS -P sapwd HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not  allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired. d:\>sqlcmd -U sa -S MDLEXPSV02\SQLEXPRESS,1184 -P sapwd 1> exit d:\>

Cannot connect to Sql Server Local Instance

Hello allI just installed sql server 2005 to my pc and when i try to log in to the server instance i get an error log in failed for user xxx (error 18456). I browse to the server instance and i keep getting the same error even though i chose windows authentication option during the installation. I restarted the service for the sql server instance (which is running).The only problem i can think about is a problem with permissions but again there should not be any problem there because i logged in as administrator. Any suggestions please!!!

bdc - unable to connect to instance

CAN SOMEONE HELP ME PLEASE??? Here is my scenerio, - only one SSP... 1. Central Admin: Integrated Windows Authentication - Negotiate Kerboros 2. ADF file: <LobSystemInstances>     <LobSystemInstance Name="requestforchanges_Instance">       <Properties>         <Property Name="rdbconnectionData Source" Type="System.String">xxxxxx</Property>         <Property Name="rdbconnectionInitial Catalog" Type="System.String">xxxxxxx</Property>         <Property Name="rdbconnectionIntegrated Security" Type="System.String">True</Property>         <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>         <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>       </Properties>     </LobSystemInstance>   </LobSystemInstances> ..... 3. Using Admin a

"Connect to Outlook" and "Open Schedule" disabled in Ribbon on instance of Project Tasks list


Hi Everyone,
I am creating a custom list template for "Project Tasks", essentially I need a customized version of the OOB Project Tasks list. I've cloned the OOB feature over to my Visual Studio 2010 solution and I am able to successfully deploy my version as expected, with everything fully functional, gantt chart and everything, except one thing. When I provision an instance of the list using the OOB list template, I am able to see everything in the Ribbon enabled. However, when I provision an instance of my custom list template (clone), I see the "Connect to Outlook" button disabled, as well as the "Open Schedule" button disabled - which allows you to open the task list with Microsoft Project (I have all Office 2010 clients installed, including Microsoft Project).

I am guessing there must be some type of setting somewhere that associates the OOB list template to those Ribbon items that I see as disabled. The only thing different between my list template and the OOB list template is the Type ID. Could this be the problem?

Where should I be looking to troubleshoot this issue?


How can I hide the SQL instance from appearing in Enterprise Manager > connect > Network servers lis


I can find all sql instances in the network in Enterprise Manager > connect > Network servers list.

How can I hide my instances to appear in the list or in the network?


InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

could somebody give me example how I can connect to database only once if I use many models in contr


I use in my ASP.NET MVC application repository pattern and I use in controller for example 3 models:

   namespace MvcApplication1.Controllers  
        public class HomepageController : Controller  
            private IWebsitesRepository _repository_websites = new WebsitesRepository();  
            private IFirmRepository _repository_firm = new FirmRepository();  
            private IPhotosRepository _repository_photos = new PhotosRepository();  

In WebsiteRepozitory, FirmRepository and PhotosRepository classes I have:

Database1Entities _entities = new Database1Entities();

So I have 3 connections to database ? Is it wrong ? How can I solve it ?

Activation error occured while trying to get instance of type Database, key "DBName"


Im using Enterprise library 5.0
I have a scenario, where I have to access two different databases in my application.

Basically this application is a webservice,delployed on my local for testing purpose.
I'm trying to access this web method from diffent windows application, default connection works fine but the other database throw's exception.

Problem is only my defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with "MYCON2" it works fine, if I try to access the other database which is not default, throws exception.

<dataConfiguration defaultDatabase="MYCON1" />
<add name="MYCON1" connectionString="Data Source=server1;Initial Catalog=dbName1;User Id=Username1;Password=password1;"

" />
<add name="MYCON2" connectionString="Data Source=Server2;Initial Catalog=dbName2;User Id=Username2;Password=password2;"
providerName="System.Data.SqlClient" />

Database myDB=EnterpriseLibraryContainer.Current.GetInstance<Database>(); --> works fine for the default database (MYCON1)

Database myDB=EnterpriseLibraryCo

SQL Server Express2008 R2 brings app down, instance problem


I have tried dozens of changes and modifications to many settings as I will outilne here and all to no avail.

The short answer here though is that I uninstalled SQL Sever Express 2008 R2 and went back to the "NON" 2008 R2 and got things working. But like the fool I am wanted to run on the more current rev and updated again, all problems returned....



Win Server 2003 R2 SP2


VWD2008 Express (removed)




XP Sp3

VWD2008 Express

SQL Server Express 2008


I was orginally getting this message after updating to SQL Sever Express 2008 R2, I removed VWD 2008 Express from the web server, no good, then uninstalled SQL Server 2008 Express R2 and reinstalled SQL Server 2008 Express. worked but had issues, couldn't install MGTM Studio. Then I removed SQL 2008, cleaned folders and reg. Reloaded SQL Server 2008 Express, still flaky, couldn't get the Management Studio to install. So I removed it again and used the Web Platform Installer, which worked but loaded 2008 R2 again. Which brought back the message.

Failed to genera

SAAS: Connect Enterprise Apps with Hosted BizTalk Services


In this article we introduce you to BizTalk Services, new technology that offers the Enterprise Service Bus features of BizTalk Server as a hosted service.

Jon Flanders and Aaron Skonnard

MSDN Magazine June 2008

Interop: Connect To Mainframe Apps With BizTalk Adapters and .NET


If you have a significant investment in legacy COBOL applications running on mainframes, you need the BizTalk Adapters for Host Integration Server .

Bashar "Bash" Badawi

MSDN Magazine December 2007

WCF Essentials: Discover Mighty Instance Management Techniques For Developing WCF Apps


Instance management refers to a set of techniques used by Windows Communication Foundation to bind a set of messages to a service instance. This article introduces the concept and shows you why you need instance management.

Juval Lowy

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