about deployment with database

Hai,
We created one application, in .net with sql server 2005. we
created the setup file also.
Now we want to install the application in client place, But,
client don't have any sql server in their system. I heard about with
MSDE, there is no need for sql server.
Anybody can explain, what we have to do now.
Regards,
Raju.Go to www.microsoft.com/sql and look at the SQL Server 2005 Express.
It is a 'FREE' product, the successor to MSDE, and may serve your needs.
SQL Server 2005 Express Edition Feature Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
http://www.pcw.co.uk/personal-computer-world/software/2155087/review-microsoft-sql-server
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162015230.775017.143230@.i42g2000cwa.googlegroups.com...
> Hai,
> We created one application, in .net with sql server 2005. we
> created the setup file also.
> Now we want to install the application in client place, But,
> client don't have any sql server in their system. I heard about with
> MSDE, there is no need for sql server.
> Anybody can explain, what we have to do now.
> Regards,
> Raju.
>|||Hai,
Thanks for you immediate response.
Whether we have to install the sql server 2005 express manually, is
it possible to install the sql server 2005 from our .net application
automatically.
First we will deploy, required installation files and database
files in our application.
So, when we install the application, first the sql server 2005
express will install and after that out application will get installed.
If this one is possible then, please give me the procedure for
that.
Thanks in advance.
Regards,
Raju.|||See:
SQL Server 2005 Unintended Installations
http://www.devx.com/dbzone/Article/31648
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
> Hai,
> Thanks for you immediate response.
> Whether we have to install the sql server 2005 express manually, is
> it possible to install the sql server 2005 from our .net application
> automatically.
> First we will deploy, required installation files and database
> files in our application.
> So, when we install the application, first the sql server 2005
> express will install and after that out application will get installed.
> If this one is possible then, please give me the procedure for
> that.
> Thanks in advance.
> Regards,
> Raju.
>|||> SQL Server 2005 Unintended Installations
Freudian slip, Arnie? :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arnie Rowland" <arnie@.1568.com> wrote in message news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
> See:
> SQL Server 2005 Unintended Installations
> http://www.devx.com/dbzone/Article/31648
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>|||Got me...
But sometimes, the user may not have 'intended' to end up with a SQL
installation -but they get one anyway.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OaGw9Xr%23GHA.4708@.TK2MSFTNGP05.phx.gbl...
>> SQL Server 2005 Unintended Installations
> Freudian slip, Arnie? :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
>> See:
>> SQL Server 2005 Unintended Installations
>> http://www.devx.com/dbzone/Article/31648
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>>|||Hello Arnie Rowland,
Now we got the sqlexpress, when we run the applcation it is
running smoothly.
The database is from our application only. But when we run the
crystal reports it is refering the database logon information on the
machine, where we created the crystal reports.
I know the problem, why it is. Bec., we created the crystal
reports, using the local datasource only.
So, how to give the datasource, when we creating the crystal
reports.
Thanks in advance.
Regards,
Raju.|||That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
to some suitable crystal reports forum, as there isn't that high probability that you find experts
on crystal reports here.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> Hello Arnie Rowland,
> Now we got the sqlexpress, when we run the applcation it is
> running smoothly.
> The database is from our application only. But when we run the
> crystal reports it is refering the database logon information on the
> machine, where we created the crystal reports.
> I know the problem, why it is. Bec., we created the crystal
> reports, using the local datasource only.
> So, how to give the datasource, when we creating the crystal
> reports.
> Thanks in advance.
> Regards,
> Raju.
>|||Hello,
Thanks for your response.
We can change that datasource at runtime also. Can you guide me
on how to do that.
Regards,
Raju.
Tibor Karaszi wrote:
> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
> to some suitable crystal reports forum, as there isn't that high probability that you find experts
> on crystal reports here.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> > Hello Arnie Rowland,
> >
> > Now we got the sqlexpress, when we run the applcation it is
> > running smoothly.
> >
> > The database is from our application only. But when we run the
> > crystal reports it is refering the database logon information on the
> > machine, where we created the crystal reports.
> >
> > I know the problem, why it is. Bec., we created the crystal
> > reports, using the local datasource only.
> >
> > So, how to give the datasource, when we creating the crystal
> > reports.
> >
> > Thanks in advance.
> >
> > Regards,
> > Raju.
> >|||> We can change that datasource at runtime also. Can you guide me
> on how to do that.
I've never used Crystal Reports. You need ask people who know Crystal Reports on how to do this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162378360.362543.118220@.b28g2000cwb.googlegroups.com...
> Hello,
> Thanks for your response.
> We can change that datasource at runtime also. Can you guide me
> on how to do that.
> Regards,
> Raju.
> Tibor Karaszi wrote:
>> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post
>> this
>> to some suitable crystal reports forum, as there isn't that high probability that you find
>> experts
>> on crystal reports here.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
>> > Hello Arnie Rowland,
>> >
>> > Now we got the sqlexpress, when we run the applcation it is
>> > running smoothly.
>> >
>> > The database is from our application only. But when we run the
>> > crystal reports it is refering the database logon information on the
>> > machine, where we created the crystal reports.
>> >
>> > I know the problem, why it is. Bec., we created the crystal
>> > reports, using the local datasource only.
>> >
>> > So, how to give the datasource, when we creating the crystal
>> > reports.
>> >
>> > Thanks in advance.
>> >
>> > Regards,
>> > Raju.
>> >
>