September 7, 2006 at 12:45 pm
Hello all,
I connect to a VPN and have an IP address to a sql database with a valid user name and password and can attach the tables in microsoft access.
How do i use enterprise manager to view the entire database using the same VPN and ip address? I'm trying to see the stored procedures.
Thank you
September 8, 2006 at 5:35 am
Open Enterprise Manager, open MS SQL Servers, right click on SQL Server Group -> New SQL Server Registration.
This should allow you to register the server with your username password.
Note: If you are using Windows authentication and this is different to your local logon then you need to right click enterprise manager (on the start menu etc) and select 'run as..' This allows you to run the program with different credentials.
You also need to have the VPN firewalls configured to allow the SQL traffic to pass through.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply