RTM vs SP

[Dukester0122]

I've installed 2-months ago SQL Server 2005 STD on a physical server and Visual Studio version is 8.0.50727.762(SP.050727-7600).

I then used the same installation files today in a VM server and got a different version 8.0.50727.42(RTM.050727-4200)

 

[mrdenny]

If visual studio was already installed on one of the machines that could make the version numbers different.

Look at the build numbers of the SQL Servers, not the build numbers of the Visual Studio applications.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Dukester0122]

SSMS is both 9.00.3042.

Here's my problem which I thought the RTM version was causing but just confirmed it didn't:

When I try to create an OLE DB connection mgr in BIDS(VS 2005) I get this message:
Creating an instance of the COM component with CLSID{C8B522D0-.....} from the IClassFactory failed due to the following error:8007007b

Maybe you can help.

 

[mrdenny]

I would recommend reinstalling and repatching the Client tools.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog