Using SQL server import & export wizard for the first time
ciaran...@gmail.com
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
()
sql_noob
your PC blocking the SQL traffic
also try to start the wizard from your PC and just specify the source
Erland Sommarskog
> 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.
the target server. Or are you importing data?
Which edition of SQL 2008 did you install? If you installed the Express
edition, Express installs by default as a named instance, SQLEXPRESS.
What exactly did you specify for the server that you cannot connect to?
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
ciaran...@gmail.com
>
> If you get it at Choose Destination, I would guess the error is with
> the target server. Or are you importing data?
- yes I am importing data. I get the error at the Choose Destination
stage, when I click the drop down box to choose a Database.
>
> Which edition of SQL 2008 did you install? If you installed the Express
> edition, Express installs by default as a named instance, SQLEXPRESS.
I've installed the full version of SQL 2008
>
> What exactly did you specify for the server that you cannot connect to?
I'm trying to specify the target database for the data to be imported
to.
Any ideas what I'm doing wrong???
Erland Sommarskog
>> If you get it at Choose Destination, I would guess the error is with
>> the target server. Or are you importing data?
>
> - yes I am importing data. I get the error at the Choose Destination
> stage, when I click the drop down box to choose a Database.
And you want to import data to a database on the local server?
>> Which edition of SQL 2008 did you install? If you installed the Express
>> edition, Express installs by default as a named instance, SQLEXPRESS.
>
>
> I've installed the full version of SQL 2008
And which edition is this?
>> What exactly did you specify for the server that you cannot connect to?
>
> I'm trying to specify the target database for the data to be imported
> to.
>
> Any ideas what I'm doing wrong???
Right now your error is that you don't answer the questions I'm asking
you. Without access to your machine, I am entirely dependent on your
answers to be able to help you.
So, at some point when you ran the wizard, you did specify a server,
didn't you? But what you did you specify?
Are you able to connect to the server through a query window in Mgmt
Studio? In such case, what do you specify for the server in that case?
If you attempt to connect with SQLCMD from the command line, are you
able to connect?
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
ciaran...@gmail.com
> (ciaran.hud...@gmail.com) writes:
> >> If you get it at Choose Destination, I would guess the error is with
> >> the target server. Or are you importing data?
>
> > - yes I am importing data. I get the error at the Choose Destination
> > stage, when I click the drop down box to choose a Database.
>
> And you want to import data to a database on the local server?
Yes, I'm trying to import data from an excel file into a database I've
created on the local machine.
>
> >> Which edition of SQL 2008 did you install? If you installed the Express
> >> edition, Express installs by default as a named instance, SQLEXPRESS.
>
> > I've installed the full version of SQL 2008
>
> And which edition is this?
Microsoft SQL Server 2008
>
> >> What exactly did you specify for the server that you cannot connect to?
>
> > I'm trying to specify the target database for the data to be imported
> > to.
>
> > Any ideas what I'm doing wrong???
>
> Right now your error is that you don't answer the questions I'm asking
> you. Without access to your machine, I am entirely dependent on your
> answers to be able to help you.
>
> So, at some point when you ran the wizard, you did specify a server,
> didn't you? But what you did you specify?
I specified (local) as the server and checked 'use windows
authentication'
The database is default and I encouter the error when I click the drop
down box in order to specify a DB.
>
> Are you able to connect to the server through a query window in Mgmt
> Studio? In such case, what do you specify for the server in that case?
> If you attempt to connect with SQLCMD from the command line, are you
> able to connect?
yes, I can connect via Mgmt Studio. I specify the server as (local).
I don't know hot to connect from the command line. Can you give me
some sytanx to test this?
Erland Sommarskog
I asked about which edition: Express, Developer etc.
>> Are you able to connect to the server through a query window in Mgmt
>> Studio? In such case, what do you specify for the server in that case?
>> If you attempt to connect with SQLCMD from the command line, are you
>> able to connect?
>
> yes, I can connect via Mgmt Studio. I specify the server as (local).
> I don't know hot to connect from the command line. Can you give me
> some sytanx to test this?
Try this:
sqlcmd -S (local)
You could also try changing the data source in the Import Wizard to
SQL Native Client. Then you could use the same client API as Mgmt Studio
uses.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online: