Installing MSDE

Being new to setting up MSDE, we are currently testing crystal reports
and Microsoft Sharepoint services. We want to install these on a
seperate server and see that they use MSDE. We also have a server
currently installed with MSDE for Altiris deployment images and HP
insite manager. Is it a good practice to link to the existing MSDE
server or house this instance of MSDE on the new test server.
Thanks
John
hi John,
JohnC wrote:
> Being new to setting up MSDE, we are currently testing crystal reports
> and Microsoft Sharepoint services. We want to install these on a
> seperate server and see that they use MSDE. We also have a server
> currently installed with MSDE for Altiris deployment images and HP
> insite manager. Is it a good practice to link to the existing MSDE
> server or house this instance of MSDE on the new test server.
usually it's considered a good practice to separate the database server from
the application server both for security reasons and performance reasons, in
order to have a "dedicated" machine for each task...
just a caveat.. Sharepoint usually requires a lot of database space and
ships with a dedicated MSDE version, known as WMSDE, which has been modified
by Microsoft to remove the 2gb limit for each database.. WMSDE is shipped
only with Sharepoint and can only be (legally) used by it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea for your info, looking at the big picture and future
expansion. Taking on board your info about a dedicated database server,
are we better off having an sql server and all are database accessing
software linking up to it like Altiris, sharepoint, crystal reports,
and our own web site which at the moment is linked to mysql.
Regards
John

Installing a DLL file in crystal reports 9.0

Hi guru.,
I had written a .dll file using VB 6.0 in a system.
Then i copied the dll to an another system which is having crystal reports 9.0.
here i have registered this dll in command prompt by c:\>regsvr32 "FILE".DLL
the message came as dll file successfully registered, then i placed a cop y of the dll file in
c:\programfiles\commonfiles\crystaldesicions\2.0\bin folder.

but i yet i am not able to access the function, even though i have named my dll file with "crufl" prefix.

could u suuggest me what could be the problem be...What is the error you got?
You need to create Package and deploy it in other system using Package and Deployment wizard of VB

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
sql

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheil
d
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
--
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
--
David Gugick
Imceda Software
www.imceda.com