SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Severity: 14, State: 8 error... Need help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/09/2007 :  03:20:10  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
Hello guys,

Error: 18456, Severity: 14, State: 8.
Login failed for user 'sa'. [CLIENT: <ip address>]

With what Ive searched.. State: 8 is wrong password. What Ive
encountered I believed is not State: 8 I guess... I have 2 pc..
PCX and PCY.. PCY has SQL Server 2005 so does PCX.. when I run my application that stores data to PCY DB it prompts me an error just
like the one above.. but what seems to be confusing me is both of them have the same DB password. Did I miss something... please help..


-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/09/2007 :  04:41:02  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Never use SA account for login with aopplications!


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/09/2007 :  04:49:04  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
What could be the appropriate thing to do when using SA? Is it too powerful for an application?

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/09/2007 :  04:58:21  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Yes. The use have access to everything!
Including dropping tables and the entire database.
Most often, create an account for end-users with datareader and datawriter rights, and execute permission to the stored procedures needed.

Read about SQL injection. This is a security risk!

Regarding your original question, both sql servers can have same password for SA account, so the error is not that.
Which application is throwing the error?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  00:43:50  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
actually PCY is the server where the DB resides. PCX is where the application that is configured to connect to the DB in PCY. when accessing PCY DB thru PCX SQL Mgt Studio, its fine. But, when the application is the one that is trying to connect, it fails..

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  00:52:26  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Change the password for the SA account in application on PCX.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  00:55:06  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
hard to explain but application in PCX automatically
run, doesn't have a login or something.. connection is configured
thru the server PCY. all connections and codes are in there...
the application in PCX, all it can do is... open the DB..
store the data.. and thats it..

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If

Edited by - iceblizzard on 01/10/2007 00:59:41
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  01:21:15  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Of course it has a login!
Where do you think the error come from? Magic? Some divine intervention?

Or do you think application on PCX randomly connects to a server of it's own choice?



Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  01:25:27  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
as ive said... it is configured in PCY.
simply means the application is PCX is a client,
once you open it.. it concurrently run..

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  01:32:34  Show Profile  Visit SwePeso's Homepage  Reply with Quote
www.connectionstrings.com


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  01:45:21  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
OK... the login password is change... but still
Ive got the same prob...

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  01:45:44  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Or you will have to change the SA password on the machine PCY to match the password what the application on PCX wants it to be.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  01:47:31  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
Ive already change the password... both PCX and PCY sa account have the same password... but still coudn't got out of this mess...

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  01:50:01  Show Profile  Visit SwePeso's Homepage  Reply with Quote
It seems (as I have told you numerous times) that the password for SA account used in the application installed on PCX is hard-coded with some other password (most obvious a blank password since you have no idea what is going on).

If that is the case, the password for the account on PCX must be changed to same password as the application uses!
What is so hard to understand about that?

Also, how does the application installed on PCX know which server to connect to? Is that hard-coded too?
Or is there a setting in the registry for this? It that is the case, I think there is a setting for the password to (I cross my fingers that the password is encrypted).


Peter Larsson
Helsingborg, Sweden

Edited by - SwePeso on 01/10/2007 01:52:32
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  01:56:09  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
Yeah your right.... it is in the registry... its encrypted...
I do as what you said.. I changed the sa password for the application in PCX... so now the sa password of the application in PCX is the same as the sa password in PCY..

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 01/10/2007 :  02:21:24  Show Profile  Visit Merkin's Homepage  Reply with Quote
Real programmer dont use VB either



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30213 Posts

Posted - 01/10/2007 :  03:27:10  Show Profile  Visit SwePeso's Homepage  Reply with Quote
And now the passwords for SA account on both PCX and PCY is what the application wants it to be?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  04:49:30  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
quote:
Originally posted by Merkin

Real programmer dont use VB either



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson



Its a matter of choice....non-sense...!
I only use that for my signature...

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

iceblizzard
Starting Member

Philippines
17 Posts

Posted - 01/10/2007 :  04:51:44  Show Profile  Send iceblizzard an AOL message  Send iceblizzard an ICQ Message  Send iceblizzard a Yahoo! Message  Reply with Quote
quote:
Originally posted by Peso

And now the passwords for SA account on both PCX and PCY is what the application wants it to be?


Peter Larsson
Helsingborg, Sweden



geez.... I hope so.. I will try it, after my other task.. Thanks..!

-------------------
Real Programmer dont document

If its hard to write Then
its easy to undertand.
End If
Go to Top of Page

cas_o
Posting Yak Master

United Kingdom
154 Posts

Posted - 07/12/2007 :  09:48:53  Show Profile  Visit cas_o's Homepage  Reply with Quote
I seem to recall if Sql Server is in mixed mode, The windows user running the app on PCX must exist and have rights on PCY also, to be able to connect and use Sql Server. This authorisation takes place *before* sql server authentication. But you get the login failed message, instead of an Access Denied message which would be more intuitive.

;-]... Quack Waddle
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000