All am asking is, can SQL Server management studio express 2008 work on VS 2008 with SQL Server 2005 database? to administer it.
View Complete Post
Hi;WeÃÂ have a server running SQL Server 2005 Ent on a Windows Server 2003 platform.ÃÂ It runs just fine and I have no problem accessing any of the Business Intelligence services using SSMS 2005.
I recently upgraded my development PC to SQL Server 2008 as we'll be deploying it to our production servers in the next few days. I am able to access the Database Engine, SSAS and SSRS on the 2005 server with SSMS 2008, but when I try to log into Integration Services, I get the following error:
TITLE: Connect to ServerCannot connect to servername.ADDITIONAL INFORMATION:Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
Connect to SSIS Service on machine "servername." failed:Class not registered
Luckily I did not uninstall SSMS 2005, so I can still access it from there, but it would be nice if I could use just one client. I'm also afraid that this might happen after the production server gets upgraded. Thanks in advance for any help in resolving this.
is it ok to connect to sql server2008 server form sql server 2005 management studio. If yes, can you please let me know what should i do ?
i cant install sql server 2005 nor 2008 on my windows 7 os
i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,
can you plz help me??