How to install SQL Server together with the C# application created?

Asked

Viewed 1,524 times

1

I have a C# project and I need that when I create your installer I also install SQL Server 2008 on the client’s machine. It would be possible to do this?

  • If the client is an individual, rather than a business client, consider using Compact SQL or sqlite

  • Does your client have an SQL Server license? I find it very complicated to install an SQL Server. When you sell a product, you end up selling a maintenance service as well. This means setting up remote access for support etc. If the idea is to have a database on the machine, follow the @dcastro tip or use an Sqlite something like that without needing anything too heavy.

  • In fact the installation to be made is that of SQL Server Express and this is a requirement that in fact must be met, not being able to use the suggested options, but I thank and managed to solve with the reply of Gypsy Morrison Mendez. Thanks

1 answer

1


It is possible.

The procedure is quite large for an answer and can be found here. The tutorial explains how to embed an instance of SQL Server 2008 into your system installation. I believe it also works for SQL Server 2012.

  • The installation worked, but by default the Windows authentication system is used in the installation. What if I wanted to use the SQL Server authentication system?

  • Then you would have to see how to configure the authentication using mixed mode. I don’t know how to do this, but there should be a way in this tutorial.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.