Jason,

You don't need to have SQL Server installed on your machine, but you do need to be able to connect to the server you're upsizing to. You'll need to enter a SQL Server user name and password to log in to the server. You may need to get this from your system administrator. You'll need to be sure that the login you use has the right to create databases.

If you're connecting to your remote server via a WAN (or even worse, via dial-up) it might take a long, long time to upsize. Unless your database is quite small you might want to have someone at the site where the server resides do the upsizing.

>Hi everyone>
>
>I am in the process of taking our existing FoxPro 6.0 database and "upsizing" it to SQL Server. So far, I haven't been able to get past the second screen of the upsizing wizard.
>
>The first step is to select your FoxPro database, which I did
>
>The next step is to select an ODBC data source, which I did.
>
>After I click next, A SQL server login form pops up and prompts me for a user name and password. I haven't been able to get past this.
>
>I was wondering if anyone reading this has had any experience upsizing FoxPro to SQL Server, using the wizard, and could point me in the right direction.
>
>Note: I have on my local computer the SQL Server Utilities, but not an actual SQL Server database. That may be a huge problem. The actual SQL Server DBase I am trying to upsize to is on a remote server, hundreds of miles away!
>
>
>I am just not clear on the exact steps I need to take to upsize. I apologize for this being so vague. I just don't know what specifics I can give. I am getting stuck on the second page of the wizard, where it prompts me for a user ID and a Password.
>
>When I click "help", it says this SQL server login form only pops up when the user (me!) calls the ODBC driver w/o specifying enough information for the driver to connect to the SQL Server.
>
>I don't know what it is talking about!
>
>Any thoughts would be very helpful
>
>
>Thank you in advance
>
>Jason