.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

SQL Express 2005 Configuration Manager - Cannot connect to WMI provider

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
Hi, when I go to the SQL Server Configuration Manager utility, the following error pops up :

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied. [0x80070005]

This is on a Windows 2003 SP1 server, and the database is an upgraded MSDE 2000 database. The database itself appears to be working OK. My application can connect to it, I can connect to it via sqlcmd, etc. (all locally). I'm logged on as an Administrator, so permissions shouldn't be a problem.

I ran FileMon to see which file it's complaining about, and it seems the culprit is sqlmgmprovider.dll. It's trying to access this .dll as Network Service. Just to check, I added Network Service to the .dll permissions and got a slightly different message :

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
The application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. [0x800736b1]

I now also get two errors in the event log :

View Complete Post

More Related Resource Links

Getting "Provider load failure" from SSRS Configuration Manager (SQL 2008 R2 Hot Fix CU3 did not fix

After upgrading our SQL 2008 cluster to R2, SSRS on one node works fine, but the second node will not allow connection via the Configuration Manager (getting "Provider load failure").  We've done re-installs, repairs and applied Hot Fix CU3, but the issue remains. NOTE: It's understood that SSRS is not a clustered resource.  We have it installed as separate instances on each of the two cluster nodes.

Access 2007 upsizing wizard can't connect to SQL Server 2005 Express


When trying to use the Access 2007 upsizing wizard to move a database to SQL Server 2005 Express, I get the following error message:

Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQ Server Driver][Share
Connection failed:
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server
does not exist or access denied.

I get the same message regardless of whether I configure SQL Server to run as a local system or service.

I am the only user on my Vista 32 PC and am therefore the administrator. As far as I can tell I have sufficient authority since I can start and stop SQL Server.

As a newbie to all this, I can't find any step by step instructions as to how a local copy of SQL Server should be configured to work with the upsizing wizard. In fact I can't even find any Access 2007 help walk-throughs on this upsizing wizard, let alone troubleshooting its error messages.

Any help would be appreciated, as well as links to step by step instructions (which I can't find in the MSDN Library materials).

PS Does MS understand how inadequate and inefficient its built-in documentation really is? Maybe that's what keeps MS Press in business!

SQL Server Express 2005 Configuration Management tool



        I have installed both the Client as well as SQL Server Studio Management Express using the following setups SQLServer2005_SSMSEE.msi & SQLEXPR32.EXE.

                                                                                              But SQL Server Express 2005 Configuration Management tool is not installed in the system. What should I do.

Thank you

Sql Express 2005 Regedit Configuration


Hi everyone,

I have Windows 7 64 bit Ultimate Edition operating system and sql express 2005 32 bit server configuration on my local machine. I want to change sql express login mode by sql query. here is the t-sql i have :

DECLARE @InstanceName NVARCHAR(1000),
       @Key NVARCHAR(4000);

EXEC master..xp_regread  N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
@InstanceName OUTPUT

IF @@ERROR <> 0 OR @InstanceName IS NULL
       RAISERROR('Could not read SQL Server instance name.', 18, 1);

SET  @Key = N'Software\Micros

cannot connect to SQL Server 2005 Express



I am in the process of migrating a website running ASP with SQL Server 2000 to SQL Server 2005 Express.

I have installed the data, and fixed the problems with orphaned users (I think).

I can access the data using SQL Server Management Studio Express

However I cannot establish a connection from any of the ASP or ASP.NET applications. At first I thought it was just the connection string (using SQLOLEDB) but then I tried to set up a data source using ODBC with either the SQL Server or SQL Native Client driver. I have tried this on a remote machine (it is set up to allow remote connections), and also on the local server. The "Create a New Data Source" returns with the error "Specified SQL Server Not Found"

I am using (IPAddress)/SQLEXPRESS as the server name (I have also tried localhost and when trying to connect locally.

When using the "Create New Data Source" locally I have tried connecting as one of the database users, and as sa, and using the local network account (which is used to run SQL Server Management Studio Express.

I have disabled the firewall.

I have checked that TCP/IP is enabled using SQL Server Configuration Manager

Port 1433 is open.

Could anyone assist me in this ?

Thank you in advance


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error 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.

Kindly help me with this


Cannot connect to the configuration database.



when i open my central administation i get this error:

Cannot connect to the configuration database


plz help?

Connect to MS Access via OLEDB provider


I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)

Here is the connection info in my Application Definition XML:

    <LobSystemInstance Name="LessonsLearnedDevOLEDB_Instance">
        <Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
        <Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
        <Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
        <Property Name="rdbconnectionProvider" Type="System.String&qu

cannot connect to the configuration database


Hi All,

Recently I have migrated my SharePoint BackEnd (Database) Server to new hard drive. The reason of migration was to deploy and configure real time database replication by Symantec Veritas. After migration activity I was getting following error message

" cannot connect to the configuration database ".

But when I execute following steps, this errors message gone and everything got fine

1. Enable Named Pipe from SQL Server Configuration Manager > Protocols for MSSQLSERVER

2. Restart  SQL Server (MSSQLSERVER) service (Note: This service was already running and status was set to automatic ) and

3. Start SharePoint Configuration Wizard  

Now I need to know why every time I have to restart this service? When I turned on my sharepoint server machines in the moring I have to restart this service ( SQL Server (MSSQLSERVER) otherwise same error message appears (cannot connect to the configuration database). After restarting this service everything gets normal.

Any help in this regard will be greatly appreciated.


Upgrading VS 2003 Project File to VB Express Edition 2005



I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.

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)

Cannot enable TCP/IP through the Configuration Manager

Hi, I am using SQL Server 2008 sp1 Developer Edition.  The database engine service is running and the SQL browser service is running. It is set to allow remote connections. When I open SQL Server Configuration Manager and expand the SQL Server Network Configuration mode and select Protocols for <server name>, it shows Shared Memory as Enabled and all others as Disabled. If I right click on TCP/IP and select Enable, I get a warning stating that the changes will be saved but will not take effect until after I restart the service. When I click OK on the warning popup to close it, it still shows TCP/IP as Disabled. After I restart the service I return to the Protocols screen and check the value of TCP/IP. It is still Disabled. I am still unable to connect to it remotely. Configuration Manager is not allowing me to enable TCP/IP. I need to do this. I looked for an alternate way to enable TCP/IP but have not been able to find one that works.  Any thoughts?

sql server 2005 express - don't allow to create table

i have downloaded sql server 2005 Express version from the web and use domainname\SQLEXPRESS as server name but now i can't create table seems every create by sa user, what is the password of this user or how to grand right to my window login user so that i can modify/create something in database.

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Multiple XML files into SQL SERVER Express 2005

Hello. I am familiar with classic ASP and use this with MS SQL SERVER EXPRESS. I have an SQL table and want to import multiple XML files into this on a daily basis. I currently have 3 files, transferdata.vbs which loops through the XML files. FAQschema.xml which maps XML to the SQL database and test.xml shows the xml in the test file. If I run transferdata.vbs I get the following error "Error opening the data file" line 33 char 3. Microsoft Bulkload for SQL Server". My SQL table is called EnqOrd id (int), Debitor (varchar), PurchaseDate (varchar)     transferdata.vbs set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "Provider=SQLOLEDB; Data Source=XXXXXX\XXXXX; Initial Catalog=XXXX; User ID=XXXXX; Password=XXXXXX" objBL.ErrorLogFile = "E:\fuelsql\Teccom\error.log" ' Here is the path to your XML files Const path = "E:\fuelsql\Teccom\XML\" Dim Text, Title, oFile Dim fso, oFolder, oFiles, wsh ' Object variables Text = "Folder " Title = "XML Files" Set wsh = WScript.CreateObject("WScript.Shell") ' Create FileSystemObject object to access the file system. Set fso = CreateObject("Scripting.FileSystemObject") ' Get Folder object. Set oFolder = fso.GetFolder(wsh.ExpandEnvironmentStrings(path)) ' Get All Files Set oFiles = oFolder.

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  
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