Answered by the Webhosting Experts
Tags +

Managed Services

We’re Experts with Windows
Is keeping your Windows server up and running eating away at precious man-hours? Let Hivelocity manage your server with one of our Windows Managed Services plans. With reboots, monitoring, updates, and more, a managed services plan from Hivelocity gives your team the time it needs to focus on growth instead of just maintenance.

Configure your server today and see the benefits a Hivelocity managed Windows solution can offer you!

Tags +

Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer Edition, a DVD or a downloaded edition. If you have it on CD or DVD, you can put it in the drive and follow the instructions on the screen as we will review them.

The following steps describe the installation on a Microsoft Windows 2000 Server by the Administrator account, a Windows XP Home Edition, a Windows XP Professional, or the downloaded edition on a Microsoft Windows 2000 Professional.

Log on to your Windows 2000 Server or open Windows 2000/XP Professional
Put the CD or DVD in the drive or download the trial edition of SQL Server
If you are using the CD or DVD, a border-less window should come up (if it doesn’t, open Windows explorer, access the drive that has the CD or DVD and double-click autorun)
If you had downloaded the file, you may have the Download Complete dialog box
In this case, click Open. A dialog box will indicate where the file would be installed
You can accept the default and click Finish. You may be asked whether you want to create the new folder that doesn’t exist and you should click Yes. After a while, you should receive a message indicating success:
Click OK
If you are using the CD installation, click SQL Server 2000 Components or press Alt C.
If you are using the downloadable edition, locate the folder where the files were installed. You should see an autorun icon. Double-click it.
Click SQL Server Components and click Install Database Server
On the first page of the Welcome wizard, click Next
On the second page, choose the type of installation you are performing by clicking the appropriate radio button. The Remote Computer choice would lead you to select a computer or provide its path so you can install SQL Server on a computer that is not close to you. Otherwise, accept or select the Local Computer radio button
After selecting the desired type of installation and if necessary providing the information needed, click Next
The next dialog box allows you to select an installation option such as performing an installation live or scheduling that can be done without your eyewitness supervision (second radio button). For this installation, you should accept the default first radio button and click Next
The next option allows you to type your name (the name you use here has nothing to do with authentication) and optionally your company. After doing this, click Next
Read the Software License Agreement COMPLETELY and, if you agree, click Next. If you don’t agree, click No and stop the whole thing. The next steps assume that you agreed with the small prints
Next, enter the 25-digit CD-Key and click Next
The next step provides other options for the installation type. The first radio button is mainly used if you are installing on a workstation that will be connecting to a server or to servers. The third option allows you to install only MDAC. You should accept or select the default second radio button
After making your selection, click Next.
If possible, accept the Default check box selected on the wizard page.
If you must enter an Instance Name, choose a convenient name and type.
Click Next
The next steps will need some decisions from you. For example, you must now set the amount of installation you want to perform and the folder in which you want to store SQL Server. In most cases, you can accept the default Typical
Click Next
The next step allows you to specify who is doing the installation. If you are an administrator, specify the account’s password. If you have an account that can perform an installation on the server, enter its username, its password, and the domain it belongs to.
Click Next
On the next step, you can accept to exclusively use Windows Authentication with the first radio button. Otherwise, you can and should use this opportunity to allow different persons to log in to this SQL Server. In this case, you can select the second radio button and create a password for the SQL Server Authentication, which would create and setup the sa account
You should never use or allow a blank password, even if you are working alone. For one thing, this would be a bad habit you should not let get to you. For another thing, database security should be one of your biggest concerns and an employer or a job interviewer would be happy to know that you take security issues to your heart and you care. If that’s the case, specify the type of authentication you will use. You should select
Click Next
Once Setup has enough information, on the last wizard page, simply click Next
Once the installation is over, click Finish

SQL Server Startup

To use SQL Server, it must start as a service. You have two options. You can start it every time you want to use. You can also make it start whenever the computer comes up from booting.
To start SQL Server, on the Taskbar, click Start -> Programs -> Microsoft SQL Server -> Service Manager
On the SQL Server Service Manager dialog box, click the Start/Continue button if necessary
On the lower-right corner of the desktop, on the clock section of the Taskbar, the button of SQL Server appears with a green play button .
Close the dialog box

Stopping SQL Server

To stop the SQL Server service, double-click the SQL Server icon on the Taskbar system tray
On the SQL Server Service Manager dialog box, click the Stop button
You will receive a confirmation message box. Click Yes.

Starting the SQL Server Service Automatically

Display the Control Panel window and double-click Administrative Tools
In the Administrative Tools window, double-click Services
In the Services window, scroll to the middle of the right frame and click MSSQLSERVER
On the toolbar, click the Start Service button
Close the Services window



Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your account or if you are on the go, please reach out from your valid account email to us here at: [email protected] We are also available to you through our phone and live chat system 24/7/365.

Rapid Restore

Backup your entire server’s data every night and have access to 5 days of rolling restore points.  Restore your server’s data, OS and configuration any time you need it.

Our Rapid Restore service saves the day during accidental data loss, hardware failures and virus contraction. Simply pick your recovery point and restore the data from that day. 

DDoS Protection

While our competitors may advertise DDoS protection, most often, they are merely implementing easily evaded router rules or simply black-holing targeted servers. They consider this “DDoS protecting their network.” However, neither of these solutions should give comfort to any online business. Should your site be attacked, chances are likely both of these options will end with your server being taken offline. At Hivelocity, we take the responsibility of keeping your servers online very seriously. For this reason, we offer two very serious forms of DDoS protection.


Every solution we provide includes our Filtering Edge of Network System (FENS). FENS is a series of proprietary systems that proactively monitors and protects the entire Hivelocity Network from most common Denial of Service (DOS) and Distributed Denial of Service (DDoS) attacks.


For an extra fee, you can enhance your server’s protection further with the addition of our Server Defense System. Our Server Defense System sits in front of your server, inspecting inbound data and looking for malicious traffic. The moment an attack is detected, it instantly begins scrubbing each data packet. Hivelocity’s Server Defense System delivers business continuity even in the face of massive and complex attacks.

Our Server Defense System is like adding an alarm and armed guard to your business, alerting you to and destroying anything attempting to jump that fence. Our Server Defense System utilizes internally developed proprietary systems in addition to Corero’s Threat Defense Smartwalls for data packet scrubbing. Each of our data centers is a scrubbing center with Corero Smartwalls on-premise, allowing us to provide on-prem zero-lag data scrubbing.

SSL Certificates

The security of your online commerce and protecting your customers’ data is as important to us as it is to you. When your customers see the green bar, they will know their connection to you is protected. We offer single domain, multi-domain, and wild-card certificates.

We offer industry leading 128-bit encryption certificates, allowing you to conduct e-commerce with complete security. Inspire confidence in your customers by displaying any number of seals and indicators certifying that your site is secure.

Load Balancing

Adding this service to two servers with identical content will allow you to distribute your load evenly across your hardware. Don’t lose business because you couldn’t handle the demand. Load balance and handle your biggest resource spikes with ease.


Stop attacks, prevent unauthorized access, and achieve regulatory compliance. Our Juniper hardware firewalls offload the work so your server never has to consume resources protecting itself from malicious traffic. A single firewall can be used to protect multiple servers.

Cloud Storage

Cloud storage offers users redundancy and easy accessibility, ensuring your data remains secure and readily available. Scale to as much as you need for only a 20¢/GB.

Cloud Storage is distributed and replicated across many servers, protecting your data from hardware failure. Highly scalable, it can handle thousands of client connections via TCP/IP. Connect to your virtual drive with SFTP, FTP, and SSHMount and in the future NFS and AFP. Cloud Storage is based on a stackable design which is upgradeable up to 2TB per instance.