can not log in to sql server 2005

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

can not log in to sql server 2005

Author

Topic

Dirk_Name
Starting Member

3 Posts

Posted - 2012-05-08 : 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

227 Posts

Posted - 2012-05-09 : 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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-05-09 : 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

3 Posts

Posted - 2012-05-09 : 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

227 Posts

Posted - 2012-05-10 : 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:

[url]http://support.microsoft.com/kb/555332[/url]

N 28° 33' 11.93148"
E 77° 14' 33.66384"

Dirk_Name
Starting Member

3 Posts

Posted - 2012-05-10 : 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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-05-12 : 04:53:37

Glad to see it worked

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

vinu.vijayan
Posting Yak Master

227 Posts

Posted - 2012-05-14 : 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"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources