Sql Server 2012 express service not starting

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

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.

Select allOpen 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...

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.


 

tonynakad, do you still need help with this question?

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

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

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

I have attached 2 files so you can see
computer-specs.png
hardrive-specs.png

sql-data.png

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.


If this is fresh installation and no database exist you can repair this installation.

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.

local-system-error.png

I get this error when I try to to put in in the builtin account

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?

yes i have it installed yes i have checked the event viewer

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>

i got it to run but now I cannot open the database in sql management studio I get the following error

management-studio-login-error.png

I get Microsoft sql server error 18456

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.

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.