无法连接到SQL db [英] unable to connect to sql db
问题描述
我将数据库从一台服务器移动到另一台SQL服务器。我做了备份和恢复数据库。我可以从我的asp.net应用程序连接到服务器A上的数据库但是当我尝试连接到我的数据库服务器B时,我正在为用户''登录失败''用户名''
>
我已将用户名添加到服务器B上的数据库,我可以打开短信并以这种方式连接到数据库,但我无法从我的asp.net网络应用程序连接。
关于什么可能导致我无法连接到我的sql server B数据库的任何建议?
8月28日下午2:47,史蒂夫 < St ... @ community.nospam.comwrote:
我将数据库从一台服务器移动到另一台SQL服务器。我做了备份和恢复数据库。我可以从我的asp.net应用程序连接到服务器A上的数据库但是当我尝试连接到我的数据库服务器B时,我正在为用户''登录失败''用户名''
>
我已将用户名添加到服务器B上的数据库,我可以打开短信并以这种方式连接到数据库,但我无法从我的asp.net网络应用程序连接。
关于什么可能导致我无法连接到我的sql server B数据库的任何建议?
您好,
您是否检查了''web.config''文件中的连接字符串?
尝试检查连接字符串中的所有参数是否正确
srv B数据库。
再见
是的,我已经多次检查过了,仍然无法连接它。
我现在迷失了它。
< ci ********* @ gmail.com写信息
新闻:11 *************** *******@r29g2000hsg.googlegr oups.com ...
8月28日下午2:47,Steve < St ... @ community.nospam.comwrote:
>我将数据库从一台服务器移动到另一台SQL服务器。我做了备份
并恢复了数据库。我可以从我的asp.net应用程序连接到服务器A上的数据库,但当我尝试连接到我的数据库服务器B时,
我正在为用户''用户名'登录失败' '
我已经将用户名添加到服务器B上的数据库中,我可以打开短信
并以这种方式连接到数据库,但是我无法从我的asp连接.net
网络应用。
有什么可能导致我无法连接到我的
sql server B数据库的任何建议?
您好,
您是否检查了''web.config''文件中的连接字符串?
尝试检查连接字符串中的所有参数是否正确
srv B数据库。
再见
8月28日下午4:57,史蒂夫 < St ... @ community.nospam.comwrote:
是的,我已经多次检查过但仍然无法连接到它。
我现在迷失了。
< ciccone1 ... @ gmail.comwrote in message
news:11 ********************** @ r29g2000hsg.googlegr oups.com ......
8月28日下午2:47,史蒂夫 < St ... @ community.nospam.comwrote:
我将数据库从一台服务器移动到另一台SQL服务器。我做了一个备份
并恢复了数据库。我可以从我的asp.net应用程序连接到服务器A上的数据库
但是当我尝试连接到我的数据库服务器B时,
我正在接受''用户''用户名''登录失败'
我已将用户名添加到服务器B上的数据库,我可以打开短信
并以这种方式连接到数据库,但我无法从我的asp.net
网络应用程序连接。
有关可能导致我无法连接到我的
sql server B数据库?
你检查了''web.config''文件中的连接字符串?
尝试检查连接字符串中的所有参数是否正确
srv B数据库。
再见
如果可以,你应该提供更多信息所以也许我可以
更有帮助。
错误信息怎么样?
你能发一些asp代码吗?
I moved my database from one server to another SQL server. I did a backup and restore of the database. I can connect to the database on server A from my asp.net app but when I try to connect to my database server B, I''m gettting ''login failed for user ''username''
I''ve added the username to the database on server B, I can open up SMS and connect to the database that way, but I can''t connect from my asp.net web app.
any suggestions on what may be causing me not to be able to connect to my sql server B database?
On Aug 28, 2:47 pm, "Steve" <St...@community.nospam.comwrote:I moved my database from one server to another SQL server. I did a backup and restore of the database. I can connect to the database on server A from my asp.net app but when I try to connect to my database server B, I''m gettting ''login failed for user ''username''
I''ve added the username to the database on server B, I can open up SMS and connect to the database that way, but I can''t connect from my asp.net web app.
any suggestions on what may be causing me not to be able to connect to my sql server B database?Hi,
have you checked the connection string in the ''web.config'' file?
Try to check if all parameters in the connection string are correct
for the srv B database.
Bye
Yes, I''ve checked it several times and still unable to connect to it.
I''m lost on it now.
<ci*********@gmail.comwrote in message
news:11**********************@r29g2000hsg.googlegr oups.com...On Aug 28, 2:47 pm, "Steve" <St...@community.nospam.comwrote:>I moved my database from one server to another SQL server. I did a backup
and restore of the database. I can connect to the database on server A
from my asp.net app but when I try to connect to my database server B,
I''m gettting ''login failed for user ''username''
I''ve added the username to the database on server B, I can open up SMS
and connect to the database that way, but I can''t connect from my asp.net
web app.
any suggestions on what may be causing me not to be able to connect to my
sql server B database?
Hi,
have you checked the connection string in the ''web.config'' file?
Try to check if all parameters in the connection string are correct
for the srv B database.
Bye
On Aug 28, 4:57 pm, "Steve" <St...@community.nospam.comwrote:Yes, I''ve checked it several times and still unable to connect to it.
I''m lost on it now.
<ciccone1...@gmail.comwrote in message
news:11**********************@r29g2000hsg.googlegr oups.com...
On Aug 28, 2:47 pm, "Steve" <St...@community.nospam.comwrote:I moved my database from one server to another SQL server. I did a backup
and restore of the database. I can connect to the database on server A
from my asp.net app but when I try to connect to my database server B,
I''m gettting ''login failed for user ''username''
I''ve added the username to the database on server B, I can open up SMS
and connect to the database that way, but I can''t connect from my asp.net
web app.
any suggestions on what may be causing me not to be able to connect to my
sql server B database?
Hi,
have you checked the connection string in the ''web.config'' file?
Try to check if all parameters in the connection string are correct
for the srv B database.
Bye
If you can, you should provide more informations so maybe I can be
more helpful.
What about error message?
Could you post some asp code?
这篇关于无法连接到SQL db的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!