error: 18452; very urgent

We have 2 failover servers and one client in our test environment. We
have all the three configured in mixed mode authentication(windows +
sql server authentication). But when we are failing over from 1st
server to 2nd one, we are getting the following error message,
'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user 'null'. Reason: Not associated with a trusted SQL server
connection.'
I got some clue.
For instance we have ser1 and ser2 as clusters. I registered both in
the client's EM. Now what I did was, I made ser1 to run and stopped sql
service in ser2 (active/passive) through failover. Now in the client's
EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
I failed over to ser2 ( so sql service in ser1 is stopped). But now I
can still be able to access ser1 and also I can access ser2, even I'm
able to open query analyzer in ser1 through EM.But when I try to open
query analyzer directly, it is giving the same error message. ser1 is
the virtual name given to both ser1 and ser2. So I think when
connecting through EM, failover is occuring fine.I'm just wondering why
is this happening only with dsn. Can anybody help me?
Thanks,
Preethihttp://support.microsoft.com/default.aspx?scid=kb;en-us;555332
"sqldbapree" <mohanpreethi0125@.gmail.com> wrote in message
news:1129898680.495504.25600@.g44g2000cwa.googlegroups.com...
> We have 2 failover servers and one client in our test environment. We
> have all the three configured in mixed mode authentication(windows +
> sql server authentication). But when we are failing over from 1st
> server to 2nd one, we are getting the following error message,
> 'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
> State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
> user 'null'. Reason: Not associated with a trusted SQL server
> connection.'
> I got some clue.
> For instance we have ser1 and ser2 as clusters. I registered both in
> the client's EM. Now what I did was, I made ser1 to run and stopped sql
> service in ser2 (active/passive) through failover. Now in the client's
> EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
> I failed over to ser2 ( so sql service in ser1 is stopped). But now I
> can still be able to access ser1 and also I can access ser2, even I'm
> able to open query analyzer in ser1 through EM.But when I try to open
> query analyzer directly, it is giving the same error message. ser1 is
> the virtual name given to both ser1 and ser2. So I think when
> connecting through EM, failover is occuring fine.I'm just wondering why
> is this happening only with dsn. Can anybody help me?
> Thanks,
> Preethi
>

error: 18452; very urgent

We have 2 failover servers and one client in our test environment. We
have all the three configured in mixed mode authentication(windows +
sql server authentication). But when we are failing over from 1st
server to 2nd one, we are getting the following error message,
'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login fai
led for
user 'null'. Reason: Not associated with a trusted SQL server
connection.'
I got some clue.
For instance we have ser1 and ser2 as clusters. I registered both in
the client's EM. Now what I did was, I made ser1 to run and stopped sql
service in ser2 (active/passive) through failover. Now in the client's
EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
I failed over to ser2 ( so sql service in ser1 is stopped). But now I
can still be able to access ser1 and also I can access ser2, even I'm
able to open query analyzer in ser1 through EM.But when I try to open
query analyzer directly, it is giving the same error message. ser1 is
the virtual name given to both ser1 and ser2. So I think when
connecting through EM, failover is occuring fine.I'm just wondering why
is this happening only with dsn. Can anybody help me?
Thanks,
Preethihttp://support.microsoft.com/defaul...kb;en-us;555332
"sqldbapree" <mohanpreethi0125@.gmail.com> wrote in message
news:1129898680.495504.25600@.g44g2000cwa.googlegroups.com...
> We have 2 failover servers and one client in our test environment. We
> have all the three configured in mixed mode authentication(windows +
> sql server authentication). But when we are failing over from 1st
> server to 2nd one, we are getting the following error message,
> 'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
> State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login f
ailed for
> user 'null'. Reason: Not associated with a trusted SQL server
> connection.'
> I got some clue.
> For instance we have ser1 and ser2 as clusters. I registered both in
> the client's EM. Now what I did was, I made ser1 to run and stopped sql
> service in ser2 (active/passive) through failover. Now in the client's
> EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
> I failed over to ser2 ( so sql service in ser1 is stopped). But now I
> can still be able to access ser1 and also I can access ser2, even I'm
> able to open query analyzer in ser1 through EM.But when I try to open
> query analyzer directly, it is giving the same error message. ser1 is
> the virtual name given to both ser1 and ser2. So I think when
> connecting through EM, failover is occuring fine.I'm just wondering why
> is this happening only with dsn. Can anybody help me?
> Thanks,
> Preethi
>

error: 18452; very urgent

We have 2 failover servers and one client in our test environment. We
have all the three configured in mixed mode authentication(windows +
sql server authentication). But when we are failing over from 1st
server to 2nd one, we are getting the following error message,
'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user 'null'. Reason: Not associated with a trusted SQL server
connection.'
I got some clue.
For instance we have ser1 and ser2 as clusters. I registered both in
the client's EM. Now what I did was, I made ser1 to run and stopped sql
service in ser2 (active/passive) through failover. Now in the client's
EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
I failed over to ser2 ( so sql service in ser1 is stopped). But now I
can still be able to access ser1 and also I can access ser2, even I'm
able to open query analyzer in ser1 through EM.But when I try to open
query analyzer directly, it is giving the same error message. ser1 is
the virtual name given to both ser1 and ser2. So I think when
connecting through EM, failover is occuring fine.I'm just wondering why
is this happening only with dsn. Can anybody help me?
Thanks,
Preethi
http://support.microsoft.com/default...b;en-us;555332
"sqldbapree" <mohanpreethi0125@.gmail.com> wrote in message
news:1129898680.495504.25600@.g44g2000cwa.googlegro ups.com...
> We have 2 failover servers and one client in our test environment. We
> have all the three configured in mixed mode authentication(windows +
> sql server authentication). But when we are failing over from 1st
> server to 2nd one, we are getting the following error message,
> 'Unable to connected to server xxxx: Server : Msg 18452, Level 16,
> State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
> user 'null'. Reason: Not associated with a trusted SQL server
> connection.'
> I got some clue.
> For instance we have ser1 and ser2 as clusters. I registered both in
> the client's EM. Now what I did was, I made ser1 to run and stopped sql
> service in ser2 (active/passive) through failover. Now in the client's
> EM I'm able to open ser1 and I cannot access ser2. Now what I did was,
> I failed over to ser2 ( so sql service in ser1 is stopped). But now I
> can still be able to access ser1 and also I can access ser2, even I'm
> able to open query analyzer in ser1 through EM.But when I try to open
> query analyzer directly, it is giving the same error message. ser1 is
> the virtual name given to both ser1 and ser2. So I think when
> connecting through EM, failover is occuring fine.I'm just wondering why
> is this happening only with dsn. Can anybody help me?
> Thanks,
> Preethi
>

Error: [DBNMPNTW]Access denied.

Hi,
I have set up a server with IIS. The pages needs authentication to browse.
When the pages are browsed from the machine where IIS is set up It is loging
in the user.
When a user is trying to login from a different location or machine, its
gives the following error message, How to fix the issue.
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
We are using Named Pipes. Do we have to make any settings changes...
Can any one help...
I always use TCP/IP when connecting from ASP/VB. Have you tried that
instead?
http://www.aspfaq.com/
(Reverse address to reply.)
"Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> Hi,
> I have set up a server with IIS. The pages needs authentication to browse.
> When the pages are browsed from the machine where IIS is set up It is
loging
> in the user.
> When a user is trying to login from a different location or machine, its
> gives the following error message, How to fix the issue.
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Access denied.
>
> We are using Named Pipes. Do we have to make any settings changes...
> Can any one help...
>
>
|||Aaron,
Thanx for your reply, The problem is like this.
Like if i logion to the machine where teh site is set up and Login, for the
next five minutes or so i am able to login from different machines/ location.
After that if the session in the Server Machine expires then from all the
other places if i try to login the login is giving the below mentioned error
message
Deepak
"Aaron [SQL Server MVP]" wrote:

> I always use TCP/IP when connecting from ASP/VB. Have you tried that
> instead?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
> message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> loging
>
>

Error: [DBNMPNTW]Access denied.

Hi,
I have set up a server with IIS. The pages needs authentication to browse.
When the pages are browsed from the machine where IIS is set up It is loging
in the user.
When a user is trying to login from a different location or machine, its
gives the following error message, How to fix the issue.
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
We are using Named Pipes. Do we have to make any settings changes...
Can any one help...I always use TCP/IP when connecting from ASP/VB. Have you tried that
instead?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> Hi,
> I have set up a server with IIS. The pages needs authentication to browse.
> When the pages are browsed from the machine where IIS is set up It is
loging
> in the user.
> When a user is trying to login from a different location or machine, its
> gives the following error message, How to fix the issue.
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Access denied.
>
> We are using Named Pipes. Do we have to make any settings changes...
> Can any one help...
>
>|||Aaron,
Thanx for your reply, The problem is like this.
Like if i logion to the machine where teh site is set up and Login, for the
next five minutes or so i am able to login from different machines/ location.
After that if the session in the Server Machine expires then from all the
other places if i try to login the login is giving the below mentioned error
message
Deepak
"Aaron [SQL Server MVP]" wrote:
> I always use TCP/IP when connecting from ASP/VB. Have you tried that
> instead?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Deepak Natarajan" <Deepak Natarajan@.discussions.microsoft.com> wrote in
> message news:D933A8B2-34FB-4DE4-A7D0-5C9355A60B5B@.microsoft.com...
> > Hi,
> >
> > I have set up a server with IIS. The pages needs authentication to browse.
> > When the pages are browsed from the machine where IIS is set up It is
> loging
> > in the user.
> >
> > When a user is trying to login from a different location or machine, its
> > gives the following error message, How to fix the issue.
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > [DBNMPNTW]Access denied.
> >
> >
> > We are using Named Pipes. Do we have to make any settings changes...
> >
> > Can any one help...
> >
> >
> >
> >
>
>

Error with basic authentication - Reporting Service Add In for Sharepoint

Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?i'm having this issue, too. help?

Error with basic authentication - Reporting Service Add In for Sharepoint

Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?i'm having this issue, too. help?