Administering SQL 2005 databases

zero said:
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
Click to expand...

Sorry but we won't be changing the view permissions, MS can make their software more shared friendly and we'll love it but until then, we can't do it.

Or Hsphere could make the dbo user the official database owner and it would work, but they won't and want hsphere user to be the owner, it is something that can't be edited or hsphere will break, and MSSQL itself gives a conflict error if we try to change it manually(and then again hsphere would throw error if we changed it, but I have tried such workaround anyway)
 
Yikes!

Are there any other options? The EMS tool is simply not usable. Can a dedicated DB server, or even a VPS running SQL 2005 Express be used as a substitute?

I do almost all the development for my hosting clients, so I don't really care if I can't use the DB setup in Hsphere. So maybe something like a dedicated or VPS would work? What would be the pros/cons of doing something like that?
 
Well, this seems to be a BIG HURDLE for the clients and they are already pointing out other hosts Supporting this.

Jodo needs to do something on this

Indian
 
Indian, many other hosts block access to mssql in total, and with the abuses I have bee seeing growing it is an attractive thing to do no doubt.

There won't be any change on this regard.
 
Stephen said:
Indian, many other hosts block access to mssql in total, and with the abuses I have bee seeing growing it is an attractive thing to do no doubt.

There won't be any change on this regard.
Click to expand...

As in no more MSSQL? I hope and pray that Jodohost does not take this drastic step, as that would spell disaster for us...
 
hafa said:
As in no more MSSQL? I hope and pray that Jodohost does not take this drastic step, as that would spell disaster for us...
Click to expand...

NOOO not at all, external DB access only is what I am talking about, and we won't even take that step :)
 
I don't understand. Why can't seperate instances (1 per account) be setup? Then we can access all of the databases in the database view. This would also prevent any issues with someone crashing their instance bringing all databases down.

That would seem like a much safer and secure route. Is this not possible with H-Sphere and whatever other software that manages SQL stuff?

To be honest, I would prefer to have database access internal only in addition to 1 instance per Jodo account (which would break everyone's hopes and dreams in this thread). So the only way to connect to a database would be via an internal address within Jodo's network (i.e. a private class A, B or C address (10.*, 172.16.*-172.31.*, 192.168.*)). This is doable if you install Express onto your VPS but beyond that I'm not so sure. I've always had the idea that databases should not be exposed to the outside world directly and I believe it's a security requirement for certain types of businesses (by law).
 
Hello,

Separate instances would require insanely expensive plans as it uses so much RAM and license costs.
 
Stephen said:
Hello,

Separate instances would require insanely expensive plans as it uses so much RAM and license costs.
Click to expand...
Hmm that makes sense. You'd think there was some sort of middle ground though.

Anyway, as said before you can easily use SQL Management Studio as long as you specify the database name so I don't think this is a huge deal anyway.
 
Another problem is that EMS does not support Unicode characters, so it is impossible to change some values from there...
 
You know, I'm visual guy and I do not want to guess table and column names, which I have to do if I do not see them in object explorer...
 
papaja said:
You know, I'm visual guy and I do not want to guess table and column names, which I have to do if I do not see them in object explorer...
Click to expand...
Why would you have to guess? They're not documented or at least scripted out?

I can understand wanting a visual representation though. If you have Visual Studio you can setup a database connection and view everything correctly. The free versions of Visual Studio (Express) might work as well.
 
KrisSiegel said:
Anyway, as said before you can easily use SQL Management Studio as long as you specify the database name so I don't think this is a huge deal anyway.
Click to expand...
Please describe the process to "specify the database name".

Also, when you say "use" are you referring to using the full functionality of SQL Management Studio (including the explorer) or are you just saying you can use it to execute SQL scripts? If it's the later, please don't bother explaining how to specify the DB name.

I can execute scripts with a command line tool. The reason SQL Management Studio is such a good tool is because of the visual aid it gives us amateur DBA's. Without the visual aid, it's just as crap as EMS.
 
zero said:
Please describe the process to "specify the database name"...
Click to expand...

Go to connect > database engine. In the resulting dialogue box, click the "options" button. On the "Connection Properties" tab, enter the database name in the field adjacent to the text, "Connect to database".
 
hafa said:
Go to connect > database engine. In the resulting dialogue box, click the "options" button. On the "Connection Properties" tab, enter the database name in the field adjacent to the text, "Connect to database".
Click to expand...

That's what I was referring to, which will NOT show your diagrams, tables, etc. That is not an acceptable workaround for me, but thanks for the suggestion.
 
You must log in or register to reply here.
Back
Top