x

How do I restart a SQL Express Instance loaded with quiet install?

I was working with several programs open - You Tube, Visual Studio, SQL Server, Demo9 (movie maker), when my Windows 8.1 operating system gave a me a :( message and "said" something has happened, it's being reported to Microsoft and your computer will now restart. Lost was a lot of work.

I come back from a restart and all the SQL Express 2012 instances that I had loaded with a quiet load, (I've put the code at the bottom), are in a Stopped State. I have tried to uninstall those instances and it hangs up at this point: SqlEngineConfigAction_remove_validation_Cpu64. I cannot connect to any of these instances through SSMS. I receive a "...that SQL Server is configured to allow remote connections:(provider: Shared Memory Provider, error: 40) and Could not open a connection to SQL Server, Error: 2. I was able to load another instance of SQL. But I need connection to the others.

My installation code: processObj = Process.Start("C:\DTHSQL2012\ExtractFile\setup.exe", "/q /Action=Install /IACCEPTSQLSERVERLICENSETERMS /Hideconsole /Features=SQLEngine /InstanceName=DTH2012 /SQLSYSADMINACCOUNTS=""NT AUTHORITY\SYSTEM"" /SQLSVCACCOUNT=""NT AUTHORITY\SYSTEM"" /BROWSERSVCSTARTUPTYPE=""Automatic""")
more ▼

asked Jul 28 at 06:23 PM in Default

haughtchick gravatar image

haughtchick
11 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x57
x53

asked: Jul 28 at 06:23 PM

Seen: 155 times

Last Updated: Jul 28 at 06:29 PM