SQL Server Connection problem

Posted on 2011-10-07
Last Modified: 2012-05-12
Let me ask the short version first?
What is wrong with SQL 2008 express SP1/SP2 installation if local client app cannot connect to it until you install management studio express and suddenly everything is working?

Now Let me introduce the background:
I have got a deployment task of application originally developed in 2.0 and uses some 3rd party components developed in c++ and vb6. In project there are lots of SQLDMO usage and last owner solved SQL 2008 compatibility issue by using SQL 2005 backward compatibility package. So far this application working fine on Windows7 32bit environment.
Requirement was deploy it to 64 bit windows7.
I successfully created a installable package for 64 bit windows7 by replacing SQL server 2008 32 bit version with 64 bit version and SQL 2005 Backward compatibility pack also replaced with 64 bit version. In my project configuration I configured the application is X86 because otherwise I cannot use some 3rd party library originally in use. This set up working fine on my development environment.
But after I packaged and installed them to clean windows7 application can create the database but cannot create tables until I install management studio 2008 express on that environment. After that bingo!  everything works fine.

I do not want to add management studio as requirement of my application, there is no use of it but my application not working without it.

Can someone provide me some idea how can I debug/fix this problem? Or what might be going wrong? I have spent lots of time already and tried this with different setup.

I hope I provided enough detail but I can give you more detail if you ask.

Thanks in advance.
Question by:Aikeremu
    LVL 39

    Assisted Solution

    <<What is wrong with SQL 2008 express SP1/SP2 installation if local client app cannot connect to it until you install management studio express and suddenly everything is working?>>

    This means that your " local client app" connects through some method/driver that is not installed with SQL Express SP1/SP2 but is part of Management tools suite - SSMSE

    Microsoft SQL Server 2008 Management Studio Express (SSMSE) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

    Author Comment

    Hi, thanks for the comment but if so how can my local client app work with SQL 2008 express SP1 on 32 bit windows7 without problem? also in my development environment on 64 bit machine I have not installed management studio and when I debug it works well.

    Author Comment

    It would be great if I can find what else I need to install in addition to SQL 2008 express and SQL 2005 backward compatibility package in order to make it work. I have suspected that it was msxml 6.0 because it is one of prerequisitives management studio. I tried to installed it but did not work.
    LVL 39

    Assisted Solution

    "how can my local client app work with SQL 2008 express SP1 on 32 bit windows7 without problem?"

    That means in my opinion the "connectivity" component comes with Windows 7 32 but maybe not there  with 64 bit until you install SQL SSMSE tools.

    Accepted Solution

    Thank you for everybody's comment, I found out yesterday the reason was adodb.dll was used in my application but it is not installed on my testing environment. Seems that dll comes with VS2005 that's why it works on my development environment and it seems also installed with management studio and that is the reason why my application works if management studio installed on my testing environment also.
    I found that redistributing the file \program files\common files\merge modules\vs_piaredist.exe together with my application solves the problem.

    Author Closing Comment

    closing this question since I found out the answer myself, lcohan's comment was helpful but did not answer my question fully

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now