Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

Help : Get-AzureVM – WARNING: No deployment found in service: ‘domainctrler’.

Posted by blakhani on July 9, 2015

As a part of my role, I also assist customers in getting their issue fixed on Microsoft Azure environment as well. Sometime to reproduce the error, I also need to create replica of their environment. In one of such deployment, while create domain controller, one of the step was to set static internal IP for domain controller. Here is the command which I ran.

PS C:\> Get-AzureVM -ServiceName domainctrler -Name MyAzureDC1 | Set-AzureStaticVNetIP -IPAddress | Update-AzureVM

and I was welcomed with below message.

WARNING: No deployment found in service: ‘domainctrler’.


While researching, I realized that I recently added another subscription to my account and now I have two subscriptions associated with my login. You can confirm that using below command

Get-AzureSubscription | Select SubscriptionName


To switch to a different subscription, I used

Select-AzureSubscription -SubscriptionName "Your-Desired-Subscription-Name-Here"

… and after that whole world was so beautiful because I was able to execute the command which I needed. To avoid this in future, I have changed my login default to the one which I would be using frequently.

Select-AzureSubscription -SubscriptionName "Your-Default-Subscription-Name-Here" –default

In summary, if you have multiple subscription then you might face the error. You can either switch “current” subscription or set most used one as “default” using Set-AzureSubscription command.

  • Cheers,
  • Balmukund Lakhani
  • Twitter @blakhani
  • Author: SQL Server 2012 AlwaysOnPaperback, Kindle
  • Advertisements

    Posted in Microsoft Azure, PowerShell | Tagged: , | 5 Comments »

    Tips and Tricks – Hide Server Manager Dashboard on Startup

    Posted by blakhani on July 7, 2015

    Whenever I login at any server, I see below screen and I don’t like seeing it every time.


    Like me, you might not want Server Manager to automatically be displayed after each logon. I found that there are various options to disable this behavior.

    • Disable it via server manager:  If it’s not needed for many server then we can do it directly via Server Manager itself. On Server Manager console, choose Manage and then click “Server Manager Properties”.


    Over there, there is a checkbox “Do not start Server Manager automatically at logon“.

    Check the tick mark and Click OK.

    I work in troubleshooting issues and try to find what happens when the box is checked. So I captured Process Monitor and noted all registry access done by ServerManager.exe and found below


    Here are the keys which are used by Server Manager.

    DoNotOpenServerManagerAtLogon under HKEY_CURRENT_USER\Software\Microsoft\ServerManager

    DoNotOpenServerManagerAtLogon under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ServerManager

    When I check the box and hit OK, it is set by “RegSetValue” under Current User. If you are a scripting guy then you can also run below on command prompt to add registry value for your login.

    Reg Add "HKEY_CURRENT_USER\Software\Microsoft\ServerManager" /V "DoNotOpenServerManagerAtLogon" /D 1 /T REG_DWORD /F


    • Disable it via Task Scheduler:  Another method to not to launch Server Manager dashboard is using task scheduler. We can do this by launching the “Task Scheduler” on the local machine. In the Task Scheduler console (On the right hand side) navigate to Task Scheduler library > Microsoft > Windows > Server Manager. Now choose “ServerManager” task, right click and click on Disable.


    Same thing can be done via command line as ‘

    schtasks.exe /change /tn "Microsoft\Windows\Server Manager\ServerManager" /disable

    • Disable it via Global Policy (GPEDIT):  If you are a domain admin and want to apply policy then you can use gpedit.msc. Once opened, navigate to “Computer Configuration”, > Administrative Templates > System > Server Manager. Under setting look for “Do not display Server Manager automatically at logon”, right click and choose Enabled.


    Hope this helps

    Posted in Server Manager Dashboard | Tagged: , , | 4 Comments »

    Solution – Unable to install SQL Server 2008 on Windows Server 2012 Server – Error – The service did not respond to the start or control request in a timely fashion

    Posted by blakhani on June 10, 2015

    Recently I was trying to do some test with old version of SQL and ran into interesting issue. I ran the setup of SQL Server 2008 RTM on Windows Server 2012. It failed with error

    The service did not respond to the start or control request in a timely fashion

    The error means that SQL Setup was unable to start the SQL Server service in middle of the installation. I had no choice but  to cancel the installation. Here are the messages logged in various setup logs. here is the snip from Summary.txt

    Overall summary:

      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

      Exit code (Decimal):           -595541211

      Exit facility code:            1152

      Exit error code:               49957

      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

      Start time:                    2015-05-08 21:26:19

      End time:                      2015-05-08 21:37:05

      Requested action:              Install

      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150508_212400\Detail.txt

    Detailed results:

      Feature:                       Database Engine Services

      Status:                        Failed: see logs for details

      MSI status:                    Passed

      Configuration status:          Failed: see details below

      Configuration error code:      0xDC80C325

      Configuration error description: The service did not respond to the start or control request in a timely fashion. 

      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150508_212400\Detail.txt

    I love the error message in summary as it tells me what exactly need to be done. Investigate, correct the cause, uninstall SQL and re-run setup. Perfect! So let’s investigate. Detail.txt had nothing interesting than telling that I am not able to start SQL Service. Since SQL service was present after cancelling the setup, I tried to start manually but it was same error via services.msc. So I tried to start SQL Server executable via command prompt by running sqlserver.exe –c –sMSQLSERVER command and it gave me below popup message.

    Problem signature:

      Problem Event Name:         BEX64

      Application Name:           sqlservr.exe

      Application Version:        2009.100.1600.1

      Application Timestamp:      4bb6b40b

      Fault Module Name:          StackHash_120f

      Fault Module Version:

      Fault Module Timestamp:     00000000

      Exception Offset:           PCH_EF_FROM_ntdll+0x000000000009177A

      Exception Code:             c0000005

      Exception Data:             0000000000000008

      OS Version:                 6.3.9600.

      Locale ID:         1033

      Additional Information 1:         120f

      Additional Information 2:         120feecb532e5330843bb85768dc5d8d

      Additional Information 3:         86ef

      Additional Information 4:         86ef44a294d70f6087e5d1fcc74465eb


    Read our privacy statement online:


    If the online privacy statement is not available, please read our privacy statement offline:


    The code highlighted above is Access Violation hex code. I did some more search and found below KB (How to use SQL Server in Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2)


    So, now I know that my issue is that RTM version of SQL Server 2008 is not supported on Windows Server 2012 and I have to do slipstreaming of media so that SP2 is installed along with RTM.

    I Slipstreamed media using Peter’s blog

    After making media ready, I uninstalled SQL, restarted machine and used the slipstream media. This time I was able to install SQL without any error.

    Hope this helps.

  • Cheers,
  • Balmukund Lakhani
  • Twitter @blakhani
  • Posted in Installation, Setup, SQL Server, SQL Server 2008 | Tagged: , , | 2 Comments »