We have an SBS 2000 Server Box running SQL 2000.
I have installed onto my machine the "toolkit" so that I
can Administer the SQL 2000 Database, create Import/Export
functionalities etc... This is good.
However...I log onto my machine as a User of a Domain. In
SQL Server Enterprise Manager, when I expand Console
Root>Microsoft SQL Servers>SQL Server Group, then run the
Wizzard (the magic wand in the menu bar), I do not know
how to log into the SQL Server on the SBS Box!
If I log off my terminal and log on as Administrator, then
I can run the wizzard and use the NT Authorisation to
access SQL 2000 on the SBS. How do I do it logged on as a
I have noticed that there is a "sa" user. How can I
enable myself, as a Domain User and a Client to the SBS
Box, connect to SQL on the SBS Box?