Post reply

Get Data out of SQLS erver 05 to Excel

  • December 2, 2009 at 4:14 am

    #206884

    Hi folks,

    I am trying now for hours, but with no satisfying result.

    I have a MS SQL 05 DB running on a remote server with the IP Address A.B.C.D and i have also set up a test database with a table.

    Now I want Excel to connect to this tatabase, but it always gives me following errormsg: [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or Access Denied

    So I don't even know if I can connect to the DB or if just the Login Information is wrong... Does maybe some1 has experience with connecting to a remote SQL Server?

    I use A.B.C.D\SQLEXPRESS for the Server Name and the SQL Login I added to the Database.

    Cheers,

    prozero

  • December 2, 2009 at 5:25 am

    #1086382

    pro_zero (12/2/2009)

    Now I want Excel to connect to this tatabase, but it always gives me following errormsg: [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or Access Denied

    How are connecting from Excel to SQL Server? Explain the steps.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 2, 2009 at 6:20 am

    #1086429

    I want to import data from a SQL server (DATA -> From other Sources -> From SQL Server).

    Then I enter the servername myip\SQLEXPRESS

    Then I switch to "Use the following Name and Password"

    Then I enter my user information and I click on next - and then the error comes up as in my first post.

  • December 2, 2009 at 7:55 am

    #1086503

    Is your SQL Instance named as Express?

    Is SQL in mixed authentiication mode?

    Are the named pipes enabled?

    Check these out.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 2, 2009 at 8:28 am

    #1086547

    Is your SQL Instance named as Express?

    Yes, if I connect to it on the Server I use COMPUTERNAME/SQLEXPRESS

    Is SQL in mixed authentiication mode?

    Yup.

    Are the named pipes enabled?

    Dunno. Where can I look that up? Anyways, I think the Server has some Firewall Settings that prevent me from connectiong...

  • December 2, 2009 at 8:30 am

    #1086550

    pro_zero (12/2/2009)

    Are the named pipes enabled?

    Dunno. Where can I look that up? Anyways, I think the Server has some Firewall Settings that prevent me from connectiong...

    Look in SQL Server Configuration Manager and under network configurations

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

Viewing 6 posts - 1 through 6 (of 6 total)

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