SharePoint 2007 and Infopath 2007, SQL Server 2005 Logon Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AirDuster101 - 09 Jul 2007 21:52 GMT

Hi,

I have published a form to our Sharepoint 2007/Form services server. But
the form will break with below error when it tries to connect to database.
How did the logon become anonymous?

I get the error: Login
failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

==== My connection String ====

ConnectionString =
"Server=SPSQL1\SPSQL1;Database=RDB1;Trusted_Connection=Yes;Connection
Timeout=0"

Thanks

AD

Reply to this Message

K.Ramana Reddy(GGK Tech) - 11 Jul 2007 06:10 GMT

Hi,

Use Integrated Security in the Connection string.

I hope this will help for you.

Signature

k.Ramana Reddy
http://www.GGKtech.com

> Hi,
>
[quoted text clipped - 14 lines]
>
> AD

Reply to this Message

AirDuster101 - 11 Jul 2007 22:58 GMT

Hi,

I replaced trusted_user=Yes with Integrated Security = SSPI, but still got
the same error.

ConnectionString = "Server=SPSQL1\SPSQL1;Database=RDB1;Integrated
Security=SSPI;Connection
Timeout=0"

Any other suggestion?

Thanks
AD

> Hi,
>
[quoted text clipped - 20 lines]
> >
> > AD

Reply to this Message

K.Ramana Reddy(GGK Tech) - 12 Jul 2007 06:26 GMT

Hi,

You have any server instances? if you have how you installed those instances?
(I.e, 'LOCAL SERVICE' and ..)

Signature

k.Ramana Reddy
http://www.GGKtech.com

> Hi,
>
[quoted text clipped - 34 lines]
> > >
> > > AD

Reply to this Message

AirDuster101 - 15 Jul 2007 05:42 GMT

No. We just have one.

> Hi,
>
[quoted text clipped - 39 lines]
> > > >
> > > > AD

Reply to this Message