Geek asks and answers

Azure Login failed for user? System.Data.SqlClient.SqlException

Azure database and Azure site created. It uses the connection string provided by the Azure site and is populated with a password. When I try to access the database through the application, an error is returned

Login failed for user 'stefan'. System.Data.SqlClient.SqlException: Login failed for user 'stefan' In this session, the trace identifier "6ee9a27b-4be7-494b-aadd-7b05a8a3bddb" was assigned. Provide this trace identifier for customer support when you need help.

if you visit http://clickpc.azurewebsites.net/ you can see the error for yourself.

I can believe that access is denied in the IP IP address configuration for the node IP address

I allowed connections to Azure in the database, but it looks like access is denied

+5
source share
2 answers

Managing entries in the Azure SQL world is unfortunately difficult. For example, SQL Server Management Studio does not allow adding new logins and users through a graphical interface. Things must be done using T-SQL.

To start, when you first created the database using the Azure Portal, did you use Stefan as your login? This is important because Stefan assumes the dbo (admin) database role. Otherwise, you need to create new users and assign permissions.

-, Azure "". -, Stefan. , . , Studio SQL Azure db, Stefan. Microsoft : SQL Azure SQL Database

+1

, / . , :

. "XXXXXXXXX", . IP- "XXXXXXXXX" . , Portal Azure Portal sp_set_firewall_rule IP- . .

, SQL Azure - , : stefan @xxxxxxx

, SQL Azure

0

More articles:


All Articles