Re: Connection problems
- From: "Norman Yuan" <NotReal@xxxxxxxxxxx>
- Date: Tue, 30 May 2006 11:48:54 -0700
When a computer/application trys to connect to SQL Server/MSDE on the same
or other computer, it is to connect to SQL Server/MSDE, not to data file. no
application can access SQL Server/MSDE database file (*.mdf/*ldf) except for
SQL Server/MSDE itself, regardless whether the user/computer has right to
the folder or not.
You clearly have SQL Server security setup issue. Error like "Login failed
for user 'sa'. Reason: Not associated with a trusted SQL Server connection"
is typically because of disabled SQL security miexd login mode. By default
installation, Only Windows security is enabled. If you have to use
userName/Password pair to access SQL Server/MSDE, you need to enable mixed
login mode and create appropriate SQL Server login.
BTW, use "sa" user is really bad, bad practice.
"Art Billings" <abillings@xxxxxxxxxxxxxxxxxx> wrote in message
news:eFLed5AhGHA.5068@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I have searched through the archive and can't seem to find an answer, so
forgive this post if it has been answered previously. I have an
application that uses MSDE for it's database. I have three workstations
that connection to this instance of the MSDE database, which is installed
on a W2K3 SBS server. Each workstation has a mapped drive to the folder
where the data resides. Two of the three workstations connect to the
database without any problems whatsoever.
The one workstation that will not connect connects to other MSDE databases
located on other machines on the network without a problem. The user that
logs onto this workstation has all the modify rights to the folder, and
change rights to the share, where the data resides, and can traverse the
folders without any problems, via windows explorer. When I run the
application (Xactimate for those who may be familiar) I get an error that
it cannot connect to the server. I have tried using the osql command with
the -S -U -P switches and I get the following error message:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.
I have worked for 8 hours with Xactware tech support, and they contend
that there is something on the server that is blocking this one
workstations connection to the data. I have checked to insure the Named
Pipes and TCP/IP are the available connection protocols.
I am truly stumped and in desperate need of help. The workstation is a
Windows XP pro SP2 machine which has no firewall turned on. Antivirus
software is Trend Micro's Client-Server Security Agent. I have disabled
the TM security agent, still no luck.
Can anyone point me in the right direction. My next step if no one here
can help me is to reach out to MS PSS and I really only want to do that as
a last resort.
TIA,
Art Billings
.
- Follow-Ups:
- Re: Connection problems
- From: Art Billings
- Re: Connection problems
- References:
- Connection problems
- From: Art Billings
- Connection problems
- Prev by Date: Connection problems
- Next by Date: Re: Error when Installing SQL Server Express 2005
- Previous by thread: Connection problems
- Next by thread: Re: Connection problems
- Index(es):
Relevant Pages
|
Loading
