How To connect to Azure SQL "Database restricted" Server?

CristianAcostaCristianAcosta Posts: 1 New member
in SQL Doc
Hi there, I am having trouble to connect to an azure sql server. The thing is you can only connect to that server if you specify the database, otherwise you cant connect. The problem is the Connect form only allows me to specify the server, not the database, therefore it fails to connect. I thought to edit the file by my self to add a Database="databasename", yet I cannot save it to edit it if I cannot connect. Any help/Ideas?
Tagged:
· Share on Twitter

Answers

  • Kurt_MKurt_M Posts: 199 Silver 1
    Hi @CristianAcosta

    I assume you're trying to connect directly through SQL Doc. Instead of doing this, could I ask you to try connect via SSMS, where you can specify a database upon connection, and then use the Right Click > Document [server] option?




    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

    · Share on Twitter
Sign In or Register to comment.