Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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 8:48
    
also when you say a secure mssql server, secure in what sense? –  tony roth Apr 22 '11 at 19:41

2 Answers 2

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.

share|improve this answer
    
i have tried this, but it fails –  Smith Apr 22 '11 at 8:48
    
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 4:13

btw the answer to this question "is there pilicy that restrict script connecting to secure servers?" is no!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.