Share via

Hi Team we are using sql 2008 R2 problem is that after some time instance unable to show in sql

Rahul Borate 21 Reputation points
2021-01-17T14:37:47.597+00:00

Dear Team,

we are using sql 2008 r2 after restart SQL Server Browser after that sql instance show in sql . this issue happen frequently ,Please suggest

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,376 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,264 questions
Accepted answer
  1. Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee
    2021-01-17T16:25:56.87+00:00

    I would suggest you upgrade to a supported version, 2008R2 hasn't been in mainstream support for 8 years.

    To your specific issue, if you can't find the instance without browser running then you're using dynamic ports. Set the port to be default as 1433 and you shouldn't have the issue. If you want to keep using browser, then make sure it stays running. Look into the windows event logs to see why it is stopping.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2021-01-18T02:56:49.113+00:00

    Hi @Rahul Borate ,

    after some time instance unable to show in sql.

    Could you please describe your problem more specifically?
    Do you mean the instances is not displayed in SQL Server configuration Manager after restarting SQL Server Browser? Or the instances cannot be displayed and connected in SSMS?
    Are there any error messages in error log which are located in Program Files\Microsoft SQL Server\MSSQL10_50. \MSSQL\Log?
    Please try to install the latest SP for SQL Server 2008 R2.

    Best Regards,
    Amelia