Solved

SQL Browser Eventid 3

Posted on 2009-06-29
1
810 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

739 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