April 21, 2009 at 5:57 am
hi,
I have installed SQL Server 2005 Express on server running Office 2003 OS. I have a vb.net application running on client computers accessing data from SQLServer located on the server. All was working fine. but now there is a error while opening connection to SQLServer from one of the client computer, error message, "error locating SQLServer instance or SQLServer instance does not allow remote connections".
I have enabled remote connections in SQL server surface configuration.
and also the application runs smoothly from all other client computers, there is a connection problem from only one client computers which was also running smoothly previously but suddenly there seems to be a connection problem. The LAN network is working properly.
What can be the reasons?
April 28, 2009 at 10:04 pm
hi
are you able to telnet to the SQL server from the client machine successfully on the port specified by you on the server?
let me know the result
April 29, 2009 at 12:40 am
hi,
Thanks for your reply.
It may sound silly but I have no idea about TelNet
April 29, 2009 at 5:03 am
on your client PC go to Start -> Run -> CMD
it should get you to the dos prompt
next type in the following line below and hit enter:
telnet yoursqlservername portnumber (ex. telnet testserver 1433)
let me know what happens when you try this
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply