Can't connect to Azure SQL with error 18456
3
votes
2
answers
1387
views
I'm trying to grant access to my Azure SQL database (on an elastic pool) to an external developer using SQL Authentication.
In the database (not master) I ran the following commands:
create user [UserName] with password='Password', default_schema=[dbo]
alter role db_owner add member [UserName]
He can't access the database, he gets the error:
`Login failed for user 'UserName'. (.Net SqlClient Data Provider)
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536`
Both our IPs have been whitelisted, but only I can login to the database with those credentials. Any idea where things are going wrong?
Asked by user2637453
(141 rep)
Jul 23, 2020, 04:14 PM
Last activity: Jul 27, 2020, 09:20 AM
Last activity: Jul 27, 2020, 09:20 AM