Results 1 to 2 of 2

Thread: i have win xp sp2, can i install sql server like ms sql 2005 or mysql. where...

  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Default i have win xp sp2, can i install sql server like ms sql 2005 or mysql. where...

    ...do i download it for free? any free trial would do i just need to practise sql programming, better if the file size is less as my net speed is not fast, thanks
    Powered by Yahoo!

  2. #2
    Join Date
    Jan 2008
    Posts
    1

    Default

    Installing SQL Server
    This section provides information on how to install SQL Server for use with WebSphere Portal.

    Before you begin
    You should have completed reviewing the Planning for SQL Server section.
    Requirements
    You must install SQL Server separately from WebSphere Portal.
    WebSphere Portal requires Microsoft SQL Server 2000 Service Pack 4 and SQL Server 2000 Driver for JDBC SP3. You can download these drivers from http://technet.microsoft.com/en-us/sqlserver/bb331729.aspx.
    Installing Microsoft JDBC Type 4 drivers on UNIX Use the following steps to install Microsoft JDBC Type 4 drivers on UNIX:

    Download the Microsoft SQL Server 2000 Driver for JDBC SP3 and save the mssqlserver.tar file in one of the directories.
    To create the required files, run the following command from the directory that contains mssqlserver.tar: tar -xvf mssqlserver.tar
    Run ./install.ksh in the same directory.
    When installation is complete, change directory to /installation/lib, where installation is the directory in which you installed the Microsoft JDBC Type 4 drivers.
    Run the following command to change the permissions on the JAR files in the installation/lib directory:chmod 777 *.jar
    Change the ownership and group of these files by running the following commands in the installation/lib directory:
    chgrp system_grp *.jar
    chown root *.jar
    Where system_grp is the system group as labeled by your operating system.

    Installing SQL Server

    The following section provides instructions for installing SQL Server for use with IBM® WebSphere® Application Server and WebSphere Portal. See the Microsoft SQL Server product documentation for installation details.

    Install SQL Server and all required patches.
    Select SQL Server Authentication as the authentication mode during the installation.
    Complete the installation using SQL Server documentation as a guide.
    Install the Microsoft SQL Server Service Pack 4.
    Install Microsoft SQL Server 2000 Driver for JDBC Service Pack 3.
    Copy sqljdbc.dll from jdbc_root\SQLSERVER JTA directory to the sql_root\binn directory, where jdbc_root is the root directory for the JDBC Driver and sql_root is the root directory for the SQL Server driver.
    Start SQL Server.
    Use the ISQL utility to run instjdbc.sql from the jdbc_root\SQLServer JTA directory, where jdbc_root is the root directory for the JDBC Driver. The DOS prompt syntax is:
    ISQL -U sa -P sa_password -S server_name -i "jdbc__root\SQLSERVER JTA\instjdbc.sql"
    where
    sa is the SQL Server system administrator user ID
    sa_password is the password for the system administrator
    server_name is the name of the server on which SQL Server is running
    jdbc__root is the root directory for the JDBC drivers
    A message indicating success is shown. Review the message output for messages that indicate an installation or execution error.
    If you are running Windows XP SP2, Windows XP 64-Bit Edition, or Windows Server 2003, refer to the Registry Entries Are Required for XA Transaction Support document for information on a new security constraint and how to set SQL Server on Windows XP SP2, Windows XP 64-Bit Edition, or Windows Server 2003.
    Create a additional value in the Windows registry forWebSphere Portal by following these steps:

    Open theWindows Registry Editor (regedit) and navigate to the element HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL.
    From the menu bar, select Edit > New > String Value to create a new parameter named sqljdbc.dll in that element.
    Change the value of the new parameter to the location of the sqljdbc.dll file copied in step five above, for example: C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqljdbc.dll.


    YOU CAN ALSO DOWNLOAD (Trial Software) SQL by clicking below mentioned link :-

    http://www.microsoft.com/sql/downloads/trial-software.mspx#EGB
    Powered by Yahoo!

Tags for this Thread

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
  •