SQL Server - Make SQL Server Management Studio 2008 available to a network user.

Asked By Colin Douglass on 28-Apr-11 10:38 PM
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.
Col Douglass

You will need to install management studio in it entirety - Robbe Morris replied to Colin Douglass on 28-Apr-11 11:00 PM

on his machine.  You cannot just execute the .exe via mapped network drive if you want him to actually the management studio software.
Riley K replied to Colin Douglass on 29-Apr-11 12:13 AM
Client software enables client computers to connect to an instance of Microsoft SQL Server on a network. A "client" is a front-end application that uses the services provided by a server such as the SQL Server Database Engine. The computer that hosts this application is referred to as the client computer.

Refer this link,

http://
Colin Douglass replied to Robbe Morris on 29-Apr-11 12:18 AM
Thanks. I was afraid of that.
Colin Douglass replied to Riley K on 29-Apr-11 12:19 AM
Thanks but that doesn't awnswer my question.

I did receive an answer from Robbe Morris.

Thanks anyway
Thank you, they have been deleted - Asked By Robbe Morris on 03-May-11 08:12 AM
end of post