SharePoint 2007 and Infopath 2007, SQL Server 2005 Logon Error

[AirDuster101]

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

 

[K.Ramana Reddy(GGK Tech)]

Hi,

Use Integrated Security in the Connection string.

I hope this will help for you.

 

[AirDuster101]

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

 

[K.Ramana Reddy(GGK Tech)]

Hi,

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

 

[AirDuster101]

No. We just have one.

Hi,

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