Client Upgrde

  • I need to upgrade SQL 2008 client to SQL 2016.

    How to do it?? do I need to uninstall SQL 2008?

  • Nita Reddy - Wednesday, May 3, 2017 1:05 PM

    I need to upgrade SQL 2008 client to SQL 2016.

    How to do it?? do I need to uninstall SQL 2008?

    Do you mean SSMS?
    If not, what do you mean?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • by client do you mean just the native client libraries, or actual client tools like Management Studio, SQLCMD, etc.?  In general, you can have multiple versions of the client libraries and of the client tools on the same machine.  I have 3 different versions of each on my computer and there are no problems.

    You can get information about native client here:
    https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client
    For SQL Server 2016 and newer, Management Studio is a separately installed program, you can find out more here:
    https://docs.microsoft.com/en-us/sql/ssms/previous-sql-server-management-studio-releases

  • Phil Parkin - Wednesday, May 3, 2017 1:43 PM

    Nita Reddy - Wednesday, May 3, 2017 1:05 PM

    I need to upgrade SQL 2008 client to SQL 2016.

    How to do it?? do I need to uninstall SQL 2008?

    Do you mean SSMS?
    If not, what do you mean?

    Yes SSMS SQL 2016, I download the SSMS but I cannot

  • Nita Reddy - Wednesday, May 3, 2017 2:16 PM

    Yes SSMS SQL 2016, I download the SSMS but I cannot

    Cannot install? What error are you getting?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Phil Parkin - Wednesday, May 3, 2017 2:27 PM

    Nita Reddy - Wednesday, May 3, 2017 2:16 PM

    Yes SSMS SQL 2016, I download the SSMS but I cannot

    Cannot install? What error are you getting?

    Noting is coming when I execute.

  • Nita Reddy - Wednesday, May 3, 2017 2:39 PM

    Noting is coming when I execute.

    Execute what? Please try to provide a detailed explanation of what is happening.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I downloaded SSMS 2016 from Microsoft website. I executed SSMS 2016 exe file but it does not install neither it gives any messages or generates any error.

  • Are you running it as an administrator?

    Thanks

  • NorthernSoul - Thursday, May 4, 2017 6:20 AM

    Are you running it as an administrator?

    Thanks

    Yes I am admin on the server

  • Nita Reddy - Thursday, May 4, 2017 7:07 AM

    NorthernSoul - Thursday, May 4, 2017 6:20 AM

    Are you running it as an administrator?

    Thanks

    Yes I am admin on the server

    Right click on the executable and then click in the pop up Run as Administrator.

  • We run McAfee AV and must disable it to install SSMS 2016 (along with run as admin for the install).

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply