Solved

SQL Server Express Deployment

Posted on 2014-01-22
5
329 Views
Last Modified: 2014-01-29
I developed an application in MS Visual Studio 2010 that uses SQL Server Express.  I need to deploy this application, together with a database I created on the development computer to a customer.  I copied the database over to the customer computer, installed the software and installed SQL Server Express 2008 with it.  

However, the log in to the database fails, though it works just fine on the development computer.  The path to the database is the same on both computers.  I'm relatively new to SQL Server, so it's quite possible I'm missing something simple.  Any suggestions would be appreciated.  

Thanks.
0
Comment
Question by:l2Bravo
[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
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39800443
what is the type of authentication you are using?
Is SQL server installed over the other guys machine is a named instance?
0
 

Author Comment

by:l2Bravo
ID: 39800745
I'm using Windows authentication.  I think it's installed as a default instance.
0
 

Author Comment

by:l2Bravo
ID: 39812050
Any ideas?  The customer computer has a Firewall on it, but I went through the steps to enable dynamic ports.  

I could use SQL Server authentication if needed...
0
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39813459
are you able to login using the SSMS (management studio) provided when installing SQL Server express... if this is not the case then the windows authentication is not proper in your client system.

as a second shot at debugging try to put sql authentication as it will be same....
0
 

Author Comment

by:l2Bravo
ID: 39813575
Thanks.  I tried installing management studio for 2008 SQL Server Express, but the installation didn't work properly.  I removed SQL Server 2008 entirely and then installed SQL Server Express 2005 along with management studio for 2005.  SSMS was able then to see the server and I was able to attach the target database to the server.  The software I developed was able to connect to the database without any errors, but I have a few more tests to run to make sure everything is OK.

Thanks for the help.  I will update the question when I'm sure everything is working.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

635 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