I don't know if anyone has been able to connect to a secure mssql server over the internet with vbscript using the adodb object
is there pilicy that restrict script connecting to secure servers?
Asked
Active
Viewed 723 times
0
-
Is the server behind a firewall? If so, you would need to tunnel through that first. – uSlackr Apr 21 '11 at 21:28
-
@uslackr i can connect to the same server using visual studio 2010 with the same connection string, without any problem. i would have posted a connection string along with the question, but by then it would be a programming problem and not fit in here. – Smith Apr 21 '11 at 21:41
-
how are you handling the password? – tony roth Apr 21 '11 at 23:36
-
i set persistent security info to false in the connection string – Smith Apr 22 '11 at 08:48
-
also when you say a secure mssql server, secure in what sense? – tony roth Apr 22 '11 at 19:41
-
also go ahead and post the connection string. – tony roth Apr 22 '11 at 19:42
-
Data Source=www.serveraddress.com,port;Integrated Security=True;User ID=myid;password=mypassword;Encrypt=True;TrustServerCertificate=True – Smith Apr 22 '11 at 20:06
-
@tony the server is configured to accept only secure connection through ssl – Smith Apr 22 '11 at 20:07
-
what error message? – tony roth Apr 22 '11 at 23:21
-
`"The requested action with this object has failed."` – Smith Apr 23 '11 at 09:18
-
and this error is on the line number that corresponds to the connection being created? – tony roth Apr 23 '11 at 13:58
-
the line number `84` is the number of the connection object e.g **objAdobHandle.open(connectionstring)** – Smith Apr 23 '11 at 15:43
2 Answers
0
If the server has been setup with a certificate then you can add "Encrypt=yes;" to the connection string which will encrypt the connection over the network. If you want to force encryption for all connections then enable the "force encryption" option and restart the instance and all connections will be encrypted.
mrdenny
- 27,174
- 4
- 41
- 69
-
-
What error message are you getting? Can you connect from the native tools over a secure connection? If you have force encrypted enabled, then no changed to the connection string are needed. – mrdenny Apr 23 '11 at 04:13
0
btw the answer to this question "is there pilicy that restrict script connecting to secure servers?" is no!
tony roth
- 3,884
- 18
- 14