Last post Aug 13, 2009 12:59 PM by ssmurthy
Aug 10, 2009 05:43 PM|ssmurthy|LINK
I am using SQL Server express edition 2008 with Visual Studio 2005.When I am trying to create a new connection,it gives me the following error "Database schema could not be retrieved for this connection.Please make sure the connection settings are correct
and the database is online. This server version is not supported.You have to have Microsoft SQL Server 2005 Beta 2 or Later".
Do I have to change any settings for this connection?
I tried Installing the Service Pack too but it does not work!
Please help as I am not able to go ahead without creating the database.
Aug 10, 2009 06:21 PM|hugonne|LINK
You'll have to install this update for VS2005:
[EDIT] VS2005 doesn't have "out of the box" support for SQL Server 2008, so Microsoft has made an update to resolve that issue. There are still some limitations, so read carefully the notes on the download page.
Aug 11, 2009 11:25 AM|ssmurthy|LINK
When I try to install the patch it gives me this error msg "The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing or the upgrade patch may update a different version of the program.Verify
that the program to be upgraded exists on your computer and that you have the correct upgrade patch."
I am using VS 2005 Professional Edition and SQL Server 2008 (management studio) express edition(the free download one).
So I do not know if this works.
Aug 11, 2009 12:02 PM|hugonne|LINK
Are you sure you DO have VS2005 SP1 installed? It will only work on that version. To check it out, in VS, go to Help > About Microsoft Visual Studio
[EDIT] Here are the complete system requirements:
Check this page for more info, and let me know if it works.
Aug 11, 2009 12:40 PM|ssmurthy|LINK
I have the following in the Help->About Microsoft Visual Studio :
Microsoft Visual studi0 2005 Professional Edition.
Microsoft Visual Studio 2005
2005 Microsoft Corporation
All Rights Reserved
Microsoft .NET Framework Version 2.0.50727 SP 2
Microsoft Visual Web Developer 2005
Aug 11, 2009 12:52 PM|hugonne|LINK
Well, in fact it doesn't seem like you have SP for Visual Studio installed. You do have the SP for the .NET Framework 2.0, but that's a different thing. For instance, I have VS2008, and what I see is this:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Get the SP from here:
And if you have Windows Vista, you might need this as well:
SP1 installation for VS2005 is a very long process, so you'll have to be patient.
Aug 11, 2009 05:37 PM|ssmurthy|LINK
Finally it works!!!! Thanks a lot!!!!!!!
Aug 13, 2009 12:59 PM|ssmurthy|LINK
Is there a bug fix for the bugs in the above service pack?
I am not able to add tables or View the Table definitions in the "Server Explorer" tab in VS 2005.
Is there a bug fix to resolve this issue?