September 19, 2013 at 2:08 pm
Hi,
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!!
Sue
Susanne
September 24, 2013 at 11:34 am
It looks to me that SQLExpress installs as a named instance, therefore you must have SQLBrowser running to access it remotely. In SQL Server Coniguration Manager you can change SQL Browser from Disabled to Manual or Automatic, and then start it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply