Re: Deploy SQL Express so my app still works on other machines

Your connection string will cause the application to look for the database
files (mdf and ldf) in the same directory as the application. The files
must be readable and writeable by the Windows user who is running the
application. This all assumes that SQL Express is installed on the user's
machine. If this doesn't help, maybe a more complete description of the
problem than "cannot connect" would help someone figure out what is
happening. If there an error in the SQL Server error logs, what error
message is returned, etc.


--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"John" <a@xxxxx> wrote in message
news:%23ixhnV5dGHA.3996@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,


I have an app which uses an SQL Express database. The problem I'm
encountering is that when I deploy the app (including installing SQL
Express) my app cannot connect to the database. What is it I have to do to
get this working? Is it the format of my connection string within my app.

I was under the impression developing using SQL Express was
straight-forward (which it was on my dev box) but deploying it and still
having the app working seems a nightmare.

My connection string dev-side is the following:
"Data
Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|PM.mdf;Integrated
Security=True;User Instance=True"


Regards
John.



.

Relevant Pages

  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)
  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Problem with SQL Server 2005 Express Edition
    ... Windows Authentication and changed my connection string. ... deployment goes smoothly after all, since when installating the SQL Server ... It uses a SQL Server 2005 Express Edition database to store data. ...
    (microsoft.public.sqlserver.security)
  • Re: Active Directory, IIS, and Application Roles...
    ... Can you specify in CONNECTION string of the application to which database to ... You will have to activate the Role immediatly after connection string. ... > I am creating an ASP.NET application that runs on a server with Windows ... > trusted connections and database roles for application access to SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Second SQL adapter on the same database
    ... Microsoft Certified Technology Specialist: BizTalk Server 2006 ... changes the Initial Catalog part of the connection string to read Initial ... Since there is no database called NorthwindSecondary, ... stored procedure from a particular remote SQL Server 2000 database via ...
    (microsoft.public.biztalk.general)