|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > login issue
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jim Muglia 2002-08-14, 12:23 pm |
| August 14, 2002
Greetings,
I have a customer who is running our application. The
application accesses their SQL Server 7 database. He says
that when he runs my application, he gets a message which
says "Log onto SQL Server" and asks for a password. And he
doesn't want this to happen when he runs the application.
I don't have SQL Server 7.0 up and running on my computer
here; so I can't really check into it.
My question is:
Is there anything I can tell him to do in his Enterprise
Manager to make sure that no password is asked for when
the database is accessed?
Thank you,
Jim
| |
| Keith Kratochvil 2002-08-14, 1:23 pm |
| No.
This would be handled within your application. It would be handled
differently if you are using SQL Server authentication vs NT authentication.
You would probably want to use a connection string to pass the appropriate
password (assuming SQL Server authentication). www.connectionstrings.com
has some pretty good information on how to use a connection string.
--
Keith, SQL Server MVP
"Jim Muglia" <jamesmuglia@hotmail.com> wrote in message
news:271601c243ba$931992e0$39e
f2ecf@TKMSFTNGXA08...
> August 14, 2002
>
> Greetings,
>
> I have a customer who is running our application. The
> application accesses their SQL Server 7 database. He says
> that when he runs my application, he gets a message which
> says "Log onto SQL Server" and asks for a password. And he
> doesn't want this to happen when he runs the application.
>
> I don't have SQL Server 7.0 up and running on my computer
> here; so I can't really check into it.
>
> My question is:
> Is there anything I can tell him to do in his Enterprise
> Manager to make sure that no password is asked for when
> the database is accessed?
>
> Thank you,
> Jim
| |
| Jim Muglia 2002-08-15, 7:23 am |
| Thanks for the reply. So does this mean that if they were
to change the database to NT authentication, instead of
SQL Server authentication, that he would not receive the
password prompt?
>-----Original Message-----
>No.
>This would be handled within your application. It would
be handled
>differently if you are using SQL Server authentication vs
NT authentication.
>You would probably want to use a connection string to
pass the appropriate
>password (assuming SQL Server authentication).
www.connectionstrings.com
>has some pretty good information on how to use a
connection string.
>
>--
>Keith, SQL Server MVP
>
>
>"Jim Muglia" <jamesmuglia@hotmail.com> wrote in message
> news:271601c243ba$931992e0$39e
f2ecf@TKMSFTNGXA08...
>> August 14, 2002
>>
>> Greetings,
>>
>> I have a customer who is running our application. The
>> application accesses their SQL Server 7 database. He
says
>> that when he runs my application, he gets a message
which
>> says "Log onto SQL Server" and asks for a password. And
he
>> doesn't want this to happen when he runs the
application.
>>
>> I don't have SQL Server 7.0 up and running on my
computer
>> here; so I can't really check into it.
>>
>> My question is:
>> Is there anything I can tell him to do in his Enterprise
>> Manager to make sure that no password is asked for when
>> the database is accessed?
>>
>> Thank you,
>> Jim
>
>
>.
>
| |
| Keith Kratochvil 2002-08-15, 7:23 am |
| Yes, but how would that work with YOUR application? Would they also have to
give rights to tables/stored procedures? Only you can answer these
questions.
You could try setting up a test environment in your shop. Make the changes
from SQL Server to Windows authentication and see what breaks (or what
works). From there, you will be able to document the steps that it takes to
convert to SQL to Windows Authentication.
--
Keith, SQL Server MVP
"Jim Muglia" <jamesmuglia@hotmail.com> wrote in message
news:2b9201c24458$e63614f0$39e
f2ecf@TKMSFTNGXA08...
> Thanks for the reply. So does this mean that if they were
> to change the database to NT authentication, instead of
> SQL Server authentication, that he would not receive the
> password prompt?
>
> >-----Original Message-----
> >No.
> >This would be handled within your application. It would
> be handled
> >differently if you are using SQL Server authentication vs
> NT authentication.
> >You would probably want to use a connection string to
> pass the appropriate
> >password (assuming SQL Server authentication).
> www.connectionstrings.com
> >has some pretty good information on how to use a
> connection string.
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Jim Muglia" <jamesmuglia@hotmail.com> wrote in message
> > news:271601c243ba$931992e0$39e
f2ecf@TKMSFTNGXA08...
> >> August 14, 2002
> >>
> >> Greetings,
> >>
> >> I have a customer who is running our application. The
> >> application accesses their SQL Server 7 database. He
> says
> >> that when he runs my application, he gets a message
> which
> >> says "Log onto SQL Server" and asks for a password. And
> he
> >> doesn't want this to happen when he runs the
> application.
> >>
> >> I don't have SQL Server 7.0 up and running on my
> computer
> >> here; so I can't really check into it.
> >>
> >> My question is:
> >> Is there anything I can tell him to do in his Enterprise
> >> Manager to make sure that no password is asked for when
> >> the database is accessed?
> >>
> >> Thank you,
> >> Jim
> >
> >
> >.
> >
|
|
|
|
|