I already had the SQL Server 2008 Express engine installed (just the bit that comes with VS 2008 Express). I then installed SQL Server 2005 Express followed by SQL Server 2005 Management Studio Express, all of which seemed to install OK without any errors. However, when I run SQL Server 2005 Management Studio and enter the Server name as machine name\SQLEXPRESS and click Connect I get the message:
"This version of SQL Management Studio Express can only be used to connect to SQL Server 2000 and 2005 servers".
Presumably the instance name SQLEXPRESS refers to the 2008 version, is the 2005 instance a different name, or is it a different problem? Any ideas please, thanks
SQL Server 2005 Express installed after SQL Server 2008 Express
sql serversql-server-express
Related Topic
- Sql – How to return only the Date from a SQL Server DateTime datatype
- Sql-server – How to check if a column exists in a SQL Server table
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql-server – LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- Javascript – How to connect to SQL Server database from JavaScript in the browser
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- Sql – Exporting data In SQL Server as INSERT INTO
- Sql – How to UPDATE from a SELECT in SQL Server
Best Answer
You are right that the SQL 2008 Express took the 'SQLEXPRESS' instance name. The 2005 toolset cannot connect to 2008. You need to find out the isntance name under which the 2005 VS installed it's Express. Easiest way is to start the Service Manager (run
services.msc
)and see the instance name there.