Enabling Remote Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • Re: Creation of Indexes on the subscriber database
    ... AFAIK ... there's no shortcut. ... What I do is dbcc inputbuffer to see which index it is ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • SQL Server 2005 Creating own shortcuts, Macro or macro like
    ... own shortcuts in SQL Server 2005. ... What I was trying to accomplish is selecting a table I have in the object ... browser and pushing some shortcut key and have it generate the Select script. ... Is there already a shortcut to generate the Select script? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Creating own shortcuts, Macro or macro like
    ... own shortcuts in SQL Server 2005. ... What I was trying to accomplish is selecting a table I have in the object ... menu selections to get it generate the script. ... Is there already a shortcut to generate the Select script? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL2K uninstall?
    ... system tray). ... You should be able to see a shortcut to it in ... Jasper Smith ... Add/Remove Programs doesn't show anything for SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)