IIS server set up for .net app

mecn

Hi,

I use windows authentication for .net app to connection to sql 2k server.
I got the following error ---(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)

Connection string ------- server=sql serv1;database=mydb;trusted_connection
= true

appserver = app1

Any ideas?

Norman Yuan

The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.

You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.


"mecn" <> wrote in message
news:%.gbl...
> Hi,
>
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error ---(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
>
> Connection string ------- server=sql
> serv1;database=mydb;trusted_connection = true
>
> appserver = app1
>
> Any ideas?
>

Ekrem Önsoy

Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.

If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.

--
Ekrem Önsoy



"mecn" <> wrote in message
news:%.gbl...
> Hi,
>
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error ---(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
>
> Connection string ------- server=sql
> serv1;database=mydb;trusted_connection = true
>
> appserver = app1
>
> Any ideas?
>

Ekrem Önsoy

Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.

If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.

--
Ekrem Önsoy



"mecn" <> wrote in message
news:%.gbl...
> Hi,
>
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error ---(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
>
> Connection string ------- server=sql
> serv1;database=mydb;trusted_connection = true
>
> appserver = app1
>
> Any ideas?
>