Upgrade 2000 to 2005

Last Post 28 Feb 2009 07:14 PM by kevincheang. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kevincheang
New Member
New Member

--
29 Jan 2009 07:16 PM
Dear all,

I have upgraded SQL2000 with sp4 to SQL2005 with sp1. After the upgraded, I missed many icons or components such MMC, Visual Studio for opening SSIS etc.

Finally, I found the exeute file for SQL management Studio and data has been completed transfer from 2000 to 2005.

However, I still missing Visual studio and other components when compare to a fresh installation of SQL 2005.

I try rerun SQL2005 DVD and choose all clients components for installation. Last, it shows me all of them have been installed.

How can I do to installing again the missing components? (visual studio for opening SSIS is important)

Thanks

Kevin
kevincheang
New Member
New Member

--
01 Feb 2009 06:27 PM
yes. all choose.
kevincheang
New Member
New Member

--
02 Feb 2009 05:03 PM
No files exist in this folder.
kevincheang
New Member
New Member

--
03 Feb 2009 07:22 PM
it is not work - start/run/devenv
I search all files within C:\program files\ but can't find devenv.exe

However, I have choose such option to install the above components when i upgrade to sql 2005 server before.

In start/programs/sql server 2005, no 'SQL server business inteligence development studio' and 'SQL Server management studio' inside it.

I try to reinstall it but it said that those components installed. How can I do?


kevincheang
New Member
New Member

--
04 Feb 2009 07:22 PM
I found sqlwb.exe (sql server management studio) and create the iron. how about 'SQL server business inteligence development studio'? it is valid i copy those files from a work server?

Thanks. Kevin
kevincheang
New Member
New Member

--
09 Feb 2009 12:17 AM
No. I can't find it.

Hence, I copy all files from another working server to this folder and run devenv.exe but failed.

Error message:
Cannot find one or more components. Please reinstall the application.

How can i do?

Thanks

Kevin
kevincheang
New Member
New Member

--
09 Feb 2009 05:19 PM
I try to reinstall it but it said that those components installed (I mentioned before).

My version is SQL 2005 Standard edition.

Kevin
kevincheang
New Member
New Member

--
18 Feb 2009 01:38 AM
Not found. I run setup and remove it, then error such error:

Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

Then I go to 'Add or Remove Programs' in control panel but can't found the component (BIDS) inside it.

Kevin
kevincheang
New Member
New Member

--
28 Feb 2009 07:14 PM
same error as pervious post.

However, I try another method.

1. Delete the SQL2005.
2. Reinstall it in different path: (i.e. C:\SQL2005)

And all is work. (i.e. MMC, Visual Studio)

Then I attached db (upgrade from 2000) to this sql server.

And it is work fine.

I don't know why but just try. Any explain about it?

Kevin
You are not authorized to post a reply.

Acceptable Use Policy