FlyFF SQL error

If you are using MSSQL 2005, here's a guide on how to reset your SA password.

How to reset the password for the System Administrator, or 'sa' user account, within SQL Server Management Studio

Resetting the password for your SQL Server 2005 ‘sa’ user (abbreviation for ‘System Administrator’) can be done in a few quick steps through SQL Server 2005 Management Studio, both Standard and Express Editions.

For the purposes of this article, we will demonstrate changing the ‘sa’ password from within Management Studio Express, as there is relatively no difference between the versions concerning altering the ‘sa’ password.

Open SQL Server Management Studio by navigating to Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.

http://www.serverintellect.com/suppo...Password_1.jpg

Connect to your instance of SQL Server via Windows Authentication.

http://www.serverintellect.com/suppo...sa_pass_02.gif

Once open, in the Object Explorer view, click the plus sign next to Security, and then the plus sign next to Logins. Once expanded, right-click on the ‘sa’ user, and choose Properties.

http://www.serverintellect.com/suppo...sa_pass_03.gif

In the Properties window which opens up, on the first page you will see two fields containing a masked password. Type in your preferred password and click OK.

http://www.serverintellect.com/suppo...Password_2.jpg


Good luck, (;

@ Error 404, thanks for your help but I still get the same error, did it a few times, I even did reboot my computer between changing the pass and loging into 'sa' maybe you could add me on msn and help me? ^_^
mike.decibel@hotmail.com

~Aspire

Try to change to MICHEALPC to MICHEAL-PC

@mikederoobs my pc name is michaelpc not michael-pc, but yea I already tried it but still nothin`.

Bumb = D

Bumb2:$

Understanding "login failed" (Error 18456) error messages in SQL Server 2005

In continuing with the theme of understanding error messages I'll discuss the "login failed" messages that are surfaced by the client and written to the server's error log (if the auditlevel is set to log failures on login which is the default) in the event of an error during the login process.

If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage.

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

Note that the message is kept fairly nondescript to prevent information disclosure to unauthenticated clients. In particular, the 'State' will always be shown to be '1' regardless of the nature of the problem. To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. An example of an entry is:

2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8.
2006-02-27 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>]

The key to the message is the 'State' which the server will accurately set to reflect the source of the problem. In the example above, State 8 indicates that the authentication failed because the user provided an incorrect password. The common error states and their descriptions are provided in the following table:

http://i.imgur.com/Mi710.png

Source: Understanding "login failed" (Error 18456) error messages in SQL Server 2005 - SQL Protocols - Site Home - MSDN Blogs



--------------------------------

On another hand, did you try reinstalling Sql server altogether?