Member Avatar for vishalrane

I am getting this error when i try to connect to the server...
Hot to rectify it...

"This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

Edited by vishalrane because: n/a
  • 4 Contributors
  • 6 Replies
  • 127 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by Netcode

Dani AI

Generated

Brief, practical troubleshooting for Management Studio / client–server version mismatches. Building on points from , and , below are the most reliable checks and fixes that resolve this class of problem.

  • Verify the Management Studio/client tool that is installed. Open SSMS and use Help -> About, or check Programs and Features for installed “SQL Server Management Studio” entries to identify the exact client build.
  • Remove leftover components from earlier installs before reinstalling. Use Programs and Features to uninstall any SQL shared components (Shared Management Objects, Native Client, client tools). If an entry cannot be removed, use Microsoft’s program install/uninstall troubleshooter or the SQL Server setup maintenance/uninstall options.
  • Try Repair first; if that fails do a clean uninstall of client tools, reboot, then install the matching SSMS or the latest standalone SSMS from Microsoft. Newer SSMS builds are generally backward-compatible and often fix dialog/compatibility problems without touching the server instance.
  • Confirm instance and network settings. Use SQL Server Configuration Manager to ensure the right protocols (TCP/IP) are enabled and SQL Browser is running for named instances. Verify the server/instance name and any custom port when connecting.
  • Before doing any server uninstall/reinstall: back up all system and user databases and note service accounts. Uninstalling an instance can remove databases. Collect setup logs (SetupBootstrap\Log under the Microsoft SQL Server folder) and SSMS logs if problems persist.

Typical root cause is mixed-version client/shared libraries left behind after a newer install was removed. A targeted uninstall of those shared components followed by installing a single SSMS build (or using the latest standalone SSMS) resolves it in most cases.

Recommended Answers

All 6 Replies

Member Avatar for debasisdas

To which version of SQL Server you are trying to connect to using Management Studio Express ?

Member Avatar for vishalrane

sql server 2005

Member Avatar for sandeepparekh9

i think you are trying to connect to sqlexress instance of sql 2008 server.

do u have sql 2008 installed???

Member Avatar for vishalrane

I was having 2008 but i have removed it...
still getting error...

Member Avatar for vishalrane

Reinstalled SQL Server 2005.....

Member Avatar for Netcode

i think you should reintall the server 2008

commented: i was having 2008 because of which problem arised... -1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.