I'd like to add that I've updated all the references in my project to SQL 10.0
-
Hello,
I am just getting started evaluating 2008 (July CTP) with our existing codebase. When I connect to the server to initiate the process of installing our database, I get the following exception:
{"This SQL Server version (10.0) is not supported."}. Could this be related to my workstation not having an up to date .NET framework?
The code to connect is:
.....
Microsoft.SqlServer.Management.Smo.Server server = null;
try
{
SqlConnection sqlConnection = new SqlConnection(@."Integrated Security=SSPI; Data Source=" + tserver);
//build a "serverConnection" with the information of the "sqlConnection"
Microsoft.SqlServer.Management.Common.ServerConnection serverConnection =
new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection);
//The "serverConnection is used in the ctor of the Server.
server = new Server(serverConnection);
// The actual connection is made when a property is retrieved so try to get version.
// an error means could not connect, most likely due to security
//string x = server.Information.Version.ToString();
System.Version x = server.Information.Version;
}
catch(Exception ex)
{
server = null;
Errors = "Unable to connect to the " + tserver + " server.\r\n" + ex.Message;
}
......
You probably need to use the updated assemblies. After installing SQL Server 2008, you will find them in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies.
In particular Microsoft.SQLServer.Smo.dll|||My problem was that I missed updating the assemblies in a couple of the DLL's in the project, which caused the problem.
