dbTalk Databases Forums  

SQL Server Migration Assistant Wizard for ACCESS - can't connect toSQL Server

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Server Migration Assistant Wizard for ACCESS - can't connect toSQL Server in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
slmehl420@gmail.com
 
Posts: n/a

Default SQL Server Migration Assistant Wizard for ACCESS - can't connect toSQL Server - 01-21-2009 , 12:32 PM






Hello --

The Wizard leads me through finding and adding the mdb files, and then
shows the following error in the step "Connect to SQL Server 2005":

"This version of the SQL Server is not supported. You must connect to
an instance of SQL Server 2005."

Relevant information about my SQL Server 2005 version after installing
SP3 is:
Microsoft SQL Server Management Studio 9.00.4028.00
Microsoft Analysis Services Client Tools 2005.090.4028.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.
040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600

This is displayed on top of a window showing "SQL Server 2005"!

Can anyone tell me what the problem might be?

Thanks in advance for any help.

L Mehl

Reply With Quote
  #2  
Old   
Itamar, Nobhill Software
 
Posts: n/a

Default Re: SQL Server Migration Assistant Wizard for ACCESS - can't connectto SQL Server - 01-23-2009 , 09:49 AM






On Jan 21, 8:32*pm, slmehl... (AT) gmail (DOT) com wrote:
Quote:
Hello --

The Wizard leads me through finding and adding the mdb files, and then
shows the following error in the step "Connect to SQL Server 2005":

"This version of the SQL Server is not supported. You must connect to
an instance of SQL Server 2005."

Relevant information about my SQL Server 2005 version after installing
SP3 is:
Microsoft SQL Server Management Studio *9.00.4028.00
Microsoft Analysis Services Client Tools * * * *2005.090.4028.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.
040803-2158)
Microsoft MSXML * * * * * * * * 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer * * * * * * 6.0.2900.2180
Microsoft .NET Framework * * * * * * * *2.0.50727.832
Operating System * * * * * * * * * * * *5.1.2600

This is displayed on top of a window showing "SQL Server 2005"!

Can anyone tell me what the problem might be?

Thanks in advance for any help.

L Mehl
Mehl,
I can not help you with the Wizrad, but I can offer Nob Hill's tool
Maria-Alix, it can Get Data From Any Source: SQL Server, Oracle,
MySQL, CSV or fixed-width text files, XML files, ADOMD sources (cubes)
or and many other OLEDB or ODBC-based data sources.

Check the fetchers on : http://www.nobhillsoft.com/MarieAlix_detail.aspx


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.