I am writing an application on #, running on a network of several computers connected via a switch, in general, they simply respond.

I am trying to connect SQL Express DB on my computer as a protruding storage location for DB, everything works, but from another, i.e. remotely, no. I configured everything and tsp, and a web browser, and a firewall.

Type error login failed with this type of windows identification. SQL Express has been installed since VS 2008.

  • The switch is nothing to do with if it is not "stupid" and traffic segmentation is not configured on it, does the machine with the DB respond? Judging by the error, it is obvious that authentication. - e_klimin

3 answers 3

SQL Express can only be installed locally, you cannot connect to it remotely. You can create a service that will access the database.

    Judging by the error - you have two cars, both are not in the domain. In this case, SQL Server will not allow users from another Windows Authentication machine.

    You need to enable Mixed Authentication in the server properties, enable the sa user (or create a new one), set a password for it, and use the username / password instead of Windows Authentication when connecting.

    The connection string will look like this:

    Server=myServerAddress;Database=myDataBase;User Id=myUsername;

    Password = myPassword;