18.3.09

New user creation in sql server

Today, I have tried to create a new user for my sql server. But, I got a peculiar problem




------------------------------ADDITIONAL INFORMATION:
Login failed for user 'venkat'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------BUTTONS:
OK------------------------------

Solution:

The problem is due to sql server installation. SQL Server is installed with mode as windows authentication. We need to change it to mixed mode authentication. The problem is resolved. Goto Server, right click ->properties->Security.

Thanks and Regards,

Venkatesan Prabu .J

No comments:

Post a Comment