search

hedaprakash / Universal-SQL-Installation-Scripts

SQL Server Universal Instalation Scripts
5 stars 8 forks source link

Universal SQL Installation - Error #1

Open kiransqldba opened 6 years ago

kiransqldba commented 6 years ago

Hello Prakash,

I got below error when trying to install SQL2014Dev with following command

.\InstallSQL.ps1 "NT Service\MSSQLSERVER" test@123 test1@3323 SQL2014DevSP1 "WIN-SQL2016\Administrator"

Error:-

**Import-CliXML : Could not find file 'D:\SQLPID.xml'. At D:\Universal-SQL-Installation-Scripts-master\InstallSQL\InstallSQL.ps1:117 char:15

Is that something I am missing in my Command of config file? Thanks in Advance.

-Kiran

hedaprakash commented 6 years ago

Kiran,

Hmm that file has the product key, I need to fix this once I am back from vacation

Meanwhile you can comment this line and pass key directly

~ Prakash

On Sat, Dec 16, 2017 at 9:12 AM kiransqldba notifications@github.com wrote:

Hello Prakash,

I got below error when trying to install SQL2014Dev with following command

.\InstallSQL.ps1 "NT Service\MSSQLSERVER" test@123 test1@3323 SQL2014DevSP1 "WIN-SQL2016\Administrator"

Error:-

**Import-CliXML : Could not find file 'D:\SQLPID.xml'. At D:\Universal-SQL-Installation-Scripts-master\InstallSQL\InstallSQL.ps1:117 char:15

  • $LoadSQLPID = Import-CliXML $SQLPID

  •      ~~~~~~~~~~~~~~~~~~~~~~

  • CategoryInfo : OpenError: (:) [Import-Clixml], FileNotFoundException

    • FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.ImportClixmlCommand**

Is that something I am missing in my Command of config file? Thanks in Advance.

-Kiran

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/hedaprakash/Universal-SQL-Installation-Scripts/issues/1, or mute the thread https://github.com/notifications/unsubscribe-auth/AFh7SWNbTbDTscz3tWwhdMmKt0cgTGRjks5tAzw9gaJpZM4RENop .

kiransqldba commented 6 years ago

Thank you very much Prakash for your quick response.

Enjoy you vacation. Sorry to disturb you in vacation time

I passed key manually and it worked but after got below error,

Granting SeBatchLogonRight to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Granting SeLockMemoryPrivilege to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Granting SeServiceLogonRight to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Write-Error : A positional parameter cannot be found that accepts argument ' '. At D:\Universal-SQL-Installation-Scripts-master\CommonScripts\CommonCodeNew.ps1:205 char:3

Any permission required for NT account Moreover it's my personal computer and if I want to use default Windows NT account then how can I do that without passing account name in Install command?

Thanks in Advance.

kiransqldba commented 6 years ago

Hello Prakash,

Successfully Installed in one of our test server with domain account.

Still have questions about how to install in Cluster Environment?

-Kiran

kiransqldba commented 6 years ago

One more thing is how to define different service account for SQLServerAgent service and Integration Service with passwords?

hedaprakash commented 6 years ago

Kiran,

It does not work with local NT accounts, i did not designed it to be installed on local machines. your local account should work though... pass it as hostname\username

I believe i never tested this on windows 10 as well, mostly designed for servers

~ Prakash

On Sat, Dec 16, 2017 at 10:33 AM, kiransqldba notifications@github.com wrote:

Thank you very much Prakash for your quick response.

Enjoy you vacation. Sorry to disturb you in vacation time

I passed key manually and it worked but after got below error,

Granting SeBatchLogonRight to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Granting SeLockMemoryPrivilege to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Granting SeServiceLogonRight to NT Service\MSSQLSERVER ... failed (GetAccountSid(NT Service\MSSQLSERVER)=1332 Write-Error : A positional parameter cannot be found that accepts argument ' '. At D:\Universal-SQL-Installation-Scripts-master\CommonScripts\CommonCodeNew.ps1:205 char:3

-

   Write-ERROR "Error! while granting rights to sqlstartup accou ...

-

   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • CategoryInfo : InvalidArgument: (:) [Write-Error], ParentContainsErrorRecordException
    • FullyQualifiedErrorId : PositionalParameterNotFound, Microsoft.PowerShell.Commands.WriteErrorCommand

Any permission required for NT account Moreover it's my personal computer and if I want to use default Windows NT account then how can I do that without passing account name in Install command?

Thanks in Advance.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/hedaprakash/Universal-SQL-Installation-Scripts/issues/1#issuecomment-352201844, or mute the thread https://github.com/notifications/unsubscribe-auth/AFh7SetstyFfhr21WIm6jzUcySpETrtKks5tBAzvgaJpZM4RENop .