Got an error while repairing SQL Server 2008

Asked By Aeros 0 points N/A Posted on - 11/17/2011

I was trying to repair SQL Server 2008 instance using the Control Panel when this error message popped up (see below). 

I tried doing this several times and the same error message kept popping up. 

I was wondering about the network error code 1316 and reason for such an event. 

Any take on this and any advice on how to fix the problem?

Microsoft SQL Server Compact 3.5 SP2 ENU

Error 1316.A network error occurred while attempting to read from the file

C:UsersAdministratorAppDataLocalMicrosoftWindowsTemporary InternetFileContent.IE5CTRMZBSBSSCERuntime.msi

 

• Status: Open
• Question Views: 1325
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Stephen_Lee

Go To Solution

Best Answer

Best Answer

Answered By Stephen_Lee 0 points N/A #111870

Got an error while repairing SQL Server 2008

Hi Aeros,

This error happened because you are trying to make changes on your previously downloaded program. This kind of error prohibits the repair to take place. This scenario will always happen to any applications which utilizes windows installer feature. To fix this problem:

First, you have to delete all older version program you have downloaded before. To be sure you have installed a well functioned windows installer you must installed the latest or new version of installer from the website of Microsoft and let it add this to your computer.

Second, you have to be sure that you have deleted all the older programs from the Windows menu, add or remove the program. Then to stop your applications from running use the task manager. This will deleted previous traces and try to download the program again.  

Third, you can also change your account and create another account and use the privilege of the administrator to download a program or software and you can allow the other user to use the program if you set the option by enabling the permissions.

Hope this might help you.

Thanks

About Stephen_Lee

Questions
4

Answers
127

Best Answers
43

• Vote Up 0 Vote Down

• Posted on - 11/18/2011
• Question Category: MS SQL Server

Answered By Clair Charles 15 points N/A #111873

Got an error while repairing SQL Server 2008

That kind of problem may occur if you have Visual Studio 2010 installed on your system.

The Visual Studio 2010 and SQL Server 2008 have similar MSI package for the SQL Server Compact Edition (SSCE) runtime, only that they bear different file names. Use the following steps to resolve that problem:

• First, you will need to remove Microsoft SQL Server Compact from Add/Remove  in the Control Panel.
• And then you will re-install the SQL Server 2008. After you have done that repair operation, the SQL Server Compact 3.5 SP2 X86 ENU will be reinstalled on the system, and therefore there should not be any errors.

Clair Charles

 

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 12/22/2011
• Question Category: MS SQL Server