Cant connect to SQL Server instance

  • Thread starter Thread starter Alban06
  • Start date Start date
A

Alban06

Guest
Hello!
I want to ask you about a problem.
I have developed a windows application that uses a sql database, which uses SQL Authentication (with a username and password) to log in. The database is located on a local server which uses the same networks as my company computers.
Now I have published the application and installed it on my computer (where I developed it and in which I also have the SQL server installed). I also installed the application on the computers of some colleagues who do not have any program installed (they do not have "visual Studio" or "Sql server" installed). Now when I log in to the application from my computer everything works fine.
(database communication works very well). But when I try to log in from other computers (with the same user I used on my computer) it does not work. Error is displayed:
"named pipes provider error 40 could not open a connection to sql server".
I did these steps on the server where the application is located as:
1: Enable TCP / IP in SQL Server Configuration
2.Open Port in Windows Firewall 1433
3.Allow remote connections to this server

Can you help me with any suggestions

Continue reading...
 
Back
Top