Aikeremu
asked on
SQL Server Connection problem
Hi,
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
closing this question since I found out the answer myself, lcohan's comment was helpful but did not answer my question fully
ASKER