Determine Edition in Reporting Services 2000

This may be a simple question, but I need to determine which edition of
Reporting Services I have installed on my SQL Server 2000 server. I have
already confirmed that I am running Enterprise Edition for SQL Server itself,
but cannot find anything that will give me version/edition information for
Reporting Services.
Any help would be greatly appreciated.
Daniel InmanNow I feel stupid. All you need to do is go into Add/Remove programs.
"Daniel Inman" wrote:
> This may be a simple question, but I need to determine which edition of
> Reporting Services I have installed on my SQL Server 2000 server. I have
> already confirmed that I am running Enterprise Edition for SQL Server itself,
> but cannot find anything that will give me version/edition information for
> Reporting Services.
> Any help would be greatly appreciated.
> Daniel Inman
>|||An even simpler alternative is to go to the following url:
http://rsservername/reportserver/
Of course, replace "rsservername" with the real name of your Reporting
Services Server. You'll see the version number at the bottom of that
screen.
Daniel Inman wrote:
> Now I feel stupid. All you need to do is go into Add/Remove programs.
> "Daniel Inman" wrote:
> > This may be a simple question, but I need to determine which edition of
> > Reporting Services I have installed on my SQL Server 2000 server. I have
> > already confirmed that I am running Enterprise Edition for SQL Server itself,
> > but cannot find anything that will give me version/edition information for
> > Reporting Services.
> >
> > Any help would be greatly appreciated.
> >
> > Daniel Inman
> >sql

Determin if this is Standard or Ent edition

How do I tell if an install of sql server is standard or enterprise edition?
moondaddy@.nospam.nospamselect serverproperty('edition')
Andrew J. Kelly SQL MVP
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:%23zNH8yWOGHA.348@.TK2MSFTNGP11.phx.gbl...
> How do I tell if an install of sql server is standard or enterprise
> edition?
> --
> moondaddy@.nospam.nospam
>

Detecting IIS

Good Morning,

My name is Erin. When attempting to install SQL Server Express on Windows XP Home Edition Service Pak 2, the installation freezes at "Detecting IIS...". I have been bopped around Microsoft Support since Monday. I even opened a case, but I have no success. Does anyone have any ideas on how to get around this problem? Any help would be greatly appreciated. Great question Erin.

There are several threads in the Setup Forum that may help.

Check out
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=130608&SiteID=1
and
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=54363&SiteID=1|||I made it through the installation of Net.Framework 2.0. with the SDk kit. I've installed the SQLServer, Express without any problems. Now I need to configure the Startup kit for SDK, and Net Framework 2.0. I finally got the configuration wizard, and I am asked if I have the IIS installed on my computer. I don't think I can get the IIS on the Home, ed. There may be a substitute. I ran into a support I believe some time ago. I am looking now. Thought I was alone where this matter is concerned. Will get back if I find the support for IIS.

Detecting IIS

Good Morning,

My name is Erin. When attempting to install SQL Server Express on Windows XP Home Edition Service Pak 2, the installation freezes at "Detecting IIS...". I have been bopped around Microsoft Support since Monday. I even opened a case, but I have no success. Does anyone have any ideas on how to get around this problem? Any help would be greatly appreciated. Great question Erin.

There are several threads in the Setup Forum that may help.

Check out
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=130608&SiteID=1
and
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=54363&SiteID=1|||I made it through the installation of Net.Framework 2.0. with the SDk kit. I've installed the SQLServer, Express without any problems. Now I need to configure the Startup kit for SDK, and Net Framework 2.0. I finally got the configuration wizard, and I am asked if I have the IIS installed on my computer. I don't think I can get the IIS on the Home, ed. There may be a substitute. I ran into a support I believe some time ago. I am looking now. Thought I was alone where this matter is concerned. Will get back if I find the support for IIS.

Detect installed version?

Today I installed SQL Server 2005 developer edition on a test server. Afterwards I also installed the SP1. During the installation of SP1, the installation program said the server should be restarted afterwards, which I did.

Now when I look at the Add/Remove Programs dialog I have several items which mention SP1 on the SQL Server items.

But when I request the server properties in Managemnt Studio I see the version number 9.0.2047. Shouldn't this be 9.1.XXXX?

How can I be sure the SP1 is correcty insatlled?

Stievie

If you look on the download page under the Quick Details, the version number is listed as 9.00.2047

http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

|||Isn't that the same version number as before installing the SP?

Is it possible to see which SP is installed inside the Management Studio?

|||Hi,

See more details here: http://www.aspfaq.com/sql2005/show.asp?id=20

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

StievieD wrote:

Isn't that the same version number as before installing the SP?

Before SP1, the version is 9.0.1399

|||The version for SP1 is 9.00.2047 and RTM 9.00.1399.06.|||Thanks guys, for all the help.

Detailed Procedure for implementing the SQL Server Replication

Can I have a detailed step to step guide for implementing the SQL Server
Replication.
Note : I am using SQL 2000 Server Ent. Edition. on Win2003 Server Platform
Shanthi
There are some books on my website (www.replicationanswers.com) and books on
line is also a good source. Apart from that, you might want to look here at
these basic guides: http://www.mssqlcity.com/Articles/Replic/Replic.htm
HTH,
Paul Ibison

Desperatly need help to import .csv file using Bulk Insert

Hi all-

I am in need of some help importing a .CSV file into a SQL Server 2005 Enterprise Edition.

The problem is I already implemented Bulk Insert task in SSIS but it is not importing any data. My detailed layout is as follows :
In SSIS package1 -
In Control Flow Bulk Insert Task has been inserted
Properties of Bulk Insert Task:
Connection adtc009d.ganny
Destination Table ganny.dbo.t4
Format
Format Specify
Row Delimiter {CR}
Column Delimiter Comma{,}
Source Connection
File r.csv
Options
Options Check Constraints
Maxerrors 20

This bulk insert task is connected to Data flow task, if we click edit to data flow task, data flow section will come, here Flat file source & OLE DB Destination is there. Flat file source is connected to OLE DB Destination.

Properties of Flat File
Connection Manager
Flat file connection Manager
here by clicking new link flat file properties to this.
Preview
by clicking preview all data are visible
Properties of OLE DB Destination editor
Oledb connection manager adtc009d.ganny
Data access mode: Table or View - fast load
Name of Table or view dbo.t4

After designing all this then if I start debugging I could able to get records are imported to a table.
Please suggest me where I am going wrong.

Thanks in advance
Karna

Karna,

There are several ways to find out what's wrong, the easiest is

looking at the errors reported by SSIS when you run the package.

The other way is to look at the file source and preview the rows to see if your Column delimiters and row delimiters are working correctly.

Try these and let me know

|||On the flat connection manager, you might need to put a text qualifier (like "). Also you might want to try {CR}{LF} on the row delimeter.|||Dear all,

Thanks for reply.

I solved this problem by using only Bulk Insert option alone, without using data flow task.

My biggest problem is whether we have any tool to check validations before inserting records to a table. It has to check duplicates, if duplicates are existing just insert only only real records not the duplicate ones.

I tried removing redundancy by inserting all records from csv data file to a table called t1, create another table which is copy of table t1 but has primary key called table as t2. Use insert into t2 by selecting only distinct records from t1.

My question apart from above option whether we have any tool which does all related job in SSIS.

Thanks in advance
Karna|||

The short answer is No.

The best option is to import into a 'staging' table. then you can have as many 'clean-up' and data modification steps as is necessary. For example, you may wish to create a output (in some form) of the rows that fail the concurrency test.

Desktop vs. Standard

Hello,
I purchased some software that comes with the desktop edition of SQL 2000.
I have a Windows 2003 server and about 20 clients who need to access the
database.
Are there any limits to the desktop edition that I should be aware of?
Does it work with Windows 2003?
Does it have a limit to the number of simultaneous users?
Does it have memory limits?
Thanks
I assume you mean Desktop Engine, also known as MSDE...
1. Yes
2. No. But there's a performance throttling kicking in when you have > 8 simultaneously executing
queries.
3. Max size for db is 2GB (data, not log).
More info at http://www.microsoft.com/sql/default.mspx.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"boe" <boe_d@.hotmail.nospam.com> wrote in message news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
> Hello,
> I purchased some software that comes with the desktop edition of SQL 2000.
> I have a Windows 2003 server and about 20 clients who need to access the
> database.
> Are there any limits to the desktop edition that I should be aware of?
> Does it work with Windows 2003?
> Does it have a limit to the number of simultaneous users?
> Does it have memory limits?
> Thanks
>
|||Thank you - good to know!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uKv%23VNc3EHA.3472@.TK2MSFTNGP09.phx.gbl...
>I assume you mean Desktop Engine, also known as MSDE...
> 1. Yes
> 2. No. But there's a performance throttling kicking in when you have > 8
> simultaneously executing
> queries.
> 3. Max size for db is 2GB (data, not log).
> More info at http://www.microsoft.com/sql/default.mspx.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "boe" <boe_d@.hotmail.nospam.com> wrote in message
> news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
>

Desktop vs. Standard

Hello,
I purchased some software that comes with the desktop edition of SQL 2000.
I have a Windows 2003 server and about 20 clients who need to access the
database.
Are there any limits to the desktop edition that I should be aware of?
Does it work with Windows 2003?
Does it have a limit to the number of simultaneous users?
Does it have memory limits?
ThanksI assume you mean Desktop Engine, also known as MSDE...
1. Yes
2. No. But there's a performance throttling kicking in when you have > 8 simultaneously executing
queries.
3. Max size for db is 2GB (data, not log).
More info at http://www.microsoft.com/sql/default.mspx.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"boe" <boe_d@.hotmail.nospam.com> wrote in message news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
> Hello,
> I purchased some software that comes with the desktop edition of SQL 2000.
> I have a Windows 2003 server and about 20 clients who need to access the
> database.
> Are there any limits to the desktop edition that I should be aware of?
> Does it work with Windows 2003?
> Does it have a limit to the number of simultaneous users?
> Does it have memory limits?
> Thanks
>|||Thank you - good to know!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uKv%23VNc3EHA.3472@.TK2MSFTNGP09.phx.gbl...
>I assume you mean Desktop Engine, also known as MSDE...
> 1. Yes
> 2. No. But there's a performance throttling kicking in when you have > 8
> simultaneously executing
> queries.
> 3. Max size for db is 2GB (data, not log).
> More info at http://www.microsoft.com/sql/default.mspx.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "boe" <boe_d@.hotmail.nospam.com> wrote in message
> news:%23bmI5Dc3EHA.1188@.tk2msftngp13.phx.gbl...
>> Hello,
>> I purchased some software that comes with the desktop edition of SQL
>> 2000.
>> I have a Windows 2003 server and about 20 clients who need to access the
>> database.
>> Are there any limits to the desktop edition that I should be aware of?
>> Does it work with Windows 2003?
>> Does it have a limit to the number of simultaneous users?
>> Does it have memory limits?
>> Thanks
>>
>

Desktop platform support for SQL Server Compact Edition?

Hi-

I am doing some technology research for a new app and was wondering about the desktop operating system support for SQL Server compact edition. This app has a PC component and a mobile component, and both need to be data enabled, with syncronization between the PC and the mobile device.

So it seems like SSCE would be a good fit. Just run the SSCE client on both the PC and the device. But in the system requirements for SSCE it only gives XP as a valid desktop OS...

Is that correct? Obviously, desktop platform support for a production app will need to be broader than just XP.

Will SSCE desktop run on Win98,Win2000,XP Home, and Vista?

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

|||

Jo?o Paulo Figueira wrote:

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

Hi Joao-

Thanks a lot for that info. Is there any way you can publish the URL to that list - there may be other useful info on that page?

Also, I notice Windows Mobile 6.0 is not on the supported operating systems list? Is there any estimate on when that will be supported?
|||Here's the link. Although not explicitly stated, I don't believe you will have problems running on Windows Mobile 6.|||On Windows Mobile 6.0, SQL Compact 3.1 is included in ROM.

Desktop platform support for SQL Server Compact Edition?

Hi-

I am doing some technology research for a new app and was wondering about the desktop operating system support for SQL Server compact edition. This app has a PC component and a mobile component, and both need to be data enabled, with syncronization between the PC and the mobile device.

So it seems like SSCE would be a good fit. Just run the SSCE client on both the PC and the device. But in the system requirements for SSCE it only gives XP as a valid desktop OS...

Is that correct? Obviously, desktop platform support for a production app will need to be broader than just XP.

Will SSCE desktop run on Win98,Win2000,XP Home, and Vista?

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

|||

Jo?o Paulo Figueira wrote:

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

Hi Joao-

Thanks a lot for that info. Is there any way you can publish the URL to that list - there may be other useful info on that page?

Also, I notice Windows Mobile 6.0 is not on the supported operating systems list? Is there any estimate on when that will be supported?
|||Here's the link. Although not explicitly stated, I don't believe you will have problems running on Windows Mobile 6.|||On Windows Mobile 6.0, SQL Compact 3.1 is included in ROM.

Desktop platform support for SQL Server Compact Edition?

Hi-

I am doing some technology research for a new app and was wondering about the desktop operating system support for SQL Server compact edition. This app has a PC component and a mobile component, and both need to be data enabled, with syncronization between the PC and the mobile device.

So it seems like SSCE would be a good fit. Just run the SSCE client on both the PC and the device. But in the system requirements for SSCE it only gives XP as a valid desktop OS...

Is that correct? Obviously, desktop platform support for a production app will need to be broader than just XP.

Will SSCE desktop run on Win98,Win2000,XP Home, and Vista?

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

|||

Jo?o Paulo Figueira wrote:

From my own experience, XP Home and Vista are supported. The official support list is:

Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

Hi Joao-

Thanks a lot for that info. Is there any way you can publish the URL to that list - there may be other useful info on that page?

Also, I notice Windows Mobile 6.0 is not on the supported operating systems list? Is there any estimate on when that will be supported?
|||Here's the link. Although not explicitly stated, I don't believe you will have problems running on Windows Mobile 6.|||On Windows Mobile 6.0, SQL Compact 3.1 is included in ROM.

Designing Reports for SQL Reporting Services 2000

My customer has SQL Reporting Services on a server with SQL 2000 Standard Edition. The customer wants to develop his own Reporting Services reports. We have been recommending Visual Basic.NET Standard 2003 for this purpose in that it costs less than $100 (usually). However, with the advent of Visual Studio 2005, the VB.NET 2003 is becoming difficult or impossible to obtain. One option is Visual C#.NET Standard 2003 - I assume it will work - does anyone know for sure?

More importantly, when Visual C#.NET 2003 becomes unvailable, what options are left for developing RS 2000 reports?

Thanks for any suggestions.

Mark

>More importantly, when Visual C#.NET 2003 becomes unvailable, what options are left for developing RS 2000 reports?

None from Microsoft. There are third-party solutions, e.g. Cizer.

|||

You could also write a small tool that performs a RDL structure "downgrade" conversion (see e.g. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=988366&SiteID=1). However note that RS 2000 doesn't support a number of RS 2005 features (e.g. multi value parameters).

-- Robert