.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

not able to connect to sql server using management tool but can login using mylittleadmin

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :ASP.Net


I am unable to connect using sql server management tool installed in the computer but can login using little web admin.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Could any one explain what is going wrong.

Thanks in advance

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)

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

how to connect my hosting database from my pc using sql server management studio 2005



I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance

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 Server 2008 management tool and MSXML6 sp2 question



I would like to install the management tool on my WinXP SP3 machine.
When almost went through all processes, some error happened.  And I checked it's because of the MSXML6 SP2.  I need to uninstall the MSXML6, but just can't remove it from the Add/Remove program.  I tried to reinsatll the MSXML6 but it said a newer version is already there.
How do I solve this problem?
Thanks for help.


Unable to Connect to SQL Serrver using SQL Server Management Studio


I just installed the 64bit version of SQL Server using the Developer edition CD for SQL Server.  The problem I'm having is that I cannot connect to SQL Server using SQL Server Management Studio.  I’m getting the message “a network-related or instance specific error occurred while establishing a connection to sql server. the server was not found or not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.”.  I’ve done a lot of Google searches but yet to find a solution.  I've checked to be sure it is started and enabled all protocols except VIA.  I have remote connections allowed.  I used the default name MSSQLSERVER which is what I'm using to connect to in Management Studio.

Can someone help, I have no idea what to check now.  BTW, I've also installed SP3.

[SQL-DMO] You must use SQL Server 2005 management tools to connect to this server


The application I'm using is throwing an error when trying to connect so SQL Server 2005.


If I go to Administrative Tools, Computer Management, Services and Applications, Microsoft SQL Servers, 2005 Server, I get this message:


A connection could not be established to [server name].

Reason: [SQL-DMO] You must use SQL Server 2005 management tools to connect to this server.

Please verify SQL Server is running and check your SQL Server registration properties and try again.


I have SQL 2000 and SQL 2005 installed on my pc.  I'm not having any problems with 2000.

Error while trying to connect with SSRS through Sql server management studio



I have installed SQL Server 2008 R2 on my system. Reports manager is working fine for me, but when I tried to connect to Reporting service instance using SSMS, I got the following error. I am not able to understnad why it is happening.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)


The remote certificate is invalid according to the validation procedure. (System)



how can i connect to my sql server management studio??


when i run the SSMS,while i have to enter my server name,i dont know it...

also,in the installation time,the istall didn't require any password or server name or anything to enter...

in other word,i dont have any server name for my sql server and so that i got this error:

TITLE: Connect to Server

Cannot connect to Bahador-gh-PC.


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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476



how can i resolve it??

plz as soon as you can, answer me...

tnx a lot :):)

SQL server management studio reconnects / connect fails / connects fine



I am checking out an application performance issue on a particular (distributed SQL express) machine - and now have the machine back in my possession. I have narrowed it to SQL and/or our application.

In short SQL seems 'hesitant' - SSMS connects first time sometimes, fails another time, disconnects after being connected and so-on. I'm connecting to the machine via real simple cable-hub-cable, and I'm positive its not networking as I'm RDP'd onto the machine and get quick responses whilst SSMS is being moody.

SQL logs show nothing, neither default trace or custom trace show anything, or windows logs.

In SSMS I have a query open, it returns immediately on some runs and takes 2 mins on other runs - it is a tiny query, straight select.

The treeview in SSMS is sporadically taking a long time to respond and times out sometimes - other times it was connected and then prompts for authentication ....fails to connect, you cancel, then reconnects first time after that.

...something odd is happening.

There are loads of other angles I have tried - autoclose is disabled by the way.

Anyone experiencing this sort of behaviour elsewhere or have any thoughts ?  I use SQL connections and technologies everywhere in my normal working day - this has me scratching my head.

Thanks for your brain cycles in advance !

Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St



I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.


Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'


I think the connection string is fine as I am able to connect

To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects


What could be wrong?

I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4.

EXEC @rc = master..sp_OAMethod @Obj, 'Execute'

The linked server is SQL Server 2005 x64.  Already installed is SQLServer2005_BC_x64.msi version April 15, 2006.  Local server is SQL Server 2000 SP4. 

I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed.  Profiler in 2005 indicates success for the whole sproc. 

It fails when I execute in Query Analyzer while connected on SQL 2000 SP4.  Tried this with 3 different machines SQL Server 2000 SP4.  The server do not have any 2005 component installed.

According to Profiler in 2005, the last event that happen is

SQL: BatchCompleted

if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec master.dbo.sp_MSSQLDMO80_version else if
(object_id('master.dbo.sp_MSSQLDMO70_version') is not null) exec master.dbo.sp_MSSQLDMO70_version else select 0

Below is the trapped Query Analyzer message.

Error Source: Microsoft Data Transformation Services (DTS) Package 
Error Description:Package failed because Step 'dts_name_removed' failed. 
Error code: 80040428 \
Error Help File:sqldts80.hlp 
Error Help Context ID:700 

Step Error Source: Microsoft SQL-DMO (O

Data Points: SQL Server Management Objects


SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.

John Papa

MSDN Magazine June 2007

Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT


One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

Roy Margolis

MSDN Magazine July 2002

SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation


SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Database object to automate common administration tasks such as programmatically retrieving configuration settings, creating new databases, applying T-SQL scripts, and creating and scheduling backups.

Francesco Balena

MSDN Magazine May 2001

Scripting Windows: Windows Management Instrumentation Provides a Powerful Tool for Managing Windows


The new Windows Management Instrumentation (WMI) technology for Windows 2000, Windows NT 4.0, and Windows 98 provides powerful scripting technology that can be used to administrate Windows-based systems. With WMI, you can create scripts to simplify management of devices, user accounts, services, networking, and other aspects of your system. This piece will introduce you to WMI and the WMI Scripting Object Model, taking a look at the available objects, methods, and properties. Along the way, you'll see how these elements can be used to create system management scripts.

Alan Boshier

MSDN Magazine April 2000

send the login credentials from site to another server



  i have a site which uses windows credentials to login and in the site i have link to ssrs server.

when i select the report it asks for authentication which i want to skip and send the same user

crendentials to the ssrsserver to access the report.

can anyone suggest on this..

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