Publishing A Report And Its Destination

May 7, 2008

Anyone know how I can direct different reports in the same project to different folder on the SSRS site? I can get everyone to publish to one folder, but want to know if its possible on a report/report basis to different folders

View 3 Replies


ADVERTISEMENT

Deploying(Publishing) The Report

Jun 11, 2008

Sir,

I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..

Can u suggest any solution to do the same..

Looking Forward to an early reply..

Thank You!!!

View 1 Replies View Related

Publishing A Report Programmatically.

Jun 5, 2007

Hi!



I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

View 1 Replies View Related

Publishing Report In Window Forms

Nov 27, 2007

I have a dropdown which shows all the available reports on reporting server. What I want to do is when a user select a report from dropdown and click on RUN REPORT button. That particular report will run. I am using VB.NET 2.0 version. One way which i am thinking is to use ReportViewer Control. Is there any other way to publish the reports in window forms or ReportViewer will take care. Kindly guide.

Thanks,

View 4 Replies View Related

Unable To View Reports On Report Viewer After Publishing ASP.NET Web Site

Oct 31, 2007

Hi,

I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':

http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg

When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.

Thank you.

Regards,
Antonio

View 1 Replies View Related

Publishing Report Server Through ISA Server 2006

Nov 20, 2007

I am having all kinds of problems publishing report server through ISA Server 2006. Are there any guidelines? My biggest problem is that the browser returns an error page that says ISA Server is configured to reject requests that require authentication even though I have configured ISA and the default website to allow anonymous access and require no authentication in the web listener or the firewall policy.

I have a policy that maps an external IP to the default website which has a private IP - 192.168.1.203. I have an A record in my DNS for the external IP. So, I should be able to goto http://MyReportServerSite.com/Reports/Home.aspx. NO GO! Any ideas? I have configured many other web listeners/policies for other sites and they all work fine. I've done this at least twice.

BTW, thanks to MS for the myriad of myriad of dialog boxes, property pages, dropdown lists, check boxes, etc. ad infinitum for configuring ISA Server 2006. I can't even begin to imagine calculating all the permutations... Each iteration of the product seems to get more complex. :-( Hep me, hep me pleeeease!

View 1 Replies View Related

Publishing Sql Db

Aug 2, 2007

web site made in web dev
db all ok locally
got server at local ip.......
need to upload script files to server...
got microsoft publishing wizard all working and database all scripted out.
server consul looks like horrible unix outfit.....virtuozzo
question is now what?
ip says use enterprise manager to publish to server......is that the old
version of management studio express, which i have 

View 17 Replies View Related

Help With SQL 7.0 Web Publishing

Jun 22, 2001

Hi Guys,
I have been trying to use SQL Server 7.0's Web page Publishing tools with Microsoft Frontpage without sucess. I can created the web pages using SQL that it works fine. I have the page set to change automatically when the data is changed and this works while the page is accessed from the SQL Server, however when I upload the page to a frontpage Web, the automatic update does not work. Any ideas what I'm doing wrong?

View 7 Replies View Related

Web Publishing

Jan 16, 2001

Dear All,

I am experimenting with the Web Publishing feature in MSSQL 70. Does anyone have any pros and cons when utilizing this feature within MSSQL 70?

I also would like to ask if anyone knows of a different way to access the Web Page designed other than placing it in an accessible file either in a repository or a central site and have people click on the *.htm document thus pulling up the related page on the W3.

Has anyone been able to go from the MSSQL 70 directly to a browser instead of opening the created *.htm file?

Please let me know.

TIA,
Daimon
daimon.russell@bridge.com

View 1 Replies View Related

Can't See Web Publishing

Nov 14, 2001

Hi everybody ,
can't see web publishing icon on any of 6 Sql 2000 servers
What has to be set first ?

Thanks

View 2 Replies View Related

Www Publishing

Sep 23, 1999

We are experiencing intermitant problems on out SQL 7 system. Its running FTP publishing, MS SMTP service and the www publishing service. We reset the services using net stop <service> each morning. When I use the command 'net stop www publishing service' I get the message - The service could not be controlled in its present state. This would indicate that the service has hung. The problems seem to happen over night and is cured by a reboot.

Any ideas anybody ?

Thanks in advance

View 1 Replies View Related

Publishing Tables Not Available

Aug 16, 2000

When managing publication for a particular database, not all the tables are listed as articles to add to the publication. Is this a permissions problem? Any way I can check out why they aren't available or, better yet, make them available for the publication?

View 2 Replies View Related

Publishing Subscriber

Sep 24, 2001

Hi!
How is it possible to set up a repl. scenario, where a subscriber of a DB
is also the publisher of this DB for other subscribers. i mean 3 level repliction. MAINPUB
SUB1 SUB2 SUB3
notebookSUB1...................notebooksubN

SUB1..3 are subscribing to MAINSUB and publishing to a number of notebooks!

Any help would be greatly appreciated!!!
TIA

View 1 Replies View Related

Publishing From SSIS To Web

Apr 11, 2008

Hi,

I have created a data file using SSIS, I want to publish this on a web, how could i achive that any step by step approach is welcome.

Thanks,
With Best Regards,
Madhu

View 2 Replies View Related

Publishing Problem

Dec 31, 2006

My test sql seems to be working like a train now. Also now discovering the full functionality

of sql and can see that im at the bottom of a large hill, but an interesting one.

My next problem is publishing.

My hosting package has been upgraded to the version 2.0 asp.net runtime. and has sql enabled.

web dev.......copy function drops all the files into the server nicely and i can see them all.

The problem is it will not compile or show, and returns.........you do not have privaleges to view this htm.

All a bit strange to me but???

I have not touched any of the security controls in the config manager or code.

Anybody else had these issues or problems

regards Richard

View 1 Replies View Related

Publishing Web Application

Jun 29, 2006

Hello to everybody.

I got a problem like this:

I developped a project using Visual Studio 2005 Standard Edition on a XP pro x64 Machine using a developpemet data area on a SQL 2005 Express Edition.

Everything is ok, even the user and profile management. But when I try to publish my application on IIS (we're talking about a little Intranet), I get my problems. I think is important to say that the server is a Windows Server 2003 and data (database reproduced as a backup of the developpement one) are under an SQL 2005 Standard. The strange thing is that by publishing the "site" VS create a DB under SQL Std named with the path of local ASPNETDB.MDF.

I can reach everything, all data are ok, but when I pass the login page going to main menu on my web-application, I get this error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I think the problem is SQL STD and the fact that it's not "able" to manage MDF files.

I even tried to re-map the SQL DB (named simply as ASPNETDB on the SQL std) by adjusting the web.config file on connection type and user and password to reach the DB ASPNETDB but it does't work anyway.

Can anybody solve my problem?

Thank You





View 4 Replies View Related

Help Me (Database Problems After Publishing)

Apr 18, 2007

I am using ASP.NET 2.0 C#, SQL Server 2000Connection string is: "Data Source=USMAN;Initial Catalog=CMS;Integrated Security=True"
And by searching forums and goodle, I have also set sql server 2000's secutiry as mixed modeInfact When I compile and run my projcet from visual studio it is fine, every thing works ok
Then I publish my site to a folder on desktop, when publishing completed I right clicked the folder and in web sharing option I added alias = CMS
Now when I open: http://localhost/CMS/Home.aspx, then it works fine infact all the pages that dont have SQL Server 2000 connectivity work fine, but as soon as I open some page that has connectivity with the database, it gives me error like:
Login failed for user'USMAN/ASPNET'
I wonder why this error only comes after publishing, there is nothing probemaltic when running it from Visual Studio, plz tell me what to do

View 1 Replies View Related

Importing Sqldatabase And Publishing It

Apr 20, 2007

HI,
I am working on a project in which a user can upload his database to the server...then he is able to view all the schema or execute any kind of query. Then he goes to some other machine and login and wants to download the database.
For example  Alex have uploaded the database consisting of 1000 records to mysite. Then He goes to texas to find some oil wells. He  is on another machine ... I download the database .... inseert new records and upload it back.
Its an example basically I want to know how to include the users' uploaded into my sqlserver and when required publish with data on his machine...
 Thanks.
 
 

View 4 Replies View Related

Publishing Wizard - Bad Magic?

Aug 26, 2007

I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature".  Or am I missing something?
I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data.
Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table.
From good habits I looked at the script before deploying it. It drops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables).
Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away.
Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?

View 5 Replies View Related

Database Publishing Wizard

May 27, 2008

We are trying to script out database schema and data with the Database Publishing Wizard and are having problems with output script trying to create views and stored procedures before the tables they depend on.
I've seen discussion of this on their codeplex site and back in April 2007 they said that the CTP they just released fixed the problem - but we are still seeing it.  Does anyone know a solution for this (beyond the obvious copy and pasting into the right order)?
What we are trying to do is move the SQL and some basic reference data into source control and a CI process. 

View 2 Replies View Related

SQL Server Publishing Error.

Dec 22, 2004

Hey all,

I received this publishing error a while back and can't think of a reason I would be receiving this error.

SQL error occurred. See entry specific information. Error : 21010, 01000, [Microsoft][ODBC SQL Server Driver][SQL Server]Removed 0 replicated transactions consisting of 0 statements in 6 seconds (0 rows/sec).

The error came just before another error:

SQL error occurred. See entry specific information. Information : 1205, 40001, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

I'm wondering what would cause these errors, if someone could point me in the right direction that would be great.

Cheers,
-Kilka

View 2 Replies View Related

Cannot Open Database After Publishing

Feb 11, 2007

Hi All,

I have developed a database application using c# and SQL Express 2005.

I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:

Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".

The remote machine has SQL server express installed.

Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here.
Any help would be greatly appritiated.

Thanks
Jon.

View 3 Replies View Related

Could Not Disable Publishing And Distribution

Jul 8, 2006



hello All,

i am trying to delete publications in SQL 2000, SP4 and getting this
error:

SQL Server Enterprise Manager could not disable publishing and distribution on '<publishername>'.

Error 3724 : cannot drop the procedure
'dbo.sp_sel_F854ED4CD7EA4399EFDB9697F4E24A10_pal' because itis being used for replication.



Thanks and Regards



Kanna




View 1 Replies View Related

Cannot Open Database After Publishing

Feb 11, 2007

Hi All,

I have developed a database application using c# and SQL Express 2005.

I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:

Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine nameuser name".

The remote machine has SQL server express installed.

Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here.
Any help would be greatly appritiated.

Thanks
Jon.

View 6 Replies View Related

Replication - Install Publishing Error

Jan 12, 1999

When I try to 'Install Publishing' from the 'Replication Configuration' drop down on the 'Server' Menu within Server Manager I receive the following error:

"Replication cannot be installed as @@SERVERNAME is NULL"

Please Help.

James

View 1 Replies View Related

Error 8157 When Trying To Disable Publishing

Aug 6, 2001

I am trying to disable publishing on a server. When I attempt to do so
I get the following error:

"Error 8157: All the queries in a query expression containing a UNION
operator must have the same number of expressions in their select lists.
Could no use view of function 'sysextendedarticlesview' because of binding errors."

There is more error message text but it's a repeat of the UNION and sysextendedarticlesview problem.

Can anyone help me with this?

Thanks!

Kurt

View 1 Replies View Related

SQL Server Database Publishing Wizard

Oct 20, 2006

Now here is something I have been asking the SQL Server Team for a long long while : http://www.microsoft.com/downloads/details.aspx?familyid=16D8C1E9-A6A3-43A2-9BA7-916C6EB5023B&mg_id=10046&displaylang=en . I hope this will be of use to many of us

View 1 Replies View Related

Publishing A View In Excell With Parameters

Mar 9, 2007

Hi

I am publishing a SQL view in excell using the external data/new database query option and accessing SQL server via ODBC datasource defined.

The query I use aggregates data between 2 diferent dates. I am able to pass the initial date and the end date to SQL, but the results are not aggregated becase I am forced to put in the view the GroupBy clause for the field DATE.
Is there any way of passing parameters to SQL (via Excell) and retrienve the aggregated data based on this parameters?

Many Thanks
ds9

View 3 Replies View Related

Recreating The Data Publishing Wizard

Mar 27, 2008

Hi,
I was wondering if anyone had an idea if it's possible to run a stored procedure that would basically output a .sql file used to recreate the database elsewhere. kinda like the data publishing wizard does.

?
tx

View 1 Replies View Related

Publishing From Oracle To Sql Server 2005

Sep 13, 2005

HI guys,

View 3 Replies View Related

Reporserver Not Working After Publishing In ISA (internet)

Dec 6, 2006

We have the following scenario,

Have host of web applications deployed under websites ( /app1,/app2,/app3)
We have created a virtual directory under website ( /web)
All the virtualdirectories created under root is again creaed under web virtual directory ( /web/app1,/web/app2,/web/app3)
Reportserver is configured to work (website/reports)
And manually reports virtual directory created (website/web/reports)

http://website/app1
http://website/app2
http://website/reports

http://website/web/app1
http://website/web/app2
http://website/web/reports

work, and we have published /web in ISA so that from internet I would be using the beow url to connect


http://domainname/web/app1
http://domainname/web/app2
http://domainname/web/reports


work€¦I am able to view reports from internet using http://domainname/web/reports

but when I lauch reports from http://domainname/web/app1 reports are not getting launched .can comeone suggest where I went wrong in configuring
i have oly port80,443 open between my ISA server and webserver.

Thanks in advance

View 1 Replies View Related

HELP Publishing A Site With Password Protection

Oct 29, 2006

I am new to Visual Web Developer 2005 Express.

I have created a web site containing a login control. It works great on my local machine, but when I copy it to the server, I get the following error when I try to login to the website:
Server Error in '/mrallensclass' Application.


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:





[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734931
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102




How would I correct this? It appears I need to change the setting for SQL Server 2005, but how do I do that? Thanks for your help.

View 1 Replies View Related

Announcing - SQL Server Database Publishing Wizard CTP 1

Oct 17, 2006

The SQL Server group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1.The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server.  The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster.  In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles.  In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.Details on the Database Publishing Wizard as well as the download can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!Thanks,Dan WinnSenior Program Manager, Microsoft SQL Server

View 15 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved