• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 786
  • Last Modified:

SQL 2005 restart issue

Today I made some changes to my SQL 2005  Standard SP3 server on my windows 2003 R2 Standard Dc SP2 server

I did a sql server restart reveiced these messages

Type :            Audit Failure
Date :            4/12/2010
Time :            8:54:25 AM
Event :            18456
Source :            MSSQLSERVER
Category :      Logon
User :            NT AUTHORITY\NETWORK SERVICE
Computer :      TGCS001
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: 192.168.69.10]

Type :            Audit Failure
Date :            4/12/2010
Time :            8:54:25 AM
Event :            18456
Source :            MSSQLSERVER
Category :      Logon
User :            NT AUTHORITY\NETWORK SERVICE
Computer :      TGCS001
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]

Type :            Audit Failure
Date :            4/12/2010
Time :            8:54:25 AM
Event :            18456
Source :            MSSQLSERVER
Category :      Logon
User :            NT AUTHORITY\NETWORK SERVICE
Computer :      TGCS001
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: 192.168.69.10]

Type :            Audit Failure
Date :            4/12/2010
Time :            8:54:25 AM
Event :            18456
Source :            MSSQLSERVER
Category :      Logon
User :            OUR\spsacct
Computer :      TGCS001
Description:
Login failed for user 'OUR\spsacct'. [CLIENT: 192.168.69.10]

Type :            Error
Date :            4/12/2010
Time :            8:54:25 AM
Event :            3760
Source :            Windows SharePoint Services 3
Category :      Database
User :            N/A
Computer :      TGCS001
Description:
SQL Database 'SharePoint_Config' on SQL Server instance 'tgcs001' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config" requested by the login. The login failed.

Type :            Information
Date :            4/12/2010
Time :            8:54:26 AM
Event :            9666
Source :            MSSQLSERVER
Category :      Server
User :            N/A
Computer :      TGCS001
Description:
The Service Broker protocol transport is disabled or not configured.

Type :            Information
Date :            4/12/2010
Time :            8:54:26 AM
Event :            9666
Source :            MSSQLSERVER
Category :      Server
User :            N/A
Computer :      TGCS001
Description:
The Database Mirroring protocol transport is disabled or not configured.

Type :            Error
Date :            4/12/2010
Time :            8:54:26 AM
Event :            5586
Source :            Windows SharePoint Services 3
Category :      Database
User :            N/A
Computer :      TGCS001
Description:
Unknown SQL Exception 233 occured. Additional error information from SQL Server is included below.
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Type :            Error
Date :            4/12/2010
Time :            8:54:26 AM
Event :            6398
Source :            Windows SharePoint Services 3
Category :      Timer
User :            N/A
Computer :      TGCS001
Description:
The Execute method of job definition Microsoft.SharePoint.Administration.SPConfigurationRefreshJobDefinition (ID e074a874-9eb5-43be-96fc-71538a564595) threw an exception. More information is included below.
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Type :            Audit Failure
Date :            4/12/2010
Time :            8:54:26 AM
Event :            18456
Source :            MSSQLSERVER
Category :      Logon
User :            OUR\spsacct
Computer :      TGCS001
Description:
Login failed for user 'OUR\spsacct'. [CLIENT: 192.168.69.10]

Type :            Error
Date :            4/12/2010
Time :            8:54:26 AM
Event :            3760
Source :            Windows SharePoint Services 3
Category :      Database
User :            N/A
Computer :      TGCS001
Description:
SQL Database 'SharePoint_Config' on SQL Server instance 'tgcs001' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config" requested by the login. The login failed.

again these occured after i did a sql server restart

Any ideas I know a lot of messages hopefully I am just missing some setting somewhere


Thanks
0
Inserachof
Asked:
Inserachof
1 Solution
 
BawerCommented:
check the SQl server services... in services menu...
0
 
InserachofAuthor Commented:
check them for what?
0
 
aymoon80Commented:
What kind of changes did you make is that uninstalling of microsoft CRM or Sharepoint or updating software?
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
aymoon80Commented:
Try to use "Local System Account" for sql server service.
0
 
InserachofAuthor Commented:
I changed the server memory properties

checked awe which enables awe

min and max memory settings

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_25664037.html

that is a link to where i reported the first issue the reason we changed the above settings

thanks
0
 
aymoon80Commented:
Did you try to use Local System Account ?
0
 
aymoon80Commented:
did you try to restart the server again, I know it is strange but just try.
0
 
mdan93Commented:
1.you have several error on there. you should check existence of the database 'SharePoint_Config' depending on you findings, you need to remove/update job, processes that have reference to it. Check for user accounts that failed on the local server to exists on the local server and check de default database for the specific user.
2. the localmachine ip is 192.168.69.10
3.The user  OUR\spsacct exists on your computer or have right on your computer ?   Use the admin user on startup services in order to filter out the account right problems from the logs.
0
 
InserachofAuthor Commented:
still reviewing
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now