I try to connect to a local MS SQL Server but can't find out why my web app can't connect. I get the following error "Login time out expired" The timeout is set at 30 seconds.
Server configuration and services configuration seems OK, Valentina Studio and Microsoft SQL Server Management Studio do connect without any issue.
I used the usual code to connect with the exact same parameters I use to connect with Valentina Studio :
I tried various combinations of hostname (without the server name, with "localhost"), ports, checked the firewall, activated ip addresses in SQL Server configuration manager... Nothing works.
Dim db As New MSSQLServerDatabase db.Host = "ROGER-PARALLEL\SQLEXPRESS" db.Port = 53909 db.UserName = "sa" db.Password = "ml6tech$&%" If db.Connect Then MsgBox( "Hourra!" ) Else MsgBox( "Shit\" ) End If
Anyone has advices?