Unable to access an Azure database from Visual Studio
-
I have an Azure database that I am trying to update through Visual Studio. I am an administrator on the portal. When I am at the Azure database dashboard and select open in Visual Studio it prompts me for the password of a previous developer/Administrator who is no longer on the project. I do not have the last administrator's password. It is possible that I would be able to access the old administrator's account and change the password so I can login as them from what I understand but I'm not sure. I do have the MSDN account but can only login with my user ID and PW. I do have the previous Administrators email and user ID for the MSDN account but don't have that password as well. When Visual Studio tries to open the previous Admin's user ID in defaulted in the login ID dialog. When I try to enter my id and password I receive a error dialog with the following message:
Cannot connect to ngl7ew5ap.datanbase.windows.net
Additional information
Login failed for user: 'myusername'.
This session has been assigned a tracing ID of 'd3f30e28-8c4b-bc06-4facc83c1d87. Provide this tracing ID to customer
support when you need assistance. (Microsoft SQL server, Error:18456) -
I have an Azure database that I am trying to update through Visual Studio. I am an administrator on the portal. When I am at the Azure database dashboard and select open in Visual Studio it prompts me for the password of a previous developer/Administrator who is no longer on the project. I do not have the last administrator's password. It is possible that I would be able to access the old administrator's account and change the password so I can login as them from what I understand but I'm not sure. I do have the MSDN account but can only login with my user ID and PW. I do have the previous Administrators email and user ID for the MSDN account but don't have that password as well. When Visual Studio tries to open the previous Admin's user ID in defaulted in the login ID dialog. When I try to enter my id and password I receive a error dialog with the following message:
Cannot connect to ngl7ew5ap.datanbase.windows.net
Additional information
Login failed for user: 'myusername'.
This session has been assigned a tracing ID of 'd3f30e28-8c4b-bc06-4facc83c1d87. Provide this tracing ID to customer
support when you need assistance. (Microsoft SQL server, Error:18456) -
There is one problem with your suggestion. I was just hired and am now the new Azure system administrator. I am the only one to do all of the work all by myself.
-
There is one problem with your suggestion. I was just hired and am now the new Azure system administrator. I am the only one to do all of the work all by myself.
So get some help...Connect Microsoft Support with your problem and the given token!!!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
There is one problem with your suggestion. I was just hired and am now the new Azure system administrator. I am the only one to do all of the work all by myself.
-
First of all, my problem was I was using the old Azure portal. Now when I went to server and selected reset password, changed the password, updated the password I was able to login to that database and server in visual studio. Now, because the database server was being used by a running application once that happened the application could not access the database. Doing a search for connection strings in the source code I found the original password, reset it back in Azure and everything now is good to go.
-
I have an Azure database that I am trying to update through Visual Studio. I am an administrator on the portal. When I am at the Azure database dashboard and select open in Visual Studio it prompts me for the password of a previous developer/Administrator who is no longer on the project. I do not have the last administrator's password. It is possible that I would be able to access the old administrator's account and change the password so I can login as them from what I understand but I'm not sure. I do have the MSDN account but can only login with my user ID and PW. I do have the previous Administrators email and user ID for the MSDN account but don't have that password as well. When Visual Studio tries to open the previous Admin's user ID in defaulted in the login ID dialog. When I try to enter my id and password I receive a error dialog with the following message:
Cannot connect to ngl7ew5ap.datanbase.windows.net
Additional information
Login failed for user: 'myusername'.
This session has been assigned a tracing ID of 'd3f30e28-8c4b-bc06-4facc83c1d87. Provide this tracing ID to customer
support when you need assistance. (Microsoft SQL server, Error:18456)I strongly suggest that you should consult customer support instantly with that error log snapshot.
-
I have an Azure database that I am trying to update through Visual Studio. I am an administrator on the portal. When I am at the Azure database dashboard and select open in Visual Studio it prompts me for the password of a previous developer/Administrator who is no longer on the project. I do not have the last administrator's password. It is possible that I would be able to access the old administrator's account and change the password so I can login as them from what I understand but I'm not sure. I do have the MSDN account but can only login with my user ID and PW. I do have the previous Administrators email and user ID for the MSDN account but don't have that password as well. When Visual Studio tries to open the previous Admin's user ID in defaulted in the login ID dialog. When I try to enter my id and password I receive a error dialog with the following message:
Cannot connect to ngl7ew5ap.datanbase.windows.net
Additional information
Login failed for user: 'myusername'.
This session has been assigned a tracing ID of 'd3f30e28-8c4b-bc06-4facc83c1d87. Provide this tracing ID to customer
support when you need assistance. (Microsoft SQL server, Error:18456)
