minimun installation

I need to reduce de installation pack of sql server express 2005. how
can i do that?
thanks.AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>
I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.
Thanks for the answer.|||On 24 Aug 2006 03:31:28 -0700, "AKS" <dagato2@.terra.eswrote:

Quote:

Originally Posted by

>
>Erland Sommarskog ha escrito:
>

Quote:

Originally Posted by

>AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>>
>I'm afraid that I don't really understand the question. Do you want remove
>compenents from your installation?
>>
>>
>--
>Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>>
>Books Online for SQL Server 2005 at
>http://www.microsoft.com/technet/pr...oads/books.mspx
>Books Online for SQL Server 2000 at
>http://www.microsoft.com/sql/prodin...ions/books.mspx

>
>size of SQL Server Express distrubition files is 180 MB, i want to
>reduce this size. I need to make the possible smallest distribution.
>Thanks for the answer.

These days, if 180 MB was a concern, I would expect to find myself
dealing with either (1) a nickel-and-dime client that wasn't worth
my time anyway, or (2) an embedded system (in which case I would
look into SQL products specifically designed for embedded systems).|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
..Net Framework 2.0 as well, which is another 22 MB.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

>
I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
.Net Framework 2.0 as well, which is another 22 MB.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

>
Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.
>
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

And that was essentially what I said: integrate your SQLEXPR.EXE in
your setup.

I'm sorry, I can't assist with any details, because I don't work with
Windows Installer (or any other installer). But it is quite clear to
me that there is no need to distribute the SQL Express installation
expanded into 180 MB. If Microsoft can distribute it 54 MB, so can you.

It's possible that you can remove some files from the SQL Express
installation, but I seriously doubt that you can slash it to 54 without
compressing it, one way or another. After all, once you've extracted
the exe-file, right-click and select Add to Zip file. Don't tell me
you cannot that.

You should probably investigate if you can find a forum devoted to
Windows Installer, so you can get some tips on building your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.

The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...

So you need to learn how to incorporate SQLEXPR.EXE in your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I think it too. Thanks for all.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.
>
The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...
>
So you need to learn how to incorporate SQLEXPR.EXE in your setup.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

sql

Minimum RAM Requirement For installation

256 RAM is running on my computer. is it possible to run Microsoft SQL Server 2005 Reporting Services on it?

NOTE: I installed Microsoft SQL Server 2005 Reporting Services. By the installation, it gives an error, that system resource is not enough. Although this, installation resume, but program not worked at the end.

I

No.

http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en#Requirements

minimum installation?

What is the minimum installation for the developer's computer if the person
is going to desing the reports locally? Typical installation of Visual
Studio 2005 does not have anything to do with Reporting Services, SQL Server
Express installed together with VS2005 also not configured for Reporting
services.
So, which components the developer must add to VS and/or SQL Server Express
to start working with the reports?
--
Regards,
Dmitry DuginovIf you want to design and deploy locally, you will need to install SQL
Server Reporting Services on the local PC, since it will create a
ReportServer and ReportTemp DB on the local SQL Server. You will also
need ASP.net 2.0 and IIS, but the RS install will evaluate your target
machine to determine what missing components you need to install first.
Don't forget the service packs.
Actually, I've just noticed you are using SQL Server Express
Check this link for product comparisons...SQL Server Express does not
come with Reporting Services
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
On Oct 24, 3:26 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> What is the minimum installation for the developer's computer if the person
> is going to desing the reports locally? Typical installation of Visual
> Studio 2005 does not have anything to do with Reporting Services, SQL Server
> Express installed together with VS2005 also not configured for Reporting
> services.
> So, which components the developer must add to VS and/or SQL Server Express
> to start working with the reports?
> --
> Regards,
> Dmitry Duginov|||"weelin" <weelin@.gmail.com> wrote in message
news:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> If you want to design and deploy locally, you will need to install SQL
> Server Reporting Services on the local PC, since it will create a
> ReportServer and ReportTemp DB on the local SQL Server. You will also
> need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> machine to determine what missing components you need to install first.
Nope, you got it wrong. The guy wants to design/edit reports locally, deploy
on the remote server. What does he need to get the Report Designer in Visual
Studio 2005?
Regards,
Dmitry Duginov|||http://msdn2.microsoft.com/en-us/library/ms173745.aspx -- RS in BIDS
- you need to install RS to get the RS templates in BIDS
http://msdn2.microsoft.com/en-us/library/ms365166.aspx -- RS in SQL
Server Express
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
-- installing Reporting Services - you need a SQL Server to install RS
whether that is local or remote.
When RS first came out, you HAD TO have a SQL Server license and hence
a SQL Server install to install it, since it needs somewhere to install
it's DBs. After you install it, you can always deploy to remote
servers, but I thought you would need your own SQL Servier instance to
hold your ReportServer and ReportTempDB. I am not sure that you can
connect to a remote instance of ReportServerTempDB just to develop on.
Otherwise everyone could just use one instance of SQL Server and all
have RS.
If you find out otherwise, I would like to know.
On Oct 24, 4:07 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> "weelin" <wee...@.gmail.com> wrote in messagenews:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> > If you want to design and deploy locally, you will need to install SQL
> > Server Reporting Services on the local PC, since it will create a
> > ReportServer and ReportTemp DB on the local SQL Server. You will also
> > need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> > machine to determine what missing components you need to install first.Nope, you got it wrong. The guy wants to design/edit reports locally, deploy
> on the remote server. What does he need to get the Report Designer in Visual
> Studio 2005?
> --
> Regards,
> Dmitry Duginov|||Thank you, that's been really helpful!
D.
"weelin" <weelin@.gmail.com> wrote in message
news:1161706899.281701.60240@.k70g2000cwa.googlegroups.com...
> http://msdn2.microsoft.com/en-us/library/ms173745.aspx -- RS in BIDS
> - you need to install RS to get the RS templates in BIDS
> http://msdn2.microsoft.com/en-us/library/ms365166.aspx -- RS in SQL
> Server Express
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> -- installing Reporting Services - you need a SQL Server to install RS
> whether that is local or remote.
> When RS first came out, you HAD TO have a SQL Server license and hence
> a SQL Server install to install it, since it needs somewhere to install
> it's DBs. After you install it, you can always deploy to remote
> servers, but I thought you would need your own SQL Servier instance to
> hold your ReportServer and ReportTempDB. I am not sure that you can
> connect to a remote instance of ReportServerTempDB just to develop on.
> Otherwise everyone could just use one instance of SQL Server and all
> have RS.
> If you find out otherwise, I would like to know.
>
> On Oct 24, 4:07 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> > "weelin" <wee...@.gmail.com> wrote in
messagenews:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> >
> > > If you want to design and deploy locally, you will need to install SQL
> > > Server Reporting Services on the local PC, since it will create a
> > > ReportServer and ReportTemp DB on the local SQL Server. You will also
> > > need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> > > machine to determine what missing components you need to install
first.Nope, you got it wrong. The guy wants to design/edit reports locally,
deploy
> > on the remote server. What does he need to get the Report Designer in
Visual
> > Studio 2005?
> >
> > --
> > Regards,
> > Dmitry Duginov
>

MIGRATIONSQL7 to SQL2000

Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean installation of SQL2000. How do I do this?
Thanks!!
You can both attach and restore 7.0 databases into 2000:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Utopian" <gla1972@.yahoo.com.ar> wrote in message news:ORGDjc$JFHA.3516@.TK2MSFTNGP10.phx.gbl...
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean installation of
SQL2000. How do I do this?
Thanks!!

MIGRATIONSQL7 to SQL2000

Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean
installation of SQL2000. How do I do this?
Thanks!!You can both attach and restore 7.0 databases into 2000:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Utopian" <gla1972@.yahoo.com.ar> wrote in message news:ORGDjc$JFHA.3516@.TK2M
SFTNGP10.phx.gbl...
Hello!!
I have a Data Base in sql7 and I want to transfer to another PC with a clean
installation of
SQL2000. How do I do this?
Thanks!!