Stephen Selinas Books
2009-09-25 11:59:01 UTC
I have installed SQL Express 2005 and the services seem to be running.
I am trying to run SSMA to convert an Access 2003 to SQL. In the Migration
Wizard on the 'Connect to SQL Server 2005', it is asking for the Server Name.
What do I put in there?
I've tried just a full-stop, SQLEXPRESS & FINAWARE and it always comes up
with the same error: -
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. Named Pipes Provider error 40 could not open a connection to SQL
server.
I've gone into Surface manager and changed the settings to allow remote and
named pipes, closed and restarted the services.
This is my first experience of using SQL, so I'm struggling.
Regards
Steve
I am trying to run SSMA to convert an Access 2003 to SQL. In the Migration
Wizard on the 'Connect to SQL Server 2005', it is asking for the Server Name.
What do I put in there?
I've tried just a full-stop, SQLEXPRESS & FINAWARE and it always comes up
with the same error: -
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. Named Pipes Provider error 40 could not open a connection to SQL
server.
I've gone into Surface manager and changed the settings to allow remote and
named pipes, closed and restarted the services.
This is my first experience of using SQL, so I'm struggling.
Regards
Steve