Solved

SQL Server instance install

Posted on 2011-09-29
8
250 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
  • 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
 
LVL 7

Author Comment

by:Camillia
ID: 36815413
how can I check that?? check which account?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server R2 Stored procedure performance 8 42
SQL Help - 12 60
SQL query to summarize items per month 5 52
Determine log file requirements 7 35
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now