Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-03-04
8
Medium Priority
?
1,902 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 1000 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 1000 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

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 1000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

596 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