Monday, March 12, 2012

reporting services in SQL server 2005 express edition

I want to know if reporting services are available in sql server 2005 express edition that is running along side visual web developer 2005 express edition because i cant see reporting services in the configuration tools. This is Urgent, that is of course if you have the time.

Thanks .

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

"Reporting Services features are not yet available in SQL Server 2005 Express Edition."

|||

aus_nexxus:

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

"Reporting Services features are not yet available in SQL Server 2005 Express Edition."

That is not correct Microsoft have now added advanced features for SQL Server Express which includes all but the Agent and database Mirroring with trade offs. Try the link below for details. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.|||

Nick Asiimwe:

So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.

It is available with the Advanced features download link I posted. Hope this helps.

|||

Okay. So what happens to my applications database if i upgrade from sql server 2005 express edition to sql server 2005 express edition with Advanced services. I feel i need to enhance my reports with SQL server reporting services urgently.

Please remember that iam running the 2005 express edition with visual web developer 2005 express edition.

|||Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.|||Yes thanks. So help full|||

Caddre:

Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.

OH?

1. I had problems with User Instances..."could not create user instance..."

2. Ensured user instances was on in SQL Server...the app complained about user instances not supported.

3. Tried to run the ASP.NET Configuration tool against my application...it complains about user instances...

4. Uninstalled everything; reinstalled SQL Server Express with Advanced Features followed by VWD and Languages (as before)

5. It no longer complains about user instances...but it now tells me I have not created the security database that was created by default before and when I look in the apps folder...nada database...even my own is gone (thank goodness only a trial base) yet all my previously written files are there.

6. Based on 5 above, it tells me to run the command line utility called aspnet_sqlreg...when I look up the docs on this little gem, it says that it MUST NOT BE USED WHEN USER INSTANCES is enabled.

7. So here I sit, looking for help...find my issue quite quickly, only to fine a curt answer with links to features and stating...NO problems.

Nope. NO problems here!!!

Any more thoughts on this?

|||

P.S. to my last post.

Sorry for being a Newbie, finding and exploring features I need/want.

|||

eyetech:

P.S. to my last post.

Sorry for being a Newbie, finding and exploring features I need/want.

No problem I am here to help, so here is the it is free but you need to this or it will not run list from Microsoft I knew there must be such list so go through it and let me know if you need more help.

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

No comments:

Post a Comment