Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2008 Expand / Collapse
Author
Message
Posted Wednesday, February 9, 2011 11:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 27, 2011 10:43 PM
Points: 7, Visits: 18
HI, WHEN I SELECT SQL SERVER CONFIGURATION MANAGER AND SELECT SQL SERVER SERVICES IN THE LEFT PORTION AND IN THE RIGHT PORTION ARE
SQL SERVER INTEGRATION SERVICES 10.0 " IT IS running"
SQL SERVER (sqlexpress) "it is stopped"
sql full-text filter daemon luncher (mssqlserver)"It is running"
sql server (mssqlserver) "it is stopped"
sql server Analysis services (mssqlserver)"it is running"
sql server reporting services (mssqlserver)"it is running"
sql server agent (sqlexpress)"it is stopped"
sql server browser"It is running"
sql server agent (mssqlserver) "it is stopped"

these are the parameters i can see in my manager please can u tell me what is wrong.
Post #1061425
Posted Wednesday, February 9, 2011 11:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 934, Visits: 2,673
We can't tell you what is wrong unless you tell us what problem you are experiencing. What you are seeing is the state of each service of SQL Server. I'm guessing from this information that you are not able to connect to your default or SQL express instance. This is shown by seeing this:
SQL SERVER (sqlexpress) "it is stopped"
sql server (mssqlserver) "it is stopped"

To fix this you can right-click each one of those servers and click "start". If there is an issue with it starting an error might be displayed. But it is more likely you will get a more detailed answer by checking the Application or System log in Windows Event Viewer.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1061435
Posted Wednesday, February 9, 2011 10:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 27, 2011 10:43 PM
Points: 7, Visits: 18
see this is the message

when i run the stopped service this is the message i get
the request failed or the service did not respond in a timely fashion. consult the event log or other applicable error logs for details


Shawn Melton (2/9/2011)
We can't tell you what is wrong unless you tell us what problem you are experiencing. What you are seeing is the state of each service of SQL Server. I'm guessing from this information that you are not able to connect to your default or SQL express instance. This is shown by seeing this:
SQL SERVER (sqlexpress) "it is stopped"
sql server (mssqlserver) "it is stopped"

To fix this you can right-click each one of those servers and click "start". If there is an issue with it starting an error might be displayed. But it is more likely you will get a more detailed answer by checking the Application or System log in Windows Event Viewer.
Post #1061695
Posted Thursday, February 10, 2011 1:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:44 AM
Points: 45, Visits: 852
hi
post error from errorlog or application for detailed reference.
Post #1061760
Posted Thursday, February 10, 2011 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 27, 2011 10:43 PM
Points: 7, Visits: 18
sorry to say where is log error from can i get the error
k.thanigaivel (2/10/2011)
hi
post error from errorlog or application for detailed reference.
Post #1061911
Posted Thursday, February 10, 2011 6:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 934, Visits: 2,673
Well you may not actually see any error in the SQL ERRORLOG file but default location is:
C:\Program Files\Microsoft SQL Server\MSSQ.1\MSSQL\LOG.

I would actually first look in your Windows Event Log (Start > Run > eventvwr). The Application and/or System Log should also tell you why it did not start, or what issue it is caught on.

Is the service set to run as a system account (Local System, or system account like NT AUTHORITY\SYSTEM) or a local/domain account? This can effect permissions if it is running as a customized account, depending on how it was setup.

If it is a local account within the properties of the service (using SQL Server Service Manager) re-enter the usrename and password. This will attempt to give it the correct permissions it requires.


Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1061918
Posted Thursday, February 10, 2011 6:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 27, 2011 10:43 PM
Points: 7, Visits: 18

Log Name: Security
Source: Microsoft-Windows-Security-Auditing
Date: 2/10/2011 4:28:02 PM
Event ID: 5061
Task Category: System Integrity
Level: Information
Keywords: Audit Success
User: N/A
Computer: AbdulRehman
Description:
Cryptographic operation.

Subject:
Security ID: LOCAL SERVICE
Account Name: LOCAL SERVICE
Account Domain: NT AUTHORITY
Logon ID: 0x3e5

Cryptographic Parameters:
Provider Name: Microsoft Software Key Storage Provider
Algorithm Name: RSA
Key Name: Microsoft SQL Server$MSSQLSERVER$FallBackCert
Key Type: User key.

Cryptographic Operation:
Operation: Open Key.
Return Code: 0x0
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-Security-Auditing" Guid="{54849625-5478-4994-A5BA-3E3B0328C30D}" />
<EventID>5061</EventID>
<Version>0</Version>
<Level>0</Level>
<Task>12290</Task>
<Opcode>0</Opcode>
<Keywords>0x8020000000000000</Keywords>
<TimeCreated SystemTime="2011-02-10T13:28:02.021710900Z" />
<EventRecordID>5127</EventRecordID>
<Correlation />
<Execution ProcessID="720" ThreadID="756" />
<Channel>Security</Channel>
<Computer>AbdulRehman</Computer>
<Security />
</System>
<EventData>
<Data Name="SubjectUserSid">S-1-5-19</Data>
<Data Name="SubjectUserName">LOCAL SERVICE</Data>
<Data Name="SubjectDomainName">NT AUTHORITY</Data>
<Data Name="SubjectLogonId">0x3e5</Data>
<Data Name="ProviderName">Microsoft Software Key Storage Provider</Data>
<Data Name="AlgorithmName">RSA</Data>
<Data Name="KeyName">Microsoft SQL Server$MSSQLSERVER$FallBackCert</Data>
<Data Name="KeyType">%%2500</Data>
<Data Name="Operation">%%2480</Data>
<Data Name="ReturnCode">0x0</Data>
</EventData>
</Event>
quote]Shawn Melton (2/10/2011)
Well you may not actually see any error in the SQL ERRORLOG file but default location is:
C:\Program Files\Microsoft SQL Server\MSSQ.1\MSSQL\LOG.

I would actually first look in your Windows Event Log (Start > Run > eventvwr). The Application and/or System Log should also tell you why it did not start, or what issue it is caught on.

Is the service set to run as a system account (Local System, or system account like NT AUTHORITY\SYSTEM) or a local/domain account? This can effect permissions if it is running as a customized account, depending on how it was setup.

If it is a local account within the properties of the service (using SQL Server Service Manager) re-enter the usrename and password. This will attempt to give it the correct permissions it requires.[/quote]
Post #1061929
Posted Monday, November 19, 2012 3:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:48 AM
Points: 3, Visits: 141
--eliminates database owned by sa, and read only databases
sp_msforeachdb 'USE [?]; if exists(
SELECT Name, SUSER_SNAME(owner_sid) from sys.databases
where name = ''?'' and isnull(SUSER_SNAME(owner_sid),'''') <> ''sa'' and is_read_only = 0) EXEC dbo.sp_changedbowner @loginame = ''sa'';'
Post #1386260
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse