FRESHERSHOME![]() |
This is a discussion on i have win xp sp2, can i install sql server like ms sql 2005 or mysql. where... within the MySQL forums, part of the Data Base Related category; ...do i download it for free? any free trial would do i just need to practise sql programming, better if ...
| |||||||
| Notices |
| MySQL MySQL Related discussion, MySQL configuration help, and everything related to MySQL |
![]() |
| | Thread Tools | Display Modes |
|
#1
| |||
| |||
| ...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
| |||
| |||
| 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 |
| win, sp2, install, sql, server, 2005, mysql |
| Thread Tools | |
| Display Modes | |
|
|
Sitemap
Jobs by Location: Advertising and Marketing Jobs - IT Software Jobs - Walk-in Jobs - BPO Jobs - Government Jobs - Sales / BD Jobs - Tele Communication Jobs App Programming - Network Admin
Jobs By Location: Jobs in Bangalore - Jobs In India - Jobs in Delhi - Jobs in Hyderabad - Jobs in Kochi - Jobs in Mumbai - Jobs in Trivandrum - Jobs in pune - Jobs in Jonida - Jobs in Chennai - Jobs in Coimbator
Jobs Type: Full Time Jobs - Part Time Jobs
Latest Jobs - Accounting Jobs - Engineering Jobs - IT Jobs - Walkins - How to Face Interview - HR Round Tips - Career Info - Guide For Freshers - Apply for Jobs - Future Studies - Jobs Forums - Freshers IT Software Salary Details