I have installed sql server 2000 and sql server 2005 in windows XP. In a Sql server 2000 enterprise manager, it shows two groups. The first one is local machine (Windows NT) and the second one is SQLEXPRESS (Windows NT).
I successfully set sql server and windows authentication by clicking Local (windows NT) properties and then security, but I can't able to set SQL Server and windows Authentication in SQLEXPRESS. It display message connection failed check SQL SERVER Registration
Morever When I used to set SQL Server & windows Authentication mode using SQL Server 2005 Management studio, it sets perfectly but when i fire a query just to know the version of sql server 2005 , it shows
"Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3) "
So in this case I can't able to restore my previous database that has been previously developed in sql server 2005.
Kindly help in this matter..
View Complete Post