Solved

SQL Server instance install

Posted on 2011-09-29
8
251 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 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