FRESHERSHOME
Freshers Forum

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

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 ...


Go Back   Jobs in India Forum > Programming > Data Base Related > MySQL

Notices

MySQL MySQL Related discussion, MySQL configuration help, and everything related to MySQL

 
Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2008, 04:10 PM
YahooHoo
 
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 01-13-2008, 04:16 PM
YahooHoo
 
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
win, sp2, install, sql, server, 2005, mysql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

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


All times are GMT +6.5. The time now is 02:09 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
FreshersHome.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62