Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem adding a new user
Message
From
13/03/2008 13:01:31
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01301802
Message ID:
01301818
Views:
11
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>I added a new user, but I can not login using this new user credentials.
>
>I'm getting
>
>TITLE: Connect to Server
>------------------------------
>
>Cannot connect to < ... >
>
>------------------------------
>ADDITIONAL INFORMATION:
>
>Login failed for user 'webApp'. 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
>------------------------------
>
>---------------------------------------------------------
>Do you know what should I do to rectify the problem and also how can I re-start the server, if needed? I don't see this option in the All Programs/SQL Server menu.

What are you using to manage MSSQ. If SMSS:
Right click on the server instance. The dropdown has stop and start options.
Also Properties/Security page has the option to enable SQL logins.
HTH,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform