Can somebody tell me why if I specify a server name in Data
Environment property for SQL server I get a message "Connection failed...." If I specify IP address I get the connection. What should I look at to use server name?
The server name (and IP) is in the host file. I am trying to connect from dif computers with dif operating system. When hit on Test Connection button the exact message is "Test connection failed because of an error i initialization provider. [DBNETLIB][ConnectionOpen (Connect().\SQL Server does not exist or access denied". If change server name to IP address connection established. Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.