Dashboard Shop Ask a question
Log in
Knowledge base
Introduction User Interface description FAQs VPS Hosting FAQs What is a VPS or VDS? Why is it Called 'Virtual'? Why is it Considered 'Dedicated'? What is the Difference Between VDS, VPS, VM, and Cloud Server? How is a Physical Server Shared Among Virtual Servers? How Does VPS Compare to Other Hosting Products? What are the Benefits of Using VPS Compared to Hardware Dedicated Servers? What Can I Do With My VPS? What Types of Operating Systems are Supported? Is it Possible to Install the OS of my choice? How Can I Access or Remotely Manage My Server? How are Resources Shared: Disk Space, Memory, Processor? Is There Firewall or Other Traffic Filters Between My Server and the Internet? What Hardware is Used for Hosting the VPS? SSL FAQs What is SSL? Does Somee.com Offer SSL Certificates? What are Let's Encrypt SSL Certificates? What is a Certificate Authority? How long does enrollment take and how soon will I be able to secure my site? What is a certificate signing request or CSR? How do visitors know if a website is using SSL? Are There Any Costs Involved? What About Certificate Renewals? How Does Let's Encrypt Benefit My Website? How Do I Set Up a Let's Encrypt SSL Certificate on Somee.com? Is Let's Encrypt Trusted by All Major Browsers? Can I Use Let’s Encrypt for E-commerce Sites? What Happens to the SSL Certificate if I Change My Hosting Provider? Are There Any Limitations of Using Let’s Encrypt SSL Certificates? Windows Hosting FAQs What is Windows Hosting? Can I host my ASP.Net or .Net Core website? Which version of Microsoft .NET Framework do you support? Do you support Microsoft Access databases? Can I open a hosting account without a domain name? If I already own a domain, do I have to transfer it to you? Can I recover my website from your backups? What types of websites are best suited for Windows Hosting? Do you offer support for other programming languages and technologies besides ASP.NET and .NET Core? What is the uptime guarantee for your Windows Hosting service? What security measures are in place to protect my website and data? What is your policy on server maintenance and downtime? ASP.NET Hosting What is ASP.Net Hosting? What is ASP.NET Core? MS SQL Server Database FAQs What are the Benefits of Using SQL Server? What Applications Can Be Developed with SQL Server? What is Microsoft SQL Azure? What are the Hosting Options for SQL Server? Does SQL Server Have a Reporting Engine? Does SQL Server Support Spatial and Location Data? What are SQL Server's Integration and Migration Capabilities? Can Mobile Device Applications Use SQL Server? How is SQL Server Compact Licensed? Knowledge base Code samples MS Access Connect to MS access database usin DSN-less connection Email Sending email from ASP.Net page using local mail server Send an Email message using CDOSYS Send an Email message using CDOSYS and Google Apps mail servers Send Email via C# through Google Apps account Troubleshooting Web site errors General HTTP errors 500 Internal Server error for all ASP pages 404.17 Not Found. The requested content appears to be script and will not be served by the static file handler This page isn’t working (HTTP ERROR 500) in ASP.NET Core app ASP.Net Errors Library not found Scripts written with ASP.NET version 2.0 or higher return errors. I have uploaded files, but it showing “Site under construction” Session variables expire irregulary One of your services has been disabled because it used as a file storage MS SQL errors The media set has x media families but only 1 are provided Enterpise Manager connection hangs or has delayed response time Mail errors Unable to send email. Error: “No Server”. Unable to send email. Errors: (550) No relay, or (530) no authentication. MS Access errors Can not connect to MS Access database. Virtual servers Virtual server recovery Remote Desktop Connection ‘Internal Error has occurred’ What type of support provided for self-managed Virtual servers Free web hosting Why did my free MS SQL database got deleted and can I restore it? Why did my free website got deleted and can I restore it? Configuration Host a WCF service in IIS How to Register a new account Your Payment Options Keep your free account active Create a website Manage website Upload website content How to deploy Web project from Visual Studio Add a domain to your web site Manage default docments Grant write, modify, delete access rights on website's folder Upgrading from free to paid hosting Host a Non-English website Deploy MS SQL database Create an empty MS SQL database Manage MS SQL database Run SQL script Backup database Restore database Attach database Get database files Connect to database Manage backup location List database tables MS SQL Database connection string Upgrading from free to paid MS SQL hosting Manage email Add mail domain. Add SMTP account Add Mailbox Add MX record Setup mail client Create a Virtual Dedicated Server (VDS) Manage virtual server Access virtual server remotely Access virtual server with ESXi vSphere Client Protect Windows virtual server Upgrade virtual server Virtual server DNS management Pointing a domain name to your Virtual Server Manage your SSL certificates Free SSL certificates Export SSL certificate Bind free SSL certificate to a website on Windows VPS Deploy ASP.Net Core application Enable shadow copies for ASP.Net Core application Legal documents Terms of service Privacy policy Refund Policy

Create an empty MS SQL database

Instantiated MS SQL databases are not supported! But they still can be used if properly attached.

Before you'll be able to create a database on our server you'll need to acquire a web hosting package with MS SQL database support or standalone MS SQL hosting package at our store.

 

After you acquired desired hosting package, in "User menu" pane navigate to "User -> Managed products -> MS SQL -> Logins".  And create a MS SQL server login.

Than navigate to "User -> Managed products -> MS SQL -> Databases". You'll see a list of available MS SQL plans. Click on "Create" hyperlink.

Enter database name, select Login and MS SQL version and click on "Create empty database» button.

 

MS SQL database deployment is rather complicated process. With Doka panel we tried to make it as easy as possible. You, however, still need to understand what steps are involved in MS SQL database creation with Doka control panel:

1. Each of your databases will have a unique MS SQL server name, even if they are hosted on the same MS SQL server. This is done for flexibility reasons. It will ease a process of migration (if required) of your MS SQL database. For these reasons for each of your MS SQL database the system will add a single "A record" in our DNS servers, which you'll have to use for MS SQL Server name when connecting to the database. And because of DNS replication delays the MS SQL Server name may not be available for some time. 

2. For every MS SQL database, our system also creates a "Backup location". That's a place where you can store database files, database backups and database scripts. You will be able to FTP to the backup location to upload or download required files. You'll also be able to use a built in file manager to access it. Unique FTP address is created for every backup location and it's a subject to DNS replication delay too.

3. Finally, an empty database created on selected MS SQL server.

After that you'll be able to deploy your MS SQL database on our servers.

© Copyright 2024 Doka management panel