Sql Server 2012 express service not starting

i have sql server 2012 express installed in windows 2012 r2 standard and the service is not starting
tonynakadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tonynakadAuthor Commented:
windows could not start the sql server sql express on local computer for more information review the system event log this is not microsoft service contact the service vendor and refer to service specific error code 945
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
would that be this error:
SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-inaccessible-files-or-insufficient-memory-or-disk-space-see-the-sql-server-error-log-for-details/
Fix/Solution/WorkAround:
1) If possible add more hard drive space either by removing of unnecessary files from hard drive or add new hard drive with larger size.

2) Check if the database is set to Autogrow on.

3) Check if the account which is trying to access the database has enough permission to perform operation.

4) Make sure that .mdf and .ldf file are not marked as read only on operating system file system level.

Open in new window


typically this happens when the transaction log file was not configured correctly (aka no t-log backups in place), and it filled the disk completely...
0
Deepak ChauhanSQL Server DBACommented:
service is not starting

Which service log on account is using to run the service?
1. Check the Windows event log for actual cause of the error. or you can share the event log if possible.
2. Open SQL server configuration manager and check the startup parameters... showing in image.
3. Check the master.mdf, master.ldf file exist at the location mentioned in statup parameter.


 ConfigMgr.JPG
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Vitor MontalvãoMSSQL Senior EngineerCommented:
tonynakad, do you still need help with this question?
0
tonynakadAuthor Commented:
i have capacity 100gb used space 33.7gb I have 8gb of ram intel xeon r cpu w35
0 2.8ghz 2.79 4 procesors
0
tonynakadAuthor Commented:
I already tried both it's not like I don't have any space I do have I have it installed on VMware I can increase the memory and the hardrive capacity
sql-error-express.png
0
tonynakadAuthor Commented:
I need to install urgently as im studying for cbt nuggets and I cannot install it right now the username im using is the administrator
0
tonynakadAuthor Commented:
I have attached 2 files so you can see
computer-specs.png
hardrive-specs.png
0
tonynakadAuthor Commented:
0
Deepak ChauhanSQL Server DBACommented:
Did you check the service startup parameters as showing in above image. -Master data file location, master log file location and error log file location.

Try to change the service account to Local system and start the service.

Service.JPG
If this is fresh installation and no database exist you can repair this installation.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you do what the error message says?
Go to Event Viewer and check the error messages there. Can lead you to the solution to solve this.
0
tonynakadAuthor Commented:
0
tonynakadAuthor Commented:
I get this error when I try to to put in in the builtin account
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
i have sql server 2012 express installed (...)
I need to install urgently (...)
So, do you have it install or not? By the screenshots I would say you have it.


I get this error when I try to to put in in the builtin account
And why you want to do that?

Again, did you check in the Event Viewer for errors?
0
tonynakadAuthor Commented:
yes i have it installed yes i have checked the event viewer
0
tonynakadAuthor Commented:
I'm getting this error message in event viewerLog Name:      System
Source:        Service Control Manager
Date:          6/24/2015 7:35:52 PM
Event ID:      7024
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      3cx.3cx.com
Description:
The SQL Server (SQLEXPRESS) service terminated with the following service-specific error:
%%945
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7024</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2015-06-24T23:35:52.994436100Z" />
    <EventRecordID>9034</EventRecordID>
    <Correlation />
    <Execution ProcessID="536" ThreadID="6848" />
    <Channel>System</Channel>
    <Computer>3cx.3cx.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">SQL Server (SQLEXPRESS)</Data>
    <Data Name="param2">%%945</Data>
    <Binary>4D005300530051004C002400530051004C0045005800500052004500530053000000</Binary>
  </EventData>
</Event>
0
tonynakadAuthor Commented:
i got it to run but now I cannot open the database in sql management studio I get the following error
0
tonynakadAuthor Commented:
0
tonynakadAuthor Commented:
I get Microsoft sql server error 18456
0
Deepak ChauhanSQL Server DBACommented:
Error 18456 showing authentication issue. No issue with SQL server services.

Can you login with "SA" or other login which is added in sql server logins. Or you can use the login which you added as administrator during the installation.
0
Deepak ChauhanSQL Server DBACommented:
If you dont have SA password or you don't know which user is added as administrator in sql server login.

If you don't know the password of SA and you dont know which users is added as admin in sql server in this case you have to start sql server in single users mode by adding the  -m switch in startup parameter and restart the service. This way you will able to login into sql server using windows administrator account.

Once you entered into sql server you can reset the password of SA or you can create a new login and grant him SYSAdmin SQL server role going forward you can use this new login. Also you can add your login ID.

Single-user-Mode.JPG
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
The user you're trying to use to log on doesn't exist in SQL Server so we'll be not able to login with those credentials.
Do you have another login that you can try?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.