单独的Web服务器和SQL Server - 将asp.netapp连接到数据库时出错 [英] Separate Webserver and SQL Server -- error when connecting asp.netapp to a database
问题描述
大家好，
我想请一些关于分离asp.net
网络服务器和sql服务器的帮助。
我为某个公司创建了一个asp.net应用程序。最初，
我们在一台机器上安装了iis和sql server。不太好
很久以前，这台机器出现了一些硬件问题，管理层决定为asp.net和sql server购买新的服务器。
一旦我们在第一台服务器上安装了我的webapp，而在另一台机器上安装了我的web服务器，我们就遇到了一些错误。基本上，继续说的
异常是：
SQL Server数据库不存在或访问被拒绝。
尝试为webapp创建一个用于连接的Windows帐户，并且将b $ b配置为sql server，但它不起作用。
尝试使用SQL Server帐户连接数据库，但
无济于事。
请帮忙！我真的很感激!!
问候，
Ann Marinas
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
Once we installed my webapp on the first server and the sql server on
another, we have encountered some errors with it. Basically, the
exception that keeps on saying was:
"SQL Server database does not exist or access denied."
Tried creating a windows account for the webapp to use to connect and
configure it to the sql server, but it does not work.
Tried also connecting with the database using a SQL Server account, but
to no avail.
Please help! I would really appreciate it!!
Regards,
Ann Marinas
推荐答案
一个ASP .NET应用程序通常通过
System.Data.SqlClient.SqlConnection对象连接到数据库。
要更改SQL服务器，需要查找所有SqlConnection对象并
更新他们的ConnectionString属性以指向新数据库
服务器。
问候，
Wessel
-----原帖-----
来自：Ann Marinas [mailto：ka ******** @ xtra .co.nz]
发表于：2005年4月10日星期日下午12:11
发布至：microsoft.public.dotnet.framework.aspnet
对话：单独的Web服务器和SQL Server - 连接
asp.net应用程序到数据库时出错
主题：单独的Web服务器和SQL Server - 错误时连接
asp.net应用程序到数据库
大家好，
我想要o请求关于分离asp.net
webserver和sql server的一些帮助。
我为某个公司创建了一个asp.net应用程序。最初，
我们在一台机器上安装了iis和sql server。不太好
很久以前，这台机器出现了一些硬件问题，管理层决定为asp.net和sql server购买新的服务器。
一旦我们在第一台服务器上安装了我的webapp，而在另一台机器上安装了我的web服务器，我们就遇到了一些错误。基本上，继续说的
异常是：
SQL Server数据库不存在或访问被拒绝。
尝试为webapp创建一个用于连接的Windows帐户，并且将b $ b配置为sql server，但它不起作用。
尝试使用SQL Server帐户连接数据库，但
无济于事。
请帮忙！我真的很感激!!
问候，
Ann Marinas
An ASP.NET application typically connects to the database through a
System.Data.SqlClient.SqlConnection object.
To change the SQL server, you need to find all SqlConnection objects and
update their ConnectionString property to point to the new database
server.
Greetings,
Wessel
-----Original Message-----
From: Ann Marinas [mailto:ka********@xtra.co.nz]
Posted At: Sunday, April 10, 2005 12:11 PM
Posted To: microsoft.public.dotnet.framework.aspnet
Conversation: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database
Subject: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
Once we installed my webapp on the first server and the sql server on
another, we have encountered some errors with it. Basically, the
exception that keeps on saying was:
"SQL Server database does not exist or access denied."
Tried creating a windows account for the webapp to use to connect and
configure it to the sql server, but it does not work.
Tried also connecting with the database using a SQL Server account, but
to no avail.
Please help! I would really appreciate it!!
Regards,
Ann Marinas
" Ann Marinas" ; < KA ******** @ xtra.co.nz>在留言中写道
新闻：O8 ************** @ TK2MSFTNGP10.phx.gbl ...
"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:O8**************@TK2MSFTNGP10.phx.gbl...
请救命！我真的很感激!!
Please help! I would really appreciate it!!
1）您使用的是本机.NET数据提供程序，OleDb还是（当然不是！）ODBC？
2）你使用什么ConnectionString？
3）安装SQL Server时，你选择了什么身份验证模式
（SQL服务器，Windows或混合）？
4）在SQL Server计算机上，启动SQL查询分析器（不是企业
MANAGER！）并尝试登录使用上面2）中
ConnectionString的UserID和密码 - 你呢？如果是这样，你可以删除数据库
下拉列表并从2）中的ConnectionString中选择数据库吗？如果
那么，运行SELECT * FROM sysobjects - 你看到了什么？
1) Are you using the native .NET data provider, OleDb or (surely not!) ODBC?
2) What ConnectionString are you using?
3) When you installed SQL Server, what authentication mode did you choose
(SQL Server, Windows or mixed)?
4) On the SQL Server machine, launch SQL Query Analyzer (NOT ENTERPRISE
MANAGER!) and try to log in using the UserID and password from the
ConnectionString in 2) above - can you? If so, can you drop the database
dropdown and select the database from the ConnectionString in 2) above? If
so, run SELECT * FROM sysobjects - what do you see?
Wessel！
感谢您的回复。
我已经在数据库被转换到另一台服务器之后更改了我的connectionstring属性并且它已经全部正确的值，但
仍无济于事。
再次感谢您帮助我！真的很感激！
干杯，
Ann
Wessel Troost写道：
Hi, Wessel!
Thank you for your reply.
I''ve changed my connectionstring property after the database was
transfered to another server and it has got all the correct values, but
still no avail.
Thanks again for helping me out! Really do appreciate it!
Cheers,
Ann
Wessel Troost wrote:
ASP.NET应用程序通常通过System.Data.SqlClient.SqlConnection对象连接到数据库。
要更改SQL服务器，您需要查找所有SqlConnection对象并更新
他们的ConnectionString属性指向新的数据库服务器。
问候，Wessel
-----原帖-----
来自：Ann Marinas [mailto：ka ******** @ xtra.co.nz]
发表日期：2005年4月10日星期日下午12:11
发布至：microsoft.public.dotnet.framework.aspnet
对话：单独的Web服务器和SQL Server - 将
asp.net应用程序连接到数据库时出错
主题：单独的Web服务器和SQL Server - 将
asp.net应用程序连接到数据库时出错
大家好，
我想请求关于分离asp.net的一些帮助
网络服务器和s ql服务器。
我为某个公司创建了一个asp.net应用程序。最初，我们在一台机器上安装了iis和sql server。不太好
很久以前，机器出现了一些硬件问题，管理层决定为asp.net和sql server购买新的服务器。
一旦我们安装了我的第一台服务器上的webapp和另一台上的sql server，我们遇到了一些错误。基本上，继续说的
异常是：
SQL Server数据库不存在或访问被拒绝。
尝试创建一个Windows帐户用于连接和配置到sql server的webapp，但它不起作用。
尝试使用SQL Server帐户连接数据库，但是
没有用。
请帮忙！我真的很感激!!
问候，
Ann Marinas
An ASP.NET application typically connects to the database through a
System.Data.SqlClient.SqlConnection object.
To change the SQL server, you need to find all SqlConnection objects and
update their ConnectionString property to point to the new database
server.
Greetings,
Wessel
-----Original Message-----
From: Ann Marinas [mailto:ka********@xtra.co.nz]
Posted At: Sunday, April 10, 2005 12:11 PM
Posted To: microsoft.public.dotnet.framework.aspnet
Conversation: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database
Subject: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
Once we installed my webapp on the first server and the sql server on
another, we have encountered some errors with it. Basically, the
exception that keeps on saying was:
"SQL Server database does not exist or access denied."
Tried creating a windows account for the webapp to use to connect and
configure it to the sql server, but it does not work.
Tried also connecting with the database using a SQL Server account, but
to no avail.
Please help! I would really appreciate it!!
Regards,
Ann Marinas
这篇关于单独的Web服务器和SQL Server - 将asp.netapp连接到数据库时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
