Tuesday, February 14, 2012

Connecting to SQL2005 Developer edition

I'm attempting to connect to and instance of SQL and cannot seam to find it. The server logs says its listening on '127.0.0.1 <ipx4> 1545'.

Kind of stuck what to check next. Will using pipes help? What do I need to do?

Hi,

check if the port listening or not using command prompt as:

netstat -an | find "YOUR PORT NUMBER"

for exampl, my SQL Server is listening to port 1433:

netstat -an | find "1433"

if it's working you'll find that the port is listening to local machine in TCP otherwise maybe there is a problem, you can check the Event Viewer to trace it

No comments:

Post a Comment