如何将表单访问2013迁移到sql server 2008 R2 [英] how to migrate form access 2013 to sql server 2008 R2

问题描述

嗨
我项目中的
数据库是访问2013，我想将它迁移到SQL Server 2008

我正在使用Microsoft SQL Server迁移助手访问程序迁移

我的问题出现在迁移向导和连接到SQL Server的框中

服务器名称fied是空的，所以我无法连接到SQL Sever
$ b我安装SQL Server 2008 R2的方式是$ b，我的操作系统是Windows 8.1

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?

推荐答案

To在可用服务器列表中查看SQL Server实例，不仅需要运行SQL Server进程，还需要运行SQL Browser服务。



您可以从服务MMC（如果已安装服务）或通过SQL Server配置管理启动浏览器服务。

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.

我从视图服务运行SQL Browser服务但我的问题是我仍然无法连接到SQL服务器ause服务器名称字段为空

我该怎么办？

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 ?

这篇关于如何将表单访问2013迁移到sql server 2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！