i had sqlserver2000 (including the enterprise manager and desktop engine) and .net 2003 installed in my development machine, I developed a vb.net application that communicates with a locally hosted mssql db.
recently i had .net 2005 and MS Server 2005 installed, then I converted my application in .net 2005, after, I started having problem deploying the application and db together to client machine and even on my own development machine, it's all database communication sort of problems. (now i have SQL Server Management Studio Express CTP installed)
Did i make any mistake? should i uninstall sqlserver2000, .net 2003 before installing server2005 and .net 2005?
btw, in my explorer, C:\Program Files\Microsoft SQL Server, i have 5 subfolders: "80", "90", "MSSQL", "MSSQL.1" and "MSSQL$SETUPTESTAPPINS". i know that 80 and MSSQL are the folders for server2000, 90 and MSSQL.1 are probably server2005 folders. but what is "MSSQL$SETUPTESTAPPINS"? from the readme.txt i found it's related to server2000, but what is it about?
also, in my registry, HKEY_Local_Machine/Software/Microsoft/Microsoft SQL Server/, the value of "InstalledInstances" is MSSQL SETUP TESTAPPINS SQLEXPRESS, after i removed SQLServer2000 stuff, the key value became "SETUP TESTAPPINS SQLEXPRESS", Now i dont have server2000 in my system anymore, how come SETUP TESTAPPIN is still there?
sorry for my bad explanation, plz help
This question might be better answered in the Setup forum, but from what I can gather from your statements, I don't think you did anything wrong. SQL Server 2000 and SQL Server 2005 will coexist on a single machine, as will the .NET versions. That may be where your issue is.
If you can post the specific errors you're seeing, that might a better place to start.
Buck Woody
|||Hi,
Yes SQL 2000 and SQL Express / 2005 can coexists, i have MSDE and SQL Express installed on my system, it works without any problem.
Can you post error message from Windows Event Viewer and SQL Server Error Log
Hemantgiri S. Goswami
No comments:
Post a Comment