SQL 2000 UserID & Password Question

30 Sep 2005 2:29 AM

Hugh O

Hi,
I have the following error that I have gotten when I try to use Crystal
Reports within Visual Studio.Net 2003 and within a VB ASP.Net app that
accesses a SQL Server 2000 Database

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.

Searching through Google it seems to be a common problem that can be
resolved by setting Crystal Reports Logon database userid and password. It
appears that Crystal Reports needs the SQL Userid and password even though
the SQL database I use for the Web app uses Windows authentication.

Trouble is I have tried numerous different combinations and I am no longer
positive what my SQL UserId and password is. Since I have used the Windows
authentication, I have rarely ever had to use it.

Is there any way of determining my SQL UserID and password. Or can I reset
it to a default and then reset it to something I will remember. Everything
is really working OK. I would hate to have to reinstall just to get at the
UserID and password.

I am running Win /XP Pro and Visual Studio.Net 2003 and IIS with a server
environment on my desktop for development. If I have to re-install. What
would be the required steps? Would it just be an Uninstall and reinstall.
Or do I have to do something to save my data or environment?

Of course I would love a direct answer, but any direction would be a help.

Thanks
Hugh

30 Sep 2005 4:40 AM

Matt Neerincx [MSFT]

If you are the admin of the SQL box you can reset any password. Log in
using you Windows account and just reset it.

See sp_password function in SQL Server books online.

For example:

sp_password null,'new_password','someuser'

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

Show quote

"Hugh O" <HughLD@newsgroup.nospam> wrote in message
news:O%2373JbWxFHA.3400@TK2MSFTNGP14.phx.gbl...
> Hi,
> I have the following error that I have gotten when I try to use Crystal
> Reports within Visual Studio.Net 2003 and within a VB ASP.Net app that
> accesses a SQL Server 2000 Database
>
> CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
>
> Searching through Google it seems to be a common problem that can be
> resolved by setting Crystal Reports Logon database userid and password.
> It appears that Crystal Reports needs the SQL Userid and password even
> though the SQL database I use for the Web app uses Windows authentication.
>
> Trouble is I have tried numerous different combinations and I am no longer
> positive what my SQL UserId and password is. Since I have used the
> Windows authentication, I have rarely ever had to use it.
>
> Is there any way of determining my SQL UserID and password. Or can I
> reset it to a default and then reset it to something I will remember.
> Everything is really working OK. I would hate to have to reinstall just
> to get at the UserID and password.
>
> I am running Win /XP Pro and Visual Studio.Net 2003 and IIS with a server
> environment on my desktop for development. If I have to re-install. What
> would be the required steps? Would it just be an Uninstall and reinstall.
> Or do I have to do something to save my data or environment?
>
> Of course I would love a direct answer, but any direction would be a
> help.
>
> Thanks
> Hugh
>

30 Sep 2005 1:16 PM

Hugh O

Matt,
Thanks a lot.

Since submitting this post I have learned that there is a Business Objects
Newsgroup that covers Crystal Reports. I will use that to understand the
UserID and Password requirements of Crystal Reports then I may use this
reset capability to resolve the issue once and for all.

Thanks again,
hugh
Show quote

"Matt Neerincx [MSFT]" <ma***@online.microsoft.com> wrote in message
news:usCyTkXxFHA.3900@TK2MSFTNGP10.phx.gbl...
> If you are the admin of the SQL box you can reset any password. Log in
> using you Windows account and just reset it.
>
> See sp_password function in SQL Server books online.
>
> For example:
>
> sp_password null,'new_password','someuser'
>
>
>
> --
> Matt Neerincx [MSFT]
>
> This posting is provided "AS IS", with no warranties, and confers no
> rights.
>
> Please do not send email directly to this alias. This alias is for
> newsgroup purposes only.
>
> "Hugh O" <HughLD@newsgroup.nospam> wrote in message
> news:O%2373JbWxFHA.3400@TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have the following error that I have gotten when I try to use Crystal
>> Reports within Visual Studio.Net 2003 and within a VB ASP.Net app that
>> accesses a SQL Server 2000 Database
>>
>> CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
>>
>> Searching through Google it seems to be a common problem that can be
>> resolved by setting Crystal Reports Logon database userid and password.
>> It appears that Crystal Reports needs the SQL Userid and password even
>> though the SQL database I use for the Web app uses Windows
>> authentication.
>>
>> Trouble is I have tried numerous different combinations and I am no
>> longer positive what my SQL UserId and password is. Since I have used
>> the Windows authentication, I have rarely ever had to use it.
>>
>> Is there any way of determining my SQL UserID and password. Or can I
>> reset it to a default and then reset it to something I will remember.
>> Everything is really working OK. I would hate to have to reinstall just
>> to get at the UserID and password.
>>
>> I am running Win /XP Pro and Visual Studio.Net 2003 and IIS with a
>> server environment on my desktop for development. If I have to
>> re-install. What would be the required steps? Would it just be an
>> Uninstall and reinstall. Or do I have to do something to save my data or
>> environment?
>>
>> Of course I would love a direct answer, but any direction would be a
>> help.
>>
>> Thanks
>> Hugh
>>
>
>