Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 How to Connect SQL Server 2008 using SQL 2005 M.S.

Author  Topic 

pin
Starting Member

4 Posts

Posted - 2009-01-29 : 00:15:37
Hello Friends,

How to connect sql server 2008 using SQL Server Management Studio Express 2005.

when i try to connect it gives me error that enable to connect sql server 2005. in fact i have install sql server 2008, but it try to connect with sql server 2005.

i also try to install "VS80sp1-KB954961-X86-INTL" update package, but when i run this update package it gives me error.

how to resolve this error.

please help me.

Thanks in advance,
Pin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-29 : 00:17:11
You can't connect to a SQL Server 2008 system using SSMSE 2005. Try using the 2008 client tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pin
Starting Member

4 Posts

Posted - 2009-01-29 : 00:23:50
did you mean Microsoft SQL Server 2008 Express ?

or other
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-29 : 00:25:37
Well what edition of SQL 2008 did you install?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pin
Starting Member

4 Posts

Posted - 2009-01-29 : 00:41:22
SQL Server 2008 Developer
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-29 : 00:44:16
Then you should have just the regular version of Management Studio.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pin
Starting Member

4 Posts

Posted - 2009-01-29 : 00:45:51
may i download management studio from the web.

or can use management studio 2005 after some setting or patch
Go to Top of Page

brianjensen
Starting Member

22 Posts

Posted - 2009-01-29 : 03:37:07
You can download the management tools for SQL 2008 from the SQL 2008 Express page.
But as tkizer said, if you installed developer edition, management studio should be included.
You cannot access SQL 2008 from Management studio 2005. :)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-29 : 15:14:07
Just install the client tools from your Developer edition installation media.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -