login failed for user '(null)'

I have seen this discussed before here, but I guess not quite that way I want to
use it. We would like to use pure Windows NT Integrated Security, therefore
taking advantage of AD groups and existing security in SQL Server. However,
anytime we select the 'Windows NT Integrated Security' option in the data
source, we always get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server
connection.
Can anybody help? Thanks!Did you switched on Mixed Mode Autentification on Sql Server ?
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>I have seen this discussed before here, but I guess not quite that way I
>want to use it. We would like to use pure Windows NT Integrated Security,
>therefore taking advantage of AD groups and existing security in SQL
>Server. However, anytime we select the 'Windows NT Integrated Security'
>option in the data source, we always get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> Can anybody help? Thanks!|||Yes, this is standard practice when installing new instances of SQL Server
around here.
Jens Süßmeyer wrote:
> Did you switched on Mixed Mode Autentification on Sql Server ?
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
>
> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
> news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>
>|||Seems taht you did´nt spedify the security settings in the right way. YOu
may have a look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
Make sure that when you redeploy your datasources you select the "Overwrite
datasources" option.
When even then its not working please post the part of your infrastructure
here, so that we can see how you get acces to the datasources (Servers,
ect.)
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
news:eGV9rrdRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Yes, this is standard practice when installing new instances of SQL Server
> around here.
> Jens Süßmeyer wrote:
>> Did you switched on Mixed Mode Autentification on Sql Server ?
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>>
>> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
>> news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>>|||I am modifying the (shared) datasource on the Report Server. Kerberos is enabled
across the board.
Connection type: Microsoft SQL Server
Connection string: data source=MYSERVER;initial catalog=ENTERPRISE
Connect using: Windows NT Integrated Security
Jens Süßmeyer wrote:
> Seems taht you did´nt spedify the security settings in the right way. YOu
> may have a look here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
> Make sure that when you redeploy your datasources you select the "Overwrite
> datasources" option.
> When even then its not working please post the part of your infrastructure
> here, so that we can see how you get acces to the datasources (Servers,
> ect.)
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
> news:eGV9rrdRFHA.3716@.TK2MSFTNGP14.phx.gbl...
>>Yes, this is standard practice when installing new instances of SQL Server
>>around here.
>>Jens Süßmeyer wrote:
>>Did you switched on Mixed Mode Autentification on Sql Server ?
>>HTH, Jens Süßmeyer.
>>--
>>http://www.sqlserver2005.de
>>--
>>
>>
>>"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
>>news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>>
>