![]() Sqlcmd -S "(local)" -U "sa" -P "Password12!" -Q "SELECT * FROM information_schema.tables " -d "master" ![]() # Start services Set-Service SQLBrowser -StartupType Manual Set-ItemProperty -Path HKLM:\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo -Name '(local)' -Value "DBMSSOCN, $serverName \ $instanceName " | Out-Null $instanceName = 'SQL2008R2SP2' $smo = '.' $wmi = new-object ( $smo + 'Wmi.ManagedComputer' ) # Enable TCP/IP $uri = $serverName $instanceName $Tcp = $wmi.GetSmoObject ( $uri ) $Tcp.IsEnabled = $true $TCP.alter () # Enable named pipes $uri = $serverName ']/ $instanceName $Np = $wmi.GetSmoObject ( $uri ) $Np.IsEnabled = $true $Np.Alter () # Set Alias New-Item HKLM:\SOFTWARE\Microsoft\MSSQLServer\Client -Name ConnectTo | Out-Null ![]() ![]() To allow all SQL Server instances to be started simultaneously, please run the following script at init stage which will enumerate all currently available instances setting them to use dynamic ports, as the instances available on a build worker may change over time. Therefore please start and stop them sequentially to avoid port conflicts. On the Environment tab of project settings or in appveyor.yml you can configure which services must be started after the build machine has booted.Īlso please note that all MS SQL servers use the same default port 1433.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |