Server Name in Sql Migration Assistant for Access is blank

Question

Hello All,

I had a previous question which was worded incorrectly so here it goes again.

I am trying to Migrate from Access to SQL using the Microsoft tool and the ServerName is blank and will not allow me to enter my local instance of SQl Server. I can't copy , the "." doesn't work, it doesn't allow me to type anythinng

It works correctly in SQL Management Studio as I can connect to my local server database/instance BUT NOT in Microsoft SQL Server Assistant for Access.

Here is the screen where I CANT put in the SQL Name. I checked and TCP/IP is enabled

Thanks

George

Answer 1

I just installed version 5.2; no problem being able to type in server name.  I can't get the list to auto populate either, I am unsure how it is enumerating it or enumerating at all.  Try reinstall?

---

Mohit K. Gupta --- MCTS, MCITP, MCC2011
My Blog OpsVault My MSDN Blog Twitter @SQLCAN

Answer 2

Okay ..sometimes these apps are not as complicated as I thought...

If you enter the local server name BY HAND and then enter the database name BY HAND..the NEXT appears and guess what..IT CONNECTS...

What happened to drop down lists :-)

Either way I was able to connect..

Thanks Mohit

Answer 3

Good question, I spent about 20 min trying to get that list to auto populate.  But end up giving up, just typed the names in heh.  "Maybe?" its future functionality ;-).

---

Mohit K. Gupta --- MCTS, MCITP, MCC2011
My Blog OpsVault My MSDN Blog Twitter @SQLCAN