locked
SQL Server install causes smart screen prompt, reboot and network access to stop on Any windows 10 machine RRS feed

  • Question

  • HI all im wondering if we can come together and try to sort this issue out,

    We have multiple desktops all running win10 pro latest versions etc. when developers are installing sql server on the local machine it crashes half way through and causes a smart screen prompt to say the machine will reboot and then the machine is just stuck on the login screen and fails to let anyone log in, Locally or domain account.

    it removes the domain section and local accounts fail to login. (credentials are not the issue)

    this has been replicated with both with windows 10 machines that have been imaged from scratch and also ones that have been upgraded.

    on some of the machines you get "RPC Server is unavailable" not all of them though, all with same symptoms.

    they are all running version 1511 OSbuild 10586.545

    on a side note i dont know if its all after the anniversary update, this may just be a coincidence.

    thanks and i shall wait egerly for your replies :)

    Friday, August 19, 2016 3:53 PM

Answers

  • Are the machines in a domain? If so any group policies applied that maybe relevant? Can they be checked by an OU with blocked inheritance for the computer and user see if that makes a difference?

    What options are being selected to install SQL? They are lots of options during install. What Features are selected? What paths are selected for the database temp files and logs? I have seen issue with installs if the paths for the database temp files or logs are set to the root of drive (due to the way SQL install locks the install folder permissions)

    Tuesday, August 23, 2016 11:16 AM

All replies

  • 10586.586 is the latest update for TH2 the November release, 14393 \ 1607 is the Anniversary release for information.

    Installed SQL 2014 default options and services ok on Windows 10 10586.545. So what version \ install options are you trying to install of SQL? what components and install path for databases?

    What third party software do you have installed? Anti-Virus \ Security software etc?

    Does the install work with a clean boot ?

    Friday, August 19, 2016 8:45 PM
  • Hi,

    Please check it meets the requirement for install SQL Server, Then follow Mr Happy's suggestion to install again in clean boot environment to have a try.
    Hardware and Software Requirements for Installing SQL Server 2016
    https://msdn.microsoft.com/en-sg/library/ms143506.aspx?f=255&MSPPError=-2147217396
    Hardware and Software Requirements for Installing SQL Server 2014
    https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx

    As this issue is mainly caused by installing SQL Server, you could also contact our SQL Server forum for help. They are the best resource to troubleshoot this issue.
    https://social.technet.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    Best regards


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, August 22, 2016 6:18 AM
  • Hi guys thanks for the reply. apologies in the delay getting back to you both. This was a freash clean full install of windows with the build listed in the first post "version 1511 OSbuild 10586.545"

    and just either installing sql server 2012 or 2014 litterally bricked the machine DURING the installation, so its nothing that can be setup within sql after or before. and again no 3rd party apps were even on the machine. just the OS.

    i have yet to try this with the anniversary update.

    Any other known instances of this or related instances ?

    again this is for 10 computers now in an enterprise environment

    Tuesday, August 23, 2016 10:26 AM
  • Are the machines in a domain? If so any group policies applied that maybe relevant? Can they be checked by an OU with blocked inheritance for the computer and user see if that makes a difference?

    What options are being selected to install SQL? They are lots of options during install. What Features are selected? What paths are selected for the database temp files and logs? I have seen issue with installs if the paths for the database temp files or logs are set to the root of drive (due to the way SQL install locks the install folder permissions)

    Tuesday, August 23, 2016 11:16 AM