Using Https
Mar 15, 2006I am going to use https for our website. Will this encrypt all of our web page? Can i just use https for some of pages?
Many thanks.
ADVERTISEMENT
Synchronising Via HTTPS
Dec 1, 2005Hi,
View 4 Replies View RelatedCannot Print From ReportViewer When Using HTTPS
Nov 1, 2007Hi,
We are using the ReportViewer web control (SSRS 2005) to render server reports on a webpage that is exposed over the internet. Clients connect using HTTPS, however they are connecting to an ISA server which forwards the requests to the website using plain HTTP.
Reports are shown correctly, however when the user clicks the print button, the request to the web server is sent using HTTP not HTTPS and the ISA server is not allowed to accept incoming HTTP traffic. The result is that reports cannot be printed. We have proven that the reports do print if we manually alter the request to use HTTPS, so there is definitely no problem with our printers.
The problem is that we cannot work out how we can get the print request to be automatically sent using HTTPS.
We had a similar problem when we implented ReportBuilder, but we got around this by specifying HTTPS in the ReportServerExternalUrl tag in the RSWebApplication.config file. Unfortunately this has no effect on the print request from the ReportViewer.
So if anyone has got a solution/workaround/suggestion for this problem we would be very grateful.
Thanks,
Dean.
Tunneling Enterprise Manager Over Https ASP.NET?
Jul 23, 2005My host does not provide a good web based management tool for the sqlserver database I am using. They queue imports and exports so it takesseveral hours before things are finished. They provide this web basedaccess and access through asp or asp.net. Does anyone know how I couldtunnel a connection from enterprise manager to the database using aasp.net web application?ThanksTy
View 1 Replies View RelatedHTTPS Access To SQL 2005 Cubes
Sep 18, 2006Hi there
I have two machines one 64bit machine with SQl 2005 on it and another 32 bit machine which I use as my web server both running win2003. I have followed the knowledgebase article from Microsoft (http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx) and also researched postings on this site but can't seem to access the cubes remotely. I have changed to msmdpump.ini file to have the <ServerName>mycomputername</ServerName> which points to the SQL box.
I can connect to the cubes from the 32 bit machine using somethign like crystal reports and connecting directly to the server name but can't connect to https://localhost/olap/msmdpump.dll I get an error about could not connect to the computer name or the computer is not runing analysis services.
Any ideas?
Cheers,
Derek
Https && Setting ServicePointManager.ServerCertificateValidationCallback
Jan 22, 2006Hi,
In my CLR stored procedure, I made a https request. To by pass the security check, I change the property of ServicePointManager: ServerCertificateValidationCallback . But SQL server 2005 does not allow me to do this and gives me exception related to security.
It seems the CLR assembly does not have permission to set the property of ServicePointManager: ServerCertificateValidationCallback.
What kind of user should I use to run this stored procedure?
I already assign external_resource to the assembly in SQL server 2005.
The code:
ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(myCertificateValidation);
public bool myCertificateValidation(Object sender,
X509Certificate cert,
X509Chain chain,
SslPolicyErrors Errors)
{ return true; };
thanks,
Guangming
Unable To Access Sqlcesa30.dll Under Https://
Apr 20, 2007I'm unable to do a RDA.Pull() when I have the sqlcesa30.dll running under HTTPS. What are the requirements to allow me to pull with the dll under HTTPS?
what are the impacts running under https:?
HTTPS Merge Client Synchronisation Issues
May 1, 2007Hi
We have about 70 clients, each with their own databases synching to a copy of their database on a remote webserver. They synchronise using a Windows Service which we wrote using RMO.
For completeness, our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
Sometimes, one of our clients synchronisation goes up the spout - it might take hours to synchronise - despite their internet connection being fine. And once this starts to happen, nothing will fix it. We've restarted their server, rebooted their router etc etc.
Well, the only way of fixing it is to recreate the publication, copy the backup, reinitialise and start again, which costs us a days work and inconveniences the client greatly.
What would be the likely trigger for this. How can we stop this happening again.
If it helps we could create a trace to help resolve this.....
Regards
Bruce
SSRS Reports On A Secure Server (https:)
May 1, 2007We currently have a few reports running on a external website. The users have to log in to the website using their Domain Username and Password. Our network admin wants to move from simply http, to a secure https protocol.
My question is: Are there any conciderations for making this move? ...Will it break my reports?
Problem Pulling Data Using HTTPS -SQL CE RDA Pull
Feb 2, 2008
Hello All,
I have an application pulling data from SQL Server 2005 which is running on windows mobile 5 devices, and RDA is setup and working perfectly over http and this is in the production for long time, but we have decided to implement SSL for transportation recently and we have a certificate installed to the server and i am trying to pull data using https and getting "the request to send data to the computer running IIS has failed" message, only RDA stopped working over SSL, i can access scripts and other resources from the device using https (I made code to trust any certificate for any web requests) the link to the dll is accessible from outside, i have installed the root certicate on the server, the virtual directory has been changed to communicate via https on web synchronization wizard, then problem occurs, otherwise it will work ok, i am totally stuck at this point, is this a problem with port setup port 443 is opened, the issue is clearly a SSL issue. any help would be appreciated..what are the things to be done to implement SSL for RDA, i don't see anything more in msdn.
thank you so much!
sush
WebRequest Over HTTPS Fails Under SQLCLR, But Works Elsewhere
Mar 1, 2007I have some code in a SQL CLR stored procedure that calls out to a web service at UPS to obtain tracking information for a package.
The code fails on the last line, in the call to WebRequest.GetRequestStream(), with the following exception:
"System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream()
at UPSTracking.TrackShipment(String TrackingUri)"
Here is the relevant code:
WebProxy proxyObject = new WebProxy();
WebRequest request = WebRequest.Create("https://www.ups.com/ups.app/xml/Track");
request.Proxy = proxyObject;
request.Method = "POST";
request.ContentLength = strXMLData.Length;
request.ContentType = "application/x-www-form-urlencoded";
StreamWriter sw = new StreamWriter(request.GetRequestStream());
This same code works just fine when not running in the SQL CLR assembly. The assembly is marked as External, but I've also tried marking it as Unsafe, which did not work either.
Any suggestions on what the problem might be or how to troubleshoot this further would be greatly appreciated.
Thanks,
Steve F.
Password Expiry With HTTPS Merge Replication
Feb 13, 2006Hi
We are using anonymous HTTPS merge replication.
The windows password used for the client subscriber expired on the publisher.
I reset it on the publisher - but SQL still seems to think that it is not expired - I get the following message in the event log of the publisher running SQL Server 2005
Login failed for user 'XYZ'. Reason: The password of the account has expired. [CLIENT: <local machine>]
Any ideas ?
thanks
Bruce
Connect To Analysis Manager Over HTTPS And Non Domain Account
Oct 25, 2005Please, I need your help... I`m desperate...
I`m trying to connect to the Analysis Services (AS 2000 Enterprise Edition SP4 on Windows Server 2003 EE, respository is in Access DB) throught Analysis Manager over HTTPS(HTTP) connection. I dont want to use domain account.
I need to specify USER_ID and PASSWORD to the Analysis Manager, but in registration of new server is only IP address or HTTP adress (for http://server) - but it doesn´t work - it says Unauthorized. But I`ve tried to use Anonymous account and it doesn`t work (client wan`t able to make connection)... I would like to use Basic Authentification.... Thise account is member of OLAP_Administrators... but the problem is where should I put USER_ID and PASSWORD???
It works perfect in Excel 2003.... MSOLAP.asp work fine in IE...
Thanks very much for your advise
Ricmond
Report Manager Http/https - Mixed Links
Aug 10, 2006Hi,
I have setup reportserver with default settings (non https) and afterwards in IIS added a certificate and https support.
Know I am able to work really well and secure over the internet, but some links in report manager pointing to http://server.domain.com/reports instead of https:
For example if i call a report and then in the top there are (view, properties,...)
- View is HTTPS
- Properties is HTTPS
- History is HTTP
- Subscription is HTTP
I have read some articles - mentions I should configure https, but
- in Report Configuration you could not setup HTTPS
- in rsreportserver.config i have entered the https link version but did not change anything
- in RSWebApplication.config the Reportserverurltag is blank - so i did not change anything
Thanks for any help
HANNES
Access My SQL 2005 Express Database Using Http/https
Nov 22, 2006Hi!
I'm new using MSSql 2005 Express. How can i access my DB using http/https for reporting and DB changes/administration?
Regards,
JP
Power Point :: HTTPS Web Application - Could Not Load Type
Jul 17, 2015I have a Web application in SharePoint 2013 which is HTTPS. I have powerpivot installed and it is working fine when I try to access the PowerPivot Gallery with the port number.For e.g. URL...Everything is working fine.
But when I try to accesss the same URL...without port number I am getting the error. something went wrong Could not load
type 'Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView'.
SSRS 2005 - Linked Report Email Doesn't Have Https
May 19, 2008I've got a report server that I recently inherited. I'll be the first to admit that I'm not an expert on SSRS, but I've figured out a lot in the past few weeks.
One issue I'm having (apparently it's always been there, but nobody ever bothered to fix it in the past) has to do with the report subscriptions and linked reports. We have an SSL cert inside IIS. I have SSRS configured to "require SSL connections" in the Report Server Virtual Directory tab.
So the user gets an email with a link to a report. But the link has an "http://" as opposed to "https://." When you click on the link, it throws your standard "page must be viewed on a secure channel." When I manually append an S to the url, it works great.
There has to be a way to automagically add the S to the url, but I can't seem to figure out how. Anyone ever run into this before? Google has not been good to me this morning either.
Changing Merge Agent Profile For HTTPS - MergeSubscriberType = Anonymous
Aug 8, 2006Hi
We are using HTTPS merge replication
Our setup is as follows:
subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
Some of our subscribers have low-quality internet connections - how do I get the agent at the publisher/distributer use a slower profile - I've read How to: Work with Replication Agent Profiles (Replication Transact-SQL Programming)
but can't see where you specifiy an alternate agent profile
On the distributer / publisher (same machine) I go to replication monitor -> Warnings and Agents - I can only set the profile for the snapshot agent....
thanks
Bruce
Reporting Services :: How To Enable HTTP For Existing SSRS Service With HTTPs
May 19, 2015How to enable http for SSRS service in my current sharepoint 2013 environment with https.
this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.
Replication :: Check If Web Merge Sync Is Working Between Subscriber And Publisher Thru HTTPS?
May 14, 2015How to check if web merge sync is working between a subscriber and publisher thru HTTPS ? SQL port 1433 at subscriber is blocked so no direct connection to subscriber.
View 2 Replies View Related