Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2009-10-09 : 02:28:03
|
| Hi I am getting this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)".I searched in goolge to solve this. Many are saying login trhough mixed mode. But i didn't find the option to change the mixed mode. I only able to see windows authentication and sql server authentication when i open sql server management studio.i have seen some scripts here "http://weblogs.sqlteam.com/peterl/archive/2008/06/19/How-to-change-authentication-mode-in-SQL-Server.aspx".But first of all i am unable to login...How can execute those scripts.How can i get out from this issue?developer :) |
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-10-09 : 02:41:11
|
| Because you are trying to login using windows authentication and your windows userid not added in to SQL Server. Fitst login as 'sa' to SQL server using sql server authentication(if you enabled it,Or login as windows Administrator where the sql server is hosted). Then go to securiry >> login>> new login and add the windows Domain\userid which you want to log in to SQL Server. |
 |
|
|
satish.gorijala
Posting Yak Master
182 Posts |
Posted - 2009-10-09 : 02:52:39
|
Hi Sanoj,Actually i forgot the password for sqlserver authentication. Till now i am using windows authentication. But suddently today i am getting this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)". What's the resolution if i am unable to login through sqlserver authentication ?quote:
Originally posted by sanoj_av
Because you are trying to login using windows authentication and your windows userid not added in to SQL Server. Fitst login as 'sa' to SQL server using sql server authentication(if you enabled it,Or login as windows Administrator where the sql server is hosted). Then go to securiry >> login>> new login and add the windows Domain\userid which you want to log in to SQL Server.
developer :) |
|
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-10-09 : 03:06:02
|
| Then you should know the windows Admin password where the SQL Server is running.Login to windows with an admin privilaged user and connect to SQL server using windows authentication. Then do whatever you want... |
|
|
|
satish.gorijala
Posting Yak Master
182 Posts |
Posted - 2009-10-09 : 03:22:12
|
hmm...that's the problem yar. I am unable to login through windows authentication also..getting same errorquote:
Originally posted by sanoj_av
Then you should know the windows Admin password where the SQL Server is running.Login to windows with an admin privilaged user and connect to SQL server using windows authentication. Then do whatever you want...
developer :) |
|
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-10-09 : 04:48:23
|
| Are you logging on to a domain?. Is the SQL server running on your local machine? If not, do you have the admin privilage on the box where SQL is running?(I ask about the server box. not the client) |
|
|
|
|
|
|
Login failed for user ''. The user is not associat