VPN & MS SQL Server

sql server Sri Lanka
  • 11 years ago

    Hi ppl,

     

    This might be a sort of odd question. I just wanted to If i used Hamachi or another VPN software to network two computers through internet do u think the SQL Server service manager will pick up each others as server (providing they both have sql server installed).

     Just wanted to get it clarified. Theoritically i believe it should work but thought I might get some hints from the pros.

    If you can help me out that'll be great.

     

    Thanks a million in advance

     

    Elabuwa

  • 11 years ago

    This would certainly appear to be the case:

    http://www.thescripts.com/forum/thread79907.html

    Would be worth your while checking this out as well: http://www.windowsecurity.com/articles/Secure_SQL_Server.html 

    Joe 

  • 11 years ago

    Hi joe, Thank you very much for the info. It seems like MS SQL 2005 is the best option. Which one would u recommend? 2000 or 2005? Seems like you cant use nt authentication to log in.

     

    Thank you very much for pointin me in the righ direction

     

    Elabuwa

  • 11 years ago

    Go with 2005.

    I think MS may be planning to 'disengage' from 2000 soon (http://support.microsoft.com/lifecycle/?p1=2852)... so unless there's a strong enough reason to stay with 2000 (licencing perhaps), I see no reason to stay there. My 2c's worth Indifferent

    Joe 

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“If debugging is the process of removing software bugs, then programming must be the process of putting them in.” - Edsger Dijkstra