Installing a database in SQL Express during VB app setup

Aussie Rules

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have no
skills at using it.

Is there a way I can have my VB.net Setup program install the database onto
this server? Executing a massive SQL Script I guess would work, or perhaps
just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.

May 28 '07 #1

Subscribe Reply

2212

Mr. Arnold

"Aussie Rules" <no****@nospam. comwrote in message
news:ud******** ******@TK2MSFTN GP05.phx.gbl...

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have
no skills at using it.

Is there a way I can have my VB.net Setup program install the database
onto this server? Executing a massive SQL Script I guess would work, or
perhaps just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.

Yeah, you can do it.

I talked with C# developer that tired to do the same thing, but he ran into
the problem of user authentication on the user's machine with the database.
It seems that the database would only accept Windows authentication, not
Mixed mode or SQL authentication, which was a problem, since he was giving
the user-id and psw in a connection string.

I don't know if he ever got it to work, but I pointed him to a MS SQL Server
NG where he might get his answers as to what the problem may be.

I also think you need to search Google on how to deploy a MS SQL Express
database solution with in the setup of a .Net solution deployment. The
articles are out there on Google.

May 28 '07 #2

Earl

The easiest way is to use an install program called InstallAware. It's a bit
pricey ($200 - 500 depending on version), but you can add in the kitchen
sink, including SQLExpress.

"Aussie Rules" <no****@nospam. comwrote in message
news:ud******** ******@TK2MSFTN GP05.phx.gbl...

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have
no skills at using it.

Is there a way I can have my VB.net Setup program install the database
onto this server? Executing a massive SQL Script I guess would work, or
perhaps just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.

May 29 '07 #3

Similar topics

2217

Problems installing oracle on Win2000

by: yossi | last post by:

Hello. I'm trying to install Oracle 9i Rel 2 on Windows 2000 server. During the installation I choose to create a general purpose database, and choose all the default options. Everything goes well until the end of the installation when the setup starts to configure the database. What happens is that the setup starts opening and closing black command prompt windows for a while,

Oracle Database

15228

Installing SQL Server 2000 Personal Edition on Windows XP SP1

by: Ken Lindner | last post by:

I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...

Microsoft SQL Server

2817

Error when installing SQL Server 2000 - cannot configure server

by: Chris Halcrow | last post by:

Hi I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP. I continually get the error 'cannot configure server' just at the end of the installation. I've tried the following: - Removing SQL server from 'Program Files' folder following an unsuccessful attempt to re-install, and entirely removing the registry entry 'HKEY_CURRENT_USER > SOFTWARE > Microsoft > MSSQLServer', as well as the corresponding entry under...

Microsoft SQL Server

2722

Installing VS6 After VS.Net 2003

by: Gerald Hernandez | last post by:

One of my development PC's died, and I need to have legacy VS and VS.Net installed at the same time. On the now dead PC, I had VS6 installed prior to installing VS.Net. This worked just fine. On my working PC, I already have VS.Net installed, but not VS6. My question, will installing the older VS6 with VS.Net already installed give me problems with VS.Net. Or should I first remove the VS.Net, install VS6, then re-install VS.Net? Gerald

.NET Framework

4377

Installing/configuring DB2 Connect V8.1

by: Ed Stevens | last post by:

A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled thru one install and config, with a lot of handholding from IBM Support. I'm comfortable in unix but have never dealt with DB2 Connect there. (my main job is as an Oracle DBA, and most of my db's are on Solaris or AIX) I've found the install...

DB2 Database

1312

Connect to database in non standard location

by: mr_doles | last post by:

I am writing a Database application using Visual Studio 2005 and SQL Server Express 2005. I am trying to create a back up and year end back up plan within the program. The folder structure I want is as follows: The main level is c:\program files\app name\database with the following subfolders, 1) current - holds the current db (db.mdf), 2) backup - holds the backed up databases (db1.bak) and 3) archive - holds the year end...

Visual Basic .NET

1611

Problems Setting Up Database

by: Jonathan Wood | last post by:

I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had to install some type of IIS component to run databases from Visual Studio 2003. Since then, I've installed Visual Studio 2005. I know VS 2005 has some component so that IIS is not required. Here's the two errors:

ASP.NET

1888

Installing ASP.Net 2.0 onto sql2000 web server, App_Data, SQL2005 problem

by: itfetish | last post by:

I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0 (it had 1.1 before) As I have been working on a web parts page on my laptop, hosting it there, working perfectly. I want to transfer it now, so I upgraded it. Created a new application pool for .net2.0 stuff, then used Visual Studio 2005 from my laptop to connect to Http://Bw-online/ProjectPoint and make a new website. Bw-online is our intranet at...

ASP.NET

1608

Newbie Question for VB Express

by: jch | last post by:

Sorry for the newbie question but I'm trying to learn Visual Studio. I've got VS Express 2008 and I'm using visual basic. I'm trying to learn how to deploy a program so I've written a very basic windows application (lets call it TWinApp1) with just a couple of buttons and a text box. It is very simple and runs fine in the debugger. Using TWinApp1 I'm trying to learn how to create a setup program to install an application on a system....

Visual Basic .NET

9423

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10211

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9993

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6672

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5298

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5447

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3958

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3561

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General