SQL Server Installation problems

[Trudye]

I have installed SQL Server (on my laptop, OS = Win 2k). I have added 2 new databases. I can view/alter the tables of the new db's via EM or Query Analyzer. However I cannot get my Access tables linked to SQL Server.

My initial thought is maybe I installed the wrong option. Maybe I should have installed 'Client Tools Only' since I am installing on a laptop that is not connected to a server.

If that's true than please let me know and disregard the rest of this gibberish.

I created an ODBC connection, which I am not quite satisfied with. Maybe I should take this one problem at a time. I guess I should have noted that I am a novice (like you couldn't have guessed that my now).

While creating the ODBC connection I had to use the default 'with WIN NT'. The 'SQL Server authentication option' would not recognize my login/password. I uninstalled and reinstalled SQL Server providing a specific login (or so I thought). But SQL Server seemed to override that with my Windows 2k 'customer name' information (i.e. Mary C. Jones). This was not the login/password information I used at boot-up before I loaded SQL Server. Now when I bootup the login screen has my Windows 2k 'customer name' information. Where oh where did I go wrong?

1. Should I be using the 'SQL Server authentication option'?
2. How can I control what my login is?
3. Where can I get some specific information on how to setup my ODBC for SQL?

WHEW!

Thank you for your patience I know it was a long and arduous question,
Trudye

 

[Trudye]

I think I may have stumbled on to something. I started out by doing an uninstall using SQL Server rather than Add/Remove Software.

I reloaded SQL Server, Defined my .mdb database in ODBC. imported the data using EM, and then linked the tables via Access. To my surprise the tables showed up during the Access table link process. Hooray!

Although I had problems importing some of the tables using EM because of data conversion (mainly due to datetime fields) I have gotten a lot further. I have also discovered how to import one table at a time (using EM). After I fix the tables with the datetime problems.

Thanks to everyone who took the time to read this madness. I'm sure I'll have some more novice questions, maybe before the day is over.

Trudye