Re: SQL Server on XP Home Network

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 07:04:19 -0600

Yes. The sa account is the system administrator "God" account witihin SQL
Server. This account is a SQL-Server login.

You might be able to use Enterprise Manager to go in and create a new SQL
login. Open the Logins node of the security folder. Right-click on the
Logins node. Choose New Login. Select the "SQL Server Authentication"
option button. Type in whatever name you want and specify a password.
Click ok and then verify the password.

Double-click on the newly created (SQL) login. Hit the Database Access tab.
Select the database(s) that you want to have access to. I don't know how
your system is setup or what permissions are needed. If you use stored
procedures you will need to GRANT EXECUTE ON StoredProcedureName TO
TheUserName. If you use embedded sql within your apps the user will need
select (and probably update) rights on the tables. The easy way to do this
is to give the login the db_datareader and db_datawriter database role.

The Security>Logins area is server wide.
The logins under each database node show you the same thing, only at the
database specific level.

Is Debbie your network login? Within the logins node of the security tab is
the login Debbie a Windows User or a Standard type? If Debbie is a Windows
User type you could try connecting via NT Authentication instead of SQL
Server Authentication. 

-- 
Keith
"CycleFitness" <CycleFitness@discussions.microsoft.com> wrote in message
news:47628EFA-0A3F-45CC-B470-0B274FC5E5C8@microsoft.com...
> There is an "sa" account under the Security>Logins area.  The "type" is
> standard.  Does that coorelate to a SQL Server login?  I didn't set up the
> machine so don't know the password of that account.
>
> What is the difference between users set up under the Security>Logins area
> and those set up under the Databases area?  I tried adding myself to each
> database, but got the error saying "Debbie" was already set up and that's
> because it's under Security>Logins and is set to use the "master" as the
> default.  I tried setting up the connection to use that SQL Server
> authentication, but get the same error message.
>
> No matter what combination I try, I can't get it to work.  Thanks for your
> help.
>
> "Keith Kratochvil" wrote:
>
> > It sounds like you might be trying to connect using NT Authentication
and
> > the Administrator account (unless you created a SQL login within SQL
Server
> > called 'Administrator').  Did you set a password on your sa account?  I
> > usually don't encourage using that account when connecting via an
> > application but I think that this might be the easy thing to suggest in
your
> > case since you don't know much about SQL Server.
> >
> > Use SQL Server authentication.
> > Use the sa account and whatever password you have given the account.
> > Try logging in again.
> >
> > -- 
> > Keith
> >
> >
> > "CycleFitness" <CycleFitness@discussions.microsoft.com> wrote in message
> > news:802C9308-51CE-434D-8414-E8388A1C0631@microsoft.com...
> > > I am documenting an Access DBMS running on SQL Server.   I am
attempting
> > to
> > > recreate the client's environment at my remote location and I am NOT
SQL
> > > Server savvy.  I cannot seem to get the ODBC connection from my PC to
the
> > SQL
> > > Server PC to work. Here's what I have:
> > >
> > > 1.  Separate SQL Server box set up as CREATIVE21 with an Administrator
> > > account.  It is connected to MSHOME network and can be seen from my
PC.
> > It
> > > has two databases to which I want to connect; DATABASE1 and DATABASE2.
> > > 2.  My PC is connected to MSHOME network.  I do not have password set
up
> > on
> > > my general user account from which I work.  From this PC I am
attempting
> > to
> > > set up System DSN SQL Server ODBC connection to CREATIVE1 server,
> > DATABASE1.
> > >
> > > When trying to set up the connection I get to the step where it's
asking
> > > "How should SQL Server verify the authenticity of the login ID?"
> > >
> > > I select "With SQL Server Authentication using a login ID and password
> > > entered by the user."
> > > I then checked the "Connect to SQL Server to obtain default settings
for
> > the
> > > additional configuration options" checkbox and provided the Login ID
and
> > > password of the Administrator.
> > >
> > > I then get this error ...
> > >
> > > Attempting connection
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> > > 'CREATIVE21\Administrator'. Reason: Not associated with a trusted SQL
> > Server
> > > connection.
> > >
> > > What do I have to do to make this work?
> > >
> > > Thanks in advance for any help.
> >
> >