multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed

Sometimes Windows networking really does some stupid stuff. Not only does it take up to a minute to connect to a network resource that is literally sitting one meter away, it also has annoying limitations such as the one listed in the title of this article.

I have seen this message before and usually disconnecting a network drive would do the trick. This time however the message would just not go away.


net use * /delete

The specified service has been marked for deletion

"The specified service has been marked for deletion”

Lately I have been working with Windows Services and came across this error when uninstalling and reinstalling the services. The culprit in this case is the MMC, once I closed and reopened the “services.msc” it resolved the issue.

Version of SQL Server and Service Pack

To Find out the version of Microsoft SQL Server and Service Packs installed

Query
=====
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Sample Output
=============
8.00.2039 SP4 Personal Edition