Hello,
I am trying to connect an Azure Resource-type SQL Server to my SQL Management studio.
In SQL Management studio i am using
type: database engine
name: .database.windows.net.1433 " plus my server name"
auth: SQL Server Auth
username: azure sql server name
password: azure sql server password
After trying to connect for about 20 sec. this pops up.
............................................................................................................
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
..............................................................................................................
Any help would be appreciated.