Can SQL Server 2000 and 2005 coexist on the same development computer? Or do
I really need to have one or the other.
Thanks!Yes, they can both be on the same computer as different instances names.
Install SQL 2000 first.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jeremy S." <A@.B.COM> wrote in message
news:uar$azXcGHA.3344@.TK2MSFTNGP03.phx.gbl...
> Can SQL Server 2000 and 2005 coexist on the same development computer? Or
> do I really need to have one or the other.
> Thanks!
>|||Thanks Roger. I already have 2K installed as the "default instance". Do I
have to modify that installation in any way, or can I just proceed now to
install 2K5 as a different instance?
-J
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uuAsI2XcGHA.5016@.TK2MSFTNGP04.phx.gbl...
> Yes, they can both be on the same computer as different instances names.
> Install SQL 2000 first.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Jeremy S." <A@.B.COM> wrote in message
> news:uar$azXcGHA.3344@.TK2MSFTNGP03.phx.gbl...
>|||No just install 2005
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jeremy S." <A@.B.COM> wrote in message
news:OIm8M4XcGHA.2188@.TK2MSFTNGP05.phx.gbl...
> Thanks Roger. I already have 2K installed as the "default instance". Do I
> have to modify that installation in any way, or can I just proceed now to
> install 2K5 as a different instance?
> -J
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:uuAsI2XcGHA.5016@.TK2MSFTNGP04.phx.gbl...
>|||Great. Now one last followup question before I install 2K5: How do my apps
"know" which particular installation of SQL Server is to be used? Do I have
to tell 2K to listen on one port while 2K5 listens on another port number -
and then specify the port number in my app's connection string? Or can it be
simpler than that?
-J
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uxfeHBYcGHA.3388@.TK2MSFTNGP05.phx.gbl...
> No just install 2005
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Jeremy S." <A@.B.COM> wrote in message
> news:OIm8M4XcGHA.2188@.TK2MSFTNGP05.phx.gbl...
>|||Hi.
If your 2K is you main instance you will access it through you computer
name most likely, with your second instance being accessible via the
slash notation, i.e. MACHINENAME\{INSTANCENAME}
If you don't remember which instance name you gave your SQL 2005
instance, just open up the SQL Server Service Manager (or start it if
you don't see it in the start bar), and use the server drop down to see
the name of your second (2005) instance.
Hope this helps
Andrew la Grange
BUSINESS ARTISTS
Systems / Solutions / Consulting
--
Web: http://www.businessartists.co.za
--|||Having read these posts, I am thinking to begin to learn 2K5. Is there a
conversion of the database if I move it from 2K to 2K5?
"Roger Wolter[MSFT]" wrote:
> No just install 2005
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Jeremy S." <A@.B.COM> wrote in message
> news:OIm8M4XcGHA.2188@.TK2MSFTNGP05.phx.gbl...
>
>|||OK to cancel this question. Have researched answer. Thanks...
"richardb" wrote:
> Having read these posts, I am thinking to begin to learn 2K5. Is there a
> conversion of the database if I move it from 2K to 2K5?
> "Roger Wolter[MSFT]" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment