SQL Server Authentication - Outside Domain

[nelson1460]

Hello,

I am trying to register a SQL Server and add a user from outside our network domain, in fact, outside the company. The network people are going to link us and the other company with a fiber connection... I don't know how yet. How do I connect the two SQL Servers in the two companies so that I can create an account for the outside user to have access to our server and databases so that they can send us data?

Thanking you,

Nelson.
[QUOTE]

[andi_g69]

If you want to give them the possibility to manipulate your DB directly do the following:

1) Create a SQL login
2) Make it a User in the DB(s) and grant permissions to the objects they need to access
3) Ask them to create a linked server on their box which links to your server using your login

This makes sense if they are supposed to connect real time.

If they are supposed to do batch updates only (e.g. via DTS) they can connect to your server directly from DTS without using a linked server

[nelson1460]

Andy,

Once I can see the outside server, I can batch a DTS to receive the data. My problem is how to see their server from outside our network. Do I register their machine using their IP address or what, since their machine is not in our domain?

Thank you,

Nelson.