Hi,
I want to allow someone to update the data in a database being developed in SQL Developers Edition. The idea is while I'm developing the database the person who's database it is can do the data entry. The data monkey lives no where near me so I cannot keep keep updating a local copy there...
I've tried to set up and connect but the server keeps refusing the connection. So question is... can SQL Developers Edition allow remote connections... and if so, which I hope it can, whats the way to go about setting it up.
Far as I can tell I'm ok in regards to specifying the location of the server, the SQL user account is set up and has access to the database.... can anyone help.
Yes dev edition supports remote connections, you need to go into the
surface area config tool and enable them however|||
Thank you Euan, thank you very much.
Can I also ask... can it work over a secured connection using TCP/IP and what would be involved in setting that up?
|||Whats your definition of secure? SQL Server supports SSL over the wireis one way of securing it.|||Thats what I wanted to hear. Need to try find out to set it up so I may post again. Thanks.|||Try the security forum, they will be able to help.|||good idea thanks
No comments:
Post a Comment