FlyFF SQL error

Hi ragezoners!,

Since a few days I keep getting this error when I try to login in sql with 'sa':
Cannot connect to MICHAELPC\SQLEXPRESS.

Additional information:
Login failed for user 'sa'. (Microsoft SQL server, Error: 18456)

(screenshot: 4612077/wnuinso )
I`ve used alot of different installers for SQL 2005, with different drivers. I`ve even tried a different setup, which resulted in even more errors. So`ve redownloaded it around 30-31 times now and still got the error. And yes I`m using the right password...
I`ve also shearched for this error on google and here on ragezone but all solutions for that doesnt work. Can anybody help me with TeamViewer/Through msn?

Thanks!

~Aspire
(mike.decibel@hotmail.com)

Anybody?!?!:?::?::?:

Are you sure you are using authentication mode?
Are you sure you have set the password correctly?
Are you sure you are using \ instead of /?


If not, fix that and try again.

Are you sure Server Name is Correct?

Try checking.
Right CLick on my computer and look for your computer name.

Then put in the Server Name the informations you will see there.

PCNAME\SQLEXPRESS

@ItzMeMario, @Kiira yes, I checked everything, I already set that before, so nothing changes. =C BTW: look @ my SS I posted above.

You probably inputted the wrong password.

Re-run the SQL setup thingy.

Quote:

---

Originally Posted by sora1212

You probably inputted the wrong password.

Re-run the SQL setup thingy.

---

Already did that plenty of times, I`m sure for a 100% that this is the GOOD password... I even did copy and paste from the setup a few times (yes, I tested it on notepad if it was the good pass.)
:?::?::?:

check your registry maybe the login mode changes

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\**DatabaseName**\MSSQLServer\LoginMode

must be set at 2
to use the sa login

Plus, It's suppose to be MICHAEL-PC\SQLEXPRESS, not MICAHELPC\SQLEXPRESS or whatever you put.

Quote:

---

Originally Posted by sora1212

Plus, It's suppose to be MICHAEL-PC\SQLEXPRESS, not MICAHELPC\SQLEXPRESS or whatever you put.

---

How do you know what.his pc name is?

Quote:

---

Originally Posted by sora1212

Plus, It's suppose to be MICHAEL-PC\SQLEXPRESS, not MICAHELPC\SQLEXPRESS or whatever you put.

---

My pc name IS MICHAELPC not MICHAEL-PC ;)

Quote:

---

Originally Posted by Langstra

check your registry maybe the login mode changes

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\**DatabaseName**\MSSQLServer\LoginMode

must be set at 2
to use the sa login

---

I can`t find the HKEY_LOCAL_MACHINE Folder, can you help me through MSN/TV?

EDIT: I looked for it, but it was already set to 2, help?!

Anybody else has a solution?!

Quote:

---

Originally Posted by Aspire

My pc name IS MICHAELPC not MICHAEL-PC ;)


I can`t find the HKEY_LOCAL_MACHINE Folder, can you help me through MSN/TV?

EDIT: I looked for it, but it was already set to 2, help?!

---

Restart your pc?

Quote:

---

Originally Posted by Ajeje Ü

Restart your pc?

---

Already did, but still the problem ;) Can you help me with tv?
-mike.decibel@hotmail.com-

Sorry guys I didnt provide you all the information I have for you! so :
Since I forgot to post my error log(s) so there you go, maybe now somebody know how to fix it now :ott1:

CQuery-LogFile.txt:

Spoiler:

2011/06/23 23:57:58
query:login
SQLSTATE:28000 error:[Microsoft][SQL Native Client][SQL Server]Login failed for user 'login'.
2011/06/23 23:57:58
query:login
SQLSTATE:28000 error:[Microsoft][SQL Native Client][SQL Server]Login failed for user 'login'.
2011/06/23 23:57:58

Error.txt:

Spoiler:

2011/ 6/27 23:07:16 OP: 51415594, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2011/ 6/27 23:07:54 OP: 38251, 0.0, 0.0, 38250.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2011/ 6/27 23:08:01 OP: 6816, 0.0, 0.0, 0.0, 0.0, 0.0, 6815.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0

Screenshot:

Spoiler:

4612077/uhyekuq

Maybe extra information:
Operating system: Windows 7 Home Premium 64bit (x64)
SQL Server 10.0.2531 Service pack 4.
Registery is already set to value '2'
Rebooted my pc already plenty of times.
Reinstalled MSSQL/MSSI plenty of times.
Installed it in mixed mode.
I`m sure it`s the right password.
I`m running MSSQL as Admin.
If you need any other information just post it below :thumbup1:

~Aspire

ps: Sorry, this is not ment as bump.. :C

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?