vbscript secure connection to mssql server

April 8, 2011 at 02:04:22
Specs: Windows XP, 2,4Ghz/1G
Hello,

can anyone help me with vbscript that connects to sql server over internet using secure connection?


See More: vbscript secure connection to mssql server

Report •


#1
April 9, 2011 at 02:15:26
Assuming the server's set up correctly, I believe you just add "Encrypt=yes" to the connection string.

How To Ask Questions The Smart Way


Report •

#2
April 9, 2011 at 09:29:24
i did, but it always times out

Report •

#3
April 9, 2011 at 18:22:42
Check the relevant firewalls/routers. You probably need to open up whatever port SQL Server uses for encrypted access. A quick Google search suggests it's TCP port 443.

How To Ask Questions The Smart Way


Report •

Related Solutions

#4
April 10, 2011 at 02:04:48
Please hoe do i open this port in my firewall, am using winxp sp3, i hop this won't incur security vulnerabilities

Report •

#5
April 10, 2011 at 02:07:31
It'd need to be done on the server side / server's network side.

How To Ask Questions The Smart Way


Report •

Ask Question