+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
Windows Thread, sql server in Technical; I have some sen software to install as a network installation which either uses sql or mdse, the instructions recommend ...
  1. #1
    chrbb's Avatar
    Join Date
    Oct 2005
    Location
    Midlands
    Posts
    1,507
    Thank Post
    141
    Thanked 67 Times in 62 Posts
    Rep Power
    46

    sql server

    I have some sen software to install as a network installation which either uses sql or mdse, the instructions recommend using enterprise manager to manage the sql server which I don't seem to have on our server W2003. Is it standard issue on servers or an extra that costs?

  2. #2

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,513
    Thank Post
    1,493
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302

    Re: sql server

    The enterprise manager is installed with SQL server. If you have not got SQL on already, just install the MSDE (normally comes with the program)

  3. #3
    chrbb's Avatar
    Join Date
    Oct 2005
    Location
    Midlands
    Posts
    1,507
    Thank Post
    141
    Thanked 67 Times in 62 Posts
    Rep Power
    46

    Re: sql server

    is sql an extra or does it 'come' with the server? (scuse my ignorance) we have sophos running an enterprise version which uses sql I've now got quite confused about this

  4. #4
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,434
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111

    Re: sql server

    Enterprise manager is not availiable with MSDE, you need SQL 2000 standard or above for that.

    A quick google, and voila!

    MSDE Database Limitations:

    MSDE is intended for single user or small workgroup environments. The following are some of the MSDE limitations in comparison with SQL Server:

    No Enterprise Manager
    No Query Analyzer
    No Index Tuning Wizard
    Only 2GB RAM
    Only 2GB database size limit
    Only 2 CPUs
    Only five concurrent batch workloads or 25 concurrent connections for websites
    No Database Server Failover Support
    No Full-text search
    No SQL Server Profiler
    No Import and Export Wizards
    No OLAP
    No English Query
    No SQL Books Online
    No Full or Bulk-Logged recovery model support (only simple)

  5. #5

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,513
    Thank Post
    1,493
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302

    Re: sql server

    Sophos will have installed MSDE if you did not already have an SQL database on your system for it to use. By what you are saying you have not got an SQL server on your system

  6. #6
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,434
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111

    Re: sql server

    Quote Originally Posted by chrbb
    is sql an extra or does it 'come' with the server? (scuse my ignorance) we have sophos running an enterprise version which uses sql I've now got quite confused about this
    MSDE is free, but has those limitations. SQL 2000 is not free and has two licensing models. Per CPU or per client. So to use the full sql 200 server (2005 is in beta still I think) you need either:

    A cpu license for the number of cpus you want to use (on a server). This requires no cals.

    Or you buy the potentially cheaper server license that runs on as many cpus as the edition supports (enterprise is more than standard for example) but you need a CAL for each client to access the sql server.

    Info from MS

  7. #7

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,513
    Thank Post
    1,493
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302

    Re: sql server

    2005 is out of beta, and ready for purchase now.

  8. #8
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,434
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111

    Re: sql server

    Update: quite typically the page I linked too now has sql 2005 on it. 2005 has an edition that is slightly similar to msde (the free bit), but has less of the limitations afaik (not looked into it too much as the products I use don't support 2005 yet).

    Update2: Ok, it still has most of the limitations, but with slightly bigger db, but it seems to have lost the governor that slows the MSDE 2000 version down on purpose).

  9. #9
    chrbb's Avatar
    Join Date
    Oct 2005
    Location
    Midlands
    Posts
    1,507
    Thank Post
    141
    Thanked 67 Times in 62 Posts
    Rep Power
    46

    Re: sql server

    cheers for the prompt replies, looks like we don't have sql if it costs extra, I think I got confused because sophos has used msde and there is a mssql icon on the taskbar.

    This software I need to install gives the option of using msde which is what it looks as though I'll have to use. Trouble is I don't have much confidence in some of the educational software out there it seems to cause more problems than any thing else.

  10. #10
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,434
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111

    Re: sql server

    Quote Originally Posted by chrbb
    cheers for the prompt replies, looks like we don't have sql if it costs extra, I think I got confused because sophos has used msde and there is a mssql icon on the taskbar.

    This software I need to install gives the option of using msde which is what it looks as though I'll have to use. Trouble is I don't have much confidence in some of the educational software out there it seems to cause more problems than any thing else.
    If you don't have a large database, need the enterprise manager or sql profiler and the database is only lightly used then msde will be fine.

    The mssql icon is normal, all MSDE is, is a limited version of sql 2000 (mostly).

    Edit:
    I should point out that different programs using sql on the same server can use different instances (seperate installs and databases) of MSDE (or sql 2000/5). However third party installers can have difficuly with this.

  11. #11

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,513
    Thank Post
    1,493
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302

    Re: sql server

    Just give it a whurl, the sophos database is nothing major, just a quick re-install of it will soon fix it up if it did anything to it, which it shouldnt do really!

  12. #12

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498

    Re: sql server

    Looking at purchasing SQL 2000 for our school here
    Anyone know where the best place to get it from would be?

  13. #13
    stitch's Avatar
    Join Date
    Jan 2006
    Location
    Wales
    Posts
    88
    Thank Post
    29
    Thanked 5 Times in 5 Posts
    Rep Power
    18

    Re: sql server

    Hi

    We purchase the majority of our software from Pugh Computers Ltd, which is based in Llanon near Aberystwyth. Sales Tel: 01974 200201 or Email: sales@pugh.co.uk.

    We find them very good.

  14. #14
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,249
    Thank Post
    51
    Thanked 275 Times in 213 Posts
    Blog Entries
    6
    Rep Power
    113

    Re: sql server

    We find Ramesys considerably better than Pugh. If you can, get a Select licence rather than MOLP. You'll save a packet.

    Ramesys recently quote us £240 for SQL Server 2000 and £2 per CAL.

    Additionally, if you're using MSDE or SQL Server 2005 Express Edition, download SQL Server Management Studio Express from Microsoft That lets you create and manage databases on both MSDE and SQLEE without having to use Enterprise Manager. OK, its nowhere near as powerful but considering it free who cares?

  15. #15
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,434
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111

    Re: sql server

    Quote Originally Posted by Norphy
    We find Ramesys considerably better than Pugh. If you can, get a Select licence rather than MOLP. You'll save a packet.

    Ramesys recently quote us £240 for SQL Server 2000 and £2 per CAL.

    Additionally, if you're using MSDE or SQL Server 2005 Express Edition, download SQL Server Management Studio Express from Microsoft That lets you create and manage databases on both MSDE and SQLEE without having to use Enterprise Manager. OK, its nowhere near as powerful but considering it free who cares?
    I use Pugh too for most things. My Schools agreement is with Misco atm still. I think I payed about £100 for a single processor license of sql server (no Cals needed ) Also means I can use 2005 now. I guess people might dislike paying anually to lease the software, but it is a predicatble cost and I have been enjoying its benefits lately.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Server 2003 R2 File Server Resource Manager
    By Dos_Box in forum How do you do....it?
    Replies: 1
    Last Post: 12th October 2007, 12:28 PM
  2. Replies: 5
    Last Post: 5th July 2007, 11:43 PM
  3. Windows Server 2003 File Server Resource Manager
    By mrforgetful in forum Windows
    Replies: 1
    Last Post: 17th June 2007, 01:51 PM
  4. Virtual Server 2005 R2 kills server network connection
    By ajbritton in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 31st August 2006, 06:19 AM
  5. Downsides to passing tftp server via 2003 DHCP server?
    By pete in forum Wireless Networks
    Replies: 7
    Last Post: 11th July 2006, 10:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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