We want to connect an Access adp (Office 2010) from a client computer (Windows 7 32 bit) to a SQL Server 2008 Express (installed on a Windows 7 computer as well) - both in the same domain.
Firewall off, antivirus off, ports set to 1433 at SQL Server (0 deleted at dynamic ports), remote activated, named pipes and TCP/IP activated
Access projects on SQL Server - computer can connect with windows and SQL Server authentification.
Access project on Client comuter cannot connect. Server is not listed in the access connection string-windwow (but SQL browser cannot be started at SQL Server under Express - this is disabled). I am entereing either the Server name or also tried with IP Address, tried both authentification modes but then database cannot be selected an an error occurs (no connection to SQL Server, check remote connection,...).
We cannot install telnet or Management Studio on Client computer - this is not allowed.
Any suggestions would be highly appriciated.
Thanks in advance!!