Microsoft SQL Server 2005 – Error

Asked By ace heltsley 10 points N/A Posted on - 08/13/2012

Hi Experts

I have attempted all possible side from mine. But still I got this.

The problem is, I am attempting to set up SQL Server 2005 Express version on Windows 7.But it fails in the installation process and the error message is

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

For help, click: https://www.microsoft.com/nl-nl/?ProdName=Microsoft+SQL+Server&ProdVer=9.00.5000.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40xea75

BUTTONS:
&Retry
Cancel

I need your help to solve it. Please.

Thanks a lot.

• Status: Open
• Question Views: 988
• Answer Count: 1
• Vote Up 0 Vote Down

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

Answered By Carl Jack 10 points N/A #151989

Microsoft SQL Server 2005 – Error

Hallo Ace,

To resolve the issue you are having with SQL, you will need to use the following workaround:

• On your computer, you will need to go to the Control Panel and then click on Programs and Features.
• Locate Add Remove Programs and then get rid of any previous installations of all the SQL Server components. That should include the SQL Native Client.
• After you are done with the uninstallation, you will need to get rid of the .Net Framework 2.0 Beta 2 or earlier that you may be having on your machine.
• After that you can rerun setup.

That should help you resolve the issue successfully.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/13/2012
• Question Category: MS SQL Server