If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem accessing SQL Server in upsizing wizard
After I enter the server (local) and the new database
name (upsizeSQL) in the upsizing wizard's 2nd dialog, I get the following message after clicking on "next": [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. When I click on OK, I get another message: The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source. The wizard never gets to the 3rd dialog. I am running a local instance of SQL Server (MSDE) version 8.00.760. Does anyone know why I am getting these messages and the wizard refuses to get to the next dialog? Thank you, Edward. |
#2
|
|||
|
|||
Problem accessing SQL Server in upsizing wizard
Hi Edward,
SYMPTOMS When you use the Upsizing Wizard to migrate the database objects from a Microsoft Access database (.mdb) to an existing Microsoft SQL Server database, and you use the System Data Source Name (System DSN) or the User Data Source Name (User DSN) to connect to the instance of SQL Server, you may receive the following error message: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Additionally, when you click OK on the error message, you receive the following error message: The Upsizing Wizard only works with Microsoft SQL Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data source. This problem occurs when your Access database and the instance of SQL Server do not exist on the same computer. WORKAROUND To work around this problem, use a File DSN to connect to your instance of SQL Server when you upsize your Access database. To do this, follow these steps: Start Access. Open the problem database. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard. In the Upsizing Wizard dialog box, click Use existing database, and then click Next. In the Select Data Source dialog box, select the appropriate DSN to connect to your instance of SQL Server on the File Data Source tab. Click OK. Enter the appropriate authentication information to connect to your instance of SQL Server if the SQL Server Login dialog box appears. Follow the instructions in the Upsizing Wizard. Notice that the Access database is successfully upsized without any errors. MORE INFORMATION Steps to reproduce the problem Start Access. Open the Northwind.mdb sample database. On the Tools menu, point to Database Utilities, and then click Upsizing Wizard. In the Upsizing Wizard dialog box, click Use existing database, and then click Next. In the Select Data Source dialog box, select the appropriate DSN to connect to your instance of SQL Server on the Machine Data Source tab. Click OK. Enter the appropriate authentication information to connect to your instance of SQL Server if the SQL Server Login dialog box appears. Notice that you receive the error messages that are mentioned in the "Symptoms" section, and you cannot continue the upsizing process. REFERENCES For more information about the Upsizing Wizard in Access 2003, click Microsoft Office Access Help on the Help menu, type About upsizing a Microsoft Access database in the Search for box in the Assistance pane, and then click Start searching to view the topic. For more information about the Upsizing Wizard in Access 2002, click Microsoft Access Help on the Help menu, type About upsizing a Microsoft Access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic. For additional information about how to use the Upsizing Wizard in Access 2002, click the following article number to view the article in the Microsoft Knowledge Base: 330468 HOW TO: Use the Microsoft Access 2002 Upsizing Wizard For additional information about issues with the Upsizing Wizard in Access 2002, click the following article number to view the article in the Microsoft Knowledge Base: 328319 ACC2002: Issues with the Access 2002 Upsizing Wizard Please let me know has this helped You... Thank you... Raghu... This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting records into MDB and SQL Server. | Drew | General Discussion | 1 | June 22nd, 2004 06:56 PM |
Access 2003 Data Access Page - SQL Server - NT Login | GregCrossan | General Discussion | 0 | June 17th, 2004 10:38 PM |
SQL Server Logins | base | Using Forms | 1 | June 14th, 2004 11:06 AM |
Problem with Outlook 2003 On Terminal Server | Seth Garfinkel | Setup, Installing & Configuration | 0 | June 8th, 2004 02:51 PM |
Excel printing problem (terminal server) | john | Setting up and Configuration | 0 | November 13th, 2003 10:16 PM |