problem in connect tosql of internet

Question

problem in connect tosql of internet

kiasystemsoft

SSC Veteran

Points: 279
More actions
May 6, 2017 at 10:49 am

#402035

hi
i have coneccted to sql server with ip valid of sqlserver management
password sa is 123456
type id server name : example:94.183,157.251,1433
username:sa
password:123456
but it has error:
login field login for 'sa' (microsoft sql server , error:18456)
password is corrent
but it has error
please help me
tankyou

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

kiasystemsoft - Saturday, May 6, 2017 10:49 AM
hi
i have coneccted to sql server with ip valid of sqlserver management
password sa is 123456
type id server name : example:94.183,157.251,1433
username:sa
password:123456
but it has error:
login field login for 'sa' (microsoft sql server , error:18456)
password is corrent
but it has error
please help me
tankyou

Quick question, is this a default instance or a named instance?
😎

kiasystemsoft SSC Veteran Points: 279 More actions · Answer 2

it is a default instance

also i have other instance and this have problem

excuse me i can not speek english weel

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

kiasystemsoft - Saturday, May 6, 2017 12:09 PM
it is a default instance
also i have other instance and this have problem
excuse me i can not speek english weel

Have you checked the SQL Server Configuration manager if TCP is enabled and which port, both for the SQL Server Services and also the Browser service? Obviously those ports have to be open on both the source and the target system.
😎

ChrisM@home SSC-Insane Points: 24260 More actions · Answer 4

kiasystemsoft - Saturday, May 6, 2017 10:49 AM
hi
i have coneccted to sql server with ip valid of sqlserver management
password sa is 123456
type id server name : example:94.183,157.251,1433
username:sa
password:123456
but it has error:
login field login for 'sa' (microsoft sql server , error:18456)
password is corrent
but it has error
please help me
tankyou

183,157
Should be 183.157

[font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

For better assistance in answering your questions, please read this[/url].

Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

ChrisM@home - Saturday, May 6, 2017 12:53 PM
kiasystemsoft - Saturday, May 6, 2017 10:49 AM
hi
i have coneccted to sql server with ip valid of sqlserver management
password sa is 123456
type id server name : example:94.183,157.251,1433
username:sa
password:123456
but it has error:
login field login for 'sa' (microsoft sql server , error:18456)
password is corrent
but it has error
please help me
tankyou
183,157
Should be 183.157

He he, a "punctuation" problem 😉
😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Eirikur Eiriksson - Saturday, May 6, 2017 1:06 PM
ChrisM@home - Saturday, May 6, 2017 12:53 PM
kiasystemsoft - Saturday, May 6, 2017 10:49 AM
hi
i have coneccted to sql server with ip valid of sqlserver management
password sa is 123456
type id server name : example:94.183,157.251,1433
username:sa
password:123456
but it has error:
login field login for 'sa' (microsoft sql server , error:18456)
password is corrent
but it has error
please help me
tankyou
183,157
Should be 183.157
He he, a "punctuation" problem 😉
😎

Very good catch, Chris.

If you have the IP address and port number correct, are you sure the password is correct? You'll probably want to check with the DBA that takes care of the system. After that, you'll also want to tell them to change the password.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Lowell SSC Guru Points: 323507 More actions · Answer 7

he said he is getting this error:

login field login for 'sa' (microsoft sql server , error:18456)

that means he's successfully connected to an instance.
so that leaves a few other possibilities right? maybe the server is not the one he thinks it is, which someone implied with instance names, but .
I'd go straight to the SQL logs and find the failed login for the exact reason why; it might be password expired, user disabled, only windows authentication is enabled, and he needs to toggle mixed mode;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

kiasystemsoft SSC Veteran Points: 279 More actions · Answer 8

tank you for reply

i can connected to sql with sa current of lan network

problem in for connect of internet

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 9

kiasystemsoft - Tuesday, May 9, 2017 10:25 PM
tank you for reply
i can connected to sql with sa current of lan network
problem in for connect of internet

Is there a firewall or NAT between the Internet and the Lan?
😎

david.fowler 42596 Old Hand Points: 342 More actions · Answer 10

Is there anything showing up in the SQL logs? If you're making the connection to the server correctly but the login is failing there will be an entry in the log for it.

https://sqlundercover.wordpress.com/