Connect to sql server with TCP/IP & Port

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

hello
my friends !

my connection strin is :

C#

                string strConnection;
                strConnection = "Data Source=192.168.2.107,8484;Network 
Library=DBMSSOCN;Initial Catalog=test;UID=sa;pwd=";
                SqlConnection connDB = new SqlConnection(strConnection);
                connDB.Open();

1-tcp/ip is enable
2-ping is ok
3-port in firewall is added

please, help me!

but , error :

System.Data.SqlClient.SqlException: Login failed 
for user 'sa'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
exception, Boolean breakConnection)
   at 
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
 stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
 bulkCopyHandler, TdsParserStateObject stateObj)
   at 
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean 
enlistOK)
   at 
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
 serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 
timerExpire, SqlConnection owningObject)
   at 
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String 
host, String newPassword, Boolean redirectedUserInstance, SqlConnection 
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at 
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
 owningObject, SqlConnectionString connectionOptions, String 
newPassword, Boolean redirectedUserInstance)
   at 
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
 identity, SqlConnectionString connectionOptions, Object providerInfo, 
String newPassword, SqlConnection owningObject, Boolean 
redirectedUserInstance)
   at 
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
 options, Object poolGroupProviderInfo, DbConnectionPool pool, 
DbConnection owningConnection)
   at 
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
 owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at 
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection 
owningObject)
   at 
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
 owningObject)
   at 
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection 
owningObject)
   at 
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection 
owningConnection)
   at 
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection 
outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at WindowsFormsApplication1.Form1.Form1_Load(Object sender, EventArgs
 e) in D:\Hesam\ConnectTCP_WIN\ConnectTCP_WIN\Form1.cs:line 
35

Posted 17-Aug-11 4:18am

Member 4015829

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Simon_Whale · Answer 1 · 2011-08-17T04:21:00

Solution 1

System.Data.SqlClient.SqlException: Login failed 
for user 'sa'.

As you can see from what I have higlighted the error is your username and password make sure what you have supplied is valid on the server.

Also Connectionstrings.com[^] is a great resource for these sort of moments of troubleshooting

Posted 17-Aug-11 4:21am

Simon_Whale

Updated 17-Aug-11 4:23am

v2

jdandes · Answer 2 · 2011-08-17T05:53:00

I dnt know if this one will help, but this code is the code i use everytime i connect to my SQL Server 2005 Database :

VB

Public Sub ConnectDatabase(db As String)
    'Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security 
    'Info=False;Initial Catalog=Counts2;Data Source=D-OF-MSSQM-0302
    'Disconnect
    Set conn = New ADODB.Connection
    With conn
        .CursorLocation = adUseServer
        .ConnectionTimeout = 25
        .CommandTimeout = 0
        .Provider = "SQLNCLI.1"
        .Properties("Data Source").Value = "D-OF-MSSQM-0302" '--server name
        .Properties("Integrated Security").Value = "SSPI"
        .Open
        .DefaultDatabase = db
    End With
End Sub

Simon Bang Terkildsen · Answer 3 · 2011-08-17T05:58:00

Solution 3

Try to create another user and use those credientials in the connection string.
I know this doesn't directly solve your problem, but seems like a logical next step in debugging your problem.

Posted 17-Aug-11 5:58am

Simon Bang Terkildsen

Updated 17-Aug-11 5:59am

v2

Wendelius · Answer 4 · 2011-08-17T07:16:00

Solution 4

As the error says, the password for user sa is wrong. Another thing to check is that you have mixed mode authentication on. If only windows authentication is on, you have to use trusted security.

Posted 17-Aug-11 7:16am

Wendelius