Need suggestion for reports software

Hi,

We have Visual Studio 2005 , Crystal Reports, SQL Server 2005 Express Edition.

our Manager asked about the best and easiest reporting software other than Crystal Reports.

I didn't work with reports. Please assist me, if any one have idea.

Thanks in advance

Regards

Jyothi

I have worked with crystal reports and Sql Server Reporting Services and SSRS for all its problems, beats crystal and not just on price. The points with SSRS to watch are:

Choose the right style at the outset as difficult to change afterwards.|||

I tried Crystal it is expensive but has a lot of predefined functions that SSRS doesn't. But I elected to you SSRS I like it better it is easy to use and very flexible. I just wish it would conform to the same formats as excel. I found out you can not have over 160 in in viewable colum space width. Excel allows 256...

|||

Hello,

I'm currently working on SQL Reports and found out that they are better than Crystal and DEV express reports. I'm implementing a localisation functionality with ASP.net and they are very flexible.

Here are the key features.

1- Easy to integrate with ASP.net site

2- Build custom assembly and use it in your report or use VB for embeded coding.

3- Free of cost with SQL Express.

4- Plenty of support/samples and knowledge base.

5- Free of cost report designer (Business IntelligenceProject)

Thanks,

Farooq

|||

Check these links to see the features of reporting services

http://msdn2.microsoft.com/en-us/library/ms159273.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

Check this post for a good discussion on Crystal Reports .NEt vs. SSRS :

http://asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=720164

Need infos regarding install of SQL Express 2005 SP1

Hi,

A little technical question. If I want to install SQL Express 2005 SP1, do I have to uninstall current version first?

Thanks in advance,

Stphane

No, you apply a service pack to an existing installation.|||

Hi again,

Thanks for the info. Maybe a last question. Considering the fact that a SP1 has also been issued for Visual Studio 2005, must I first install the SP1 for VS 2005 before installing SP1 for SQL Express 2005 or it doesn't matter?

Thanks for your help,

Stphane

|||

It doesn't matter.

Mike

|||

SQL Server and Visual Studio are separate products. You do not have to apply SP1 to them in any particular order, nor do you have to apply it to both (though it is a good idea.)

Please indicate if your question has been answered properly. Thanks,

|||

Hi again,

I just finished install VS 2005 Sp1. Quite long, especially the section where it was evaluating the pre-requisites, but everything completed without error. It detected the appropriate version of VS2005 I was using. Now I'm ready to apply SP1 to SQL Server Express 2005. Before going on, I really need to clarify those things.

Considering the fact that the version of SQL Server Express 2005 actually present on my system is the one I originally installed from VS2005 Standard disks, what is the appropriate install sequence I should take?:

1- If I want to install "Microsoft SQL Server 2005 Express Edition with Advanced Services", do I have to uninstall the SQL Server Express 2005 version actually installed on my machine first or do I simply install the new one over it?

ref: http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

2- I presume that I can then install "Microsoft SQL Server 2005 Express Edition Toolkit" without problem. Anything I should take care of before install?

ref: http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

3- Finally, I presume that I can apply SP1 "Microsoft SQL Server 2005 Express Edition (SP1)" without any problem. Is the following link the appropriate version to apply or should I apply another one?

ref: http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

Thanks for your help,

Stphane

|||

Stphane,

Your sequence of steps should be work ok.

|||

Hi Arnie,

Just to be sure. Must I uninstall current version of SQL Express before going on with others listed in previous message?

Thanks for your help, really appreciated!

Stphane

|||Unless you are using a beta version, you do not need to unInstall before applying the service pack.|||

Hi again,

For applying SP1, I was aware that there was no need for uninstalling as I already applied SP1 over Visual Studio 2005. In fact, my question was more about the installation of "Microsoft SQL Server 2005 Express Edition with Advanced Services" over actual SQL Express installed on my machine. Can I install it over actual version or must I first uninstall current SQL Express version installed?

Thanks again,

Stphane

|||

The 'Advanced Services" edition is the same version of SQL 2005 Express, and it includes additional functionality, including Management Studio Express.

Again, you do NOT have to uninstall before adding a service pack.

(Now is that complete enough for you to indicate you have been responded and answered?

|||

Hi again,

This last question was not about SP1. Actually the SQL Server 2005 Express version I have is the one installed directly from Visual Studio 2005 Standard Edition disks. I would like before applying SP1 to install instead version/package "Microsoft SQL Server 2005 Express Edition with Advanced Services". During your last posts, you seemed to talk only about SP1. Again, "Microsoft SQL Server 2005 Express Edition with Advanced Services" is NOT installed but I would like to install it before applying SP1.

That is why I asked again, and still ask, in order to install "Microsoft SQL Server 2005 Express Edition with Advanced Services" over current version I have of SQL Express, do I have to uninstall SQL Express version currently installed first?

After this new install will be done, THEN I know I will be able to install SP1 without touching anything, the same way I already did so far for VS 2005.

Sorry for misunderstanding, but I want to be sure before screwing up anything.

Stphane

|||

And as I have replied many, many times: NO, you do not have to uninstall your current version of SQL 2005 Express. When you start up the "Advanced Services" edition, you will be asked if you want to install a new instance, or just install the new advanced services and Management Studio Express.

Please, give it a rest. Go make your installation. Go with Peace and Florish.

|||

Hi,

Really sorry to bug you but I never went through this install so far. Having known from start that install process would have asked me this question would have made things clear in my mind. Now, with that last detail, YES, we can close the subject.

Thanks for your patience,

Stphane

|||Cool, you gave yourself credit for answering your own question!

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need Help.

I m using SQL SERVER EXPRESS edition for storing user login information. I have use built in login controls in my application. Login is working properly, user are also created but i also want to assign roles to users and modify their details programmatically.

How can i do this ? Plzzzzzzz Help. Its urgent.

These resouces should help point you in the 'right' direction:

Security -Giving Permissions through Stored Procedures
http://www.sommarskog.se/grantperm.html

SQL Server 2005 Security
http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/

NEED HELP!!! Unknown Error in SQL 2005 express toolkit

I am encountering this error when tried to execute a simple select statement against the Enterprise Edition SQL 2000 and SQl2005

An error occurred while executing batch. Error message is: Unknown error "-1".

Please advise what is the cause of this.

Thanks.

I also encountering it even I upgraded my Management studio to

Microsoft SQL Server Management Studio 9.00.1399.00

Please advise/assist in this error. Thanks.

|||

which simple select statement?

are you using Microsoft SQL Server Management Studio Express? with SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services or SQL Server 2005 database engine?

tosc

|||

I installed SQL 2005 express toolkit in my PC and tried to connect to a Enterprise Edition SQL 2000 engine and SQL 2005 engine server. I tried for select rows in a table, example,

select * from<tablename>

It returns that error. i uninstall the Express edition toolkit and installed a enterprise version of the management studio. (version on my last post), still i got the same error when I executed that SELECT statement.

|||

is this SQL Server 2005 Express or EE ... u have mentioned EE ... in any case it seems that u have not applied SP1 and SP2 .... BTW can u post the script which u ran ...

Madhu

|||

I installed SQL 2005 Express Toolkit for the client tool,(Management Studio). my plan is to use this to manage our Enterprise Edition SQL servers(2000 and 2005).

I connect my Management Studio(SQL 2005 Express) to a SQL 2000 server enterprise edition.

I encountered this error:

An error occurred while executing batch. Error message is: Unknown error "-1".

even my script is a simple SELECT statement like this one:

SELECT * FROM <dbo.TableName>

I test the same script to a SQL 2005 Ent. Edition server. same error encountered. I tried a simple UPDATE statement, no error occured. it updates row in the SQL2000 server.

Then I uninstall the Express edition Management Studio(SQL 2005 Express toolkit). I install a Enterprise Edition management Studio(See my previous reply for the version) and still I encounter the same error when selecting data from any table of an Enterprise edition server.

Hope my issue is clear. do I have to install something? please advise.

|||Do I need to install SP1 even if I don't have SQL engine in my PC? i only have client tools in my PC. Please advise.|||

Hi,

which framework and OS are you using? are you sure, that you have all privelegs - to your databases?

|||

I have .NET 1.1 and 2.0 in my PC. I am using Win XP SP2. I already applied SP1 for SQL 2005 in my PC. still same error is encountered.

I have SQL 2000 and SQL 2005 Client utilities in my PC.

I didn't encounter it in Query Analyzer. Only when I use Management Studio.

I am using SA account.

|||

I have the same issue and have yet to find the resolution. One thing I have noticed is that the issue does not occur if you set your results to Text Mode. The issue appears to be related to mscorlib.dll.

|||

Could it be resolved by replacing the same dll with one from a working PC? or do i have to consider something like file version etc.?

|||

Hi all,

Any comment/suggestions to resolve this issue?

|||

I was able to resolve this issue on my system. It turns out that the client firewall tool used at my company "BlackIce" was detecting a buffer overflow exploit when making the calls to mscorlib.cll. I was able to list "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" as an exception to rule and all is fine.

I hope these findings help you as well.

NEED HELP!!! Unknown Error in SQL 2005 express toolkit

I am encountering this error when tried to execute a simple select statement against the Enterprise Edition SQL 2000 and SQl2005

An error occurred while executing batch. Error message is: Unknown error "-1".

Please advise what is the cause of this.

Thanks.

I also encountering it even I upgraded my Management studio to

Microsoft SQL Server Management Studio 9.00.1399.00

Please advise/assist in this error. Thanks.

|||

which simple select statement?

are you using Microsoft SQL Server Management Studio Express? with SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services or SQL Server 2005 database engine?

tosc

|||

I installed SQL 2005 express toolkit in my PC and tried to connect to a Enterprise Edition SQL 2000 engine and SQL 2005 engine server. I tried for select rows in a table, example,

select * from<tablename>

It returns that error. i uninstall the Express edition toolkit and installed a enterprise version of the management studio. (version on my last post), still i got the same error when I executed that SELECT statement.

|||

is this SQL Server 2005 Express or EE ... u have mentioned EE ... in any case it seems that u have not applied SP1 and SP2 .... BTW can u post the script which u ran ...

Madhu

|||

I installed SQL 2005 Express Toolkit for the client tool,(Management Studio). my plan is to use this to manage our Enterprise Edition SQL servers(2000 and 2005).

I connect my Management Studio(SQL 2005 Express) to a SQL 2000 server enterprise edition.

I encountered this error:

An error occurred while executing batch. Error message is: Unknown error "-1".

even my script is a simple SELECT statement like this one:

SELECT * FROM <dbo.TableName>

I test the same script to a SQL 2005 Ent. Edition server. same error encountered. I tried a simple UPDATE statement, no error occured. it updates row in the SQL2000 server.

Then I uninstall the Express edition Management Studio(SQL 2005 Express toolkit). I install a Enterprise Edition management Studio(See my previous reply for the version) and still I encounter the same error when selecting data from any table of an Enterprise edition server.

Hope my issue is clear. do I have to install something? please advise.

|||Do I need to install SP1 even if I don't have SQL engine in my PC? i only have client tools in my PC. Please advise.|||

Hi,

which framework and OS are you using? are you sure, that you have all privelegs - to your databases?

|||

I have .NET 1.1 and 2.0 in my PC. I am using Win XP SP2. I already applied SP1 for SQL 2005 in my PC. still same error is encountered.

I have SQL 2000 and SQL 2005 Client utilities in my PC.

I didn't encounter it in Query Analyzer. Only when I use Management Studio.

I am using SA account.

|||

I have the same issue and have yet to find the resolution. One thing I have noticed is that the issue does not occur if you set your results to Text Mode. The issue appears to be related to mscorlib.dll.

|||

Could it be resolved by replacing the same dll with one from a working PC? or do i have to consider something like file version etc.?

|||

Hi all,

Any comment/suggestions to resolve this issue?

|||

I was able to resolve this issue on my system. It turns out that the client firewall tool used at my company "BlackIce" was detecting a buffer overflow exploit when making the calls to mscorlib.cll. I was able to list "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" as an exception to rule and all is fine.

I hope these findings help you as well.

NEED HELP!!! Unknown Error in SQL 2005 express toolkit

I am encountering this error when tried to execute a simple select statement against the Enterprise Edition SQL 2000 and SQl2005

An error occurred while executing batch. Error message is: Unknown error "-1".

Please advise what is the cause of this.

Thanks.

I also encountering it even I upgraded my Management studio to

Microsoft SQL Server Management Studio 9.00.1399.00

Please advise/assist in this error. Thanks.

|||

which simple select statement?

are you using Microsoft SQL Server Management Studio Express? with SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services or SQL Server 2005 database engine?

tosc

|||

I installed SQL 2005 express toolkit in my PC and tried to connect to a Enterprise Edition SQL 2000 engine and SQL 2005 engine server. I tried for select rows in a table, example,

select * from<tablename>

It returns that error. i uninstall the Express edition toolkit and installed a enterprise version of the management studio. (version on my last post), still i got the same error when I executed that SELECT statement.

|||

is this SQL Server 2005 Express or EE ... u have mentioned EE ... in any case it seems that u have not applied SP1 and SP2 .... BTW can u post the script which u ran ...

Madhu

|||

I installed SQL 2005 Express Toolkit for the client tool,(Management Studio). my plan is to use this to manage our Enterprise Edition SQL servers(2000 and 2005).

I connect my Management Studio(SQL 2005 Express) to a SQL 2000 server enterprise edition.

I encountered this error:

An error occurred while executing batch. Error message is: Unknown error "-1".

even my script is a simple SELECT statement like this one:

SELECT * FROM <dbo.TableName>

I test the same script to a SQL 2005 Ent. Edition server. same error encountered. I tried a simple UPDATE statement, no error occured. it updates row in the SQL2000 server.

Then I uninstall the Express edition Management Studio(SQL 2005 Express toolkit). I install a Enterprise Edition management Studio(See my previous reply for the version) and still I encounter the same error when selecting data from any table of an Enterprise edition server.

Hope my issue is clear. do I have to install something? please advise.

|||Do I need to install SP1 even if I don't have SQL engine in my PC? i only have client tools in my PC. Please advise.|||

Hi,

which framework and OS are you using? are you sure, that you have all privelegs - to your databases?

|||

I have .NET 1.1 and 2.0 in my PC. I am using Win XP SP2. I already applied SP1 for SQL 2005 in my PC. still same error is encountered.

I have SQL 2000 and SQL 2005 Client utilities in my PC.

I didn't encounter it in Query Analyzer. Only when I use Management Studio.

I am using SA account.

|||

I have the same issue and have yet to find the resolution. One thing I have noticed is that the issue does not occur if you set your results to Text Mode. The issue appears to be related to mscorlib.dll.

|||

Could it be resolved by replacing the same dll with one from a working PC? or do i have to consider something like file version etc.?

|||

Hi all,

Any comment/suggestions to resolve this issue?

|||

I was able to resolve this issue on my system. It turns out that the client firewall tool used at my company "BlackIce" was detecting a buffer overflow exploit when making the calls to mscorlib.cll. I was able to list "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" as an exception to rule and all is fine.

I hope these findings help you as well.