[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Connection problem

Posted on 2011-10-07
6
Medium Priority
?
237 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Aikeremu
  • 4
  • 2
6 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 600 total points
ID: 36932774
<<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.

http://www.microsoft.com/download/en/details.aspx?id=7593
0
 

Author Comment

by:Aikeremu
ID: 36933316
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.
0
 

Author Comment

by:Aikeremu
ID: 36933349
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.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 600 total points
ID: 36950240
"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.
0
 

Accepted Solution

by:
Aikeremu earned 0 total points
ID: 36954004
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.
0
 

Author Closing Comment

by:Aikeremu
ID: 36975528
closing this question since I found out the answer myself, lcohan's comment was helpful but did not answer my question fully
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

834 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