| Author |
 Topic  |
|
|
Dirk_Name
Starting Member
Cambodia
3 Posts |
 Posted - 05/08/2012 : 21:30:14
|
Hi all friends,
I'm new in sql server 2005. When i finished install sql server, i have one user account (sa) and password. First I can log in to sql server properly.
but since i have changed something in Server Property by right click on Server name select Property and then select security
( i have change Server Authentication from SQL Server and Window Authentication Mode to Window Authentication Mode).
Now I can't log in to SQL Server either with sa or Window Authentication.
What's can i do now to deal with this problem?
Please help me
Thank in advance
Dirk_Name |
|
|
vinu.vijayan
Posting Yak Master
India
227 Posts |
Posted - 05/09/2012 : 06:33:30
|
This maybe because the Windows account you are using is not authorized to Log into SQL Server.
So, from next time Select SQL Server Authentication and use the 'sa' log in and password to log in.
N 28° 33' 11.93148"
E 77° 14' 33.66384" |
 |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
Posted - 05/09/2012 : 14:58:30
|
Change it back to SQL Server and Window Authentication Mode.
To log on using Windows Authentication, create a Logon , that is AD or a local Windows Acct - then connect in the context of that Windows Account
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
Dirk_Name
Starting Member
Cambodia
3 Posts |
Posted - 05/09/2012 : 20:03:37
|
I have a message of log in failed with user sa. ( Login failed for user 'sa'. The user is not associated with trusted SQL Server Connection. (Microsoft SQL Server, Error: 18452).
Anyway, can you explain clearly, remember i'm a new user in SQL Server.
Thank you
Dirk_Name |
|
|
|
vinu.vijayan
Posting Yak Master
India
227 Posts |
Posted - 05/10/2012 : 00:07:37
|
quote:
Originally posted by Dirk_Name
I have a message of log in failed with user sa. ( Login failed for user 'sa'. The user is not associated with trusted SQL Server Connection. (Microsoft SQL Server, Error: 18452).
Anyway, can you explain clearly, remember i'm a new user in SQL Server.
Thank you
Dirk_Name
This error means that SQL server has been configured to operate in "Windows Authentication Mode (Windows Authentication)" and doesn't allow the use of SQL accounts.
To overcome this you'll have to change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
Check out the following link:
http://support.microsoft.com/kb/555332
N 28° 33' 11.93148"
E 77° 14' 33.66384" |
|
|
|
Dirk_Name
Starting Member
Cambodia
3 Posts |
Posted - 05/10/2012 : 10:51:44
|
Thank you vinu.vijayan and other friend
I think vinu.vijayan give me a great idea.
Now, I can log in to SQL Server Properly.
Thank you all,
Dirk_Name |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
|
|
vinu.vijayan
Posting Yak Master
India
227 Posts |
Posted - 05/14/2012 : 04:37:24
|
quote:
Originally posted by Dirk_Name
Thank you vinu.vijayan and other friend
I think vinu.vijayan give me a great idea.
Now, I can log in to SQL Server Properly.
Thank you all,
Dirk_Name
You're welcome...I'm glad it helped you.
N 28° 33' 11.93148"
E 77° 14' 33.66384" |
|
|
| |
Topic |
|
can not log in to sql server 2005
