locked
Exam 70-462 Administering Microsoft SQL Server 2012 Databases Training Kit Question RRS feed

  • Question

  • Hi,

    I am normally a fan of the Microsoft Training Kits as they are excellent value for money. However I am really struggling to follow the Practice Setup Instructions in the Introduction Chapter.

    Under the heading "Prepare a Member Server and Join it to the Domain" on page xx when I enter the command 

    Netsh interface ipv4 set dnsservers "Local Area Connection" static 10.10.10.10 primary

    I get the error; - 

    "The configured DNS server is incorrect or does not exist."

    Any help would be greatly appreciated.

    Kind Regards,

    Kieran


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Wednesday, November 5, 2014 10:30 AM

Answers

  • Try unchecking the "Enable Virtual LAN identification" option on both VM's.

    I never have this checked and when I checked it on my DC and SQL VM's, they were no longer able to communicate with each other.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, November 6, 2014 9:21 PM

All replies

  • Did you complete all the steps in "Prepare a Computer to Function as a Windows Server 2008 R2 Domain Controller" and promote the PC named DC as a domain controller? Did you ensure to select the DNS Server option (Step 11).  Did you also complete Step 3 of "Prepare AD DS"?

    I've used this resource in the past and not had any issues.

    If you did all this then try to ping the DC (10.10.10.10) from the member server to see whether there is a coms issue.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Wednesday, November 5, 2014 10:26 PM
  • Hi Jeff,

    Many thanks for replying to my question. I'm pleased that you have used this resource in the past and not had any issues. Maybe I mis-interpreted some of the previous instructions. I did attempt to complete "Prepare a Computer to Function as a Windows Server 2008 R2 Domain Controller" including (step 11) which resulted in the following screen shot; -


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Wednesday, November 5, 2014 10:47 PM
  • I understand that the warning message in the previous screen shot is to be expected by looking at the instructions in step 11.

    If I ping 10.10.10.10 on the DC server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    If I ping 10.10.10.20 on the SQL-A server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    However if I ping 10.10.10.10 (the DC IP address) from the SQL-A server I receive destination host unreachable on all 4 packets. So in summary it looks like the SQL-A server cannot see the Domain Controller. How do I rectify this?

    Thanks in advance,

    Kieran.


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Wednesday, November 5, 2014 10:53 PM
  • Have both the VM's been configured with a private network virtual switch?


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, November 6, 2014 1:28 AM
  • Many thanks again Jeff,

    I have set the virtual machine manager as follows; -


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, November 6, 2014 11:29 AM
  • The Virtual Switch was already set on the DC and SQL-A servers as follows; -

    However I still get the following result; -

    If I ping 10.10.10.10 on the DC server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    If I ping 10.10.10.20 on the SQL-A server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    However if I ping 10.10.10.10 (the DC IP address) from the SQL-A server I receive destination host unreachable on all 4 packets. So in summary it looks like the SQL-A server cannot see the Domain Controller.


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, November 6, 2014 11:33 AM
  • Try unchecking the "Enable Virtual LAN identification" option on both VM's.

    I never have this checked and when I checked it on my DC and SQL VM's, they were no longer able to communicate with each other.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Thursday, November 6, 2014 9:21 PM
  • Many thanks Jeff,

    I have made some progress after following your instructions.


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, November 6, 2014 9:58 PM
  • If I ping 10.10.10.10 on the DC server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    If I ping 10.10.10.20 on the SQL-A server I receive 4 packets sent and 4 packets received, 0% loss as expected.

    If I ping 10.10.10.10 (the DC IP address) from the SQL-A server I receive 4 packets sent and 4 packets received, 0% loss as expected (many thanks)

    If I ping 10.10.10.20 (the SQL-A IP Address) from the DC server I receive request timed out on all 4 packets. Is this to be expected?


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Thursday, November 6, 2014 10:10 PM
  • You should be able to ping SQL-A from the DC. The fact that you can ping the DC from SQL-A means that connectivity is there so not sure what's going on.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Friday, November 7, 2014 1:37 AM
  • I guess this may have something to do with my firewall and / or my host operating system being Windows 8.1 Pro where Hyper V sits. I will continue chipping away at this.


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Friday, November 7, 2014 9:26 AM
  • I use 8.1 Hyper-V as well and don't have these issues.  If it was a firewall issue you wouldn't be able to ping in either direction.

    I'm not a hardware guru so not quit sure what the issue could be.  Only knew to try the other stuff due to my own investigations with setting up VM's.  Maybe try asking a question on the TechNet Directory Services forum.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSA, MCSE: BI
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Sunday, November 9, 2014 2:58 AM
  • Kieran,

    I just finished the 70-462 book and will be taking the exam in a few weeks.  I remember very well my confusion with following the book's directions for setting up the home network, and nearly abandoned the entire plan until I found the YouTube channel "EliTheComputerGuy."  That guy will show you how to set up everything you need for a lab network.

    Note that I never did get Group Policy Management working properly.  Otherwise, I got everything working properly thanks to Eli the Computer Guy.

    -Eric

    Monday, November 10, 2014 11:36 PM
  • Hi Eric,

    Can you give me the actual YouTube link where EliTheComputerGuy shows me how to set up everything I need for my lab network.

    Kind Regards,

    Kieran.


    I am offering free SSRS mentoring in return for Research Participant Feedback!!! Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, November 11, 2014 1:18 PM
  • Absolutely!  He has a whole series of videos that you should see, that I really needed.

    This is the series link: https://www.youtube.com/playlist?list=PLJcaPjxegjBVnEN8c6O8w1mNit4WGeAWN  But he has many other videos I needed to watch before I could get the network and domain up and running, and they're not part of the series.  Watch the related video links on the right.

    I wasted a lot of time by not having a new router to add to my home network before I started.  Eventually I figured out that I needed a router to separate the networks so I could enable DHCP and DNS on my domain controller without screwing up my existing home wireless network. 

    Darn those authors for making me think it would be simple!  It's a good thing I studied for the Net+ certification or I would have been fairly lost.

    Good luck, Kieran, this took me about 3 weeks to set up.  I'm glad I did it, but it's certainly not required to have all those VM's just to practice the book.  But I haven't passed yet, so we'll see.  I did learn a heckuva lot, though.

    -Eric B.

    Tuesday, November 11, 2014 4:14 PM