February 9, 2011 at 11:30 am
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.
February 9, 2011 at 11:38 am
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
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 9, 2011 at 10:24 pm
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.
February 10, 2011 at 1:58 am
hi
post error from errorlog or application for detailed reference.
February 10, 2011 at 6:25 am
sorry to say where is log error from can i get the error
k.thanigaivel (2/10/2011)
hipost error from errorlog or application for detailed reference.
February 10, 2011 at 6:38 am
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
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 10, 2011 at 6:54 am
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)
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]
November 19, 2012 at 3:12 am
--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'';'
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply