I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use the server's IP to connect it still gives the SQL Server does not exist or Access Denied Error.
Software/Hardware used:
ASKED:
February 16, 2009 12:23 PM
UPDATED:
February 17, 2009 8:11 PM
Open Security from SQL Server Enterprise Manager and then click Login, right Click to Add new Login
and then add network user name (of your PC) and give the access of related data base for the created User.
Server does not exist or access denied isn’t an authentication problem. See link I posted above.