Administering SQL 2005 databases

Z

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

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 ]
 
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
 
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?
 
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 ]
 
Ah, I misunderstood. It's just the default view which is blocked, not the actual connection. Sorry about that. :)
 
zero said:
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]

thanks,
.brit
Click to expand...

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
 
antic said:
Ah, I misunderstood. It's just the default view which is blocked, not the actual connection. Sorry about that. :)
Click to expand...

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...
 
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. :)
 
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.
 
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?
 
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.
 
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.
 
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]
 
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
 
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.
 

Attachments

  • dbs.gif
    dbs.gif
    6.5 KB · Views: 68
You must log in or register to reply here.
Back
Top