deployment of vb.net application with MSSQL db

deployment of vb.net application with MSSQL db

• Alde

  i built an msi file with the application inside. when i installed it in another pc which has vb.net2003, the framework and mssql enterprise installed, the program doesnt work, error: SQL server does not exisit
  
  what should i do now
  
  1) should i install something else in target pc
  
  2) how can i make a copy of the mssql db on the target pc
  
  plz help

  
  
  

• strider-_-

  Now you are a little outside my experience dealing with SQL Express error messages. They've got a forum.

  You can make sure it's running by going to the Computer Management app and going to the services node. 

  I've also heard that you can't use Named Pipes with SQL Express. You have to use the default/standard protocols.  If you use the wizards in the Data Sources window to create a connnection string, that should provide you with a valid/working connection string.

   

  HTH

   

  
  
  

• Raju Pusapati

  thx David, I opened the project properties for my setup project, there is no "prerequisites" button and no "sql server express" checkbox neither. please help. btw, I use .net 2003
  
  

• RobbWil

  Unfortunately, the answer I gave was for VS 2005, and this feature wasn't really in VS 2003. As a result, in order to get MSDE to work, you have to go through a fairly complex set of steps to get the MSDE merge modules included... (we've made this a lot easier in VS 2005 with SQL Express).

  MSDE install
   FAQ: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql2k/html/sql_embeddingmsde.asp
  

   MSMS: http://www.microsoft.com/sql/downloads/2000/sp3.asp
  

  Good Luck!

   

  
  
  

• Jeetu

  To get SQL Express installed:

  1. In your Setup project, open Project Properties.
  2. Click the Prerequisites button and then select the checkbox (near the bottom) for SQL Server Express.

  To get the database included in the setup:

  1. Right click on the setup project and select Add Project Output
  2. Select "Content Files"

  When you go to install the application, run setup.exe so that SQL Express will be installed.

   

  Hope this helps.

  
  
  

• Jimmy Code

  thx david, i will try to find more help on sql forum
  
  

• Hippo

  hi david, hope you had a good xmas and also happy new year!

  I eventually got VB.net 2005 on both my working machine and the target laptop. i converted the project into a .net 2005 project and re-built the deploment file following your instructions provided above.

  however, when i installed it on my target machine, and run the application, it gave me this message:

   "an error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - could not open a connection to SQL Server)"

  I didn't quite understand this message. because in the "SQL Server Configuration Manager", i set the SQL Server (SQLEXPRESS) to "Automatic" start mode, which means that it is connected, doesnt it

  plz help

  
  
  
• deployment of vb.net application with MSSQL db