span8
span4
span8
span4
I have made a connection local with FME 64b to SQL server.
This worked for about a half year but now I get the message:
Error: COM.亚搏在线safe.fmeserver.api.FMEServerException: User encryption is specified but can't find key to decrypt.
and
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host ...,named instance ….,...failed.Error: "java.net.SocketTimeoutException: Receive timed out".Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434.For SQL Server 2005 or later,verify that the SQL Server Browser Service is running on the host.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:3639)
According to the DBA-er nothing has changed (ports are ok and there is no firewall inbetween) and when I try to log in with SQL DEVELOPER there is no problem.So I tried different varieties as :
主机\实例,端口
Host:port
etc but nothing works.
Do you have an idea what might be wrong and how I can fix this?
Thanks for your reply.Recently installed FME desktop 2018.1.0.2 build 18547.
Now I have removed the old connection and inserted a new MS server-connection and this works ok.
Thanks for your support.
Hello Xiaomeng,
The connection worked for about a half year.Every new connection to sqlserver - I have tried several string connections - but nothing works.
I'm using 2017.1.0.0 (20170731 build 17539 WIN32)
I'll ask the DBA-er for an update.I hope this will solve the problem.
Thank you for your input.
Perry
Hello Xiaomeng,.
I don't use a custom encryption key.
When i run the workspace on the server with the same connection (usr and pw) for sqlserver it works fine.When I run the workspace local on my laptop it will fail.
The server is installed by a FME-consultant and I do not have much knowledge of this install.
On the server with the user admin I only have Version Control in the System Configuration
("On the General tab of the System Configuration page,expand System Encryption,and select Encryption Mode: Restricted.")
thank you for your information
How to connect to SQL Server while setting trustServerCertificate=true1 Answer
Modifying SQL Server Connection String2 Answers
How do I connect to a Microsoft SQL Server database using an Active Directory service account?1 Answer
Is there a method for reading a SQL Server 2008 Compact Database File (*.SDF) in FME 2017?3 Answers
SQL Server Writer - switch between Bulk Insert = Yes for reload and fme_db_operation for updates1 Answer
© 2019 亚搏在线Safe Software Inc |Legal