Multi SQL Server (2000 & 2005) Problem

Hi All!

I setup MS SQL Server 2005 first and then I setup MS SQL Server 2000 with instance 'Myname' and the I created 2 database in SQL Server 2005 and 2000, When I Write an application in .NET 2005 to connect to MS SQL Server 2005 it ok, but it's not ok in sql Server 2000 and appear the error:

System.Data.SqlClient.SqlException: Snapshot isolation transaction failed accessing database 'TustenaOS' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at

How to connect to MS SQL Server 2000. Thanks

By "setup" did you mean install? Because it's usually avery bad idea to install a later version, then install a prior version. If that is what you did, I suspect things will never work the way you want them to.

|||

It looks like you are requesting snapshot isolation, and that's not a feature of SQL Server 2000.