how to connect remote sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I am trying to connect remote sql server2012 from asp.net

getting error

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

my connection string is

HTML

<add name="libacpConnectionString" connectionstring="Data Source=103.21.58.192;Initial Catalog=libacp;Persist Security Info=True;User ID=my id ;Password=my passowrd">
      providerName="System.Data.SqlClient" />

code is working ok on local server

pls help me out

[edit]Code block added - OriginalGriff[/edit]

Posted 20-Feb-15 21:46pm

Member 8893861

Updated 20-Feb-15 21:53pm

OriginalGriff

v3

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2015-02-20T21:57:00

Solution 1

The error message is pretty explicit: "Login failed for user"

That means one of three things:
1) You have the wrong IP address and the SQL instance doesn't know who you are.
2) You have the wrong User ID and the SQL instance doesn't know who you are.
3) You have the wrong Password and the SQL instance has rejected the log in request.

We can't fix any of those: you need to check your details and make sure that you are using the right information.

Posted 20-Feb-15 21:57pm

OriginalGriff

Comments

Member 8893861 21-Feb-15 4:16am

Ok
But when i tried giving direct data source(servername, sql server authentication ) to grid view , and tested it my grid get populated

when i tried to catch the exception it show long error

may be i am doing a mistake in server name

actually my site is hosted on one server having sql (ip 1)
and i m connecting other hosting server with different slq (ip 2)

i have purchased space in both the places

OriginalGriff 21-Feb-15 4:24am

"i have purchased space in both the places"
Doesn't mean that the same login details will work!

Member 8893861 21-Feb-15 5:35am

yes definitely i am using different login details for both

My question is , can i login in from my asp project from one hosting to sql server
with different hosting (with its login details )

OriginalGriff 21-Feb-15 6:03am

Yes - all you need is two different connections strings.

Member 8893861 21-Feb-15 6:21am

Ok , could you help me find a solutions ?

OriginalGriff 21-Feb-15 6:50am

How? I don't have access to your code! :laugh:

Member 8893861 21-Feb-15 8:43am

should i post my connection code?

Member 8893861 21-Feb-15 9:24am

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'libacp_pune020'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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, TimeoutTimer timeout, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 businesslogic.clsfun.retdataset(String query) in F:\C # ALL\current web projects\Lib_Web\businesslogic\clsfun.cs:line 38 at Lib_Web.WebForm12.Button1_Click(Object sender, EventArgs e) in d:\plesk\vhosts\libacp.com\httpdocs\WebForm12.aspx.cs:line 29