Re: Client access to sql database
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 9 Dec 2005 23:29:00 -0500
What ever it is that is attempting to run the report must be making a new
connection. But without knowing what or how it is attempting to do this it
is anyone's guess. The vendor must have a clue as to how they connect and
why this is happening. After all they wrote it<g>. You can try using
profiler to see what they are sending to sql server at the time it happens.
Other than that I don't have a clue as to what the app is really doing.
--
Andrew J. Kelly SQL MVP
"Billy" <Billy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A498DAFD-838E-466C-A03F-FC3102784162@xxxxxxxxxxxxxxxx
> Unfortunately I'm not a sql guru, just a network admin. This program that
> points to the database was created by an outside company. Of course they
> say
> that because only 2 of clients have the login issue it must be an xp
> client
> issue and has nothing to do with the program. But the users are already in
> the program, it is only when they try to run a report from within the
> program
> that the login box appears?
> Got any opinions one way or another?
>
> "Andrew J. Kelly" wrote:
>
>> If it is windows authentication it should not need to ask. You really
>> need
>> to see what the application is using for a connection string.
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>>
>> "Billy" <Billy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BEF206D6-AA2F-4949-9D5C-95B13AE16D42@xxxxxxxxxxxxxxxx
>> > Users logon to the domain, and from a shared drive the clients run an
>> > msi
>> > file that installs a program on their local pc's, this uses a sql
>> > database.
>> > They start the program and when they try to run a report they get a pop
>> > up
>> > box asking for login info for "TableName datatable". I think it is
>> > Windows
>> > Authentication, don't know how to check which one is being used.
>> > Trying to determine if an xp client issue or sql issue.
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Can you give more details? How exactly are they logging in? Are you
>> >> using
>> >> Windows authentication or SQL? Windows won't prompt you to login to
>> >> SQL
>> >> Server since you already logged in to the domain.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "Billy" <Billy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:FB02C0E3-2E67-4979-B809-C49BE0496BCA@xxxxxxxxxxxxxxxx
>> >> > sql 2000 on 2003 server standard, only 2 out of 10 users (xp pro
>> >> > clients)
>> >> > trying to access sql program are asked to login to database, server
>> >> > name,
>> >> > database, login id, password to TableName: datatable.
>> >> > Is this an xp client issue or sql issue.
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- Re: Client access to sql database
- From: Andrew J. Kelly
- Re: Client access to sql database
- From: Andrew J. Kelly
- Re: Client access to sql database
- Prev by Date: Re: Client access to sql database
- Next by Date: SQL Mail
- Previous by thread: Re: Client access to sql database
- Next by thread: SQL Mail
- Index(es):
Relevant Pages
|
Loading
