The answer to the above question is you need to first compile freetds and then compile PHP with freetds support.

But what is FreeTDS?
FreeTDS is a free implementation of the TDS (Tabular Data Stream) protocol that is used by Sybase and Microsoft for their database products. It implements different version os TDS which includes TDS 4.2, 5.0, 7.0 and 8.0, and can communicate with any Sybase or Microsoft SQL Server. FreeTDS generally comes with a low level library (the TDS layer) along with a number of APIs (Application Programming Interfaces). The APIs are DB-Lib, CT-Lib, and ODBC.
You can install freetds by using yum.

yum install freetds

After that you need to recompile the php with mssql support

check the php version on the server and then download the same php version file

for example php 5.3.2.
You can downlad php version by using this URL http://us3.php.net/downloads.php

cd /usr/local/src

wget http://us3.php.net/get/php-5.3.2.tar.bz2/from/in.php.net/mirror

tar -xzvf php-5.3.2.tar.bz2

cd php-5.3.2/ext/mssql

phpize

./configure –with-mssql

make
make install

Next look for the mssql.so file and make sure it is in the module directory specified in your php.ini. Copy it to the specified location if needed.

php -i | grep php.ini

vi /usr/local/lib/php.ini

Add this line to your php.ini:

extension=mssql.so

Save the php.ini and restart Apache:

/etc/init.d/httpd restart

To install Enable mssql support on Linux server you need a good tech support people from web host and eUKhost has number of customer reviews about quality support and services.

To provide multi user  access to number of databases a relation database management system is been developed that runs on a server and called as MySQL. MySQL is developed under GNU General Public License and its source code is available under its defined terms. MySQL is a popular choice of database for use in web applications and it performs really well with cPanel hosting accounts to store data of any websites. And suppose if you have forget the MySQL root password and you are not able to access your mysql service then you need to reset the password of MySQL root user by using following steps which are as follows,

Steps to Reset MySQL root Password :

1)root@server [~]/etc/init.d/mysqld stop

2)Start to MySQL server without password:
root@server [~]mysqld_safe –skip-grant-tables &

3) root@server [~] mysql
After that you can get the mysql prompt then run the following command

4)mysql >use mysql;

5)mysql >update user set password=PASSWORD(“NEWPASSWORD”) where User=’root’;

6)mysql > quit

7)root@server [~]/etc/init.d/mysqld stoproot@server [~]/etc/init.d/mysqld start
Now you can access your mysql service by using
[root@server ~]#mysql -u root -p

The article would help you with a step-by-step procedure about how to copy a table with phpMyAdmin located within the cPanel control panel.

Step 1 : Log into cPanel

Step 2 : Go to phpMyAdmin and choose the database and the table that you intend to copy

Step 3 : Go to the option titled “Operations” listed amongst the other tabs

Step 4 : Locate the box titled “Copy table to (database,table): ”

Step 5 : There are two options you may choose from ie. either create a copy of the table to the current database (usually gets selected by default) OR copy the table to a different database

Step 6 : Choose the database name from the drop-box and the name of the table to copy the structure and / or data into.

You are required to choose between the following options before proceeding any further :

• Structure only – Selecting this option would only create a copy of the table and its name. You must note that the data wouldn’t be copied in this case.

• Structure and data – Choosing this option would allow you to copy the table along-with its name, but would also copy the data it contains to the destination you choose further in the process ie. INSERT INTO >> SELECT * FROM …
• Data only – Clicking the radio button would only copy the data to the destination.

Furthermore, you are offered the option to choose whether you wish to drop the table that you are copying to before creating the table and copying the data. This runs a DROP TABLE IF EXISTS query for the copy of the table, not the original. You would not notice any change if you’ve chosen data only copy.

Then you’d have the option to choose to copy the auto increment value. This isn’t a default function, and you’d need to check it manually. The auto increment value will end up being whatever it would be after the INSERT INTO query is done. Checking the box would activate the CREATE TABLE syntax which would then include the auto increment value from the original table.

Lastly, you can see the option termed “Switch to copied table ”, as the title suggests you’d be switched over to the copied table once the queries are completed. If you leave it unchecked, the resulting page will still be looking at the original table; if checked it will change to the copied database (if applicable) and table.

–

Like this post ?

Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers.

Email us the shared link at : sales@eukhost.com or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand side of this page and we will provide you with the discount Coupon right away!

MySQL Database is named as a relational database management system that runs a server providing multi-user access to a number of databases. It is a Free-software-open source project developed by a community of programmers with a full-featured database management system called MySQL. Collation in MySQL Database is a set of rules used in comparisons. Because many people use MySQL with data to be stored in languages other than English, they need to select the rules of comparisons which in turn depends on the character set used for storing that data. To solve problems related with foreign character encoding you usually change your MySQL collation The most common method to change MySQL collation from latin1 to utf8 can be done by using phpMyAdmin and following the instructions below:

1. Please Enter successful log-in details of your cPanel hosting account and click on the phpMyAdmin icon in the Databases box.

2. Select the database you wish to manage from the drop-down menu on the left.

3. Click on the Operations tab in the top menu of your phpMyAdmin.

4. At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.

Please make a notice of this thing, once you change the collation of a database only the new tables will get created with the new collation and all other tables remain with the collation where they are initially created. And because of convenience of the customers, most web hosts have set MySQL’s collation to utf8 by default. You can also benefit from this feature by joining eUKhost. The UK web hosting service provider offers reliable and secure hosting services from last decade to thousands of customers with reliability and security to run any online business.

In web hosting industry cPanel is the only control panel which supports easy to understand GUI based (Graphical User Interfarce) to mange hosting resources of a website. cPanel hosting supports different  features to mange hosting resources which includes Spam Assasian,  Email forwarding, Awstats,  MySQL to support and manage databases of a website. And it certain time it become s necessary to upgrade from a older version of MySQL. So to upgrade you MySQL version you just have to Login to WHM with root user and access the option Server Configuration then Tweak Settings. Look for MySQL and check the radio button for 5.0 from 4.1 OR login to the server via SSH and open the file /var/cpanel/cpanel.config and find for mysql-version. Change it to 5.0 from 4.1. Save the file and exit. Now execute the commands on the server to upgrade the mysql version.

/scripts/upcp –force

/scripts/mysqlup –force
Wait for mysql to upgrade. Once the process is completed, check the mysql version.

To make changes in cPanel some of newbies as well as online organizations rely on their hosting service provider eUKhost web hosting service provider is leader in tech support services from last decade to deploy quality tech and phone support with different server technologies which includes UK Cloud hosting servers, Windows hosting server and highly configured dedicated servers.

The following tutorial explains you the backing up and restoration of your MS SQL Server 2008 Database using the Microsoft SQL Server Management Studio.

Microsoft SQL Server Management Studio Express (SSMSE) which is an free open source graphical management tool which can be used to manage your SQL Server 2008 Express Edition. You can use these backups later if a disaster strikes. It is always better to backup your database, because you never know if the information is lost or the database goes corrupt.

The backup file you download will need to be in .bak file extension. Database stored on the shared servers, the backups will be generated on the server itself. If you wish to have a copy of your server backup, then you may need to contact the windows support team.

In order to backup your MS SQL Server 2008 Database on your windows dedicated server hosting platform, follow the steps shown below:

First, you need to configure the Microsoft SQL Server Management Studio on your local machine. If you don’t have it, you can download it from the following location.

http://www.microsoft.com/downloads/en/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

Step 1: Open your Microsoft SQL Server Management Studio, whichever you prefer, standard or express edition.

Step 2: Using your Database Username and Password, simply login to your MS SQL server database.

Step 3: Select the database >> Right-click >> Tasks >> Back Up [as shown in the image below]:

Once you click on the “Backup” the following Backup Database window will appear [as shown in the image below]:

Step 4: Select the following options:

1. Backup type: Full
2. Under Destination, Backup to: Disk

Step 5: Now, by clicking on the “Add” button the following window will appear to select the path and file name for the database backup file [as shown in the image below]:

Step 6: Select the destination folder for the backup file and enter the “File name” with .bak extension [as shown in the image below]:

Make sure you place your MS SQL database .bak file under the MSSQL backup folder.

Step 7: Hit the OK button to finish the backup of your MS SQL Server 2008 Database. Upon the successful completion of database backup, the following confirmation window will appear with a message “The backup of database “yourdatabasename” completed successfully. [as shown in the image below]:

Following the above shown steps, you will be able to create a successful backup of your MS SQL Server 2008 Database into the desired folder.

How to Restore MS SQL Server 2008 Database Backup File ?

In order to restore a database from a backup file, follow the steps shown below:

Step 1: Open your Microsoft SQL Server Management Studio Express and connect to your database.

Step 2: Select the database >> Right-click >> Tasks >> Restore >> Database [as shown in the image below]:

Step 3:  The following “Restore Database“ windows will appear. Select “From device” mentioned under the “Source for restore” and click the button infront of that to specify the file location [as shown in the image below]:

Step 4: Select the option “Backup media as File” and click on the Add button to add the backup file location [as shown in the image below]:

Step 5: Select the backup file you wish to restore and Hit the OK button [as shown in the image below]:

That’s it! You will get the confirmation windows with a message “The restoration of database “yourdatabasename” completed successfully.” Now you know the procedure of backing up and restoring MS SQL Server 2008 Database.

Like this post ?

Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers. Email us the shared link at : sales@eukhost.com or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand of this page and we will provide you with the discount Coupon right away!

eUKhost has now launched Windows Shared Hosting & Windows Reseller Hosting with DotNetPanel control panel. DotNetPanel is unique feature-rich solution for simplifying Windows hosting management operations. It manages multiple servers, has robust, scalable and secure architecture, it’s very simple in use and offers unique & competitive features.

Some of the important features of DotNetPanel

Ease of Use
The installation process is quick and easy. You don’t need to spend days to make your control panel work for you!

Security
DotNetPanel uses the most advanced security technologies like asymmetric cryptography, Web Services messages signing and process isolation.

Multi-Server
DotNetPanel is a truly distributed, scalable, n-tier application.

DotNetPanel structure at eUKhost

DotNetPanel is a secure and flexible hosting management solution which supports multiple servers in a cluster. At eUKhost, we have implemented DotNetPanel for Windows Shared hosting & Windows Reseller hosting with Active Directory integration. We have installed individual service on one server and clubbed all other services under DotNetPortal to manage all hosting plans effectively.

The eUKhost structure with specifications of services is listed below:-

How eUKhost’s DotNetPanel Structure works :-

DotNetPanel has 3 separate web applications:

• DNP Web Portal
• DNP Standard Server
• DNP Server

Web Portal – DotNetPanel Web Portal is a control panel interface which works with port 9001; users and resellers can manage user accounts, hosting spaces, web sites, FTP accounts, files etc through this interface.

Standard Server – Standard Server license is a central application of the DotNetPanel system, this helps Portal and DNP server to manage web hosting operations and remote services. It also includes all business logic of the application and maintains DotNetPanel meta-data database. Enterprise Server manages remote servers through SOAP Web Services.

Server – DotNetPanel Server is a non-visual application representing a set of web services and currently hosted in IIS. DotNetPanel Server receives requests from DotNetPanel Enterprise Server and performs all low-level operations (creating web sites, FTP accounts, mail boxes, databases, etc.) on the server.

SQL Servers

Looking for high performance SQL Server Hosting? Choose one of eUKhost’s fully managed SQL dedicated servers. Dedicated SQL Servers provide enhanced performance, reliability, and dedicated resources for your application. eUKhost offers a wide range of cost effective SQL Server Hosting solutions to suit the needs of any web business. Try one of our fully managed Dedicated SQL Servers, equipped with Dual Core/Quad Core/ Dual Quad Core Xeon processors, up to 32 GB of RAM and up to 450 GB of fault tolerant SAS disk space. Create unlimited databases, users, packages, SQL jobs, maintenance plans and more.

Microsoft® SQL Server 2000/2005/2008 hosting solutions provide you with the most comprehensive platform for building and deploying database driven applications for an online business. Since Dedicated SQL Servers require intensive resources such as CPU and RAM, each of eUKhost’s SQL Dedicated Servers deliver the ultimate in terms of performance, dependability, and security, coupled with guaranteed uptime, affordable pricing, and round the clock technical support.

Our Dedicated SQL Servers allow a user the privileges to manage the entire SQL Server remotely with SQL Enterprise Manager or via RDP (Remote Desktop Protocol). All SQL Server hosting packages come with round the clock technical support from our Microsoft Certified staff. eUKhost has a dedicated team of Dedicated SQL Server Hosting experts who have sound experience in SQL Hosting administration, optimization, backups, restores, as well as implementation.

With our branded hardware dedicated server configurations, world-class data center and support for Windows Servers, you can be rest assured that your data is being delivered on the most advanced database hosting platform available.

eUKhost also offers custom solutions for your web and SQL Dedicated Server needs. Please contact our Sales Department for a quote based around your specific needs.

If you have a requirement for SQL Server 2005/SQL Server 2008 but cannot afford the costly per-cpu licenses required or quite simply do not want the extra hassle of maintaining SQL databases then why not take advantage of our Windows Web Hosting. We have shared SQL Server 2005 and SQL Server 2008 servers and can offer this to all customers who need SQL Server hosting at an much lesser cost than a full dedicated SQL server.

Q. Does your Windows Reseller hosting require a static IP address for remote SQL Server access?

Ans. It is not necessary to use a static IP address for remote SQL Server access, you can connect to MS SQL database using our shared server’s IP address from anywhere with any type of internet connection.

Q. Do you offer a Database backup service – if yes how frequent is the backup & how much does it cost?

Ans. We offer MSSQL 2005 express version, which comes with its own management interface called SQL- Express Management Studio. SQL- Express Management Studio allows you to manage the administration of your databases. You can place a helpdesk ticket with our support department to request a backup to be taken and/or restoring a backup for you. There are no charges involved with this.