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?

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 --

Are you connecting to correct DB ?

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
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?
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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

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.

Member_2_7966113Author Commented:
Thanks Pawan
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.
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

From novice to tech pro — start learning today.