Scaffolding a database in SSMS within Visual Studio to deploy on Azure
I have created a database in Azure and connected it in SSMS, but when I try to scaffold it in Visual Studio I always get the same error which says:
login failed for 'user'.
Any tips on how I can successfully scaffold it?.
I tried disconnecting and reconnecting it again, and I also changed my login details and I still get the same error.
Solution
When I tried to reproduce your requirement in my environment, I got the same error login failed for user "username".
Steps to fix the issue:
- Go to your SQL Server in Azure Portal and Reset its Password.
- Open SSMS and enter your new credentials along with the Server name. Click on options=> Connection Properties=>Select your database in
Connect to data baseinstead of default.
- In Visual Studio, Go to
Tools=>Connect to database, check if the Test connection is Successful or not.
Finally, Run the below given Scaffolding command in Package Manager console in Visual Studio.
Scaffold-DbContext "Server=tcp:<yourservername>.database.windows.net,1433;Initial Catalog=<your_database_name>;Persist Security Info=False;User ID=<User_name>;Password=<your_newly_created_password>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
Model classes has been generated as shown below:
- Which of definitions of database schema is correct?
- How to get isolation level in EF for MSSQL?
- Generate SQL Create Scripts for existing tables with query
- Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
- Index for two columns that will be used in an operation on where clause?
- How do you update a datetime field in a table every time another field in the same table gets updated?
- Pros & Cons of TRUNCATE vs DELETE FROM
- comparing and contrasting Sybase and SQL Server
- How does sql server choose values in an update statement where there are multiple options?
- How to disconnect all users in sql server except sa?
- Select Consecutive Numbers in SQL
- SQL Find consecutive numbers in groups
- Spring Quartz configuration for connecting MS SQL server
- The most elegant way to generate permutations in SQL server
- Check column has 'letter' or '-' then bring value from another column
- Reading child XML node from column
- Combine JSON objects from multiple rows into a single object
- Find all stored procedures that reference a specific column in some table
- Laravel 10 stopped working with SQL Server Database
- Using TransactionScope around a stored procedure with transaction in SQL Server 2014
- Entity storing it's status as a FK to a status table. Can I update the FK once the status changes?
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- I need to replace old path's images to new path with the same image
- Format date as yyyy-mm-dd hh:mm:ss.000
- Does a foreign key automatically create an index?
- How do I select only the latest entry in a table for each group so each 'latest' is a single row?
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- Kafka Connect SqlServer Configuration (SSL)
- SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?
- TSQL Email Validation (without regex)