Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Browser Eventid 3

Posted on 2009-06-29
1
Medium Priority
?
815 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 800 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .

773 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