Do I have the latest updates - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Do I have the latest updates

Author

Topic

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 10:51:18

select @@version
[code]
Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
May 26 2009 14:24:20
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I am trying to connect to a 2008 database from a 2005 database and it's saying I cannot. I Googled and it seems I should be able to.

Thanks,

Jim

Everyday I learn something that somebody else already knew

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-08-24 : 11:26:26

how are you trying to connect?
-in SSMS?
-in SSRS?
-in SSAS?
-using linked servers?
-in application
-in SQL using opendata
-in SQLCMD
-in...?

did you check the security issue?

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-08-24 : 11:26:48

and what are you trying to connect? :)

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 11:58:11

I'm starting in SSMS on 2005 and trying to connect to a database in SQL 2008 so that I can import a table using the wizard.

Thanks,

Jim

Everyday I learn something that somebody else already knew

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-24 : 12:10:28

SSMS 2005 can't connect to 2008. You'll need SSMS 2008

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-24 : 12:24:38

To answer your question about the latest updates, build 4053 is service pack 3 without any hotfixes. The minimum build everyone should be using on 2005 is 4262, which is the October critical security hotfix. We are actually running CU8, which is higher than 4262. CU10 was recently released too.

But the version of the 2005 engine is irrelevant to connecting to 2008. It's the client tool version that matters, which russell has answered.

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

Subscribe to my blog

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 12:34:39

Thanks everyone,
At least we can get up to date.

Thanks,

Jim

Everyday I learn something that somebody else already knew

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 13:22:42

The head IT guy says it can be done. He and I are technically in two different companies, but are merging, which is why they have stuff, like 2008, that I don't.

quote:

I can connect with both SSMS 2005 and the SQL tools that come with SQL 2000. Each of these environments has limited access to the features of 2008, but I can do basic operations. I wonder if this is an MDAC issue?

So what do I tell him to explain that he can connect and I just can't?

Jim

Everyday I learn something that somebody else already knew

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-24 : 13:31:27

What error are you getting? I don't see that listed in this topic.

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

Subscribe to my blog

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 13:40:59

TITLE: Connect to Server
------------------------------

Cannot connect to xxx

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------

Jim

Everyday I learn something that somebody else already knew

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-24 : 13:42:00

Send the head IT guy your error.

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

Subscribe to my blog

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 13:49:21

Already did, he just said that he can do it (connect to their 2008 from their 2005) so the problem is mine to solve. As you may have guessed, I'm not a dba.
Jim

Everyday I learn something that somebody else already knew

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-24 : 14:32:26

What version of SSMS are you running? Express? Maybe that's the issue. It does work fine on my Developer Edition client.

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

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-24 : 15:04:49

2008 can connect to all versions.
2005 can't connect to 2008.
2000 can connect to all versions.

I don't have developer edition, but for EE and SE what i posted above is true.

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 15:22:34

How can I tell what version I'm running?

Jim

Everyday I learn something that somebody else already knew

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-24 : 15:38:32

In management studio go to HELP / ABOUT

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-08-24 : 18:12:56

Does this help? It's all I got in the Help/About


Microsoft SQL Server Management Studio						9.00.1399.00
Microsoft Analysis Services Client Tools						2005.090.1399.00
Microsoft Data Access Components (MDAC)						2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML						2.6 3.0 5.0 6.0 
Microsoft Internet Explorer						7.0.5730.13
Microsoft .NET Framework						2.0.50727.1873
Operating System						5.2.3790

Everyday I learn something that somebody else already knew

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources