May 7, 2019 at 8:58 am
The database lies on Azure storage.
May 7, 2019 at 11:31 am
Connections should be exactly the same. What's the error?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2019 at 11:51 am
Hi Grant
This is the error I am getting.
TITLE: Microsoft SQL Server Native Client 11.0
------------------------------
Windows logins are not supported in this version of SQL Server.
<hr />
Regards
Priya
May 7, 2019 at 12:00 pm
Sounds like you're not logging in correctly to Azure then. You can only use Azure Active Directory, not the regular kind, or, a SQL login, which you say you don't have. It's also possible that you're hitting a firewall rule, but not if, from the same machine, you're connecting through SSMS. No, it sounds like SSMS is running under an account that has access and Visual Studio is not. Just change how it's logged in. Do a "run as". See if that works.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply