Tag

SQL Server

21 posts tagged with this.

All posts RSS
  1. Knowledge BaseWindows Cloud Hosting
    · 2 min read

    How to Connect to Microsoft SQL Server Over SSL

    All SQL Server instances have SSL enabled. This guide shows how to connect securely from ASP and ASP.NET apps using encrypt=true in your connection strings and how to enable Encrypt Connection in SQL Server Management Studio. Use the exact hostname from your control panel to prevent certificate erro
  2. Knowledge BaseWeb Hosting
    · 2 min read

    Encrypted or SSL Connections for SQL Server and MySQL

    All ASPnix Microsoft SQL Server and MySQL servers support encrypted SSL connections to secure data in transit. Your client, driver, or application must also support encryption. This guide covers configuration for SSMS, Navicat, our management tools, and code examples for ASP.NET, .NET, and PHP devel
  3. Knowledge BaseWindows Cloud Hosting
    · 3 min read

    How to Execute aspnet_regsql on Shared SQL Server Database

    The standard Microsoft aspnet_regsql tool generates scripts unsuitable for shared SQL Server due to permission requirements. ASPnix supplies a modified SQL script that works in our shared environment. Log in to your billing account to download the file, extract it, and run the script in SQL Server M
  4. SalesVirtual Cloud ServersWindows Cloud Hosting
    · 3 min read

    Does ASPnix Offer Web-Based Utilities to Manage SQL Databases?

    Yes, ASPnix offers web-based tools like phpMyAdmin (https://pma.anaxanet.com) for MySQL and MyLittleAdmin (https://mla.anaxanet.com) / MyLittleBackup (https://mlb.anaxanet.com) for SQL Server. Use them to manage tables, run queries, backup and restore databases without local software. This guide det
  5. SalesVirtual Cloud ServersWindows Cloud Hosting
    · 3 min read

    How to Upgrade SQL Server Database Size Beyond 10GB on ASPnix

    ASPnix supports Microsoft SQL Server databases larger than the default 10GB limit per database. Add capacity in 10GB increments at $10 per month each, purchased via the client area My Services section. This guide covers the upgrade process, T-SQL queries to monitor usage, key considerations, and bes
  6. SalesWindows Cloud Hosting
    · 3 min read

    Does ASPnix Allow Remote Management of SQL Databases?

    ASPnix does not block remote connections to shared MySQL and SQL Server databases. Connect and manage them using tools like Navicat, SSMS, phpMyAdmin, and MySQL Query Browser. This guide details supported applications, connection steps, permission boundaries on shared hosting, common pitfalls, and p