Azure SQL Server Login failed after Free-trial
I am currently using Azure for studies. My 30-day free trial is now over. However, I can see that after this free trial, there would be a period of another 11 months or so of free products, list in which SQL Server is included.
I have a SQL Server database hosted under this account and I can no longer access it. Would not it be included in this one year trial? Or should I start paying now? I want to use it for studies and I cannot pay much.
Password is correct, because I noted it down and I have it in my web.config. But I am still getting this error:
Login failed for user XXX. ... Error: 18456
According on the Azure free account document:
What happens once I use my $200 free credit or I’m at the end of 30 days?
We’ll notify you so you can decide if you want to upgrade to pay-as-you-go pricing and remove the spending limit. If you do, you’ll have access to free products.* If you don’t, your account and products will be disabled, and you'll need to upgrade to resume usage.
It gives you the answer. That's why you can't access your Azure SQL database.
You could upgrade to pay-as-you-go pricing and continue to use the Azure SQL database in the left 11 months for free.
Azure SQL database has many price tiers, if your database is not very large, you can change to the Basic price tier and only need 4.99$/month after one yeas later:
Hope this helps.
- inserting data into SQL DB from C# ASP.NET
- Fastest way to determine if record exists
- Create Index without name while creating table
- Unrecognized column name that I define
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?
- SQL copying data with new foreign keys
- SQL Server truncates decimal points of a newly created field in a view
- SQL Grouping and Nested Concatenation
- How to pull width & height out of string?
- How to delete, re-create, move, import, and export LocalDB databases?
- The locale identifier (LCID) 8192 is not supported by SQL Server
- SQL Server Initial database connection timeout in 30 seconds
- Why use a READ UNCOMMITTED isolation level?
- Recursive CTE and how to overcome circular reference error
- Select min or max based on where duplicate value exists
- Converting accented characters in varchar() to XML causing "illegal XML character"
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- Update SQL table using selection from another table
- Clarification on joins
- Foreign key constraint may cause cycles or multiple cascade paths?
- pyodbc cursor.fetchall() is returning "strange" values
- T-SQL Get File Extension Name from a Column
- How to do a cross-database-query join in SQLAlchemy?