I have installed SQL Server 2008 R2 on my application server - no problems.
I want to allow access to SQL Management Studio for one of my trusted network users. He logs in on a differenet machine and I want to put a shortcut to the management studio on his desktop.
I have shared the the Miscrosoft SQL Server directory on the application server so that on the users desktop I have a shortcut with the command \\appserver\MSSQL\...\ssms.exe
When I click the shortcut on the remote machine it fails with the error message "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix the problem."
I have checked the event log and it says "Resolve Partial Assembly failed for Microsoft.VC80.CRT. Reference error message: The referenced assembly is not installed on your system."
I then tried mapping a network drive to access the server (and changed the shortcut command accordingly) but got the same result.
I also have to give him access to the Import & Export Data (32-bit) function. This also fails although it doesn't display a message. The event log reports a .NET Runtime 2.0 error and says "Faulting application dtswizard.exe, version 2009.100.1600.1, stamp 4bb67457, faulting module kernel32.dll, version 5.2.3790.4480, stamp 49c51f0a, debug? 0, fault address 0x0000bef7."
What do I have to do to allow the user access to the Management Studio and the Import/Export Wizard.
Thanks for your help.