Link to home
Start Free TrialLog in
Avatar of l2Bravo
l2BravoFlag for United States of America

asked on

SQL Server Express Deployment

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.
Avatar of Surendra Nath
Surendra Nath
Flag of India image

what is the type of authentication you are using?
Is SQL server installed over the other guys machine is a named instance?
Avatar of l2Bravo

ASKER

I'm using Windows authentication.  I think it's installed as a default instance.
Avatar of l2Bravo

ASKER

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...
ASKER CERTIFIED SOLUTION
Avatar of Surendra Nath
Surendra Nath
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of l2Bravo

ASKER

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.