Re: SQL Server on XP Home Network
From: CycleFitness (CycleFitness_at_discussions.microsoft.com)
Date: 01/25/05
- Next message: hal_at_nospam.com: "Easiest method for moving databases from one partition to another"
- Previous message: Mike Epprecht (SQL MVP): "Re: RAID1 VS RAID5"
- In reply to: Keith Kratochvil: "Re: SQL Server on XP Home Network"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 Jan 2005 05:43:12 -0800
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.
>
>
- Next message: hal_at_nospam.com: "Easiest method for moving databases from one partition to another"
- Previous message: Mike Epprecht (SQL MVP): "Re: RAID1 VS RAID5"
- In reply to: Keith Kratochvil: "Re: SQL Server on XP Home Network"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
