Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2012
    Posts
    17

    Unanswered: Access to SQL Server

    Hi all,

    Total newbie here. I am trying to import Access database to SQL Server. And when I click on the Import to SQL server wizard in Access --> Create New Database, I am stuck at the question "What SQL Server would you like to use for this databaes"....How do I find out the name of the SQL Server? I tried typing in the name of the computer hosting the server, in this case.."TAB1", and I also tried typing in the ip address, nothing works..help!

    Thanks
    Alan

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Please descibe "nothing works" in a bit more detail. Did your PC reboot? Did the SQL Server belch blue flames and smoke? If it was less spectacular (and I sure hope it fell short of either of those!), did you get any error messages?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2012
    Posts
    17
    ahh sorry

    Connection failed:
    SQLState: '01000'
    SQL Server Error: 1060
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
    Connection failed:
    SQLState: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

    I am using the account which I use to access the server, so I think it should not be access denied?

    For the server, I tried typing in the ip address and server name

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Does the machine running MS-Access have the ability to connect to SQL Server using the standard tools provided with SQL Server? My first guess would be that you don't have the SQL Server Client tools (especially the SQL Native Driver) installed on the machine that is running MS-Access.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Mar 2012
    Posts
    17
    I just tried exporting the access file using the server computer which contains SQL Server.

    I typed the ip into the server, and it gave me this

    Connection failed:
    SQLState: "28000"
    SQL Server Error: 18456
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ' ' .

    Does this answer what you were referring to?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you have the MS Access data file on the SQL Server, consider using one of:

    1) SSMS Import Wizard
    2) SSIS
    3) Linked Server

    Any of these choices ought to work nicely if the MS Access data file resides on the SQL Server.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ask you friendly SQL Server DBA
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •