SQL Server 2005 version 9.00.4035.00 vs 9.00.1399.00

sql-server-2005

I have two servers with the versions above (9.00.4035.00 vs 9.00.1399.00), but we installed from the same source.

Now some projects don't open. How can I solve this – applying Service Pack 3?

Best Answer

9.00.4035.00 is the build number for SQL Server 2005 SP3, 9.00.1399.00 is the build number for SQL Server 2005 RTM (release to market, ie- the first release). Applying SP3 to the RTM instance may solve your problem, but it's not guaranteed. If you can post more information about any errors you're getting we may be able to give you more.

You can make them both 9.00.4035 by installing SP3 to the 9.00.1399.00 server but, like DanBig mentions, SP4 is out so you should consider just installing SP4 on both servers. It is easy to do, just download the service pack and run its setup. Of course, make sure you have all the obvious things covered - full server backup, solid backups of all databases, etc.

Dowloads for SP3 and SP4:

Also, see How to identify your SQL Server version and edition.

Related Topic