Many thx !
Yan,
As long as the usb external disk looks local to the operating system, then
you should be able to do this. However, remember that disk performance may
be less than a local IDE or SCSI disk.
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Actually, I've heard that USB2 drives perform very well in comparison to
their IDE cousins--especially on laptops where the drives are painfully
slow.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Thomas Carey, r." <tcarey@.Online.microsoft.com> wrote in message
news:ImZAAG%23kEHA.2936@.cpmsftngxa10.phx.gbl...
> Yan,
> As long as the usb external disk looks local to the operating system, then
> you should be able to do this. However, remember that disk performance
> may
> be less than a local IDE or SCSI disk.
> Please reply only to the newsgroup so that others can benefit. When
> posting,
> please state the version of SQL Server being used and the error
> number/exact
> error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||thank you very much !!!
>--Original Message--
>Yan,
>As long as the usb external disk looks local to the
operating system, then
>you should be able to do this. However, remember that
disk performance may
>be less than a local IDE or SCSI disk.
>Please reply only to the newsgroup so that others can
benefit. When posting,
>please state the version of SQL Server being used and
the error number/exact
>error message text received, if any.
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
sql
Thursday, March 29, 2012
Can i install MS SQL Server in Novell 5
Hello All,
does anyone know if MS SQL SERVER 2000 can be installed on Novell 5, and if there are any challenges that need to be considered.
Thanks to all,
SammySQL Server installs only on Windoze. It works nicely in a Novell network, but it won't install on a Novell server.
-PatP|||thanks Pat, much appreciated
does anyone know if MS SQL SERVER 2000 can be installed on Novell 5, and if there are any challenges that need to be considered.
Thanks to all,
SammySQL Server installs only on Windoze. It works nicely in a Novell network, but it won't install on a Novell server.
-PatP|||thanks Pat, much appreciated
Can I install more then one copy of MSDE on a server?
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||Yes, you can. It just requires a different instance name than the other
installed instances.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||That depends on the app. The app may expect a particular instance name, for
example.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>> Or can I just use the same MSDE for the new app.? Can MSDE have more the
>> one DB?
>>
>> TIA,
>> Clayton
>>
>> "Clayton" <none@.none.com> wrote in message
>> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same
>> server. The new app. also needs MSDE. My question is can I install and
>> run more then one copy of MSDE? Is there anything I need to know about
>> doing it?
>>
>> TIA,
>> Clayton
>>
>
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||Yes, you can. It just requires a different instance name than the other
installed instances.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||That depends on the app. The app may expect a particular instance name, for
example.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>> Or can I just use the same MSDE for the new app.? Can MSDE have more the
>> one DB?
>>
>> TIA,
>> Clayton
>>
>> "Clayton" <none@.none.com> wrote in message
>> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same
>> server. The new app. also needs MSDE. My question is can I install and
>> run more then one copy of MSDE? Is there anything I need to know about
>> doing it?
>>
>> TIA,
>> Clayton
>>
>
Can I install more then one copy of MSDE on a server?
Yes, you can. It just requires a different instance name than the other
installed instances.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||That depends on the app. The app may expect a particular instance name, for
example.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||That depends on the app. The app may expect a particular instance name, for
example.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>sql
installed instances.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||That depends on the app. The app may expect a particular instance name, for
example.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>|||That depends on the app. The app may expect a particular instance name, for
example.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>sql
Can I Install Enterprise edition on Windows 2000 Server as in Small Business Ser
Hi.
We have Windows 2000 Small Business Server
In control panel/System the operating system is identified
as
Windows 2000 server service pack 4
Microsoft pages on System requirements for SQL Server
Enterprise edition says requires Windows 2000 Server
The operating system I have seems to be Windows 2000
Server even though it has some junk in it making it
Windows 2000 Small Business Server.
Question can i Install SQL Server 2000 Enterprise?
I need this because i need to use Indexed Views which do
not exist in Sql Server standard edition.
THe answer varies depending on whome i ask at Microsoft.
Apreciate any advice.Hi
There is no mention of SBS on the system requirements at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
even though SQL Server comes with it!!
I have never tried installing this onto a specific SBS system, so can not be
100% but I am pretty sure that it is no different. If you do help/about
windows in Windows Explorer and it says Microsoft (R) Windows Version 5.0
then I don't think there would be any reason for it not to.
John
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>|||Please do not post the same message independently in different newsgroups, I
posted an answer in .setup.
--
Jacco Schalkwijk
SQL Server MVP
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>
We have Windows 2000 Small Business Server
In control panel/System the operating system is identified
as
Windows 2000 server service pack 4
Microsoft pages on System requirements for SQL Server
Enterprise edition says requires Windows 2000 Server
The operating system I have seems to be Windows 2000
Server even though it has some junk in it making it
Windows 2000 Small Business Server.
Question can i Install SQL Server 2000 Enterprise?
I need this because i need to use Indexed Views which do
not exist in Sql Server standard edition.
THe answer varies depending on whome i ask at Microsoft.
Apreciate any advice.Hi
There is no mention of SBS on the system requirements at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
even though SQL Server comes with it!!
I have never tried installing this onto a specific SBS system, so can not be
100% but I am pretty sure that it is no different. If you do help/about
windows in Windows Explorer and it says Microsoft (R) Windows Version 5.0
then I don't think there would be any reason for it not to.
John
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>|||Please do not post the same message independently in different newsgroups, I
posted an answer in .setup.
--
Jacco Schalkwijk
SQL Server MVP
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>
Can I install both version of SQL server 2000 & 2005 on my Computer ?
I now know only I can install both .Net 1.1 and 2.0 on one computer
but I don't know, Can I do it on SQL Server ?
Please advise me...
You cannot have SQL 2000 and SQL 2005 running in the same computer.
Cheers
Al
|||Yes you can. SQL Servers run under their own process, and different instances maintain their own memory space. You're fine to run both on one server, though I dont recomend it for a production enviroment.|||When you try, there is an error from the installer! How do you get around that?
Cheers
Al
|||
albertpascual:
When you try, there is an error from the installer! How do you get around that?
Cheers
Al
EDIT
You can if you install 2000 before 2005, companies run different versions on the network as of last year you can still download 6.5 from MSDN. And yes I have run both in one box during the SQL Server 2005 roll out.
|||Hi Albert, I have a machine which first has SQL2005 installed and then I added SQL2000 to it, without any problem. Do you remember what's the error you got from the installer?|||Yes, something like you cannot install SQL 2005 when another instance is already installed.
The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?
|||
Yes, something like you cannot install SQL 2005 when another instance is already installed.
The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?
The CTPs were bad one CTP between beta 2 and 3 cost me a hard drive and the OS that came with it, back then it takes a while to find the Management Studios all that changed with the final product, you can even get a child to install it but I have not tried it. it is very easy now. But 2000 remains ignore Windows questions just answer those relevant to you.
|||You are correct, took me a long time to finish the installation of SQL 2005 CTP, the release version was fast and easy on a clean computer. I already removed all my SQL 2000 from any computer, I only use SQL 2005, love the speed!
I am glad that people can install both in the same machine now. Some day I may try that instead of just upgrading it.
Cheers
Al
Can I install both Management Studio and Management Studio Express on same machine?
I want to install the following on my machine:
MSDE 2000 Release A
SQL Server 2000 SP4
SQL Server 2005 Developer Edition with SP1
SQL Server 2000 Express with SP1
Management Studio
Management Studio Express
The only one that I'm concerning is whether Management Studio and Management Studio Express can coexist in one machine.
Thanks for any help,
Peter
NO. Products have been mutually exclusive since early betas.sql
Subscribe to:
Posts (Atom)