Introduction:
In this topic, I will explain steps to allow access of SQL server Database to other Computer when Windows Firewall is OFF.
Description:
In previous article, I explained about Restrict Database Access of User in SQL Server. (Please read this article to restrict access of user in shared database)
When you work with your team in single project then it becomes necessary to share SQL server database in many computer. By sharing database, all team members can work on same database which will increase productivity.
SQL server provides database sharing functionality in very easy to configure manner. You just need to follow some steps and you can allow access of any SQL server database to other computer.
Let's jump directly on steps to allow access of your SQL Server database :
1. From Start menu, open SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration from left pane and select protocol for which you like to allow access. It will open Protocol name and current Status of protocol in right pane.
3. In Right pane, from listed protocol select TCP/IP protocol and make it Enabled. You can use either of following ways to make protocol Enabled :
- Right click on TCP/IP protocol name and select Enable option.
- Double click on TCP/IP protocol name, it will open TCP/IP properties window. From opened window, select Protocol tab and set Enabled property to Yes and click Ok.
4. After completing above steps, you need to restart SQL Server Browser and SQL Server services. To restart services, go to Run and open services.msc. It will open Services window which includes all services currently available in computer.
5. From opened Services window, right click on SQL Server Browser and SQL Server services and select restart option which will restart both services automatically.
After restarting both services, any user can access SQL Server database.
In this topic, I will explain steps to allow access of SQL server Database to other Computer when Windows Firewall is OFF.
Description:
In previous article, I explained about Restrict Database Access of User in SQL Server. (Please read this article to restrict access of user in shared database)
When you work with your team in single project then it becomes necessary to share SQL server database in many computer. By sharing database, all team members can work on same database which will increase productivity.
SQL server provides database sharing functionality in very easy to configure manner. You just need to follow some steps and you can allow access of any SQL server database to other computer.
Let's jump directly on steps to allow access of your SQL Server database :
1. From Start menu, open SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration from left pane and select protocol for which you like to allow access. It will open Protocol name and current Status of protocol in right pane.
3. In Right pane, from listed protocol select TCP/IP protocol and make it Enabled. You can use either of following ways to make protocol Enabled :
- Right click on TCP/IP protocol name and select Enable option.
- Double click on TCP/IP protocol name, it will open TCP/IP properties window. From opened window, select Protocol tab and set Enabled property to Yes and click Ok.
4. After completing above steps, you need to restart SQL Server Browser and SQL Server services. To restart services, go to Run and open services.msc. It will open Services window which includes all services currently available in computer.
5. From opened Services window, right click on SQL Server Browser and SQL Server services and select restart option which will restart both services automatically.
After restarting both services, any user can access SQL Server database.
No comments:
Post a Comment