Hi
I already Install the MS Sql server 2005 into my machine,but I want to install the Sql server 2008 into my machine.I want to install the sql server into "D:" Drive, because of few space available in "C:" drive.
1)Can I install sql server 2008 into "D:" drive?
2)If I install the sql server 2008 it effect to sql server 2005.
1) You can install it anywhere you want to
2) You can install them side-by-side but the tools are installed in a common location so you can only have one version of them. The SQL2008 tools are backward compatible so you want to install their version of the tools and not sql2005:
http://stackoverflow.com/questions/175881/sql-server-express-2008-install-side-by-side-w-sql-2005-express-fails
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.