带有和不带数据的SQL DB Restore问题 [英] SQL DB Restore issue with and without data

问题描述

hi



（提供商：命名管道提供商，错误：40 - 无法打开与SQL Server的连接



我恢复了一个备份，我没有创建到新数据库，如果我连接上面说的问题即将到来，如果我从恢复的数据库生成脚本并在另一个新数据库中运行没有数据并连接到同一个工作正在工作..你能告诉我什么是确切的问题，我发现脚本中有一个数据库级用户，如下所示。



创建用户[appointment_bee]没有登录WITH DEFAULT_SCHEMA = [dbo]



请让我知道这是什么问题..

hi

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

I restored a backup which i was not created to a new database and if i connect above said issue is coming , if i generate script from restored DB and running without data in another new database and connecting to the same is working .. can you plz tell what will be the exact problem and i found one database level user is there as below in the script.

CREATE USER [appointment_bee] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

kindly let me know whats the problem ..

推荐答案

我好为您的问题提供一个简单的解决方案。遵循以下步骤：

1.转到SQL Server配置管理器

2. SQL Server网络配置：2.a.MSSQLSERVER的协议

3.在右侧窗格拆分页面中，您必须按如下方式禁用VIA：共享内存 - 启用b.Named Pipes ---启用c.TCP / IP --------启用d.VIA -----------禁用。

Well I have an easy solution for your question.Follow the steps:
1. Go to SQL Server Configuration manager
2. SQL Server Network Configuration : 2.a. Protocol for MSSQLSERVER
3. In the right pane split page you will have to disable VIA as follows a.Shared Memory-- Enable b.Named Pipes ---Enable c.TCP/IP --------Enable d.VIA -----------Disable .

这篇关于带有和不带数据的SQL DB Restore问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！