Getting a "SQL Server does not exist or access denied. Connection open (Connect())" error when trying to connect to the SQL Server service whioch is installed on the local PC. Have tried to connect to (local) MACHINENAME and IP.ADD.RE.SS and still nothing. The installation completed successfully, the service is running and have tried restarting it. Still nothing.
Its XPSP2, I have tried explicitly allowing the ports in the firewall to allow everything and even switched it off.
Any ideas?
Thanks, Matt