G
Guest
I'm trying for the first time to upgrade a .mdb database created with Access
2003 to use with the SQL server. I have Visual Studio 2005 installed, which
includes Microsoft SQL Server 2005 (Express Version). I've gone to the SQL
Server Configuration Manager and entered the same name and password as I have
for the computer administrator (which is me), and ensured that the SQL Server
is running. I then go into Access 2003 and run the Upsizing Wizard. I check
'Create new database', and the next window asks "What SQL Server...?", and
defaults to "(local)", which I leave as is. I type in the same Login ID and
Password as with the Configuration Manager, and click Next. After a short
while, a error window shows up "Microsoft SQL Server Login", with "Connection
failed: SQLSTATE: 01000, SQL Server Error: 2", and also "Connection failed
failed: SQLState 08001 SQL Server Error 17". As I have never done this
before, I suspect there is something simple I'm missing. Suggestions?
2003 to use with the SQL server. I have Visual Studio 2005 installed, which
includes Microsoft SQL Server 2005 (Express Version). I've gone to the SQL
Server Configuration Manager and entered the same name and password as I have
for the computer administrator (which is me), and ensured that the SQL Server
is running. I then go into Access 2003 and run the Upsizing Wizard. I check
'Create new database', and the next window asks "What SQL Server...?", and
defaults to "(local)", which I leave as is. I type in the same Login ID and
Password as with the Configuration Manager, and click Next. After a short
while, a error window shows up "Microsoft SQL Server Login", with "Connection
failed: SQLSTATE: 01000, SQL Server Error: 2", and also "Connection failed
failed: SQLState 08001 SQL Server Error 17". As I have never done this
before, I suspect there is something simple I'm missing. Suggestions?