Re^2: Connect to remote MSSQL database with DBD-ODBC?

JamesNC wrote: "Your dba has to set up a seperate account for remote logins."

Seems like I need to set up this account / settings without the help of the customer... since their database admin doesn't seem to have any experience with how to do make that happen. I seems like it will be part of my job to make it work... The database server has been on the intranet for years (not connected to the Internet), but they now want to publish some of the data on the net - via a publishing tool (Perl) hosted on our server.

I know this is not a direct Perl-question (even though my Perl-code won't do any real work until I get that database connection up and running), but have you got any ideas on exactly how to set up an account for remote logins, that can be used for a connection via a ODBC DSN called by Perl on a remote machine?

Comment on Re^2: Connect to remote MSSQL database with DBD-ODBC?

Replies are listed 'Best First'.
Re^3: Connect to remote MSSQL database with DBD-ODBC? by JamesNC (Chaplain) on Dec 14, 2005 at 15:13 UTC
Why don't you google for how to add user accounts? How to add user accounts to MSSQL This link seems relevant. Since this is pretty much OT at this point. You need to dig into the docs. ciao, JamesNC	[reply]
Re^4: Connect to remote MSSQL database with DBD-ODBC? by FinnR (Novice) on Dec 14, 2005 at 19:07 UTC
No problem, I'll dig. Just thought if someone had the answer right in their pocket, they might wanted to share the result of their own sweat and tears. Thanks again. Wiedersehen. / FinnR	[reply]