How can I access SQL Server on UAT ?

(1) Share

Report

Posted on by Community Member

Hi All,

I already install sql server 2017 on SANBOX-2 UAT. But when I used a server name , username , password from LCS for access SQL Server on UAT. I can't access it.

Please support - How can I access SQL Server on UAT ? I want to backup sql data from sanbox-2 UAT to sanbox-1 But I can't access SQL Server so that I can't do this job.

If Our company go live in the future . Can I access sql server on production ?

Thanks

Pham

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi phongqn2000,

You don't need to install anything there. Tier-2 uses Azure SQL and you can connect to it using management studio and credentials from LCS.

Was this reply helpful? Yes No
Suggested answer

RM-22040759-0 2,014 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Adding more information.

You don't have any control over production database.

Best Regards,

Ravi Theja Madisetty

https://technoguns.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

After I install SQL I can access it. You are right I can using management studio for access database.

thanks your support

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Pham.

So you don't need to copy the UAT database to another instance? Where do you get the SQL Server connection string information on the LCS site?

dl

[quote user="phongqn2000"]

Hi All,

I already install sql server 2017 on SANBOX-2 UAT. But when I used a server name , username , password from LCS for access SQL Server on UAT. I can't access it.

Please support - How can I access SQL Server on UAT ? I want to backup sql data from sanbox-2 UAT to sanbox-1 But I can't access SQL Server so that I can't do this job.

If Our company go live in the future . Can I access sql server on production ?

Thanks

Pham

[/quote]

Was this reply helpful? Yes No
Suggested answer

Umesh Pandit 9,315 User Group Leader on at

Like (5)

Report
Copy link

Link copied!

Log in to LCS> Select the Environment> UAT>

Download the RDP file of AOS-1

Log in with Admin account.

Now Open SSMS> Database name can be found out in

Database Accounts of LCS> it has SQL Server\Database Name

So it will be like abc-test-appdbserver-212pp020

just copy this and add .database.windows.net

It this case this should be abc-test-appdbserver-212pp020.database.windows.net followed by SQLadmin user name and password from LCS! :)

Was this reply helpful? Yes No
Verified answer

Angela B 30 on at

Like (1)

Report
Copy link

Link copied!

".database.windows.net" - who knew!?

Thank you Umesh Pandit. I've been tearing out my hair for several minutes :D

Was this reply helpful? Yes No
M Anas Khan 1,424 on at

Like (0)

Report
Copy link

Link copied!

Another tip on connecting to the UAT SQL database:

https://dynamicsaxinsight.wordpress.com/2020/04/30/how-to-connect-to-sql-database-in-uat/

Was this reply helpful? Yes No