Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment

Page creation date :

summary

Notes for connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment.

ワークグループ環境下でクライアントから Management Studio で別 PC の SQL Server に接続する

Operation confirmation version

Supported SQL Server versions

  • 2008
  • 2008 R2

Check SQL Server version

  • 2008
  • 2008 R2

substance

※ Because it is a memo writing, please look at it as a reference degree.

environment

  • SQL Server version: 2008, 2008 R2
  • Workgroup environment
  • Server: Windows Server 2008 R2
  • If the server and client account passwords are different
  • Create an instance of a SQL Server database

condition

  • Sql Server authentication only allowed

establishment

* All server-side settings

Allow SQL Server authentication

From Management Studio, open the properties of the target database engine (the item at the root of object explorer) and set it from the "Security" item.

After the change, you need to restart the SQL Server service (from the Start menu, click the "SQL" tool from the Start menu to restart the
Server Configuration Manager and restart SQL Server (Instance Name) from the SQL Server service).

Remote connection permission

Set from the "Connection" item of the above property

Login permission for sa

Open the sa property from Root - Security - Login and set a password. Allow "Login" from the "Status" page

firewall

  • 1434 UDP ports allowed
  • Allow the following programs:
2008 C:\Program Files\Microsoft SQL Server\MSSQL10. Instance Name\MSSQL\Binn\sqlservr.exe
2008 R2 C:\Program Files\Microsoft SQL Server\MSSQL10_50. Instance Name\MSSQL\Binn\sqlservr.exe