Solved

SQL Server instance install

Posted on 2011-09-29
8
246 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

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.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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

20 Experts available now in Live!

Get 1:1 Help Now