To allow access to users in a Windows domain
- Open the SQL Server Management Tool.
- Log in to the machine. This step presumes that you are the administrator of the computer and the SQL Server installation.
- In the Object Explorer window, expand the Security node.
- Right-click Logins and click New Login....
- Type in the name of the user to allow using the domain\username format.
- Click Search and use the dialog to confirm that the user is a Windows authenticated user. Then close the New Login dialog.
- In the Object Explorer pane, expand the Databases node.
- Expand the node of the database you want to grant access to.
- Expand the Security node of the database.
- Right-click the Users node and click New User.
- In the User name box, type in any name you want for the user.
- In the Login name box, type the name of the user using the domain\username format.
- In the Role Members list box, check the box of the role you want to grant the user for the database. Common options are db_dataread and db_datawriter.
Enable a Port
This is a one-time procedure that is performed on the computer hosting the SQL Server installation. You must instruct the computer to allow access to the machine through a specific port. The default set by SQL Server is 1433. If you change the default, follow the directions below and change the port number as appropriate.
To enable port 1433
- On the Start menu, click Control Panel.
- Under Security, click Allow a program through Windows Firewall.
Note: Alternatively, click Start, and in the Search box type Windows Firewall. If two versions appear, select the simpler version (that is "Windows Firewall" and not "Windows Firewall with Advanced Security." In the dialog box, click Allow a program through Windows Firewall.
- If prompted, click Continue. This presumes you are the administrator of the computer.
- In the Windows Firewall Settings dialog box, click the Add Port button.
- In the Name box, type a name, such as "SQL Server Port".
- In the Port number box, type 1433. Use the default protocol TCP.
- Click OK.
Start sql server browser service
Restart the SQL Server Service
Set a Protocol
This is also a one-time procedure performed on the computer hosting SQL Server. You must instruct SQL Server about which protocol to use when communicating with remote clients. This procedure uses the TCP/IP protocol.
To set the protocol
- Open the SQL Server Configuration Manager application. This is found in the Configuration Tools folder of the Microsoft SQL Server 2008 folder.
- Expand the SQL Server Network Configuration node.
- Click Protocols for MSSQLSERVER.
- If the Named Pipes Status is set to Disabled:
- Double-click the Named Pipes row.
- Set the Enabled property to Yes and click OK.
- Double-click the Named Pipes row.
- To stop and restart SQL Server:
- Open the SQL Server Management Studio application.
- Log into the computer. This presumes you are the administrator of the computer and the SQL Server installation.
- In the Object Explorer window, right-click the topmost node (by default, it is the name of the computer with a SQL Server version and other information) and click Restart.
- Open the SQL Server Management Studio application.
- If the TCP/IP Status is set to Disabled:
- Double-click the TCP/IP row.
- Set the Enabled property to Yes and click OK.
- Double-click the TCP/IP row.
0 comments:
Post a Comment