Secure data export: Recommendations please

[Mark]

Hi everyone, I am just after some ideas about the best way (Read secure) to
make some data available to an external source.

Currently, we have an MSSQL database which another external company wants to
retrieve some information from.

Our internal platform is all Microsoft 2003 with SQL Server 2000 and all
applications are written in .NET
The external application is PHP/ MySQL based.

Now, the data contains information about people so we want to keep things as
secure as possible.

Thanks in advance for any ideas
Regards
Mark

[John Timney \(ASP.NET MVP\)]

use certificates and web services

http://support.microsoft.com/default...307267&sd=tech

and consider using Web Service Enhancements to handle usernames and
passwords

http://www.eggheadcafe.com/articles/20021227.asp

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Mark" <do**@spam.me> wrote in message
news:eR*************@TK2MSFTNGP15.phx.gbl...

Hi everyone, I am just after some ideas about the best way (Read secure) to make some data available to an external source.

Currently, we have an MSSQL database which another external company wants to retrieve some information from.

Our internal platform is all Microsoft 2003 with SQL Server 2000 and all
applications are written in .NET
The external application is PHP/ MySQL based.

Now, the data contains information about people so we want to keep things as secure as possible.

Thanks in advance for any ideas
Regards
Mark

[Mark]

Hi John, thanks for that. I did think that this would be the way to go, just
wanted to make sure :)

Thanks again
Mark

"John Timney (ASP.NET MVP)" <ti*****@despammed.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

use certificates and web services

http://support.microsoft.com/default...307267&sd=tech

and consider using Web Service Enhancements to handle usernames and
passwords

http://www.eggheadcafe.com/articles/20021227.asp

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Mark" <do**@spam.me> wrote in message
news:eR*************@TK2MSFTNGP15.phx.gbl...

Hi everyone, I am just after some ideas about the best way (Read secure) to

make some data available to an external source.

Currently, we have an MSSQL database which another external company

wants to

retrieve some information from.

Our internal platform is all Microsoft 2003 with SQL Server 2000 and all
applications are written in .NET
The external application is PHP/ MySQL based.

Now, the data contains information about people so we want to keep

things as

secure as possible.

Thanks in advance for any ideas
Regards
Mark