Guest User

Untitled

a guest
Jan 15th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.82 KB | None | 0 0
  1. Problems with bootstrapping sql install
  2. string res = RunCmdLineProc(Directory.GetCurrentDirectory().ToString(), "msiexec", " /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES");
  3. Thread.Sleep(120000);
  4. string localdbInstanceName = "G2";
  5. string LocalDBUtilityPath = @"C:Program FilesMicrosoft SQL Server110ToolsBinn""; // aleksey.berezan: added 2nd quote to fix stack overflow syntax highlighting
  6. //Directory.GetCurrentDirectory().ToString()
  7. res = RunCmdLineProc(LocalDBUtilityPath, "SqlLocalDB", " " + "create" + " " + localdbInstanceName);
  8.  
  9.  
  10. public static string RunCmdLineProc(string sWrkDir, string sExe, string sArgs)
  11. {
  12. try
  13. {
  14. string res = "..empty...";
  15. myLogger.LoggerInstance.sw.Write("n In RunCmdLineProc method..params:" + sWrkDir + " " + sExe + " " + sArgs);
  16. ProcessStartInfo procStartInfo = new System.Diagnostics.ProcessStartInfo();
  17. myLogger.LoggerInstance.sw.Write("n1 " + res);
  18. procStartInfo.FileName = sExe;
  19. procStartInfo.WorkingDirectory = sWrkDir;
  20. procStartInfo.Arguments = sArgs;
  21. procStartInfo.RedirectStandardOutput = true;
  22. procStartInfo.UseShellExecute = false;
  23. procStartInfo.CreateNoWindow = false;
  24. //procStartInfo.Verb = "runas";
  25. procStartInfo.UserName = "admin";
  26. System.Security.SecureString pw = new System.Security.SecureString();
  27. pw.AppendChar('');
  28. pw.AppendChar('');
  29. pw.AppendChar('');
  30. pw.AppendChar('');
  31. pw.AppendChar('');
  32. pw.AppendChar('');
  33. pw.AppendChar('');
  34. pw.AppendChar('');
  35. pw.AppendChar('');
  36. procStartInfo.Password = pw;
  37. //procStartInfo.Verb = "runas";
  38. //procStartInfo.RedirectStandardError = true;
  39. procStartInfo.ErrorDialog = true;
  40. Process proc = new System.Diagnostics.Process();
  41. proc.StartInfo = procStartInfo;
  42. myLogger.LoggerInstance.sw.Write("n2 " + res);
  43. proc.Start();
  44. myLogger.LoggerInstance.sw.Write("n3 " + res);
  45. res = proc.StandardOutput.ReadToEnd();
  46. myLogger.LoggerInstance.sw.Write("n4** " + res);
  47. proc.Close();
  48. proc.Dispose();
  49. myLogger.LoggerInstance.sw.Write("n5 " + res);
  50. return res;
  51. }
  52. catch (SystemException ex)
  53. {
  54. //ex = new Exception(ex.Source.ToString(), ex.InnerException);
  55. myLogger.LoggerInstance.sw.Write("n6 " + ex);
  56. //myLogger.LoggerInstance.sw.Close();
  57.  
  58. throw ex;
  59. }
  60.  
  61. finally
  62. {
  63. myLogger.LoggerInstance.sw.Write("");
  64. }
  65. }
Add Comment
Please, Sign In to add comment