MS SQL
Switching MS SQL database servers
There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres. In this example we will look at how to move an … Continue reading
Pipe Ten still the best value for MS SQL hosting
8 years on and Pipe Ten still offer some of the best deals for MS SQL Server hosting. Take our Windows Venture package for example, it is still just £5 per month and comes with a 100 MB MS SQL … Continue reading
Explained: Warning (Approaching resource limit)
If you receive an email from support@pipeten.co.uk or .com with the title “Warning (Approaching resource limit)” it means that you are approaching or exceeding some of the inclusive resources on your hosting package. Explanations of what these resources are and … Continue reading
Explained: Warning (Approaching resource limit) – MySQL Quota or MSSQL Quota
When you reach approach or exceed the default size of your hosting packages inclusive database quota/storage you will receive an email from support@pipeten.co.uk or .com to the primary account contact with the subject “Warning (Approaching resource limit)”. This post provides … Continue reading
MS SQL Server Management Studio 2008
When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect … Continue reading
MS SQL Server Management
Support for the old MS SQL Manager that used to be available via the online control panel has been removed. This was because of the lack of functionality, security risks and general poor performance that the third party package was … Continue reading
New SQL 2005 Administration Utility
Pipe Ten are please to announce a beta release of MyLittleAdmin, the web based administration tool for SQL servers.
New SQL Server 2005 backup facility
Due to popular request Pipe Ten have now launched their exciting new SQL Server 2005 backup facility using MyLlttleBackup. All customers that have databases on Pipe Ten’s MSSQL server can now log in to the new online backup facility to … Continue reading
How do I import or export MSSQL database?
This FAQ assumes SQL Server 2005 Express is running on your development server. If not already installed you will need the Microsoft SQL Server 2005 Express Edition Toolkit: http://go.microsoft.com/fwlink/?LinkId=65111 The DTS Wizard can be downloaded (SQLServer2005_DTS.msi) from here: http://www.microsoft.com/downloads/details.aspx Here … Continue reading
Database Publishing Wizard
An easy way to publish your database to Pipe Tens database server is to use the Database Publishing Wizard.
How do I connect to my MSSQL database using Enterprise Manager?
You can obtain Enterprise Manager by downloading MSDE (Microsoft Data Engine) from Microsoft
How do I manage my MSSQL database?
There are a range of clients available for managing your MS SQL 2005 database and they all should work with Pipe Ten’s servers without a problem. Each client offers slightly different functionality and licensing. Below are two of the more … Continue reading
Do you allow connections to remote MSSQL servers hosted elsewhere?
No, for security and efficiency reasons our web servers can only access Pipe Ten’s MS SQL servers.
Can I connect to my MSSQL database using a client remotely?
Yes, you can connect to your database using a client such as MySql Front or Aqua Data Studio. We only enforce standard authentication for remote MySql connections, you just require your database username, password and server address.
Why can I see MSSQL databases which are not mine?
The databases which appear are when a user chooses to alter the permissions of the database to be publicly accessible. These databases to not count towards your quota, nor pose a security risk.

