Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Moved App and Database from PC to Server ....

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-03-21 : 16:32:38
Hi server pros,

To get better security, I have moved some app software from a PC to a 2003 Server. Also moved the SQL Server databases. I can get everything connected and working on the server...

But I'm struggling with how the user can run the app/exe, which resides on the server, from their XP desktop. I don't want them to have to remote into the server.

Sorry for such an elementary question :)

Thanks, John

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-21 : 16:46:29
What does the app/exe do? Can they just run it via UNC path?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-03-21 : 17:56:57
I created a shortcut with target "\\Pnclkronosdb\c$\Program Files\WINPAKPRO\Winpak2.exe"

When we run it we get error "the application failed to start because abc.dll was not found"

I think most, if not all, of the app will have to be installed on the PC - which kind of neagtes the benefits of moving even the database to the server.

Oh, the app is an Access Control system that controls access to the doors as people scan their badges.

Any ideas? Thanks.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-21 : 18:00:21
Well apparently that application needs certain things to run, so it's not standalone. The PC will either need to get the prerequisites installed or the person will need to RDP to the server to run it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -