用户''登录失败。用户未与受信任的SQL Server连接关联。 [英] Login failed for user ''. The user is not associated with a trusted SQL Server connection.
问题描述
我的机器有Win XP和IIS 5.1。
我安装了没有SQL Express 2005的Visual Studio 2005. SQL Server
2005安装在另一台机器上使用Win 2003.
我在.NET VB中创建了一个网站。我创建了与我的SQL
服务器数据库的连接，我可以在SERVER EXPLORER中检索/更改数据。当我尝试使用一个表创建一个包含数据的gridview并在Internet Explorer中运行web
页面时，我收到以下错误。
用户'''登录失败。用户没有与受信任的SQL
服务器连接相关联。
能帮助我吗？
My machine has Win XP and IIS 5.1.
I installed Visual Studio 2005 without SQL Express 2005. SQL Server
2005 is installed on another machine with Win 2003.
I created a Web Site in .NET VB. I created a connection with my SQL
server database, I can retrieve/ change data in SERVER EXPLORER. When I
try to create a gridview with data fron one table and to run the web
page in Internet Explorer I receive the following error.
Login failed for user ''''. The user is not associated with a trusted SQL
Server connection.
Can you please help me ?
推荐答案
您使用哪个连接字符串连接到数据库，我想b / b
猜你正在使用未设置的SQL Server身份验证
正确在您的计算机上。
因此切换到混合身份验证，或使用Windows帐户连接
到数据库 -
HTH，Jens Suessmeyer。
---
http://www.sqlserver2005.de
---
Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn′t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
您使用哪个连接字符串连接到数据库，我猜你正在使用SQL Server身份验证，而不是在您的计算机上正确设置
。
所以切换到混合身份验证，或使用Windows帐户连接
到d atabase-
HTH，Jens Suessmeyer。
---
http://www.sqlserver2005.de
---
Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn′t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
您好
如何设置数据库？ Windows认证还是混合？
< CL ***** @ gmail.com>在消息中写道
news：11 ********************* @ z34g2000cwc.googlegro ups.com ...
Hi
How do you set up your database? A Windows Authenication or Mixed?
<CL*****@gmail.com> wrote in message
news:11*********************@z34g2000cwc.googlegro ups.com...
我的机器有Win XP和IIS 5.1。
我安装了没有SQL Express 2005的Visual Studio 2005. SQL Server
2005安装在另一台带有Win 2003的机器上。
我在.NET VB中创建了一个Web站点。我创建了与我的SQL服务器数据库的连接，我可以在SERVER EXPLORER中检索/更改数据。当我尝试使用一个表创建一个包含数据的gridview并在Internet Explorer中运行web页面时，我收到以下错误。
用户'''登录失败。用户与可信的SQL
服务器连接无关。
你能帮助我吗？
My machine has Win XP and IIS 5.1.
I installed Visual Studio 2005 without SQL Express 2005. SQL Server
2005 is installed on another machine with Win 2003.
I created a Web Site in .NET VB. I created a connection with my SQL
server database, I can retrieve/ change data in SERVER EXPLORER. When I
try to create a gridview with data fron one table and to run the web
page in Internet Explorer I receive the following error.
Login failed for user ''''. The user is not associated with a trusted SQL
Server connection.
Can you please help me ?
这篇关于用户''登录失败。用户未与受信任的SQL Server连接关联。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
