SQL Server Registration over VPN

[BrimReap]

Hello,

I connect to my company's LAN through a VPN. We have SQL Sever running on our LAN server. I'd like to connect to it through SQL Manager but when I try and register the SQL server i get the following error

Login failer for user '(null or any username i put)'. Not associated with a trusted SQL connection.

What do i need to do to connect to this database?

Thanks

 

[foxdev]

You are trying to connect using Windows authentication; switch to standard mode (username/password), if the server is configured to allow that.

 

[BrimReap]

I've tried putting in a username and pass and i still get the same error

 

[chiph]

Try running the client registration tool on your PC, first with the server name, and if that doesn't work, use the TCP/IP address of the server. You may have to talk to your network admin to get him to add your home PC to the Active Directory (or Domain if you're on NT4).

Chip H.

 

[essa2000]

Dear ;

You VPN Connection should have following setting when you are setting it up:

1- Don not dial the initial connection
2- Destination Address as your domain like mail.abc.com
3- Connection availibility for all users.
4- Should have TCP/IP installed

You SQL Registration Process should have following setting:

1- SQL Server Authentication options is selected
2- Login Automatically use "sa" as login and blank password
3- And give the name of that SQL Server which is running at your LAN side. e.g SQL1 it should be same as which is running other side.

I have setup SQL server registration here following these steps from USA.


Regards,
M. Essa Mughal