Widgets Error 1219. Multiple connections to a server


I dream in code

About the author

Robert Williams is an internet application developer for the Salem Web Network.
E-mail me Send mail
Go Daddy Deal of the Week: 30% off your order at! Offer expires 11/6/12

Recent comments




Code Project Associate Logo


The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

Error 1219. Multiple connections to a server

Occasionally, after connecting to a server using Sql Management Studio, Remote Desktop or through Windows Explorer using a file share and then trying to connect again using another of these methods I will be stopped by this error:

Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to the server or shared resource and try again.

In the past I have rebooted to resolve the problem, but when you have half a dozen windows open this can be most inconvenient. Fortunately, I just found a better way:

Open a Command Prompt and type these commands:

net use (to see all existing connections)
net use * /del /yes (to delete all existing connections)

Categories: Networking | Windows | XP
Posted by Williarob on Thursday, March 12, 2009 10:38 AM
Permalink | Comments (1) | Post RSSRSS comment feed
blog comments powered by Disqus