March 24, 2009 at 6:49 am
hi am geting this error while am trying to connect to sql server its a .net application
a network-related or instance-specified error occurred while established a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections
March 24, 2009 at 7:27 am
is it a named instance?
March 24, 2009 at 7:35 am
no is not
March 24, 2009 at 7:37 am
Have you tried IP address?
March 24, 2009 at 7:38 am
i'd start by trying to ping the server, if no response then it's in the network, DNS, etc
or try to connect by IP to see if it works
March 24, 2009 at 7:45 am
this is the thing i have tru to do
Changing ports to 1433
Firewall disabling
Remote Connection enabled on SQL Server
TCP/IP and Named Pipes enabled in configuration
Modified Web.Config to use IP Addresses/ Usernames passwords /Trusted_Connections/ Different SQL Server on a different machine
Re-Installing SQL Server
March 24, 2009 at 7:46 am
how do i connect by IP
March 24, 2009 at 7:55 am
instead of a server name use an IP address
if it connects by IP then it means you have DNS issues. also try to connect using sql authentication. once in a while we have domain controller issues and windows authentication doesn't work, but a test connection using sa works.
March 24, 2009 at 8:18 am
AM ABLE TO CONNECT USING IP
March 24, 2009 at 8:30 am
i have also try To resolve the issue - I had to change the VSTS Options; From Tools -> Options -> Data base Tools -> Design Time - Validation Data base -> Connection Options -> SQL Serevr Instance Name = SQLEXPRESS
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply