Re: Using SQL server import & export wizard for the first time

check to see if the service is running and if you have a firewall on
your PC blocking the SQL traffic

also try to start the wizard from your PC and just specify the source



On Jan 27, 8:38 am, ciaran.hud...@xxxxxxxxx wrote:
Hi,

I've just installed SQL server 2008 having been used to 2000 and am
experiencing problems using the import wizard for the first time.

I have created a DB on my local machine and at the choose destination
step I receive the error below.
A little bit of online research makes me think that the wizard thinks
that the server on my local machine is not running, but it has been
started.

I suspect I just need to chage something simple, but frustratingly I
cannot figure out what the problem is.

Regards,
Ciarán

===================================

Could not retrieve table list. (SQL Server Import and Export Wizard)

===================================

Login timeout expired
A network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and if SQL Server is
configured to allow remote connections. For more information see SQL
Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2].
(Microsoft SQL Server Native Client 10.0)

------------------------------
Program Location:

   at System.Data.OleDb.OleDbConnectionInternal..ctor
(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection
(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject)
   at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection
(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList
()

.

Relevant Pages

  • Re: How to import one DB to another using any tool
    ... I'm simply looking for an easy GUI way of doing this. ... If you absolutely want a wizard, there is the Copy Database Wizard ... Keep in mind that when working with a server application like SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Collation Change - Unusably slow Import/Export Wizard
    ... Database is about 5GB. ... just selected all tables in the wizard, ... has to bulk load from somewhere outside SQL Server, ... be a different process than SQL Server for the task. ...
    (microsoft.public.sqlserver.server)
  • Re: Access 2003 and SQL Server 2005 Express
    ... Are you on the latest service packs for Office and SQL Server 2005? ... Using the Wizard and choosing 'create a new database', ... migration wizard requires SQL ...
    (comp.databases.ms-access)
  • Re: Migrate ACCESS to MSSQL
    ... Most folks prefer using DTS to the upsizing wizard... ... the upsizing wizard, go back and ensure that the sql column data types are ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Using SQL server import & export wizard for the first time
    ... I've just installed SQL server 2008 having been used to 2000 and am ... A little bit of online research makes me think that the wizard thinks ... Could not open a connection to SQL Server. ... DbConnectionPool pool, DbConnection owningObject) ...
    (comp.databases.ms-sqlserver)