Administering SQL 2005 databases

Discussion in 'H-Sphere Reseller Hosting' started by zonefx, Jan 1, 2008.

  1. zonefx

    zonefx Guppy

    I'm trying to access my SQL 2005 database on MSQL10 but couldn't see it using MS SQL Management sudio. I've found a few threads that mention EMS Sql Manager Studio. I downloaded a copy and ity works fine however I only get a 30 day trial. I don't want to pay $750 to licence it, so my questions!!

    1. Is it possible to access SQL 2005 databases on MSSQL10 through a local copy of MS SQL Management Studio...... or MS SQL Server Management Studio Express?
    2. Is there a Free "Lite" version of EMS SQL Manager? And if so, does anyone have a link?

    Thanks loads..............
  2. Pratik

    Pratik SkyWalker Staff Member

    For MSSQL management studio you are not able to view the database since we have revoked the permission for that. However you can use MSSQL Lite version available at
    http:// www. snapfiles. com /get / emsmssqllite.html

    and use it. [ Remove the Spaces ]
  3. zero

    zero Perch

    The database to connect to can be specified through command line options:

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE>sqlwb.exe -S [DB Hostname] -d [DB Name] -U [User Name] -P [Password]

    This will connect SQL Management Studio to the specific DB, but not connect the Object Explorer (on the left side of the UI for Management Studio). Attempts to connect the object explorer result in the DB not being visible in the databases list, even after setting executing the sp_defaultdb correctly.

    I would love to find a way for us to use SQL Management Studio if possible. It's a much better tool than the EMS version (IMHO).

    Anyone have any other suggestions?


    thanks,
    .brit
  4. antic

    antic Perch

    Am I to understand than we cannot connect to an MS SQL 2005 database on Jodo's servers using the Microsoft SQL 2005 Management Studio program?

    Am I the only one to be ever so slightly boggled by this? What's the reason?
  5. Pratik

    Pratik SkyWalker Staff Member

    If you see closely at your Management studio after you have given user name and password to connect to mssql2005 you will see that you not see the database but still you will be connected to it.

    This is because by default the database view is blocked. You can use mssql lite and that will allow you to specify the database you need to connect and then you can see that.
    http: // www. snapfiles. com / get / emsmssqllite.html [ Remove the Space ]
  6. antic

    antic Perch

    Ah, I misunderstood. It's just the default view which is blocked, not the actual connection. Sorry about that. :)
  7. cdog

    cdog Perch

    You can also set the database name by clicking the options button at the login screen and choosing the connection properties tab when in management studio Also found I could view the databae objects when in visual studio 2005 for those that have it
  8. hafa

    hafa Perch

    The entire object explorer view of the database is blocked, regardless of login parameters. The only workaround I've found is to set up a single user as "DB admin", submit a ticket to have that one user be given permissions to view the object explorer and then use that one user to create all databases for all projects with explicit permissions.

    Of course, this only works if you're the developer. For those hosting for other developers, you're basically out of luck unless you want to use the "lite" tools...

    It's a shame MS hosed this one so thoroughly...
  9. antic

    antic Perch

    lol.. I was just researching this issue, typed in sql management studio "database view" blocked in google, and the first item is this very thread. Useful. :)
  10. Stephen

    Stephen US Operations Staff Member

    :D google likes.
  11. SALvation

    SALvation Perch

    Is there anyway we can use Management Studio or Enterprise Manager to manage our databases? I really don't like the fact I have to have my developers get used to another SQL tool. Is there another plan we should pick or can we specifiy what server we are on? To me this is a big enough issue to find a new reseller.
  12. zero

    zero Perch

    I don't think I would go as far as to go elsewhere. Jodo has been great to me for years now, but I would be very interested in finding some solution to this issue. M$ SQL Management Studio is an integral piece of the Microsoft development toolset. The EMS product is good for a free product, but that's where I draw the line.

    Are there ANY other options for enabling access through M$ SQL Management Studio?
  13. antic

    antic Perch

    uh, I gathered that you can use Management Studio, but you just have to tweak it to look for your specific database. It's the database view which is blocked, which just means you don't get to see everyone's databases on that server.

    Correct me if I'm wrong but that's what I gathered from the previous posts. Haven't tried it yet myself.
  14. zero

    zero Perch

    The only thing I've been able to get working in Eng Mgr is a query window. The things that I use most like Data Import, Export, new tables, etc. are not available due to not seeing the database listed in the left hand column.
  15. antic

    antic Perch

    ah.. that would be a problem then.

    Stephen/Pratik, why is this?
  16. Stephen

    Stephen US Operations Staff Member

    It is due to the database view, that is ALL we have turned off from public.
  17. zero

    zero Perch

    So, that alone is causing the no access through Enterprise Manager?

    You would think that M$ would have a way around this.
  18. david3rd

    david3rd Perch

    I'm still confused....

    Is there a way to use MS SQL Server Mgmt Studio Express or not? I know the view is disabled... but can we still use it for creating tables, queries and so forth?

    I personally can't stand the EMS tool.

    If it is impossible to use the MS tool, is it possible to get a dedicated database server that all my plans use?

    [update] And so far every time I've sent a ticket Jodo has made it so I can see the databases and use the MS tool. I had it done twice today, but then the third time was told it was disabled. But I can still use the MS tool on all my other databases. I'm just confused. :)[/update]
  19. zero

    zero Perch

    I agree. The EMS tool is not a full featured as SQL Mgt. Studio. Using EMS is not an option. Changing hosts is an option.

    Other than this issue, Jodo is the best host I've ever used. I've been with them for five years or so, but if they don't figure out how to fix this issue I will go somewhere else for new accounts.

    I find it hard to believe that Microsoft has a security hole that doesn't all for safe use of their own database management software.

    I have several sites at other hosts and none of them disable access to the DB's through SQL Mgt. Studio.


    .b
  20. antic

    antic Perch

    Well, I can connect to an SQL 2000 server with SQL Mgmt Studio 2005 and see all the DBs, and have access to the Import and Export tasks from the context menu.

    Haven't tried it on an actual SQL2005 server, though.

    Attached Files:

    • dbs.gif
      dbs.gif
      File size:
      6.5 KB
      Views:
      68

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services