Deployment Problem with SQL EXpress !!


Hi,
I have a SQLExpress database in my project and it's working well in my Computer ,But when i deploy my project and install in another pc my app can not login to the server ,please give me a compelete help about this problem , and about how to include an SQLExpress database to a project setup ,
Tanx .
[319 byte] By [Donor_044] at [2007-12-22]
# 1

How are you using the express system, and how are you connecting to the server... is it on the local machine or on another machine to the client... You may have to configure the system to allow remote connections to the server.

GlennWilson at 2007-8-30 > top of Msdn Tech,Windows Forms,ClickOnce and Setup & Deployment Projects...
# 2

Hi,

this is my Connection string :

"Data Source=(local)\SQLExpress;Initial Catalog=Lib;I ntegrated Security=True;providerName="System.Data.SqlClient"

and i'm running it on the local machine .

Donor_044 at 2007-8-30 > top of Msdn Tech,Windows Forms,ClickOnce and Setup & Deployment Projects...
# 3

Have you checked that the remote connections are enabled, the link is in my first post.

GlennWilson at 2007-8-30 > top of Msdn Tech,Windows Forms,ClickOnce and Setup & Deployment Projects...
# 4

Hi,

We are using VB.NET 2003 and SQL Express 2005. We would like to deploy a sample application first with SQL Express database in our client machine. My questions are:

1) Is it possible to include the SQL Express 2005 database file in .NET 2003 setup project? If 'Yes' tell me in detail

2) Tell me the dependency files for SQL Express 2005 in .NET 2003 setup project?

3) Should client machine need of SQL Express 2005 installation?

Please send your reply to gopalan@sofist.com or okugops@hotmail.com.

Thanks

Gops M.

Sofist India

Okugops at 2007-8-30 > top of Msdn Tech,Windows Forms,ClickOnce and Setup & Deployment Projects...