开发者

problem in connecting studio management to sql server

开发者 https://www.devze.com 2023-03-07 19:39 出处:网络
I had installed SQL Server 2008, but faced some complications with that. I then installed SQL Server 2005, and now installed SQL Server Management Studio for SQL Server 2005 successfully.

I had installed SQL Server 2008, but faced some complications with that. I then installed SQL Server 2005, and now installed SQL Server Management Studio for SQL Server 2005 successfully.

I am not able to connnect to the server name it suggests.

TITLE: Connect to Server

Cannot connect to POO开发者_开发技巧NAM-C586A95C\SQLEXPRESS.


ADDITIONAL INFORMATION:

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)

It doesn't show any other option of SQL Server name, though I changed the name as I remembered but for no good.

How can this be solved?


It sounds as if you're trying to connect to the 2008 instance with the 2005 SSMS. It's not clear whether you un-installed the 2008 instance.

Suggest installing the SQL Server 2008 SSMS.

Confirm/modify as needed that you're running the SQL Server instance that you require. This will show you which instances are available.

problem in connecting studio management to sql server


I would also check to make sure that you're connecting to the correct port. I'm come across a similar error before and the solution was to specify the port to connect to, i.e.

compname\instancename,portnum

0

精彩评论

暂无评论...
验证码 换一张
取 消