Solved

Communication module is not valid.  Driver has not been correctly installed

Posted on 2011-03-04
8
1,728 Views
Last Modified: 2012-05-11
Hello,

I have an application that I am trying to load on my Windows 2008 R2 server.  The application installs MSSQL 2005 too.  When I am completeing the installation the install tries to connect to the database but it cannot.  It gives a generic error: "Communication module is not valid.  Driver has not been correctly installed"  I have looked in Event View for more infomration and did not see anything.

I can go into 2005 SQL Sever Manager Studio Express and login to the database, etc..
0
Comment
Question by:tucktech
  • 5
  • 3
8 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 250 total points
ID: 35041542
Is this a custom application? It sounds like it is trying to use the incorrect database connection driver (e.g. trying to use a SQL 2000 ODBC driver for a SQL 2005 connection, etc)

0
 

Author Comment

by:tucktech
ID: 35043089
This is a purchase application.   It can use either MSSQL2000 or 2005. I requested 2005 and it installs mssql 2005 express.   I do have SQL2000 loaded and running on the system too.
0
 
LVL 15

Assisted Solution

by:derekkromm
derekkromm earned 250 total points
ID: 35043594
Ya, it sounds like it might be using a 2000 specific-driver to connect to the 2005 database.

I'd contact the vendor about how you can detect whether or not that is the case. Explain that you have both DBMS versions installed and that you can connect to both okay from your desktop.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:tucktech
ID: 35043896
I think I will try to load the app/database back to SQL2000 to see if I get the same results.  Software support not available this weekend....  

good insight derekkromm
0
 

Author Comment

by:tucktech
ID: 35046638
I was able to connect to the MSSQL 2000 database with the application.  I am not able to connect to the MSSQL 2005 database for the application.  

How can I load the drivers for MSSQL 2005?  

I think both SQLs can liver on the same server, right?
0
 
LVL 15

Assisted Solution

by:derekkromm
derekkromm earned 250 total points
ID: 35046706
They should be able to live on the same server, absolutely. Its most likely that the drivers for both are installed and the application is just trying to use the wrong one for 2005. Like I said, I think you'll have to take it up with their support. At least you have done some troubleshooting, so they'll know it works on 2k but not 2k5 and it may even be a known issue for them.
0
 

Author Comment

by:tucktech
ID: 35048013
I completely uninstall SQL 2005 and all of its componets, rebooted and reinstalled the application in its entirity.  That worked...
0
 

Author Closing Comment

by:tucktech
ID: 35048017
Thanks!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question