Good Day
I have a workstation that we have installed SQL Express 2008 R2 on. We do not have a server which we log onto, all workstations are linked LAN and automatically assigned IP address. The server statically assigned. 192.168.0.156 Able to ping and see this workstation on the net.
When trying to connect via SQL Server name and SQL instance correct. Have done all the tutorials on allowing TCP/IP and given a TCP port 1433, have also created a rule to allow access in the firewall with all the readily available document on the net, yet still no access?
Someone had metioned that it may be that there is not a guest account on the Operating System to allow access?
Any help most welcome
Regards
Richard
I have a workstation that we have installed SQL Express 2008 R2 on. We do not have a server which we log onto, all workstations are linked LAN and automatically assigned IP address. The server statically assigned. 192.168.0.156 Able to ping and see this workstation on the net.
When trying to connect via SQL Server name and SQL instance correct. Have done all the tutorials on allowing TCP/IP and given a TCP port 1433, have also created a rule to allow access in the firewall with all the readily available document on the net, yet still no access?
Someone had metioned that it may be that there is not a guest account on the Operating System to allow access?
Any help most welcome
Regards
Richard