Post reply

Upsizing a ms Access database to MS SQL

  • February 14, 2006 at 12:27 pm

    #68077

    Hello People!.

     

    I have a MS SQL server on an internet web hosting package. I am having trouble upsizing the classic MS Access demo file JobApplication to the SQL Server online? this is becasue it wont let me basically connect to the SQL database!?...

    These are the error messages I get?...Is the Server name the host name?

    Any ideas please?..

     

  • February 14, 2006 at 1:35 pm

    #620815

    Welcome.

    I'm having trouble seeing your pictures.

    If the sql server is the default instance, the servername is likely to be your hostname.

    What connectionstring are you using?

    Is this using the Access upsizing wizard?

  • February 14, 2006 at 3:10 pm

    #620855

    Hi,

    Not sure if you can see my pictures?..yes this is the upsizing wizzard

    I have set up a database on my mssql server using the webspace internet service provider called oneandoneinternet.co.uk. I used one of their tools to create this database just to test if the MS SQL server was working.

    database name = db152591563

    username = dbo152591563

    host name = mssql10.oneandone.co.uk

    description = james

    on that page with the above data it says: log in to the admin tool using ur user name = u39697174 and password given

    So which bits of the above information do i enter into the upsizing wizzard boxes for connection?

    server: = ?

    login id = ?

    password = ? (which 1?password given or the database password?)

    please can you help me log on and connect to the MS SQL Server!...using the upsizing wizzard!

    Thanks James

     

  • February 14, 2006 at 3:10 pm

    #620854

    Hi,

    Not sure if you can see my pictures?..yes this is the upsizing wizzard

    I have set up a database on my mssql server using the webspace internet service provider called oneandoneinternet.co.uk. I used one of their tools to create this database just to test if the MS SQL server was working.

    database name = db152591563

    username = dbo152591563

    host name = mssql10.oneandone.co.uk

    description = james

    on that page with the above data it says: log in to the admin tool using ur user name = u39697174 and password given

    So which bits of the above information do i enter into the upsizing wizzard boxes for connection?

    server: = ?

    login id = ?

    password = ? (which 1?password given or the database password?)

    please can you help me log on and connect to the MS SQL Server!...using the upsizing wizzard!

    Thanks James

     

  • February 15, 2006 at 10:33 am

    #621114

    server: =mssql10.oneandone.co.uk

    login id = dbo152591563

    password= dbo152591563's password

    Can you verify through the admintool that the user dbo152591563 can login?

  • February 15, 2006 at 11:26 am

    #621143

    James, have you verified with the hosting provider that they allow you to connect via port 1433 from the Internet. They may not allow those connections.

    Their support people may be the best people to ask for assistance with this.

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

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

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