Enabling Remote Access

  • Thread starter Thread starter ExcelMan
  • Start date Start date
E

ExcelMan

I have built and Access Data Project with a SQL Server back end and
deployed in on a server in our office. Within our office a shortcut
to the ADP is provided to each user on their desktop. They are able
to properly launch the application and use it simulutaneously. There
is also a shortcut placed on the server's desktop which also works
fine.

Now my manager wants to allow users to access the application from
home or on the road. I am able to VPN into the server using Remote
Desktop Connection (RDC), click on the shortcut on the server and
launch and use the application.

However I am not able to set up an icon on my laptop desktop and
launch the application. We are using Windows Integrated
Authentication and it appears that the SQL Server backend does not
recognize my login credentials when I come in via the VPN. The login
name in SQL Server is MachineName\username and generally we have
entered the machine name of the server on which the SQL Server
resides. I have tried to create a login on SQL Server that uses the
machine name of my laptop, but that is not accepted either by SQL
Server or Windows on the server.

So my basic question is:

How can I put either a shortcut icon or an icon to a local instance of
my ADP on my laptop desktop and access a SQL Server backend via our
VPN?

Thanks.

Steven
 
If your local machine is not recognised as part of an authenticated domain
by Windows when connected through the VPN, that's pretty much say it:
SQL-Server won't recognise it either.

In your case, you must create a sql-server login and use it when connecting
through the VPN and the authentification mode of SQL-Server must be set to
the mixed mode (Windows + SQL-Server). When connecting using the connection
dialog window of ADP, you must use the option "Use a specific user name and
password" and not the "Use Windows NT Integrated security".
 
If your local machine is not recognised as part of an authenticated domain
by Windows when connected through the VPN, that's pretty much say it:
SQL-Server won't recognise it either.

In your case, you must create a sql-server login and use it when connecting
through the VPN and the authentification mode of SQL-Server must be set to
the mixed mode (Windows + SQL-Server).  When connecting using the connection
dialog window of ADP, you must use the option "Use a specific user name and
password" and not the "Use Windows NT Integrated security".

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)










- Show quoted text -
Click to expand...

Sylvain,

Thank you very much for your response.

Let me add a little more information. When I log into the VPN I also
have some drives on my machine mapped to drives on the server where
the SQL Server resides. When I open Windows Explorer and click on the
server drive to see the folders and files there, a dialog box pops up
asking we to log in with my username and password on that server.
When I do so, it shows me the files and folders.

I was wondering if there is a similar mechanism possible with my ADP.
When I open the ADP client and it tries to connect to the server
backend, can it pop up a dialog asking for the server-level username
and password?

Steven
 
Maybe it's possible in your case: I did make some more research on the
internet and found that in some (but not all) cases, you can use a named
pipe connection to etablish a trusted connection to a sql-server over a vpn
connection:

http://sqljunkies.com/WebLog/roman/archive/2004/11/28/5296.aspx

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


If your local machine is not recognised as part of an authenticated domain
by Windows when connected through the VPN, that's pretty much say it:
SQL-Server won't recognise it either.

In your case, you must create a sql-server login and use it when
connecting
through the VPN and the authentification mode of SQL-Server must be set to
the mixed mode (Windows + SQL-Server). When connecting using the
connection
dialog window of ADP, you must use the option "Use a specific user name
and
password" and not the "Use Windows NT Integrated security".

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)










- Show quoted text -
Click to expand...

Sylvain,

Thank you very much for your response.

Let me add a little more information. When I log into the VPN I also
have some drives on my machine mapped to drives on the server where
the SQL Server resides. When I open Windows Explorer and click on the
server drive to see the folders and files there, a dialog box pops up
asking we to log in with my username and password on that server.
When I do so, it shows me the files and folders.

I was wondering if there is a similar mechanism possible with my ADP.
When I open the ADP client and it tries to connect to the server
backend, can it pop up a dialog asking for the server-level username
and password?

Steven
 
Back
Top