{"id":72043,"name":null,"username":"jpveen","avatar_template":"/user_avatar/support.jodohost.com/jpveen/{size}/55_2.png","created_at":"2011-09-07T20:19:59.000Z","cooked":"\u003cp\u003eHi,\u003cbr\u003e\nI work with EMS at Jodo infra also. (I use EMC 3.6.0.1 free lite version)\u003cbr\u003e\nMaybe this can help you.\u003c/p\u003e\n\u003cp\u003eSteps to follow to connect to database:\u003c/p\u003e\n\u003col\u003e\n\u003cli\u003efind out the good db server connection string. If you are on cluster1 (my h sphere.biz) at mssql3 the correct string is:  mssqlmgr.go \u003ca href=\"http://hsphere.com\" rel=\"noopener nofollow ugc\"\u003ehsphere.com\u003c/a\u003e,5203\u003c/li\u003e\n\u003cli\u003estart EMS and click register database.\u003c/li\u003e\n\u003cli\u003efill in database server name:  mssqlmgr.go \u003ca href=\"http://hsphere.com\" rel=\"noopener nofollow ugc\"\u003ehsphere.com\u003c/a\u003e,5203 (without space)\u003c/li\u003e\n\u003cli\u003eChoose the standard MSSQL authentication and provide user \u0026amp; pass\u003c/li\u003e\n\u003cli\u003eProvide the exact database name. Using the drop down menu can take a while if you are on long distance from Texas, USA. Be patient, after clicking drop down button, I have seen 200sec waiting time… Using drop down does not work on all DB servers, depending on security level on the server. In that case type the exact DB name\u003c/li\u003e\n\u003cli\u003eClick finish and you are all set! You can start connecting to the db and browse the tables. Also here be aware that remote long distance connections are not very efficient for SQL server, so be patient after clicking…\u003c/li\u003e\n\u003c/ol\u003e\n\u003cp\u003eHope this helps you.\u003c/p\u003e\n\u003cp\u003eBest regards,\u003cbr\u003e\nJan-Pieter\u003c/p\u003e","post_number":32,"post_type":1,"posts_count":32,"updated_at":"2026-08-03T06:39:31.166Z","reply_count":0,"reply_to_post_number":null,"quote_count":0,"incoming_link_count":0,"reads":0,"readers_count":0,"score":0.0,"yours":false,"topic_id":13465,"topic_slug":"ms-sql-manager-error","display_username":null,"primary_group_name":null,"flair_name":null,"flair_url":null,"flair_bg_color":null,"flair_color":null,"flair_group_id":null,"badges_granted":[],"version":1,"can_edit":false,"can_delete":false,"can_recover":false,"can_see_hidden_post":false,"can_wiki":false,"user_title":"European","title_is_group":false,"bookmarked":false,"raw":"Hi,\nI work with EMS at Jodo infra also. (I use EMC 3.6.0.1 free lite version)\nMaybe this can help you.\n\nSteps to follow to connect to database:\n\n1. find out the good db server connection string. If you are on cluster1 (my h sphere.biz) at mssql3 the correct string is:  mssqlmgr.go hsphere.com,5203 \n2. start EMS and click register database.\n3. fill in database server name:  mssqlmgr.go hsphere.com,5203 (without space)\n4. Choose the standard MSSQL authentication and provide user \u0026 pass\n5. Provide the exact database name. Using the drop down menu can take a while if you are on long distance from Texas, USA. Be patient, after clicking drop down button, I have seen 200sec waiting time... Using drop down does not work on all DB servers, depending on security level on the server. In that case type the exact DB name\n6. Click finish and you are all set! You can start connecting to the db and browse the tables. Also here be aware that remote long distance connections are not very efficient for SQL server, so be patient after clicking...\n\nHope this helps you.\n\nBest regards,\nJan-Pieter","actions_summary":[],"moderator":false,"admin":false,"staff":false,"user_id":592,"hidden":false,"trust_level":1,"deleted_at":null,"user_deleted":false,"edit_reason":null,"can_view_edit_history":true,"wiki":false,"post_url":"/t/ms-sql-manager-error/13465/32","reactions":[],"current_user_reaction":null,"reaction_users_count":0,"current_user_used_main_reaction":false,"can_accept_answer":false,"can_unaccept_answer":false,"accepted_answer":false,"topic_accepted_answer":null}