Solved

SQL Server instance install

Posted on 2011-09-29
8
253 Views
Last Modified: 2012-05-12
We have a develper in another state who says she's installed SQL Server instance. She even sent me a sreenshot of what she had installed. When she looks at "control panel, administartor tools, Services", we dont see the instance,,,,

We see MSSQLServer and SQL Express. I asked her to stop SQL Express. She did but when she wants to start MSSQLServer...she gets an error.

I've attached both screenshots. If she's actually installed an instance, where is it?? She tried repairing and unisntalling...seems like it got worse...i can ask her for the latest error but where to go from here??
AddRemovePrograms.png
whenItryToStart.png
0
Comment
Question by:Camillia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36814732
Can you tell me what you in the eventlogs during the same time frame?
0
 
LVL 7

Author Comment

by:Camillia
ID: 36814967
This is what she sees in the errorlog..some error related to master.mdf...
2011-09-28 18:44:12.45 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-09-28 18:44:12.45 Server      Error: 17113, Severity: 16, State: 1.
2011-09-28 18:44:12.45 Server      Error 2(The system cannot find the file specified.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

Open in new window

0
 
LVL 8

Expert Comment

by:venk_r
ID: 36815365
May be a permission issue.Whats the account the sqlserver service is running on?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 7

Author Comment

by:Camillia
ID: 36815413
how can I check that?? check which account?
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36815419
In the above scenario, some other process/application has a lock on master.mdf and this isn’t allowing SQL to take access, hence the service fails to start. To find out which process it is you can use either Process Explorer or Handle.exe from sysinternals. The usual culprits are Anti-Virus or Anti-Malware services. Once you identify the process, after stopping that, attempt to start SQL again.

 Some Common Causes for SQL Service startup failures

•Access denied on the folders for the SQL Server Service Account, specifically on the DATA folder which contains the SQL Server system databases.
•Due to some other processes like anti-virus holding a lock on the SQL database files.
•Insufficient permissions granted to the SQL Server Service account.


 Important:

 Always make SQL service account changes via the SQL Configuration manager since only this tool sets the proper permissions or ACL’s to the new service account. Services.msc does not set ACL’s.



 


 


•Server side protocols for SQL not set correctly or disabled.
•Critical system database files not found due to either accidental deletion of files or disk failures.
•System database files having inconsistencies preventing SQL Server startup.
•Password of the service account was changed but not updated on the server that has the SQL instance installed.
•Startup parameters have incorrect file path locations.
•The SQL Server service is disabled in Service Control Manager.

0
 
LVL 8

Expert Comment

by:venk_r
ID: 36815452
from control panel->Administrative tools-?SERVICES->SQL Server
right click  properties->logon tab
And you'll see the account info.
0
 
LVL 7

Author Comment

by:Camillia
ID: 36815714
It's "local system account". The thing is, she says she's installed with an instance...sent me a screenshot of the instance but when we look at Services, the instance is not there...

she sent me a screenshot ...above. I see MSSQLServer...not her instance. Should she uninstall and redo?
0
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
ID: 36815881
I think that would be my best bet.I think its got some conflicts between different versions.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question