Azure SQL Database Access Denied

Hello Experts,

I have just created a Azure SQL Database. I think connect to the database via Microsoft SQL Server Management Studio as Administrator, but I keep on getting the message shown in the image. Even though I created the database.. can someone let me know how to get around this issue?

access
Cheers
LVL 1
Member_2_7966113Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
Please check this --

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms

Are you connecting to correct DB ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Member_2_7966113Author Commented:
Hi Pawan

Thanks for responding.

I only have one database
0
Member_2_7966113Author Commented:
Hi Pawan,

In the document it states
If you forget your server login information, navigate to the SQL Database server page to view the server admin name

I can't see where I can find the server admin name?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Pawan KumarDatabase ExpertCommented:
Check in the azure.
0
Member_2_7966113Author Commented:
ok, so I've got the server admin login, but I'm still getting the same message
0
Pawan KumarDatabase ExpertCommented:
same error?
0
Member_2_7966113Author Commented:
yes, same error
0
Member_2_7966113Author Commented:
Ahhhh...

Just found out the problem. I was attempting to create a table in the system database as opposed to the database I created, see image.

access
0
Member_2_7966113Author Commented:
Thanks Pawan
0
Pushpakumara MahagamageVPCommented:
log on your azure portal
Go to SQL Databases ----> and Then your database
and find connection string and click it, there you can find the username.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.