Connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment
Notes for connecting from a client to SQL Server on another PC in Management Studio in a workgroup environment.
Operation confirmation version
Supported SQL Server versions
- 2008 R2
Check SQL Server version
- 2008 R2
※ Because it is a memo writing, please look at it as a reference degree.
- 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
- Sql Server authentication only allowed
* 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
- 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|