SQL 2005 remote login

[Former Member]

Hi there,

Could you let me know me - how do you configure / disable remote logon for SQL 2005. Are <sid> and SAP<SID>DB allowed to logon remotely?

Thank you!

Sim

[Former Member · Accepted solution]

Hi Joey,

I was referring to remotely login using the SQL Management Studio.

1. Are the OS users <sid>adm/SAPService<SID> allowed to remote login?

2. Are the SAP DB users <sid> / SAP<SID>DB allowed to remote login?

if yes, how to disable that?

Thank you!

[Former Member · Accepted solution]

Hi,

if you want to disable remote login on sql server 2005 do following

-> Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

->On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

->On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections

if you only allowed local connection then check local connections only. apply

regards,

kaushal

[Former Member · Accepted solution]

Hi Kaushal,

Thanks so much! Sorry I was not able to reply earlier.

[Former Member]

Do you mean the SIDADM and SAPServiceSID users?

These are domain users.

You can limit remote logon in Active Directory.