As a part of the SQL Server 2008 Go Live Program, myhosting.com now offering accounts on the SQL Server 2008 platform. By joining the Beta program and trying out SQL 2008, you’re getting an opportunity to test out the software before it is available to the public. Your SQL 2008 database can be activated through the Control Panel once your web hosting account has been activated. If you want to read more about this offering then please visit our SQL Server 2008 page.

How to activate your Microsoft® SQL Server™ 2008 Database using your myhosting.com Account

1- First log in to your control panel located at https://support.myhosting.com/

 

---

2- Once you log in, take a look at the top left portion of the page and make sure that your hosting plan says either Premium Web Hosting or Professional Web Hosting. You also need to be on a Windows Hosting plan in order to use MS SQL Server 2008.

 

 

---

3- Once you verified your hosting plan then click on “Site Management” tab at the top.

 

 

---

4- On the “Site Management” page, notice the left menu and click on “Microsoft SQL Database” link located under “Database” category.

 

 

---

5- You are now on “SQL Databases Page”. If you haven’t added any SQL Databases then the page will say “You currently do not have any SQL databases.” so click on “Click here to add a new SQL database.” link.

 

 

---

6- Next page will ask you to choose the platform you would like your database created on. Click on “SQL Server 2008 Beta” link.

 

 

---

7- Next page will be “Microsoft SQL 2008 Beta Database Signup” page. Although you may sign-up for a free version of SQL 2008, you may also consider paid versions if your project require more disk space. For this guide, we will go ahead and click on first option (Free). Select the first option, scroll down and click on “Continue” button.

 

 

---

8- This page requires you to enter a password for your database. Make sure that you read the password guidelines on the page. We will go ahead and enter a password.

 

 

---

9- Next you will be presented with a billing summary of your selection. As we chose the free version, your summary will indicate zero dollars (as seen below). Simply click on “Confirm” button to continue.

 

 

---

10- Congratulations, your database has been created. Make a note of your SQL Server information, you may need them in the future. If you want to manage your database then click on “Click here to manage your database.” link.

 

 

---

11- This page will let you manage various aspects of your database. If you want to access myLittleAdmin for your database then simply click on “SQL Web Administration” link.

 

 

---

And that is it, now you have added the latest and greatest database solution to your account.

 

If you have any questions please do not hesitate to contact me.

Timur Catakli
myhosting.com - Community Manager
http://portal.myhosting.com

ps: Did you like this post? Would you like to see more of user guides with screenshots, if so contact me.

Posted in myhosting.com ~ 1 Comment

As part of the Microsoft SQL 2008 Go Live program, myhosting.com has now launched SQL 2008 Beta Databases for all of our customers to try. Our Premium and Professional Windows-based hosting plans even include a 25 MB SQL 2008 Beta Database for free! Please note that the SQL 2008 Beta database won’t work with our Linux-based hosting plans, such as the Basic plan, but these accounts all include a free MySQL database.

If you are already using a SQL 2000 database or want to get a head start with SQL 2008, you can sign up from our Control Panel today. SQL 2008 databases are set up in real-time, and in a matter of a few minutes you’ll be up and running with your new database.

Once activated, you can use the web-based SQL Manager utility provided by myLittleAdmin for no extra charge, or you can use SQL Server Management Studio to access your database remotely.

Microsoft SQL 2008 includes many of the features you have become used to in SQL 2000/2005, plus the following new and improved features:

• Auditing of Data Changes
• Entity Data Services
• LINQ Support
• Data Synchronization Features
• No size restriction on User Defined Types
• Improved Date and Time data types and new Spatial Data Types
• XML Enhancements
• Table Valued Parameters

And just a few of the advantages of using Microsoft SQL 2008 include the following:

• Build next generation data-centric applications with the ADO.NET Entity Framework
• Revolutionize data access queries with LINQ
• Harness Data Platform technologies with Visual Studio
• Take advantage of a full range of data connectivity technologies
• Store any kind of data in SQL Server 2008
• Build highly scalable applications with SQL Server 2008

For more information on SQL 2008, please visit the Microsoft SQL Server 2008 web site.

Thanks,

Tim Attwood
Product Manager
SoftCom Technology Consulting Inc.

Posted in myhosting.com ~ No Comments