Online SQL database for LOCAL NETWORK only, connect via c#

Asked

Viewed 3,273 times

3

I developed a system for my company and need a database hosted on our internal network, explaining better I want to host this database on a PC running a Windows Server 2012 here in the company, our connection is all wired...

It’s just a network, all LOCAL. This system was developed in Visual C# (C# dot.NET), I want to connect my system to this database hosted on the local network of the company.

I tried it in a way: there are shared folders on our network, so I tried to access the bank directly only with the path (SQL SERVER connection via file) ai he returned me an error saying that it is necessary to set up an environment for this type of connection.

c# database sql-server winforms

  • How to enable IIS tutorial. It is the best way to get your application to work is by IIS!

  • 1

    If the tag is correct its application is Windows Forms, then the use of IIS does not apply to it.

  • You can put exactly what the mistake was?

  • 1

    Would that be? Connecting to an instance of Sqlserver

  • Lucas as Leandro said is Windows Forms and the use of IIS does not apply... Paulo the error only guided me to set up an instant environment and @Shura16 Yes I’ve been researching is the only way, but do not want to leave it open for external connections only INTERNAL!

1 answer

2


  • As I imagined I would have to install an instance in the company’s micro SERVER and free the local access, it would be this?

  • 1

    @Pedro Sim, that’s right. The latest versions of SQL Server Express do not need much additional configuration, other than Firewalls and some network permissions.

  • 1

    Beauty thank you! I will try to install on the server here from the company and just free INTERNAL access.

Browser other questions tagged c# database sql-server winforms

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