Re: network connection problems after Windows updates

My MSDE instance is running Local service not network service? What is that service have as it's "log on as"?

Call 1-866-pcsafety.

Current known issues are interactions with Zone Alarm and the DNS patch.

Clarence wrote:
Same issue here after applying updates. Noted that the MSSQLSERVER service is started, but the MSSQL$SHAREPOINT is not. Attempts to start it fail. Companyweb access attempts result in the following:

Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com.

This document states four (4) causes for this issue.

1. The SQL database is not running.
[ I've verified that the SQL database is not running and will not start. The MSSQLSERVER service is running, but the MSSQL$SHAREPOINT service is not running. Attempts to start it fail.]

2. Internet Information Services (IIS) is configured to run in IIS 5.0 isolation mode.
[ Verified IIS is not running in IIS 5.0 islolation mode ]

3. The account that is used by application pool does not have the required permissions to the SQL Server database.
[ Unable to verify that the account (Network service) that is used by the application pool is the account that has the required permissions to the SQL Server database. Attempts to verify permissions generate a 'connection failed, check SQL Server Registration Properties' error. Unable to edit the Registration Properties. Deleted the servername\SHAREPOINT server from the SQL Server Group in Enterprise Manager, then recreated a new SQL Server Registration. Had to manually enter the name (not in list). Set to use Windows authentication. Not change - still unable to start.]

4. Network connectivity has been lost between the Windows SharePoint Services server and the Microsoft SQL Server server.
[ I have network connectivity and correct name resolution between the servers ]

Any ideas would be greatly appreciated. Meanwhile, checking Google again.

Clarence

"Terry" <terry@xxxxxxxxxxxxxxxxxx> wrote in message news:28F35C3B-811A-43C9-AE20-180EEEDFA9EA@xxxxxxxxxxxxxxxx
I have a problem with LAN connections after applying updates KB951748, KB951746, and KB948110. I can not connect to the SBS 2003 server or SharePoint Website nor can I ping anything from the SBS box. Has anyone else had any troubles? Internet connections are working, clients are setup for DHCP on the router. Everything was fine until the updates. Any suggestions?

Thanks,


.

Relevant Pages

  • Re: network connection problems after Windows updates
    ... required permissions to the SQL Server database. ... then recreated a new SQL Server Registration. ... Network connectivity has been lost between the Windows SharePoint ...
    (microsoft.public.windows.server.sbs)
  • Re: network connection problems after Windows updates
    ... The MSSQL$SHAREPOINT service has 'Local System account' for 'Log on as:' ... required permissions to the SQL Server database. ... Network connectivity has been lost between the Windows SharePoint ...
    (microsoft.public.windows.server.sbs)
  • Re: NT Authority etworkservice failed to connect
    ... It should be Network Service by default. ... from the web config. ... your SQL Server on same server as IIS, If SQL Server is on seperate server ... SQL-server, but nothing happens.. ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint / Companyweb / MSDE Sharepoint Instance / KB829358
    ... Local Service and Network Service account: ... > running for both SQL Server and Distributed Transaction Coordinator. ...
    (microsoft.public.windows.server.sbs)
  • Re: Network Service Account
    ... SQL Server process as Network Service, but rather as a Domain User ... you do follow using user or domain accounts as the ...
    (microsoft.public.sqlserver.security)