SitePoint Sponsor

User Tag List

Results 1 to 14 of 14
  1. #1
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Getting Enterprise Manager (SQL Server)

    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)?
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  2. #2
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How is the remote copy licensed?
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    The server is maintained by the host, so I would think they would have their own Processor license.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  5. #5
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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!
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  6. #6
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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 )
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  7. #7
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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...
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  8. #8
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  9. #9
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  10. #10
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah, that's all the actual database engine... I just need enterprise manager
    ahem....

    ...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...
    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 ....)
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  11. #11
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Hmm... Aright, I'll download it now and see if I can find it
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  12. #12
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  13. #13
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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
    Wayne Luke
    ------------


  14. #14
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I'll have a look on Thursday, thanx so much Wayne. I just need to be able to manage this remote DB
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •