Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

How to browse and test SQl server connection in Azure

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

How to browse and test SQl server connection in Azure

Postby blin » Fri Feb 09, 2018 3:56 pm

I setup Azure AD DS, SQL server and a VM in Azure for a small company. The client can login SQL Studio management and create databases. However, their application Miracle Service can't browse the SQL server.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: How to browse and test SQl server connection in Azure

Postby blin » Fri Feb 09, 2018 3:57 pm

From your description, I understand that the Miracle Service could not browse the SQL Server instance. If anything is misunderstood, please let me know.

In order to avoid confusion, I’d like to explain that Miracle Service is third party. And we do not know about it. So our Community is not the right media to work with it. But I will still provide my personal opinions.

Firstly, we need to confirm if Miracle Service support Azure SQL Databases and SQL Server Version. Secondly If we use SSMS to connect to Azure SQL, the server name should be something like ‘mynewserver20170313.database.windows.net.’ So in the Miracle Service, is there any option to specify the server name.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: How to browse and test SQl server connection in Azure

Postby blin » Fri Feb 09, 2018 3:58 pm

We are checking Miracle Service. Is there a way to test it to make sure we can access the instance? If the Miracle Service doesn't support SQL server 2017, what's our options?
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Re: How to browse and test SQl server connection in Azure

Postby blin » Fri Feb 09, 2018 3:58 pm

I use ODBC to test. It work. It must be the Miracle Service. Thank you.
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 6 guests