sql server database not connecting through sql server authentication

Question

0.00/5 (No votes)

See more:

I have created an application an published it on IIS. but when I am running that application it is not being connected with the database.
I am using sql server authentication mode to connect through database. It is not showing error also. Can you please guide me how connect database through sql server authentication mode.
And that application is running successfully when i am running through local host but not after publishing it on server

Posted 24-Feb-12 0:43am

Qureshali

Updated 24-Feb-12 0:45am

v2

Add a Solution

Comments

ZurdoDev 24-Feb-12 7:54am

If you are using SQL Server authentication mode you need to look at your connection string.

Qureshali 24-Feb-12 8:21am

it is working correctly on local host then why not after publishing.
This is my connection string
Data Source=FTPserver;Initial Catalog=MockTestDatabase;User ID= TCOER;Password=TCOER

ZurdoDev 24-Feb-12 8:45am

What is the error?

2 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)

Ganesan Senthilvel · Answer 1 · 2012-02-24T15:14:00

Solution 1

Write try.. catch block around DBConnection method. It will help to get the exact error.

C#

try
{
  // dbconnection method
  // SqlConnection connection = new SqlConnection(connectionString);

}
catch (Exception ex)
{
  //
}

Posted 24-Feb-12 15:14pm

Ganesan Senthilvel

Updated 24-Feb-12 15:16pm

v2

Sarvesh Kumar Gupta · Answer 2 · 2012-02-24T15:35:00

Hi, check below point

1. First check Sql Server,open SQLServer and login on this using SQL Authentication, giving userid and pwd.

2. If First is correct then check your connection string in application, there are all parameters in connection string i.e. Server, Database, userid, password etc.

3. If first is incorrect then first login with windows authentication and change settings in sql, change to SQL Server Authentication and assign userid and password and save this setting.

4. now again login with using that uid and pwd.

Hopefully, it will solve your problem. :-)