Login failed for user 'domain\username'

[Phanindra Kumar]

Hi, When trying to connect to sqlserver 2000 I am getting this error. I am having Windows 2003 server, VS.NET 2003, Sql Server 2000 in my machine.I tried lot of articles but no use.Can anyone help me ? Thanks in Advance

Phanindra...

[R Palanivel]

HI Kumar Go to SQL server 2000 enterprise manager and expand sql server group under your server name will display.right click on that server name ,choose properties and select "Security Tab".in that Security tab choose Authentication as "SQL server and Windows" Regards RPL

r_palanivel83 10:01 4 Jan '06

[Phanindra Kumar]

Hi, Thanks for reply. Eventhough I changed authentication type from 'Windows' to Mixed mode, I am getting the same error. But when I am trying to remove identity impersonate="true" in web.config i encountered a different error like: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Any help in this issue ? Thanks

Phanindra...

[R Palanivel]

HI Create a new User for your database and give the permission for all tables and sp's for that user. -- Create New User Expand your Server on SQL enterprise manager,Open Security->Logins. Here u can create a New user for your database after that u have to set userid, password for your connection(trusted SQL mean Userid,password must) Regards RPL

r_palanivel83 10:01 4 Jan '06

[Phanindra Kumar]

Hi, I had done everything you said. But the problem persists. I am getting the same error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.". When i am trying to use the same connection string in another application it is working fine. I am confused! Thanks

Phanindra...

[R Palanivel]

HI check your IIS Configuration is Anonymous.if it is checked this problem should go Regards RPL

r_palanivel83 10:01 4 Jan '06

[Phanindra Kumar]

I checked both the anonymous and integrated authentication. But no use. I also tried without integrated authentication. Thanks

Phanindra...