question

pits avatar image
pits asked

server access

Hello, Can I access sql 2008 enterprise edition database from sql server 2005 standard client? if yes then 2005 standard client should have service pack 2 or 3? does it require Cumilative Updates ...if yes which? please let me know the details? rgds,
sql-server-2005sql
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
Yes. As far as service packs, your client tools should always be maintained at the latest service pack: [Service Pack 4][1] at this time. [1]: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b953e84f-9307-405e-bceb-47bd345baece
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thanks,which features of sql 2008 entp edition can not be accessed by sql 2005 standard client ?...replication? what else?
0 Likes 0 ·
In addition to replication, you'll also lose access to maintenance plans and a few other odds and ends that don't come right to mind. Even for the features that work, the Object Explorer Details screen will not populate with details. You might be happier if you install the SQL 2008 client tools.
0 Likes 0 ·
"the Object Explorer Details screen will not populate with details"... and, more confusingly, some features appear in different places within the Object Explorer, depending on the version of Server to which you are connected. Grr.
0 Likes 0 ·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
According to **[this blog][1]** you need the latest cumulative updates to SQL Server 2005 SP2 or later. But as @KenJ says - you should already have SQL Server 2005 SP4 installed, so that shouldn't be a problem :) [1]: http://blogs.msdn.com/b/howard_dierking/archive/2008/06/17/connect-sql-server-2005-ssms-to-sql-server-2008.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Yes, you can. However, you won't have access to any GUI functionality that's new in 2008; but you will still be able to do it the hard way (ie by writing T-SQL to do the job...) Here's the list of "[What's new in SQL 2008][1]" [1]: http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What, you mean like using the SQL2008 client to manage SQL2005 servers? In theory, the behaviour should degrade; however, I have noticed a few places where things don't quite hang together as they should! I generally install the client tools for each version that I'm currently managing - on this machine, therefore, I have SQL 2000,2005 & 2008 clients.
2 Likes 2 ·
thank you all,for your valuable inputs, is it that the lower to higher edition data base access is not recommended?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.