Click here to Skip to main content
15,937,012 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi
database in my project is access 2013 and I want to migrate it to SQL server 2008
I'm using Microsoft SQL Server Migration Assistant for Access program for migration
my problem is at migration wizard and at connect to SQL Server box
server name fied is empty so I can't connect to SQL Sever
by the way I installed SQL Server 2008 R2 and my OS is windows 8.1
How can I solve this problem?
Posted

To see your instance of SQL Server in the list of available servers, not only do you need the SQL Server process running, but you also need the SQL Browser service running.

You can start the browser service either from you Services MMC (if the service is installed) or through your SQL Server Configuration management.
 
Share this answer
 
Comments
firaso2014 3-Sep-14 12:59pm    
I did SQL Browser service running from view services but my problem is still I can't connect to SQL server because server name field is empty
what do I do ?
PhilLenoir 3-Sep-14 14:11pm    
Are you sure that the browser service is running? Do you definitely have a network route to that server (you could try pinging it?) To populate the list, the application sends out a UDP broadcast and all servers on that network should respond.

One diagnostic you could try is to create a blank Access database. Under external data, choose an ODBC import. Select one of the SQL Server drivers (I usually use the original one instead of Native Client 10 as I've had problems occasionally and the original one is OK for this exercise) You should then see your server in that list. If not, then either your UDP packets aren't hitting that server or the browser process just isn't listening!
I did SQL Browser service running from view services but my problem is still I can't connect to SQL server because server name field is empty
what do I do ?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900