remote connection sql express 2008
-
Hi, look im going to configure sql express 2008 for accepting remote connection, BUT, automically ... I mean the enduser will not set anything, after installing sql express it whould be configured for network connections and etc. actually i need sql scripts for this...
-
Hi, look im going to configure sql express 2008 for accepting remote connection, BUT, automically ... I mean the enduser will not set anything, after installing sql express it whould be configured for network connections and etc. actually i need sql scripts for this...
As in a local Sql Express database that you just installed? Enabling is explained here[^], but a word of warning though; it allows Sql Express to receive commands that originate from another computr - and that might be someone with malicious intent. If someone could get into the server without permission, chances are that they could execute scripts. That could include scripts that modify the filesystem and/or the registry! Next point to consider; even if you install Sql Express with the option to allow remote connections to be made, there might still be a firewall disallowing it.
I are Troll :suss:
-
As in a local Sql Express database that you just installed? Enabling is explained here[^], but a word of warning though; it allows Sql Express to receive commands that originate from another computr - and that might be someone with malicious intent. If someone could get into the server without permission, chances are that they could execute scripts. That could include scripts that modify the filesystem and/or the registry! Next point to consider; even if you install Sql Express with the option to allow remote connections to be made, there might still be a firewall disallowing it.
I are Troll :suss:
-
Thank you, but the link does not work! this is the link for sp of enable remote: http://www.sql-articles.com/index.php?page=Scripts/remoteconn_dos.php[^] which opens no downloadable text page!