August 26, 2010 at 8:40 pm
Hi all,
I have instance of sql servers up and running and I am able ping the server but not able to connect it. how can I resolve this issue?
Thanks,
Ravi Shankar
August 26, 2010 at 10:28 pm
wats the error u getting??
August 27, 2010 at 9:32 am
As metioned above, the exact error you're receving will go a long way in helping us know what the root cause is. Could be any number of things.
Do you have access to the server that the SQL Server is hosted on? Did you install/config it?
Since your'e already in a CMD prompt PING'ing, you could also try attempting to TELNET on port 1433 to see if the SQL Server service is up and accepting connections on the default port.
August 31, 2010 at 12:45 am
Check the Firewall port 1433 or the Port you configured for SQL Server for connection
September 1, 2010 at 12:26 am
Hi all,
I have instance of sql servers up and running and I am able ping the server but not able to connect it. how can I resolve this issue?
"how did you know that the DB's are up and running "
now not able to connect to sql server " does this mean that you are not able to connect by SSMS"
if bthis is the case you can try sqlcmd to connect to the server, this type of error generally comes when client tools are not properly installed/configured,
did you check all the options in config manager like(protocols etc)
one among these should fix the issue, can you please paste the error msg here to have more clarity on the thing
September 1, 2010 at 12:43 am
Issue may be with your Protocols (they are disabled).
Enable - TCP/IP if you are using the machine name as serverName
Enable - TCP/IP & Named Pipes if you are using machinename\instanceName
You can enable the protocals using "SQL Server Configuration Manager".
Thanks
September 1, 2010 at 3:34 am
Ensure your listening ports are opened on firewall and as already indicated, you have enabled the listening protocols.
Thank you,
Phillip Cox
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply