September 14, 2004 at 6:17 pm
Hi,
I am new to SQL Server and I got a brand new SQL Server 2000 landing in my lap all set up at scratch. I am sufficient in MS Access and I am trying to upsize my databases to my sql server. I am going through the Access upsize wizard and do not see any problems but when I go into the server (enterprise manager) my new database is not there. All I can think of is that my original Access database is correctly mapped in the report but my output SQL Server database is only listed by name. I should add that all my tables have Errors meaning that none are imported and I assume that the connection is wrong? I would appreciate if anybody can go through scenarios that I could have done wrong.
THANKS!
September 16, 2004 at 10:09 am
It sounds like you might not have put in the correct user name and password to link to SQL server, or, if SQL Server is set up to use 'windows authentication' only, you have not set up your 'windows logon ID' as a Logon in SQLServer.
What is the error message you get for each table?
Peter
September 16, 2004 at 10:49 am
I got it to work Thanks Peter!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply