This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers

sql-server-2005-express
Avani Soni picture Avani Soni · Jul 12, 2013 · Viewed 9.6k times · Source

I have installed SQL Server Management Studio Express 2005 in windows 7.

SERVER TYPE: Database Engine
SERVER NAME: Avani-PC\SQLEXPRESS
AUTHENTICATION: Windows Authentication
USER NAME: Avani-PC

when I click on connect I found the following Error:

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)

Answer

Jared picture Jared · Aug 5, 2013

I just ran in to this issue as well but then was able to find the solution. You just need the newer version of SSMSE which is now 2008! Here's the MS download page:

http://www.microsoft.com/en-us/download/details.aspx?id=7593

Related questions

How to change identity column values programmatically?

I have a MS SQL 2005 database with a table Test with column ID. ID is an identity column. I have rows in this table and all of them have their corresponding ID auto incremented value. Now I would like to …

Read More
Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am trying to deploy my website on windows server 2003. Am i missing something or what is wrong from the following error message, how can I correct it? Thank I am having the error message: A connection was successfully established …

Read More
How can I join on a stored procedure?

I have a stored procedure that takes no parameters, and it returns two fields. The stored procedure sums up all transactions that are applied to a tenant, and it returns the balance and the id of the tenant. I want …

Read More