Synchronising Via HTTPS
Dec 1, 2005Hi,
View 4 Replies
ADVERTISEMENT
Synchronising Logins(Urgent)
Nov 19, 2001Hello,
I've installed development server and created the databases, and restore the ddatabase from backups of production server, There the users in the databases which are not in sysxlogins in master, Please guide me how I can synchronise the logins? Can I bcp out sysxlogins from development and then bcp in in development server? Is there any way there even groups in the database and do I have to corncern about any other tables in master db
Thanks in Advance
Alpa
Synchronising Databases With Different Schemas
Apr 28, 2008Hey folks,
I'm looking to gather ideas on this before I start the project; so what better way to start than to ask here? ;)
The situation is this: we are in the process of replacing a large data driven application with a new one. Before turning the old'un off (that's not for a minimum of 6 months), we need to migrate data between the two entirely different schemas, and I've been tasked with writing the interfaces.
Now, here comes the kicker; they don't just want a "straight-forward data conversion", they want to run a period where they can still update both databases and any changes in the old one are to be pushed into the new db.
Because the schemas are not the same, I believe replication is out of the question so I was looking for advice as to what possibilies I have ahead of me to achieve this.
I fear I may not have expained this well enough; so as always if there are holes in the detail let me know and I'll do my best to fill them in :)
Old db = SQL Server 2000
New db = 2005
Thanks,
George
Synchronising With Remote Server
Dec 25, 2005HiWe have an internal ms access database which we need to synchronise with ourwebsite with sql server 2005 backend which is hosted on a public host. Myquestion is; is there a way to keep the two databases synchronised using thetechnologies built in sql server 2005 and/or access? We also have thepossibility of an in-house sql server 2000. Can this be used in anyway tohelp, perhaps by moving data from in house access to in house sql server2000 and then synching sql server 2000 and remote sql server 2005?ThanksRegards
View 1 Replies View RelatedSQL CE Merge Synchronising Schedule
Jun 27, 2007Hello guys,
I'm stumped. Is there a way to get a compact edition client (running on a standard PC) to automatically sync. (using merge replication) with a server on a schedule?
I can quite happily pull up SQL Managerment Studio and sync. on the client, but I want to have something running in the background basically doing this for me (again, on the client). I know I can do it in code, but we've not yet received our Visual Studio package, so for the moment, I want something already written to do it for me.
Surely this must be possible?
Thanks in advance!
SYNCHRONISING XDA MINI S WITH PC USING VISTA
Jan 23, 2008I have a problem synching my xda mini s with my pc using vista. A previous thread was unhelpfully closed by Ilya as being off topic; well it isn't on topic anywhere else. At least not according to microsoft's own search engine. Ilya, why not try giving a helpful answer instead of 'not my problem'? My xda will not synch using vista; XP and ActivSync has been perfect. I've tried installing mobile device centre version 6.1 but I suspect vista isn't compatible with Windows mobile version 5.1. Should it be? If not, is there a patch or is upgrading to vista going to cost another couple of hundred pounds to get a compatible mobile device? If so, I'm off to a different operating system. Perhaps, like many others, back to XP and let Microsoft continue to dither around and experiment on others.
View 1 Replies View RelatedSynchronising Data Between 2 SQL Server 7 Databases - Help ;o)
Oct 4, 2001Hi, can anyone point me in the right direction of how to sync an in-house SQL Server 7 with a remote SQL server 7.
We are a development house. We build website using SQL server 7 databases then move them up to an entirely different SQL server 7 database in a remote location.
Now, please don't laugh, currently we export all the data from the development server into a csv and import it back into the live server. As you can imagine, it's clunky, time consuming and unreliable.
Is there a way to automatically sync the two? I tried desperately to find any information but even the MicroSoft MCSE training manual on SQL doesn't say how to do this.
Any help would be greatly appreciated.
Thanks in advance.
Chris
Synchronising/replicating Access With Sql Server
Dec 28, 2005HiIs there a way to synchronise/replicate an access db with sql server 2000db, short of writing the code oneself?ThanksRegards
View 1 Replies View RelatedSynchronising Data Between SQL 2000 32 Bit And SQL 2005 64 Bit Servers
Nov 17, 2006Hi
I have a production system running sql 2000 server 32 bit
Now i am planning to move to SQL server 2005 64 bit setup .
I need to have a set up of both SQL 2000 and sql 2005 in parallel for some time until it is sure that the sytem can completly move .
The problem is how do i synchronize the data in the two servers when they are operating parallely.....
Please advice.
Thanks in advance......
Synchronising SQL CE Database With SQL 2000 Using Active Sync In 2003
Feb 8, 2007HI ,
I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem
Thanks in Advance
Regards
Ihsan
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.
Cannot 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