How to access SQL Server on Tier 2 or Tier 4 environment

(0) Share

Report

Posted on by Yuji

4,131

Hi,

Is it possible to access the SQL Server environment on Tier 2 or Tier 4 environment? I would like to capture and monitor the SQL Server to trouble shoot some performance issue. The LCS insight does not provide enough information.

Thanks,

I have the same question (0)

All responses (3)

Answers (2)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

I think on tier 2 environment it is still possible to log in to SQL server .

Was this reply helpful? Yes No
Verified answer

mhdshb1 1,250 on at

Like (0)

Report

Hi Yuji

For Tier 2 environment you can access it through management studio

this is a related post on how you can connect

community.dynamics.com/.../806419

Regards,

M

Was this reply helpful? Yes No
Verified answer

Fangyuan Hou on at

Like (0)

Report

Yes. for Tier2 and above sandbox environment you can connect to database using SSMS.

It is Azure SQL Server, you can connect follow below docs. In LCS, under environment details you should be able to see server name.

docs.microsoft.com/.../sql-database-connect-query-ssms

Regarding the performance troubleshoot in LCS, please see below docs.

docs.microsoft.com/.../performancetroubleshooting

Was this reply helpful? Yes No