Post reply

Using SSMS to connect to 2008

  • December 18, 2018 at 10:03 am

    #376661

    I am using newest version of SSMS I can connect to a 2008 server but I am unable to connect to IIS of the 2008. Is this even possible? If yes what do I need to do to configure it

  • December 18, 2018 at 10:21 am

    #2016692

    You can't use SSMS to connect and manage IIS, You need something called IIS Manager for that. If you are referring to SSIS, I would not use SSMS 17.9.1 to connect to SSIS 2008. BTW, if its SSIS, what error message are you receiving?

  • December 18, 2018 at 10:27 am

    #2016696

  • December 18, 2018 at 11:10 am

    #2016704

    to connect to integration services you need a SSMS associated with that particular version of Integration services - this is a known issue with SSMS

    although there are some workarounds for some versions (google) it still does not work for all versions from what I could see.

  • December 18, 2018 at 11:13 am

    #2016706

    Thanks I was afraid of that. Would that go for visual studio also

  • December 18, 2018 at 11:18 am

    #2016707

    You can open a New Query window on just about any version of SQL Server from the latest Management Studio.  I say "just about" because I can't test it on anything older that 2005 at the moment, but I had no problem with SQL 2000 queries the last time I needed it.  The query window just needs to open a connection to the SQL server, send queries, and display the results.

    The Object Browser window, including connections to SSIS/SSRS/SSAS/Azure, is much more version-sensitive.  It is much more complex than the query window and uses a lot of .Net code to make magic GUI windows appear for you.  SSIS in particular had a lot of changes between 2008 and 2012.  You also will have issues trying to update maintenance plans on older servers.

    Either you can maintain multiple versions of Management Studio on your own computer, or use Remote Desktop to connect to the server you want to administer to be confident that the Management Studio version will be compatible.

  • December 18, 2018 at 11:23 am

    #2016709

    For Visual Studio, you can set the .Net framework version to different levels to get different versions of the SMO libraries.  Assuming you are trying to use the SMO object model.

    If your programs just use SQL connection, command, and datareader objects you probably don't need to worry about the version.

  • December 18, 2018 at 11:27 am

    #2016710

    Thank you for all the help this was very useful

Viewing 8 posts - 1 through 7 (of 7 total)

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