将sql server数据库上传到Web服务器的问题 [英] problem with upload sql server database to web server

问题描述

大家好
我想用sql server数据库上传我的asp.net网站.
我正确上载了asp.net文件，尝试上载数据库时出现了问题.我使用sql manager 2011来上载它，并使用用户名和密码在Web主机中创建了数据库，并在sql manager中正确输入了这些数据，但我收到了错误消息

[DBNETLIB] [ConnectionOpen Connect()].sql服务器不存在或访问被拒绝.

谁能帮助我解决问题或告诉我另一种上载sql server数据库的方法.

hi all
i want to upload my asp.net website with sql server database.
i correctly uploaded the asp.net file the problem when try to upload database i used sql manager 2011 to upload it and created database in web host with user and password and entered these data correctly in sql manager but i get an error message

[DBNETLIB][ConnectionOpen Connect()].sql server does not exist or access denied.

can any one help me solve problem or tell me another way to upload sql server database.

推荐答案

1)我同意Bala检查您的连接字符串...

2)添加Asp.net文件夹App_Data，然后在此文件夹中添加数据库并发布网站...

Hi,

1)I am agree with Bala Check your connection String...

2)Add Asp.net Folder App_Data then add Your Database In this folder And Publish The Website...

您已经将SQL Server的名称和密码正确了.

您在哪里获得该服务器.我希望他们为您提供了用于sqlserver的控制面板.

这样您就可以看到一个查询窗口.

首先使用生成脚本选项将数据库转换为脚本查询.

之后，将该脚本粘贴到该控制面板查询窗口中.

然后点击运行.

您可以在那里看到所有表格

最好的

Hi,

you''ve your sql server uname and pwds right.

where you got that server.I hope they gave you controlpanel for sqlserver.

In that you can see one query window.

First convert your database into script query.by using options of generate scripts

After that paste that script into that control panel query window.

And click on run.

you can see all your tables in there

All the Best

这篇关于将sql server数据库上传到Web服务器的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！