SQL Server Connection problem
Posted on 2011-10-07
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 vb.net application originally developed in VB.net 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.