hi, i am trying to learn the ssms 2008 Import Export Wizard, while following the tutorial i got an error at step 10 below: Launch SQL Server Management Studio and log in to your test server. Open a new query window. Select the master database from the Available Databases combo box on the toolbar. Enter this text into the query window: CREATE DATABASE Chapter16 Click the Execute toolbar button to create a new database. Expand the Databases node in Object Explorer Right-click on the Chapter16 database and select Tasks > Import Data. Read the first page of the Import and Export Wizard and click Next. Select SQL Native Client for the data source and provide login information for your test server. Select the AdventureWorks2008 database as the source of the data to import. when i try opening the "Database" dropdown list at the "Choose a Data Source" window, i get the following error: i get same error if clicking "refresh", and if i just write the database name and click Next. =================================== Could not retrieve table list. (SQL Server Import and Export Wizard) =================================== 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. Client unable to establish connection Registry information is corrupt or missing. Make sure the provider installed and registered correctly. (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.ResolveDefaultCatalog() and also same error if trying to export from one of my DBs. i am running sql server 2008 express, here is ssms info: Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) Microsoft Data Access Components (MDAC) 6.1.7600.16385 (win7_rtm.090713-1255) Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4952 Operating System 6.1.7600 At "Server Name" i choose the only one available: RLM-PC\SQLEXPRESS i use Win authentication (as i do when logging in to ssms) PC: win 7 ultimate N, 64 bit Eerything else works just fine, i can create tables, query and all. i'll be greatfull for assistance. many thanks, Ronen

You need to check the remote connections and if they are supported by your instance. To do this, right-click on your server entry in SSMS's object explorer, and choose Properties. Then in the Conenctions tab, select the option for "Allowing remote connections to this server". Also, have a look at this post for checking the protocols your SQL Server currently supports: http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ You might also need to configure your firewall: http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/ Please mark as answer if this helps. Thank you! http://thebipalace.wordpress.com

hi Saeedss, thanks, did it all, error same as before. note that my sql instance runs perfectly well in all other aspect, its only the import\export that's failing. additional ideas anyone? cheers

It could be a config issue. E.g. the server does not accept a connection, a firewall, etc. See this to resolve: http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/Arthur My Blog

thanks ArthurZ, this also didnt help :(

What happens in the Windows App and System logs?Arthur My Blog

The error message indicated that this is a connectivity issue. You may first follow this FAQ to do self troubleshootings to see if you can resolve it, http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/thread/a9b863fb-6b92-45c0-b1db-33f02f259457. Please remember to mark the replies as answers if they help and unmark them if they provide no help

can you be more specific?

can you be more specific?

tnx, i followed the troubleshooting, it all looks quite fine. i think maybe something wrong with my firewall settings? so i decided to test, i turned firewall off compltily - the same error popus up at same stage. so i guess its not my firewall... are you guise sure i can use ssis on sql 2008 express? any further ideas? i'm kinda lost... cheers

tnx, i followed the troubleshooting, it all looks quite fine. i think maybe something wrong with my firewall settings? so i decided to test, i turned firewall off compltily - the same error popus up at same stage. so i guess its not my firewall... are you guise sure i can use ssis on sql 2008 express? any further ideas? i'm kinda lost... cheers

SSIS is NOT part of the SQL Express edition. Arthur My Blog

SSIS is NOT part of the SQL Express edition. Arthur My Blog

You did not install SSIS but just use Import/Export feature in your SSMS. It should work. I recommend that you try re-installing your SSMS. You can download the installation package here, http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff Besides I recommend that you apply the latest service pack for your SQL Server 2008 Express: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=40acf55f-0715-4bb0-9735-d02fc2c8a7afPlease remember to mark the replies as answers if they help and unmark them if they provide no help