Newbie Question

Hello,

I am very new to .NET and have just installed Visual Studio
2005 on a 
newly reformatted laptop.  I see that is come with SQL
Server 2005, I 
still need to support some of the application that I built
in a 
different language that were based on SQL Server 2000.  Can
I install 
SQL 2000 on the same machine without any issues? 

Thanks

Mike





Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com

Mike,

You can safely run SQL2000 and SQL2005 on the same box.  I
do this in dev
and production without any problems.

Bill

-----Original Message-----
From: bounce-aspnet-58372aspadvice.com
[mailto:bounce-aspnet-58372aspadvice.com] On Behalf Of
Mickael
Sent: Monday, May 29, 2006 10:28 AM
To: aspnetaspadvice.com
Subject: [aspnet] Newbie Question

Hello,

I am very new to .NET and have just installed Visual Studio
2005 on a 
newly reformatted laptop.  I see that is come with SQL
Server 2005, I 
still need to support some of the application that I built
in a 
different language that were based on SQL Server 2000.  Can
I install 
SQL 2000 on the same machine without any issues? 

Thanks

Mike





Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com


Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com

yes you can!

that version of SQL Server 2005 Express default installs to
(localhost)\SQLExpress

So, as long as you don't want to call your SQL 2k
(localhost)\SQLExpress, you shouldn't have any problems.

The SQL 2k could run on localhost or another named instance
such as
(localhost)\sql2k

Dwight.

On Mon, 29 May 2006 13:27:54 -0400, "Mickael"
<mikeefactory.ca> said:
> Hello,
> 
> I am very new to .NET and have just installed Visual
Studio 2005 on a 
> newly reformatted laptop.  I see that is come with SQL
Server 2005, I 
> still need to support some of the application that I
built in a 
> different language that were based on SQL Server 2000. 
Can I install 
> SQL 2000 on the same machine without any issues? 
> 
> Thanks
> 
> Mike
> 
> 
> 
> 
> 
> Need SQL Advice? http://sqladvice.com
> Need RegEx Advice? http://regexadvice.com
> Need XML Advice? http://xmladvice.com
-- 
  Dwight H. Barbour
  .NET Community Builder
  Section 508 and ASP.NET Educator and Developer
  dbsdbsolutions.net



Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com

Yes...I have at least 3 machines with both. None have an
issue with it.
However, you can use 2005 Studio Manager to connect to a SQL
2005 and
administer it. I went that route when 2005 came out just so
I could get use
to the new IDE for 2005.

David

-----Original Message-----
From: Mickael [mailto:mikeefactory.ca] 
Sent: Monday, May 29, 2006 12:28 PM
To: aspnetaspadvice.com
Subject: [aspnet] Newbie Question

Hello,

I am very new to .NET and have just installed Visual Studio
2005 on a 
newly reformatted laptop.  I see that is come with SQL
Server 2005, I 
still need to support some of the application that I built
in a 
different language that were based on SQL Server 2000.  Can
I install 
SQL 2000 on the same machine without any issues? 

Thanks

Mike





Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com






Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com

hi Mickael
I'm not sure...I'm sure u can install SQL 2005 as another
instance in the
same PC where is installed SQL 2000

try to Install SQL 2000 as another instance different as
"default"

Regards

On 5/29/06, Mickael <mikeefactory.ca> wrote:
>
> Hello,
>
> I am very new to .NET and have just installed Visual
Studio 2005 on a
> newly reformatted laptop.  I see that is come with SQL
Server 2005, I
> still need to support some of the application that I
built in a
> different language that were based on SQL Server 2000. 
Can I install
> SQL 2000 on the same machine without any issues?
>
> Thanks
>
> Mike
>
>
>
>
>
> Need SQL Advice? http://sqladvice.com
> Need RegEx Advice? http://regexadvice.com
> Need XML Advice? http://xmladvice.com
>



-- 
MSc.Hassan Arteaga Rodríguez
Microsoft Certified System Engineer
IT Specialist.
ColdFusion & .NET Programmer



Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com