Solved

SQL Server instance install

Posted on 2011-09-29
8
252 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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