When browsing the database list inside Microsoft SQL Server Management Studio, you may get the error below:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Invalid column name 'mirroring_role'.
Invalid column name 'mirroring_state'.
Invalid column name 'mirroring_state'. (.Net SqlClient Data Provider)
One of the reasons for this error is that you are trying to connect to a final version of SQL Server 9.0 (SQL Server 2005) using a beta version of SQL Server Management Studio.
To be able to connect to a final release of SQL Server 2005, you also need the final release of SQL Server Management Studio, not the beta.
Nathan Pakovskie is an esteemed senior developer and educator in the tech community, best known for his contributions to Geekpedia.com. With a passion for coding and a knack for simplifying complex tech concepts, Nathan has authored several popular tutorials on C# programming, ranging from basic operations to advanced coding techniques. His articles, often characterized by clarity and precision, serve as invaluable resources for both novice and experienced programmers. Beyond his technical expertise, Nathan is an advocate for continuous learning and enjoys exploring emerging technologies in AI and software development. When he’s not coding or writing, Nathan engages in mentoring upcoming developers, emphasizing the importance of both technical skills and creative problem-solving in the ever-evolving world of technology.
Specialties: C# Programming, Technical Writing, Software Development, AI Technologies, Educational Outreach
