Showing posts with label computer. Show all posts
Showing posts with label computer. Show all posts

Friday, March 23, 2012

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

Wednesday, March 21, 2012

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
>

Minimum Hardware Requirements For SQL Client

What would be the minumum hardware (and software) requirements to have
SQL client on 10 of our contractors' computer with a maximum database
size of 5GB?
Thank you very much
mike
The client machines can be pretty wimpy because the server process the T-SQL
and just returns the results the clients.
At a minimum I would want a PIII running Win2k with 256MB RAM.
Keith
"Mike" <mj1sql@.yahoo.com> wrote in message
news:9a55bd2d.0410070814.5589c64e@.posting.google.c om...
> What would be the minumum hardware (and software) requirements to have
> SQL client on 10 of our contractors' computer with a maximum database
> size of 5GB?
> Thank you very much
> mike

Friday, March 9, 2012

migration sql Server 2000 to sqlServer2005

hi,

i must convert my SqlServer2000 to SqlServer2005. I just do it on my Computer and i run a component "SQL Server upgrade wizard" it convert my SQLServer.
But now i must do it on my Server Web and if i run that component it give me an error : "must run SQL 6.5" and i don't installed it.

Can i download it with all right migration?

thank you

If you get such error you may have inherited a database upgraded from 6.5 to 2000 with a wizard that could be a problem because I always advice 6.5 migration should be manual done by a skilled SQL Server expert. So create a blank database and run the SSIS(sql server integration services) and the error will go away. Hope this helps.