.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

When i connect SqlServer db i got The specified network name is no longer available.

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server



 i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.


A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...



View Complete Post

More Related Resource Links

Outlook Unable to connect to MySite's "Social Network"

Running into a really odd issue. I have to farms configred pretty much identically, a production farm and a dev farm. For some reason I'm able to set up a social network connection from outlook to my dev farm without any problems but I get "invalid user name or password" when I try and connect tot he production farm. There's no errors showing in the SPLogs or the event viewer. I've checked everything I can think of but knowing me I'm missing something really small.

how can i connect to Access DB in another PC in network

Hello all ,  i want to make 2 separated programs that share database in network the Access DB is on PC and the program is on another one how can i make the connection between them ?Kareem Naguib

local pipes vs. network pipes (to connect to SQL Server)

Choosing a Network Protocol (SQL Server 2008 R2) tells: "It is also important to clarify if you are talking about local pipes or network pipes. If the server application is running locally on the computer that is running an instance of SQL Server, the local Named Pipes protocol is an option. Local named pipes runs in kernel mode and is very fast" Well, it is not me who is talking in cited article, I believe so. Should it be understood that "If the server application is running locally on the computer that is running an instance of SQL Server" and configuring/choosing Named Pipes mean running "local Named Pipes"?

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

SQLServer Express 2008 R2 - Cannot connect Error: 18456, Severity: 14, State: 11.

I have just installed  running MSSQL Server 2008 R2 (Express), along with Visual Web Developer 2010 Express In SQL Server Configuration Manager I can see the SQL Server Service running (SQLEXPRESS) and the SQL Server Browser service running. On running SQL Server Management Studio when trying to log on I get the message Login failed for user Phil-PC`Phil (Microsoft SQL Server, Error: 18456) In the SQL Server Error log I see this error 2010-09-16 10:24:16.07 Logon       Error: 18456, Severity: 14, State: 11. 2010-09-16 10:24:16.07 Logon       Login failed for user 'Phil-PC\Phil'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] I have been unable to find anything useful on Google on how to resolve this problem. I have tried running the command line utility sqlcmd -L and this lists the following Servers:     Phil-PC     Phil-PC\SQLEXPRESS   In my list of Installed programs in Control Panel I see both MS SQL Server 2008 & MS SQL Server 2008 R2, is that correct?

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

How can connect Sqlserver 2000 over internet


Dear All

i need all of you help me. i want to conect sql server over internet from 1 country to other country using vb 6.

if can please show in example code?


thank for your help.


Connect Analysis Server across network using ADOMD connection



I'm new to Analysis Server. How will i connect the Remote Analysis Server across Network using ADOMD Connection.


Please Help me!


unable to connect to sqlserver while creating my account using VS2010 proffessional in WIN 7 home pr



I am getting  an error while  debug my application that unable to connect SQL server......The message is...


 at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
   at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
   at System.Web.Security.Roles.RoleExists(String roleName)
   at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line 51
   at CreateUser(DomainService , Object[] )
   at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
   at System.

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.


how to write SMO's conn.ConnectionString with IP address and port?

Connect to server with other network credentials??


I work from home and need to connect to my employers database server. I am running SQL Server 2008 on my home PC and I am connected remotely to my employers network via vpn. However, if I try to make a connection via windows authentication it's using my credentials I use to log onto my PC and not the credentials I use to connect via vpn. How can I enter my vpn credentials and register the remote server in Server Management Studio?

Thank you...

Unable to connect to sql server in network but working fine over VPN




I have a sql server 2005 named instance running on windows 2003. I have an issue  in sql connectivity:

When the client system is in the network, client is not able to connect in management studio to the SQL server without specifiying the port number i.e. tcp: abc\xyz. If the client specifies the port number, he is able to connect to it like tcp:abc\xyz,20001.

Now the strange thing is : The same client system when connected over vpn works fine without specifying the port number in the connection string  like tcp: abc\xyz,20001.

then why is it failing to get the port number when the system is in the network?

I verified sql browser service. it is running fine. Firewall is in stopped state. What new components would come into picture over vpn that allow browser to service the port number? It's pretty strange issue and hence looking for any thoughts.

Note: SPN is not registered for the sql service.


how to connect PHP with SQLSERVER 2008

how to connect PHP with SQLSERVER 2008

Cannot connect to SSAS production server in customers network



I have a problem when connecting to the SSAS production server (SQL Server 2008 Standard Edition) of my customer.

The situation is as follows: I have SSMS installed on my computer and also on the production server. On the server the connection to my SSAS/database works fine, but on my machine it doesn't. I am connected through a VPN connection with the customers network. The Windows Firewall is not activated on the Windows Server 2003 SP3 where SSAS is installed on. The connection to the SQL Server Database located on the same server from my machine works fine (via Windows Authentication), but as I said, the connection to SSAS does not. As we have different Windows Domains I am logged on with my corporate login (RCG\alexander.greiner) on my machine and connected through VPN with the administrative credentials (CUSTOMER\myadmin) I got from my customer.

Following error message is displayed when I try to connect to the remote SSAS in my customers network: "A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)"

Do you have any ideas on how I can solve this problem?


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?


unable to connect SQLserver 2008 to (local) on windows 7


TITLE: Connect to Server

Cannot connect to (local).


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)

Where's my Microsoft##SSEE? Can't connect, isn't in the Network Configuration, Doesn't show with



I've been having various problems with Sharepoint etc since migrating from SBS2003 to SBS2008, but currently my problems all seem to be coming back to this one thing:

The Windows Internal Database (Microsoft##SSEE)

In the SQL Server Configuration Manager it's there under SQL Server 2005 Services.

It's NOT there when I look under SQL Server 2005 Network Configuration, and it's not there in portqry2 either.

I can connect to SBSMonitoring with Microsoft SQL Server Management Studio Express using Windows Authentication, but while I can select it from the "browse for more" list, I can't connect to the Microsoft##SSEE instance the same way. It gives me an error 26.

I am doing this from the server the instance is running on. Any ideas at all would be welcome.


Full details:


Cannot connect to fangio\MICROSOFT##SSEE.


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) (.Net SqlClient Data Provider)

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