how to migrate form access 2013 to sql server 2008 R2

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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 3-Sep-14 6:08am

firaso2014

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

PhilLenoir · Answer 1 · 2014-09-03T06:17:00

Solution 1

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.

Posted 3-Sep-14 6:17am

PhilLenoir

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!

firaso2014 · Answer 2 · 2014-09-03T08:09:00

Solution 2

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 ?

Posted 3-Sep-14 8:09am

firaso2014