I can't connect my VB app to an SQL Server 2005 instance because "server don't exist or access has been denied" (the Conection String is correct because the app works in other networks and also i wrote the server's ip instead his name). However I can connect from the same network with SqlCmd (tcp protocol).
Does anyone knows possible reasons for the error?
Thanks.
Dim StringConexion As String = "Provider=SQLOLEDB;Data Source=server's_ip\myInstance;Initial Catalog=mydb;User ID=myUser;Password=myPassword"
The error message is generated by .NET Framework (it was my spanish translation so myabe you can't recognize it). I will try to translate it better:
Unhandled exception in the application. If you click Continue, the application will ignore this error and attempt to continue. If you click on the application will close out immediately.
[DBNETLIB] [ConnectionOpen (Connect ()).] SQL Server does not exist s Server or denied access.