locked
SQL Server 2008 Express and GoDaddy RRS feed

  • Question

  • I have been using SSMS 2008 Express to Log into my DB at GoDaddy for a little while.  Just this past week it stopped working and I had to use the GoDaddy login controls, which are VERY clunky, to say the least.  I know the Server name, Login, and Password are all correct in SSMS because I used the very same credentials to log into GoDaddy and that worked just fine.  When I use these credentials to log into GoDaddy using SSMS, I see Databases (with a + next to it); I expand this and see only ‘System Database’ and ‘Database Snapshots’.  Before the weirdness started, I would Login using my credentials, and I would see several hundred databases, but of course I only had access to my own database (based on credentials).  So anyway, I wanted to use my suave and sophisticated method (SSMS) of logging into GoDaddy, btu all of a sudden it is not working anymore.  Does anyone have any idea why this may be???

     

    Thanks!

    Thursday, August 12, 2010 3:17 AM

Answers

All replies

  • Hello,

    I suggest to ask the support / helpdesk of GoDaddy, because this problem isn't really related to SSMS / MS SQL Server.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    • Proposed as answer by Tom Li - MSFT Friday, August 13, 2010 6:04 AM
    Thursday, August 12, 2010 5:47 AM
  • Thaks, but I thought it was a SQL Server thing.  I logged into GoDaddy last night without a problem, but their system is slow, feeble, and clunky at best.  They certainly are cheap though!!  I like using SQL Server to do my work at GoDaddy b/c SQL Server is fast, intuitive, and quite powerful.  That's my 2-cents.  So, any other ideas as to what could be preventing this from working?

    Thanks everyone!!

    Thursday, August 12, 2010 1:55 PM
  • Chances are they have some level of programmatic right elevation when you use their interface.
    As Olaf stated, you do need to address this with the helpdesk at GoDaddy, so:

    1) They can look at any potential issue that is preventing you from seeing the databases you own

    2) give you the appropriate procedure to achieve a, not only successful logon, but have rights to the db you need.

    Below are some of the docs from GoDaddy:

    http://help.godaddy.com/article/36

    http://help.godaddy.com/article/4977

    http://stackoverflow.com/questions/2859583/problem-with-connection-to-ms-sql-server-database-using-ssms


    Enrique Lima Solutions Architect | Apparatus, Inc. | http://geekswithblogs.com/enriquelima
    • Marked as answer by ryguy72 Saturday, August 14, 2010 6:22 AM
    Thursday, August 12, 2010 2:15 PM
  • Thanks Enrique!!  This was the solution:

    1. Open SSMS
    2. Connect to the Database with Godaddy
    3. Open "Object Explorer Details"
    4. Click on Database
    5. Right-Click on any column name heading
    6. Un-check collation column
    Saturday, August 14, 2010 6:22 AM