Ms Sql 2005 Launched on Windows Plans

Im pleased to announce that all new Windows shared hosting accounts will now get access to the Ms Sql 2005 shared database Server through their shared hosting control panels, which can be used in conjunction with the MyLittleTools that we also recently launched.

Some Features available with Sql 2005 include;

Hosted CommonLanguage Runtime

With SQL Server 2005 developers can create database objects using familiar languages such as Microsoft Visual C# .NET and Microsoft Visual Basic .NET. Developers can also create two new objects—user-defined types and aggregates.

Security Enhancements

The security model in SQL Server 2005 separate users from objects, provides fine-grain access, and enables greater control of data access. Additionally, all system tables are implemented as views, providing more control over database system objects.

ADO.NET version 2.0

From new support for SQL Types to Multiple Active Result Sets (MARS), ADO.NET in SQL Server 2005 evolves dataset access and manipulation to achieve greater scalability and flexibility.

Native XML Support

Native XML data can be stored, queried, and indexed in a SQL Server database—allowing developers to build new classes of connected applications around Web services and across any platform or device.

Web Services

With SQL Server 2005 developers can develop Web services in the database tier, making SQL Server a hypertext transfer protocol (HTTP) listener and providing a new type of data access capability for Web services-centric applications.

Visual Studio Integration

Tight integration with Microsoft Visual Studio and the .NET Framework streamlines development and debugging of data-driven applications. Developers can build database objects, such as stored procedures, using any .NET language and can seamlessly debug across .NET and Transact-SQL (TSQL) languages.

To available of these tools and other tools included with Sql 2005 , simply sign up for any of the windows hosting accounts available on the site www.register365.com/hosting

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks

5 thoughts on “Ms Sql 2005 Launched on Windows Plans

  1. My understanding, and please correct me if I am wrong, is that despite what this post says register365 do not yet have a working sql server 2005 environment abailable to clients

  2. Hi Michael,

    Yes this has been available from the time i posted on the blog, if you would like you can drop me an email aidan.mccarron AT register365.com with your details and i can have you moved across.

    Just to add , it’s added by default onto all new windows hosting plans.

  3. Hi Aidan,
    I know that sql server 2005 has been added to all new windows hosting accounts as this was my main motivation for joining with register365. I checked before I joined by contacting your support centre and I was assured that sql server 2005 was available, and in fairness it is.

    My problem however is that it doesn’t work. I have been able to login and create a sql server 2005 database but I cannot connect to the database from asp.net applications hosted on your servers. Furthermore, I couldn’t get this issue resolved by the support team and was told that it was a known issue but that your engineers could not provide any estimation of when the issue would be resolved. After several wasted days I eventually decided to sign up with digiweb and create a database on their servers.

    When I then pointed my ASP.NET code (hosted with register365) at my new database (hosted by digiweb) I received the same error. It turns out (as far as I can see), that the issue is not with the SQL Server 2005 databases itself, but rather that the firewall or some port settings on register365 servers block all access to any SQL Server 2005 database.

    Hence, why my original post stated that their was no SQL Server 2005 Environment available to your customers. Surely, you will agree that whether or not register365 offer customers access to Sql server 2005 the fact that they cannot develop applications that have a SQL server 2005 back end means that offering this service and advertising it as being available is a little mis-leading.

    I apologise for my rant, but I became a little frustrated as I wasted a lot of time trying to get my application set up on register365s environment and was disappointed as I had heard positive stories about register365 but in the end was left with no choice but to open a second hosting account with Digiweb.

    This is the error message that is displayed when my ASP.NET applications hosted by register365 trys to access a SQL Server 2005 database:
    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

  4. Hi Aidan,
    I still get the same error message.

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

Leave a Reply

Your email address will not be published. Required fields are marked *