Announcement Announcement Module
Collapse

myhosting.com Forum Guidelines

Welcome to the myhosting.com Forums! The purpose of this forum is to allow you to discuss topics relating to hosting and topics of interest with other myhosting.com Customers. The primary focus should relate to issues not generally included in our Wiki or Control Panel, or information not provided by our Customer Support Team. Some examples include programming and coding support, web site design ideas and SEO practices.

The forum is not meant as a replacement to our Wiki or Customer Support. We highly recommend searching our Wiki before posting on the forum. Also, if you have a question for our Customer Support team, please contact them as you would normally.

We ask that if you have any complaints or questions relating specifically to your account, that you address them to our Customer Support department. Do not post personal account information such as passwords or other sensitive and private information the forum, as this type of information is best kept secret. Also, please be respectful of other users and refrain from defamatory comments or use of coarse language.

We will visit the forum from time to time, and contribute to various topics. We reserve the right to delete any posts which are deemed offensive or against the spirit of the forum. Any spamming or illegal activity will not be tolerated. We also reserve the right to block any user who violates these guidelines.

To get started, we welcome you to sign up at our User Management site. Any account created there will have access to these forums, our Wiki, our Ideas site and commenting permission on our Status Blog.
See more
See less
Connect to SQL Server 2008 w/ Mngmt Studio Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Connect to SQL Server 2008 w/ Mngmt Studio

    Hello,

    I am trying to connect to my database using SQL Server 2008 Management Studio. When I log on successfully and click on databases I get the error:

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
    - An exception occurred while ececuting a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    - Invalid object name 'msdb.dbo.syspolicy_configuration'. (Microsoft SQL Server, error: 208)


    I can connect to the database on my development server both locally and from another machine, connecting to the remote 2008 myhosting db causes this error.

    any help is much appreciated,

    Thanks

  • #2
    Re: Connect to SQL Server 2008 w/ Mngmt Studio

    I have the exact same problem...

    Anyone out there that can answer this? Using the crippled web interface is really inconvenient.

    Comment


    • #3
      Re: Connect to SQL Server 2008 w/ Mngmt Studio

      Let us look into this issue and get back to you ASAP. Thank you,

      Comment


      • #4
        Re: Connect to SQL Server 2008 w/ Mngmt Studio

        Our operations team has looked into the problem you are having and they are thinking it could be related to the version of SQL Management Studio you are using to connect to the DB. Microsoft released RC0 last week, but we have not upgraded as of yet. We are planning to do this next week and are awaiting upgrade installation documentation from the GoLive team

        Alternatively the problem could be with the your DB, we would require your DB name to further troubleshoot this problem. If you would like to continue this investigation please send an email to support@myhosting.com with a description of the problem and your domain name and database name. We'll be able to troubleshoot further with that information.

        Regards,

        Daryl Brown
        Manager Customer Support
        http://myhosting.com
        http://mail2web.com
        http://softcom.biz

        Comment


        • #5
          Re: Connect to SQL Server 2008 w/ Mngmt Studio

          Eman and Underated,

          Do you still have the same problem. Did our response solve your problem? Please let us know.

          Thank you,

          Comment


          • #6
            Re: Connect to SQL Server 2008 w/ Mngmt Studio

            I get the same message, but I'm not sure if the problem is the same.

            I was using SQL server 2005 EE and everything was fine. Now I moved to 2008 EE version and I also expierience no problems.

            Although when I try to view databeses in my User Instance I get this message:

            TITLE: Microsoft SQL Server Management Studio
            ------------------------------

            Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

            For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476

            ------------------------------
            ADDITIONAL INFORMATION:

            An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

            ------------------------------

            Invalid object name 'msdb.dbo.syspolicy_configuration'. (Microsoft SQL Server, Error: 208)

            For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476
            What I'm doing is:
            - run user instance with SSEUtil
            - I'm connecting to it by using management studio 2008 ee
            - I try to expand databases
            - I get the message above.

            I can connect to UI but I can't see any db there. What should I do?

            Comment


            • #7
              Re: Connect to SQL Server 2008 w/ Mngmt Studio

              Hi Magnat,

              What version of SSMS are you using? You can find this out by running SSMS, then going to the menu and choose "Help" then "About". If you can provide me with this information it should help to troubleshoot the problem you're having.

              Regards,

              Daryl Brown
              Key Accounts Manager
              http://myhosting.com
              http://mail2web.com
              http://softcom.biz

              Comment

              Working...
              X