Solved

SQL Browser Eventid 3

Posted on 2009-06-29
1
806 Views
Last Modified: 2012-05-07
Source SQL Browser
EventID: 3

The configuration of the AdminConnection\TCP protocol in the SQL instance MICROSOFT##SSEE is not valid.

as well
as

Source SQL Browser
EventID: 3
The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.

I have tried the following:

Enable TCP/IP and Named Pipes using SQL Server Configuration Manager
Enable TCP Dynamic Port
Restart the server, problem persists

I have wss 3.0 and wsus 3.0 installed on this machine and I think these are what these databases are.
0
Comment
Question by:Anti-Mhz
1 Comment
 
LVL 18

Accepted Solution

by:
brejk earned 200 total points
ID: 24740286
There is a trace flag 7806 that has to be enabled if you wish to use DAC with Express Edition. Run:

DBCC TRACEON(7806, -1)

or start your SQL Server service with -T7806 switch.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now