Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How can I access SQL S...
Finance forum
Answered

How can I access SQL Server on UAT ?

Posted on by Microsoft Employee

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

  • M Anas Khan Profile Picture
    M Anas Khan 1,416 on at
    RE: How can I access SQL Server on UAT ?

    Another tip on connecting to the UAT SQL database:

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

  • Verified answer
    Angela B Profile Picture
    Angela B 30 on at
    RE: How can I access SQL Server on UAT ?

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

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

  • Suggested answer
    Umesh Pandit Profile Picture
    Umesh Pandit 9,102 User Group Leader on at
    RE: How can I access SQL Server on UAT ?

    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! :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I access SQL Server on UAT ?

    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]

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I access SQL Server on UAT ?

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

    thanks your support

  • Suggested answer
    RM-22040759-0 Profile Picture
    RM-22040759-0 2,014 on at
    RE: How can I access SQL Server on UAT ?

    Hi,

    Adding more information.

    You don't have any control over production database.

    Best Regards,

    Ravi Theja Madisetty

    https://technoguns.com

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,274 on at
    RE: How can I access SQL Server on UAT ?

    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. 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans