Okay... I don't personally have a license for SQL Server, so how do I access a remote copy via Enterprise Manager?
Just buy a CAL (Client Access License)?
| SitePoint Sponsor |
Okay... I don't personally have a license for SQL Server, so how do I access a remote copy via Enterprise Manager?
Just buy a CAL (Client Access License)?
How is the remote copy licensed?
The server is maintained by the host, so I would think they would have their own Processor license.
You'd be OK licensing-wise to just connect to it then, wouldn't you? I don't think you'd need a new CAL.
Or do you need to get a CAL to get the appropriate software?
Grrrr SQL Server licensing - I'm writing a business case this week on why we need to get a copy as well.
Yeah, it's not so much the accessing... I don't have the actual "management app" that SQL Server uses (Enterprise Manager) so I don't really have a way to connect to it.
We just upgraded to SQL Server (finally) and we're very happy with it at work, but that doesn't help me personally!
Hmmm - OK.
Kevin did a piece on SQL Server in a recent Tech Times I think, and talked about client software. I'm not sure if he said the client-side stuff was available anywhere else or not... maybe check with him?
I'm not much help unfortunately - can't place the TT article and I'm sitting here at work with all the SQL Server client software preinstalled by our friendly IT guys (sorry - had to rub it in)
S'aright, I can rub too. We just got a full copy of Enterprise on Processor license for one tenth the original price
Doesn't help me at home though...
Ergh, I'll keep asking around...
You win
here's the bit from TT:
That takes care of MSDE, now how about the SQL Server
administration tools? Well, Office XP Developer Edition comes
with SQL Server Developer Edition, which is another option for
SQL Server development on the cheap. Although this version of SQL
Server severely limits the number of database connections that
are allowed, you can selectively install just the administration
tools and use them with MSDE.
Alternatively, you can download the 120-day trial of SQL server
and only install the administration tools, although the legalities
of this method are somewhat questionable after that 120-day period.
Yeah, that's all the actual database engine... I just need enterprise manager
I would steer clear of anything but a SQL Server Processor license if you're going to be using it for online stuff anyways as each connection is literally considered a "client". So any applications, any web users, any internal staff are all counted against your "connection limit". That's why we went with Processor
ahem....Yeah, that's all the actual database engine... I just need enterprise manager
We're probably going with CALs as it's much cheaper in our situation (due to some technical constraints, we're only having ~6 connections, and these are always going to be the same connections - kind of tricky to explain...you can selectively install just the administration
tools and use them with MSDE.
Alternatively, you can download the 120-day trial of SQL server
and only install the administration tools.......)
Hmm... Aright, I'll download it now and see if I can find it
Alternatively, if you find the latest SQL Server 2000 service pack and manually extract all the files, you shuold be able to run Enterprise Manager no probs!
M@rco
You just need an application to access the server? You don't need to use Enterprise Manager (which truly sucks in my opinion anyway).
You can use any front-end that can connect to the server. Personally, my suggestion is to try dbArtisan. It can access Oracle, Sybase, DB2, and SQL Server databases. You can do multiple connections and copy between databases. It has full reporting capabilities which can be output in HTML. Monitoring, Tracking, Code editors, Debugging and a lot more.
You can download a trial at:
http://www.embarcadero.co.uk/product...isan/index.asp
I'll have a look on Thursday, thanx so much Wayne. I just need to be able to manage this remote DB
Posting Permissions
Bookmarks