DaniWeb Forum Index > Software Development > C#

Connection to remote SQL Database problem in app

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2009

Posts: 2

Reputation: Nfurman is an unknown quantity at this point

Solved Threads: 0

Nfurman

Offline

Newbie Poster

Connection to remote SQL Database problem in app

Oct 10th, 2009

Hello guys!

I am developing simple desktop application that suppose to connect to SQL DB launched on remote server.

Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'."

So, looks like i need to create some user with password and give him at least 'read rights'. How can I do it.

What I tried:

1. 'sa' name doesn't work.
2. Allow remote connection - enabled.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
SqlConnection sqlconn = new SqlConnection("Data Source=64.191.121.53,1433;Network Library=DBMSSOCN;Initial Catalog=remoteDB;User ID=guest;Password=;");
SqlConnection sqlconn = new SqlConnection("Data Source=64.191.121.53,1433;Network Library=DBMSSOCN;Initial Catalog=remoteDB;User ID=guest;Password=;");

•

Join Date: Oct 2009

Posts: 28

Reputation: sanch01r is an unknown quantity at this point

Solved Threads: 2

sanch01r

Offline

Light Poster

Oct 18th, 2009

NFurman, Looking at your connection string I am unable to determine what credentials you are using, but the credentials in the connection string should be the SQL server credentials, not the client logon credentials.

•

Join Date: Feb 2009

Posts: 3,437

Reputation: sknake has much to be proud of

Solved Threads: 624

sknake

Offline

.NET Enthusiast

Oct 19th, 2009

You also need to set "Integrated Security=False;" when using a username/password connection string. Here are example connection string builders:

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
    public static string BuildSqlNativeConnStr(string server, string database)
    {
      return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=True;", server, database);
    }
    public static string BuildSqlNativeConnStr(string server, string database, string username, string password)
    {
      return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};Password={3};", 
        server, 
        database,
        username,
        password);
    }
    public static string BuildSqlNativeConnStr(string server, string database)
    {
      return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=True;", server, database);
    }
    public static string BuildSqlNativeConnStr(string server, string database, string username, string password)
    {
      return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};Password={3};", 
        server, 
        database,
        username,
        password);
    }

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Oct 2009

Posts: 2

Reputation: Nfurman is an unknown quantity at this point

Solved Threads: 0

Nfurman

Offline

Newbie Poster

Oct 19th, 2009

Hello again. thanks for reply. Can you please advise me step by step how to create such db i need.

I made this:

1. Created db in SQL 2008 Express
2. Created an empty table (ID,Name...there will be no any use of it)
3. In Object Explore > Security > Credentials created new credential with Username Password.
4. In Object Explore > Logins created new login and password with the same logs and passes as my new credential.
5. Saved database.
6. From Microsoft SQL Server > MSSQL.1>MSSQL>DATA copied RemoteDB.mdf on the desctop and that after sent this file by FTP into remote webserver. Placed him in root.
7. In my program changed connection string as sknake has adviced.
8. tried to connect. Alas, the same problem cannot connect and throws me MessageBox (exeption) "Login failed for user 'NathanBase'."

Where have I went wrong?

Last edited by Nfurman; Oct 19th, 2009 at 5:04 pm.