SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sql server 2008


sql server 2008

Author
Message
muhamadehsan
muhamadehsan
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 24
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.
Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5665 Visits: 3537
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: blog.wsmelton.info
muhamadehsan
muhamadehsan
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 24
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.

k.thanigaivel
k.thanigaivel
SSC-Enthusiastic
SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)

Group: General Forum Members
Points: 179 Visits: 852
hi
post error from errorlog or application for detailed reference.
muhamadehsan
muhamadehsan
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 24
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.

Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5665 Visits: 3537
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: blog.wsmelton.info
muhamadehsan
muhamadehsan
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 24
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]
gleb.zalt
gleb.zalt
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 227
--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'';'
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search