April 9, 2009 at 8:32 pm
Hi,
One of our Production Server, we face the below mentioned problem.
We are unable to open the SQL Server Management Studio. It throws an error "Package - SQL Server Management Studio failed to open".
Regards,
S.Balavenkatesh
April 9, 2009 at 8:45 pm
Anything in the application/error log please?
April 9, 2009 at 9:29 pm
Hi,
Please find the Application Event Viewer Log details:
Product: Microsoft Visual Studio 2005 Premier Partner Edition - ENU -- Error 1706.No valid source could be found for product Microsoft Visual Studio 2005 Premier Partner Edition - ENU. The Windows installer cannot continue.
Detection of product '{C25EF637-BE7A-4761-9B45-9069989C319F}', feature 'VS_IDE' failed during request for component '{C4ACB788-B12A-4996-99E2-7EF364819D3A}'
Detection of product '{C25EF637-BE7A-4761-9B45-9069989C319F}', feature 'VS_IDE', component '{CC264F7C-92C4-4623-875B-2BB8BEB06D48}' failed. The resource 'C:\Program Files (x86)\Microsoft.NET\Primary Interop Assemblies\' does not exist.
Regards,
S.Balavenkatesh
April 9, 2009 at 9:42 pm
Are you accessing server through any we application? or are you directly trying to connect to the SSMS?
And also have you got required permissions?
April 9, 2009 at 9:54 pm
Directly i logged on that server and open the SQL Server Management Studio. Immediately it throws the error.
But when i connect the server throuhg some other system it is working fine.
Regards,
Bala
April 9, 2009 at 10:23 pm
Do you have anything else written on your application log about registry errors? Either you don't have enough permissions or the installation has changed. Are you logging in as admin?
It clearly says that 'one source' is not able to get access to 'another resource'. Did you check whether .Net framework is corrupted?
April 9, 2009 at 10:37 pm
I have Local System Admin Priviledges. I don't know how to check .Net Framework corrupted.
I checked in the Add or Remove program it shows .Net Version 2.0 with SP2 and .Net Version 3.0 with SP2 also instlled.
Can you please tell how to verify whether .Net framework work correct or not / corrupted.
Bala
April 9, 2009 at 11:42 pm
sbvenkatesh77 (4/9/2009)
Can you please tell how to verify whether .Net framework work correct or not / corrupted.Bala
I am not so sure Bala, Sorry. I would google it a bit, its 6:30 am here in the UK now and i havent had asleep yet, or else i would have googled it for ya. Lets wait for other members and see for their replies.
April 10, 2009 at 5:11 am
sbvenkatesh77 (4/9/2009)
Hi,One of our Production Server, we face the below mentioned problem.
We are unable to open the SQL Server Management Studio. It throws an error "Package - SQL Server Management Studio failed to open".
Regards,
S.Balavenkatesh
It is corrupted. Now the only alternative is to reinstall but before reinstall, remember
1. take the backup of all the databases by opening the SQL Server on your system from another pc on network [if your PC is on network].
2. if it not suffice the point 1, then the take the backup from the command line
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe" -E -Q "BACKUP DATABASE mydatabase TO DISK='C:\tmp\mydatabase.bak' WITH FORMAT"
use osql or sqlcmd
3. Use Import/Export / DTS to transfer the data etc.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
April 10, 2009 at 6:00 am
You should only have to reinstall the client tools. This should not affect any of your databases (though a DB backup is always a good idea anyway).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 10, 2009 at 7:06 pm
Hi,
Can you please confirm how we conclude that this problem "Package - SQL Server Management Studo failed to open" is due to corrupt of .Net Framework.
Bala
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply