RE: How do I get back to base SQL server on my SBS 2003 server?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Dan,

Many thanks for your update.

The security group SQLServer2005SQLBrowserUser$Computername shall be
created during SQL Server setup. After some research, I found that there're
a couple of cases mentioned that the group did not create successfully
which caused the problem. I suspect that the problem may caused by security
permission.

You can refer to the SQL Server 2005 Readme and installation requirements
for info about the group.

SQL Server 2005 Readme and installation requirements
http://support.microsoft.com/kb/910228/en-us

Thank you for sharing your experience in the newsgroup, and we look forward
to working with you again.

Sincerely,
Bill

--------------------
Thread-Topic: How do I get back to base SQL server on my SBS 2003 server?
thread-index: Acflm99E5XyyQqXaQIOfnT6xRBz/Ww==
X-WBNR-Posting-Host: 207.46.193.207
From: =?Utf-8?B?RGFuRGFu?= <DanDan@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <8DBE08A9-CE00-419D-AADB-E51CF7ED2C5E@xxxxxxxxxxxxx>
<XzjM8yL2HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
<EE922183-5A44-4512-BCC3-F8AB106DF6EF@xxxxxxxxxxxxx>
<TZN0B702HHA.360@xxxxxxxxxxxxxxxxxxxxxx>
<fw18uxG4HHA.360@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: How do I get back to base SQL server on my SBS 2003 server?
Date: Thu, 23 Aug 2007 08:40:03 -0700
Lines: 49
Message-ID: <7BDB96D0-10DD-4B36-93BB-A2E441FE6A9D@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
Newsgroups: microsoft.public.windows.server.sbs
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:58487
NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
X-Tomcat-NG: microsoft.public.windows.server.sbs

The solution was very well hidden.

The CSS support person, who was very dogged and helpful found this:

* Found a similar case in which this failed also. Resolved by creating a
new Group called "SQLServer2005SQLBrowserUser$servername" and adding the
Domain Administrator account to this group.

* From this point the install completes successfully.

We added the security group in the AD and the install completed
successfully.

That seems really bizarre to me. That is, the install process *should*
check for the existence of the group, and, if not present, create it. I
am
wondering if the check was made, and a false positive was given because of
the earlier unsuccessful un-install.

--
the IT guy for small business


"Robert Li [MSFT]" wrote:

Hi Dan,

Please send me the following information:

1. Zip the "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files" folder.

2. MSDE_SBSMonitoring Log

%sbsprogramdir%\support\MSDE_SBSMonitoring.log

3. SBS Monitoring Error Log

%programfiles%\Microsoft SQL Server\MSSQL$SBSMonitoring\LOG\errorlog

Then upload by click the following link:


https://sftasia.one.microsoft.com/choosetransfer.aspx?key=3473efd8-9b1d-498d
-b4c1-d02b0a2a4859
Password: 30[cZ9p4h

I am looking forward to hear from you.

If you need further assistance, please don't hesitate to let me know.




.



Relevant Pages

  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: Critical Alert Update - W32.Slammer
    ... The .net SDK 1.0 sp1 comes with a very basic SQL Server engine for testing ... >> Microsoft SQL Desktop ... >>>cumulative SQL security patch, is completely safe from ... >> may install SQL ...
    (microsoft.public.security)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • Re: Installed VS 2005 want to Manage SQL 2005 Server
    ... Microsoft SQL Server Management Studio 9.00.3042.00 ... Microsoft Analysis Services Client Tools 2005.090.3042.00 ... If you later install a more recent service pack, this service pack will be uninstalled automatically. ... How to uninstall SQL Server Management Studio ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Server Express on SBS2003 standard
    ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... After you applied the SBS 2003 SP1 successfully, you can install the ... SQL Server Express on SBS. ...
    (microsoft.public.windows.server.sbs)