RE: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!

Hi Robert,

Sorry for the delayed response. The user NT AUTHORITY\Network Service is
already a user with all necessary privaleges. I am a SQL newbie, so I am
still learning as I go.

The following error is logged every hour: #50070 Unable to connect to the
database STS_[SERVERNAME]_1930237570 on SERVER1\SharePoint and then a
duplicate error occurrs every hour when trying toconnect to:
STS_[SERVERNAME]_122171160 on SERVER1\SharePoint.

But that doesn't surprise me because there are no databases with those names
anywhere in my system; let alone in SERVER1\SharePoint.

Any ideas are appreciated.

-Charlie

"Robert Li [MSFT]" wrote:

Hi Charli

Thanks for updaing.

I made deep research on this issue. Please try the following:

'NT AUTHORITY\NETWORK SERVICE' user was not a member under SQL Server users.

Please add the user 'NT AUTHORITY\NETWORK SERVICE' to sql server users
through Query Analyzer using the below command and that resolved
the issue.

1. sp_grantlogin [NT authority\network service]
2. sp_addsrvrolemember [NT authority\network service], [sysadmin]

Hope the informaton helps.

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

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<Thread-Topic: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!
<thread-index: AceeJoNoMWrB6j0HTN64BFfN8xEM7Q==
<X-WBNR-Posting-Host: 207.46.19.168
<From: =?Utf-8?B?Q2hhcmxpZQ==?= <Charlie@xxxxxxxxxxxxxxxxxxxxxxxxx>
<References: <136B573B-7CC3-4C0B-A0B4-945B501836A6@xxxxxxxxxxxxx>
<hSiU3CEnHHA.1428@xxxxxxxxxxxxxxxxxxxxxx>
<Subject: RE: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!
<Date: Thu, 24 May 2007 10:11:05 -0700
<Lines: 193
<Message-ID: <701D101E-5C57-44A3-AC72-79FB1430A54E@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:39193
<NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<Hi Robert,
<
<Thanks for your reponse. Unfortunately, your suggestion did not correct
the
<error. Perhaps a little more information will be useful. Again,
everything
<is working fine; WSUS, Sharepoint, etc. and I can successfully connect to
all
<instances in SQL Mgmt Studio.
<
<In Mgmt Studio, In the object explorer, under [SERVERNAME]/SHAREPOINT,
under
<databases we have the usual suspects (System, Snapshots, etc.), then we
have
<STS_Config, STS_[SERVERNAME]_1. All good. But then we also have
<STS_[SERVERNAME]_683861137, which happens to be the identifier for
<UpdateServices in IIS. UpdateServices is functioning normally.
<
<There are actually two separate errors in the application event log. the
<first cannot connect to database STS_[SERVERNAME]_1930237570, and the
second
<references STS_[SERVERNAME]_122171160. I have no ideas what these
databases
<are for, or why the sharepoint instance is trying to connect to them.
<
<Let me know if this helps, and thank you so much for investigating.
<
<-Charlie
<
<"Robert Li [MSFT]" wrote:
<
<> Hi Charli,
<>
<> Thanks for posting in our newsgroup and also for Costas's input.
<>
<> From your description, I know that you get Event ID 1000 and 18456 on
your
<> SBS 2003 R2 server. If I am off-base, please don't hesitate to let me
know.
<>
<> If you have installed SQL 2005 workgroup edition, the SHAREPOINT
instance
<> of WMSDE is upgraded, so you can not see mssql$sharepoint instance.
<> Instead, you see SQL Server (SHAREPOINT) in service management.
<>
<> Based on my experience, this issue may occur when the SharePoint Timer
<> service is running as an account that does not have access to SQL Server
or
<> the databases.
<>
<> Thus, I would suggest you synchronize the timer service with the
SharePoint
<> Central Admin pages. The following steps will ensure that the
SharePoint
<> Configuration Database, the Admin application pool, and the SharePoint
<> Timer Service are all running under the same context.
<>
<> 1. Go to "SharePoint Central Administration" page.
<> 2. Click "Windows SharePoint Services" on the left side.
<> 3. Under Server Configuration, Click Configure Virtual Server for
Central
<> Administration
<> 4. Select Use an Existing Application Pool
<> 4. Select the application pool that the SharePoint Central
Administration
<> server is running under. (You can check it in IIS, by default, it is
<> CentralAdminPool)
<> 5. Click OK.
<> 6. Restart the IIS Admin service. (From Start-->Run-->services.msc,
press
<> OK button to launch services console.)
<> 7. Restart the SharePoint Timer Service.
<>
<> If the issue persists, please also check if the SQL 2005 instance which
<> hosts the Share Point Services database is listed and work properly.
<>
<> If not, please cover the following steps for the issue:
<>
<> 1. Click Start, and then click Run.
<> 2. In the "Open" box, type "services.msc" (without the quotation marks),
<> and then press ENTER.
<> 3. Check the Service "SQL Server ( SHAREPOINT )", is it started? If not,
<> please try to start it.
<> 4. Then, in the SQL Management Studio, please try to connect to the
<> instance.
<> NOTE: Please make sure you have add the instance name after the server
<> name. You need to type <your server name>\sharepoint in the server name
on
<> the Connect to Server dialog box.
<>
<> Step 3: Please try the steps in the KB 889646.
<>
<> 889646 "Error 18456" error message when you specify configuration
database
<> settings
<> on the Set Configuration Database Server page of SharePoint Central
<> Administration
<> http://support.microsoft.com/default.aspx?scid=kb;EN-US;889646
<>
<> Please have a check and let me know if the steps work well. Expect your
<> reply and have a good day!
<>
<> Best regards,
<>
<> Robert Li(MSFT)
<>
<> Microsoft CSS Online Newsgroup Support
<>
<> Get Secure! - www.microsoft.com/security
<>
<> =====================================================
<>
<> This newsgroup only focuses on SBS technical issues. If you have issues
<> regarding other Microsoft products, you'd better post in the
corresponding
<> newsgroups so that they can be resolved in an efficient and timely
manner.
<> You can locate the newsgroup here:
<> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
<>
<> When opening a new thread via the web interface, we recommend you check
the
<> "Notify me of replies" box to receive e-mail notifications when there
are
<> any updates in your thread. When responding to posts via your
newsreader,
<> please "Reply to Group" so that others may learn and benefit from your
<> issue.
<>
<> Microsoft engineers can only focus on one issue per thread. Although we
<> provide other information for your reference, we recommend you post
<> different incidents in different threads to keep the thread clean. In
doing
<> so, it will ensure your issues are resolved in a timely manner.
<>
<> For urgent issues, you may want to contact Microsoft CSS directly.
Please
<> check http://support.microsoft.com for regional support phone numbers.
<>
<> Any input or comments in this thread are highly appreciated.
<>
<> =====================================================
<>
<> This posting is provided "AS IS" with no warranties, and confers no
rights.
<>
<> --------------------
<> <Thread-Topic: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!
<> <thread-index: AcebypYlFdvHGoL7RGCSL4X9PFhP5Q==
<> <X-WBNR-Posting-Host: 207.46.193.207
<> <From: =?Utf-8?B?Q2hhcmxpZQ==?= <Charlie@xxxxxxxxxxxxxxxxxxxxxxxxx>
<> <Subject: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!
<> <Date: Mon, 21 May 2007 10:08:00 -0700
<> <Lines: 40
<> <Message-ID: <136B573B-7CC3-4C0B-A0B4-945B501836A6@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:38307
<> <NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
<> <X-Tomcat-NG: microsoft.public.windows.server.sbs
<> <
<> <Almost too weird,
<> <
<> <The Sharepoint site (companyweb) is working perfectly. I am receiving
the
<> <two error messages in the event logs. Here is the kicker...when I
check
<> the
<> <services to make sure all necessary services are started,
<> MSSQL$SHAREPOPINT
<> <doesn't even appear in the list. All of the others are there, WSUS,
<> <SBSMONITORING, MSFW. In SQL SERVER Management Studio, I can connect to
<> the
<> <following database engines: SERVER\SHAREPOINT, SERVER\WSUS,
<> <SERVER\SBSMONITORING, SERVER\MSFW. Please help, or at the very least
<> point
<> <me in the right direction.
<> <
<> <Running: SBS 2003 R2, SQL 2005.
<> <
<> <-Charlie
<> <
<> <Error #1
<> <Event Type: Error
<> <Event Source: Windows SharePoint Services 2.0
<> <Event Category: None
<> <Event ID: 1000
<> <Date: 5/21/2007
<> <Time: 10:35:55 AM
<> <User: N/A
<> <Computer: SERVER1
<> <Description:
<> <#50070: Unable to connect to the database STS_SERVER1_1221711620 on
<> <SERVER1\SharePoint. Check the database connection information and make
<> sure
<> <that the database server is running.
<> <------------------------------------------------------------------------
<> <Error# 2
<> <Event Type: Failure Audit
<> <Event Source: MSSQL$SHAREPOINT
<> <Event Category: (4)
<> <Event ID: 18456
<> <Date: 5/21/2007
<> <Time: 10:35:55 AM
<> <User: NT AUTHORITY\NETWORK SERVICE
<> <Computer: SERVER1
<> <Description:
<> <Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT:
<> 192.168.3.16]
<> <
.

Loading