I am a newbie with SQL and I can not connect to SQL Server 2008 Express using SSMA (SQL Server Migration Assistant 2008 for Access). Both are new installations, the file I am trying to migrate is Access 2003 format. I am using a Vista Business 64-bit machine, Firewall is off.
When I try to make the connection, I receive the following error:
"Connection to SQL Server failed.
A network-related or instance-specific error occurred while establisihing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. [provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server]"
I can open SQL Server Confiiguration Manager and SQL Server Management Studio; they appear to be fine.
I have tried various connection configurations using the "Log On" tab on the properties window for "SQL Server" services. (SQL Server Surface Area Configuration is not available on SQL Server 2008)
And I have looked on Experts Exchange, including: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23525725.html