Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Misc
 CJWSoft Support Info : Misc
Subject Info: FREE SQL Server Desktop Engine A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: February/20/2005 at 1:12am | IP Logged Quote cwilliams

Microsoft has a free version of SQL server 2000 than you can run on a development machine.


http://www.microsoft.com/downloads/details.aspx?FamilyID=413 744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

This is really the same thing as the MSDN version of SQL server that comes with Visual Studio

It is limited in two ways.

  • No single database can exceed 2 gigabytes in size. However, each Desktop Engine server instance can contain many databases, each of which can be up to 2 gigabytes in size. Each computer can host up to sixteen instances of Desktop Engine.

  • Performance will rapidly decline when more than five simultaneous users use the database engine at the same time. With five users or less Desktop Engine will operate with full SQL Server speed.

    After you install this your going to need a way to connect to your sql server as well as a way to run queires on it.

    I suggest either install the client tools off any SQL 2000 Installation Disc (giving you enterprise manager and query manager)

    or use the FREE SQL Server Web Data Administrator which will do amost everything you  will need to do. It is really very slick
    http://support.cjwsoft.com/forum/forum_posts.asp?TID=127& ; ; ;PN=1

    Then you have a pretty sweet setup for testing and developing locally using SQL server.

    If you are wondering why someone with a real SQL Server 2000 cd wouldn't just install the real SQL server locally it is because the server part will usually not install on XP Pro or non server versions of windows for licensing reasons. (at least every SQL 2000 CD I have is like that regardless of whether it is standard or enterprise) But the client side tools on the cd are invaluable so I just install the Desktop Version of SQL along with the client side tools and everything works great.



    • __________________
    Best Regards, Christopher Williams www.CJWSoft.com
    Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
     
    cwilliams
    Admin Group
    Admin Group
    Avatar
    CJWSoft Web Software Developer

    Joined: April/06/2004
    Online Status: Offline
    Info: 1769
    Added: February/20/2005 at 11:34am | IP Logged Quote cwilliams

    All this being said installing the desktop version of SQL may be a little tricky as it may complain that your SA account needs a strict password.

    The solution is to run the SQL Desktop setup.exe with some parameters specifying a password for the SA account.

    So you go to the command prompt or make a shortcut to the setup file and run something like this

    setup.exe SAPWD="YourPassword"

    minus the quotes...

    I got that info from this article and it worked fine
    http://www.experts-exchange.com/Databases/Q_21036508.html

    The other thing to remember is it might take a reboot to actually see the SQL server icon running in the taskbar. You may also need to go into the administrative services and enable the "SQLSERVERAGENT" as well as set its startup type to "automatic"

    And a reboot here and there..

    Whammo... your in business...



    __________________
    Best Regards, Christopher Williams www.CJWSoft.com
    Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
     
    cwilliams
    Admin Group
    Admin Group
    Avatar
    CJWSoft Web Software Developer

    Joined: April/06/2004
    Online Status: Offline
    Info: 1769
    Added: February/20/2005 at 11:37am | IP Logged Quote cwilliams
    Lastly, I put there information here to help, but please don't ask me any questions about it.

    I am not microsoft SQL server support. If this doesn't work for you simply start troubleshooting and doing google searches like I do.

    __________________
    Best Regards, Christopher Williams www.CJWSoft.com
    Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
     

    If you wish to make a comment to this info you must first login
    If you are not already registered you must first register

      A d d - P o s tAdd P o s t
    Printable version Printable version

    Info Jump
    		You cannot add new info in this area
    You cannot add to info in this area
    You cannot delete your info in this area
    You cannot edit your info in this area
    You cannot create polls in this area
    You cannot vote in polls in this area

    Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com