Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

After installing SQL server, how to configure SQL server?

April 26, 2017configure SQL Server

0

Posted

After installing SQL server, how to configure SQL server?

2 Answers

0

Posted

After Successful Installation of SQL Server 2005, Go to Start> All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration o Select SQL Server 2005 Surface Area Configuration then o Select Remote Connections under Database Engine then o Select Local and Remote Connections under this step select Using TCP/IP and named pipes Only then o Select Service under SQL server browser then o Select Automatic from Startup type then o Click on start button After that Start SQL Server Browser service from Administrative Tool Services. You can see the video of SQL server 2005 configuration.

0

Posted

After Successful Installation of SQL Server 2005, Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration o Select SQL Server 2005 Surface Area Configuration then o Select Remote Connections under Database Engine then o Select Local and Remote Connections under this step select Using TCP/IP and named pipes Only then o Select Service under SQL server browser then o Select Automatic from Startup type then o Click on start button After that Start SQL Server Browser service from Administrative Tool Services. You can see the video of SQL server 2005 configuration.