SQL server 2008 hosted by Windows 7 Pro(32bit)
Posted on 2013-02-01
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
I can not connect to the SQL from the Other PC which is on the same network (non-domain environment). I will explain the old setup and new setup.
Main PC was XP Pro which was hosting Sql server and the custom made application which had the database. NOW the other computer on the network with Vista Business was accessing that program without any problem.
NOW the XP PC died. So we replaced with new Windows7 Pro(32bit) PC.
The Main program which uses the SQL on the main pc is working fine and all the sql services are running.
The folder of the program been shared and the other PC can see it and access it.
SQL browser, SQL server program has been allowed in exceptions.
TCP protocol is enabled, Remote Connections is enabled in Database Properties.
TCP port: 1433 and UDP port: 1434 is allowed in the exceptions.
From the other PC when I telnet port 1433 then it was not connecting. And so I found out that the SQL hosting pc was giving random port. So I have given default port 1433 in the SQL. And after that I am able to telnet pcname 1433.
BUT I can not telnet pcname 1434. It keeps denying.
What else I can check to troubleshoot that why UDP port 1434 is not accepting the connection.
I was reading some article allowing port number in the string. But how can I do that if i got the string like Target path "\\pcname\programfolder\filename.exe \\pcname\programfolder\filename.udl". Start In "\\pcname\programfolder\filename.exe"
Could it be the router. But the whole setup has been working fine before with XP Pro as the main pc.
any help will be appreciated