I have installed SQL Express 2005 on two computers networked and running windows XP. I've copied the database from the first computer to the second and run queries on both to show that both computers have an active database that is up and running.
Now I am trying to use the Sql Server Management Studio Express (SSMSE) on the first machine to establish contact with the second machine. In order to have the two machines communicate I've configured the SQL Server on the second machine as
Under the protocols for the SQL Server 2005 Network Configuration I've enabled the TCP/IP pipes and set the TCP/Dynamic ports to 1032 (when I ran netstat -a it indicated that this was an active connection which I think this means it is available - though
it says that the port has a Foreign Address and it State is listening). As an aside the port 1433 was not among the active connections.
Both the SQLServer and the SQLServer browser are running (which presumably means they are both enabled).
I've run the surface Area Configuration For Services and Connections Tool to Set the SQLExpress Remote connections for Local and remote connections using TCP/IP and named pipes.
The Client Protocols for the SQL Native Client Configuration is stillset so that the default port is 1433.
When I look at the most recent
View Complete Post