Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Diya
Starting Member
11 Posts |
Posted - 2009-03-16 : 14:25:46
|
I created an access database using Access 2003. It is splitted into back-end containg related tables and front-end database containg queries forms etc. Now I am trying to upsize only the back-end database to sql server database through upsizing wizard of Ms Access in order to overcome the 2GB limitation of Access database. I want to retrieve data through jet database engine. But I couldnt upsize. I got following message after going through the upsizing wizard:"Connection failed:SQL State 01000SQL Server Error: 53[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).Connection failedSQLState: 08001SQL Server Error: 17[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQLServer does notExist or access denied"I installed SQL Server 2005 express edition (version 9.3.403500).My work is limited within the local machine. I dont want to use networking.What should I do?Anyone can help me anyway?With best regards,Diya |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|