<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
sql server 2008
sql server 2008
Rate Topic
Display Mode
Topic Options
Author
Message
muhamadehsan
muhamadehsan
Posted Wednesday, February 09, 2011 11:30 AM
Forum 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
Shawn Melton
Shawn Melton
Posted Wednesday, February 09, 2011 11:38 AM
Right there with Babe
Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754,
Visits: 1,891
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
@wshawnmelton
Post #1061435
muhamadehsan
muhamadehsan
Posted Wednesday, February 09, 2011 10:24 PM
Forum 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
k.thanigaivel
k.thanigaivel
Posted Thursday, February 10, 2011 1:58 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45,
Visits: 851
hi
post error from errorlog or application for detailed reference.
Post #1061760
muhamadehsan
muhamadehsan
Posted Thursday, February 10, 2011 6:25 AM
Forum 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
Shawn Melton
Shawn Melton
Posted Thursday, February 10, 2011 6:38 AM
Right there with Babe
Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754,
Visits: 1,891
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
@wshawnmelton
Post #1061918
muhamadehsan
muhamadehsan
Posted Thursday, February 10, 2011 6:54 AM
Forum 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
gleb.zalt
gleb.zalt
Posted Monday, November 19, 2012 3:12 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, May 12, 2013 3:18 AM
Points: 3,
Visits: 99
--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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
