473,380 Members | 1,448 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,380 software developers and data experts.

Crystal Reports and Logon Failed.

Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run and
display ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

Nov 21 '05 #1
19 4336
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run and
display ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with theregristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

.

Nov 21 '05 #2
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run and
display ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with theregristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

.

Nov 21 '05 #3
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run anddisplay ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with

the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

.

.

Nov 21 '05 #4
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run anddisplay ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with

the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put into
these fields, can anyone suggest a solution.

Michael

.

.

Nov 21 '05 #5
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run

anddisplay ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with

the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put intothese fields, can anyone suggest a solution.

Michael

.

.

.

Nov 21 '05 #6
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each table
of the report.

Kind Regards
Jorge

-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run

anddisplay ther report that I am getting a "Login Failed"
message. At first I thought it might have to do with

the
regristration key, but that ok, when I right click on
Servers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to put intothese fields, can anyone suggest a solution.

Michael

.

.

.

Nov 21 '05 #7
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********", database
= "pubs" and have checked the trusted connection option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for eachtableof the report.

Kind Regards
Jorge
-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run

and
display ther report that I am getting a "Login Failed"message. At first I thought it might have to do with
the
regristration key, but that ok, when I right click onServers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to putintothese fields, can anyone suggest a solution.

Michael

.

.

.

.

Nov 21 '05 #8
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********", database
= "pubs" and have checked the trusted connection option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.
-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for eachtableof the report.

Kind Regards
Jorge
-----Original Message-----
Hi All

Am having major problem with crystal reports...Have
designed my report no problem, its when I try to run

and
display ther report that I am getting a "Login Failed"message. At first I thought it might have to do with
the
regristration key, but that ok, when I right click onServers in the server explorer and then expand the
Crystal Server, there is a red x beside the Crystal
Enterprise. When I click on log in, I am asked for a
username and a password. I don't know what to putintothese fields, can anyone suggest a solution.

Michael

.

.

.

.

Nov 21 '05 #9
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source Selectionhave selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********", database= "pubs" and have checked the trusted connection option.Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.

-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each

table
of the report.

Kind Regards
Jorge
>-----Original Message-----
>Hi All
>
>Am having major problem with crystal reports...Have
>designed my report no problem, its when I try to run
and
>display ther report that I am getting a "LoginFailed">message. At first I thought it might have to do withthe
>regristration key, but that ok, when I right clickon>Servers in the server explorer and then expand the
>Crystal Server, there is a red x beside the Crystal
>Enterprise. When I click on log in, I am asked for a>username and a password. I don't know what to put

into
>these fields, can anyone suggest a solution.
>
>Michael
>
>.
>
.

.

.

.

Nov 21 '05 #10
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source Selectionhave selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********", database= "pubs" and have checked the trusted connection option.Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under Server
Explorer, Server, Crystal Server).

Mike.

-----Original Message-----
Hi Michael

Have you tried the .ApplyLogOnInfo method for each

table
of the report.

Kind Regards
Jorge
>-----Original Message-----
>Hi All
>
>Am having major problem with crystal reports...Have
>designed my report no problem, its when I try to run
and
>display ther report that I am getting a "LoginFailed">message. At first I thought it might have to do withthe
>regristration key, but that ok, when I right clickon>Servers in the server explorer and then expand the
>Crystal Server, there is a red x beside the Crystal
>Enterprise. When I click on log in, I am asked for a>username and a password. I don't know what to put

into
>these fields, can anyone suggest a solution.
>
>Michael
>
>.
>
.

.

.

.

Nov 21 '05 #11
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source

Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",

database
= "pubs" and have checked the trusted connection

option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge

-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under ServerExplorer, Server, Crystal Server).

Mike.

>-----Original Message-----
>Hi Michael
>
>Have you tried the .ApplyLogOnInfo method for each
table
>of the report.
>
>Kind Regards
>Jorge
>
>
>>-----Original Message-----
>>Hi All
>>
>>Am having major problem with crystal reports...Have
>>designed my report no problem, its when I try to runand
>>display ther report that I am getting a "Login

Failed"
>>message. At first I thought it might have to dowith>the
>>regristration key, but that ok, when I right click

on
>>Servers in the server explorer and then expand the
>>Crystal Server, there is a red x beside the Crystal
>>Enterprise. When I click on log in, I am asked fora>>username and a password. I don't know what to put
into
>>these fields, can anyone suggest a solution.
>>
>>Michael
>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #12
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source

Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",

database
= "pubs" and have checked the trusted connection

option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike
-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge

-----Original Message-----
Hi Jorge,

Thanks for the swift reply. I am not specifying any
login information in my code. I am trying to get the
Crystal Enterprise service to log in (see under ServerExplorer, Server, Crystal Server).

Mike.

>-----Original Message-----
>Hi Michael
>
>Have you tried the .ApplyLogOnInfo method for each
table
>of the report.
>
>Kind Regards
>Jorge
>
>
>>-----Original Message-----
>>Hi All
>>
>>Am having major problem with crystal reports...Have
>>designed my report no problem, its when I try to runand
>>display ther report that I am getting a "Login

Failed"
>>message. At first I thought it might have to dowith>the
>>regristration key, but that ok, when I right click

on
>>Servers in the server explorer and then expand the
>>Crystal Server, there is a red x beside the Crystal
>>Enterprise. When I click on log in, I am asked fora>>username and a password. I don't know what to put
into
>>these fields, can anyone suggest a solution.
>>
>>Michael
>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #13
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source

Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",

database
= "pubs" and have checked the trusted connection

option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike

-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge

>-----Original Message-----
>Hi Jorge,
>
>Thanks for the swift reply. I am not specifying any
>login information in my code. I am trying to get the>Crystal Enterprise service to log in (see underServer>Explorer, Server, Crystal Server).
>
>Mike.
>
>>-----Original Message-----
>>Hi Michael
>>
>>Have you tried the .ApplyLogOnInfo method for each
table
>>of the report.
>>
>>Kind Regards
>>Jorge
>>
>>
>>>-----Original Message-----
>>>Hi All
>>>
>>>Am having major problem with crystal reports...Have>>>designed my report no problem, its when I try torun>and
>>>display ther report that I am getting a "Login
Failed"
>>>message. At first I thought it might have to do

with
>>the
>>>regristration key, but that ok, when I right clickon
>>>Servers in the server explorer and then expand the
>>>Crystal Server, there is a red x beside the Crystal>>>Enterprise. When I click on log in, I am asked

fora
>>>username and a password. I don't know what to put
into
>>>these fields, can anyone suggest a solution.
>>>
>>>Michael
>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #14
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the pubs
database.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source

Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",

database
= "pubs" and have checked the trusted connection

option.
Then clicked Finished.
5. Selected the employee table from pubs, selected the
employee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike

-----Original Message-----
Hi
If your using the SQL Server then you need to put the
username and password of the sql user.

Kind Regards
Jorge

>-----Original Message-----
>Hi Jorge,
>
>Thanks for the swift reply. I am not specifying any
>login information in my code. I am trying to get the>Crystal Enterprise service to log in (see underServer>Explorer, Server, Crystal Server).
>
>Mike.
>
>>-----Original Message-----
>>Hi Michael
>>
>>Have you tried the .ApplyLogOnInfo method for each
table
>>of the report.
>>
>>Kind Regards
>>Jorge
>>
>>
>>>-----Original Message-----
>>>Hi All
>>>
>>>Am having major problem with crystal reports...Have>>>designed my report no problem, its when I try torun>and
>>>display ther report that I am getting a "Login
Failed"
>>>message. At first I thought it might have to do

with
>>the
>>>regristration key, but that ok, when I right clickon
>>>Servers in the server explorer and then expand the
>>>Crystal Server, there is a red x beside the Crystal>>>Enterprise. When I click on log in, I am asked

fora
>>>username and a password. I don't know what to put
into
>>>these fields, can anyone suggest a solution.
>>>
>>>Michael
>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #15
If you used sa as a user ID, what did you use for the
password???

Michael
-----Original Message-----
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the

pubsdatabase.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source
Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",
database
= "pubs" and have checked the trusted connection
option.
Then clicked Finished.
5. Selected the employee table from pubs, selected theemployee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike

>-----Original Message-----
>Hi
>If your using the SQL Server then you need to put the>username and password of the sql user.
>
>Kind Regards
>Jorge
>
>>-----Original Message-----
>>Hi Jorge,
>>
>>Thanks for the swift reply. I am not specifying any>>login information in my code. I am trying to getthe>>Crystal Enterprise service to log in (see under

Server
>>Explorer, Server, Crystal Server).
>>
>>Mike.
>>
>>>-----Original Message-----
>>>Hi Michael
>>>
>>>Have you tried the .ApplyLogOnInfo method for each
>table
>>>of the report.
>>>
>>>Kind Regards
>>>Jorge
>>>
>>>
>>>>-----Original Message-----
>>>>Hi All
>>>>
>>>>Am having major problem with crystalreports...Have>>>>designed my report no problem, its when I try to

run
>>and
>>>>display ther report that I am getting a "Login
Failed"
>>>>message. At first I thought it might have to do
with
>>>the
>>>>regristration key, but that ok, when I rightclickon
>>>>Servers in the server explorer and then expand the>>>>Crystal Server, there is a red x beside theCrystal>>>>Enterprise. When I click on log in, I am askedfora
>>>>username and a password. I don't know what to put>into
>>>>these fields, can anyone suggest a solution.
>>>>
>>>>Michael
>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #16
If you used sa as a user ID, what did you use for the
password???

Michael
-----Original Message-----
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB (ADO)
and like you I left the integrated integrity unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissions
to see if that can help.

Michael O'Donnell.
-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the

pubsdatabase.

Kind Regards
Jorge
-----Original Message-----
Hi Jorge

Here are the steps I have followed...
1. Created a new Crystal Report
2. Have selected the report wizard option
3. Selected ODBC (RDO) and from the Data Source
Selection
have selected the SQLServer option.
4. For the connection information have Specified the
username: "Administrator", password: "********",
database
= "pubs" and have checked the trusted connection
option.
Then clicked Finished.
5. Selected the employee table from pubs, selected theemployee id, forename and surname, set groupby
option: "employeeID" and clicked finish
6. Then have added in the normal code and clicked go

What am i doing wrong. Have also repeated the above
operations for the Ole db data source.

Mike

>-----Original Message-----
>Hi
>If your using the SQL Server then you need to put the>username and password of the sql user.
>
>Kind Regards
>Jorge
>
>>-----Original Message-----
>>Hi Jorge,
>>
>>Thanks for the swift reply. I am not specifying any>>login information in my code. I am trying to getthe>>Crystal Enterprise service to log in (see under

Server
>>Explorer, Server, Crystal Server).
>>
>>Mike.
>>
>>>-----Original Message-----
>>>Hi Michael
>>>
>>>Have you tried the .ApplyLogOnInfo method for each
>table
>>>of the report.
>>>
>>>Kind Regards
>>>Jorge
>>>
>>>
>>>>-----Original Message-----
>>>>Hi All
>>>>
>>>>Am having major problem with crystalreports...Have>>>>designed my report no problem, its when I try to

run
>>and
>>>>display ther report that I am getting a "Login
Failed"
>>>>message. At first I thought it might have to do
with
>>>the
>>>>regristration key, but that ok, when I rightclickon
>>>>Servers in the server explorer and then expand the>>>>Crystal Server, there is a red x beside theCrystal>>>>Enterprise. When I click on log in, I am askedfora
>>>>username and a password. I don't know what to put>into
>>>>these fields, can anyone suggest a solution.
>>>>
>>>>Michael
>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #17
the blank password
-----Original Message-----
If you used sa as a user ID, what did you use for the
password???

Michael
-----Original Message-----
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB (ADO)and like you I left the integrated integrityunchecked.However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:
Not associated with a trusted SQL connection.

Any suggestions, am looking at the security permissionsto see if that can help.

Michael O'Donnell.

-----Original Message-----
Hi
I tried to follow the same steps and i get the logon
failed. I tried to OLE DB (ADO) and removing the
integrated integrity it works fine i can access the

pubs
database.

Kind Regards
Jorge
>-----Original Message-----
>Hi Jorge
>
>Here are the steps I have followed...
>1. Created a new Crystal Report
>2. Have selected the report wizard option
>3. Selected ODBC (RDO) and from the Data Source
Selection
>have selected the SQLServer option.
>4. For the connection information have Specified the
>username: "Administrator", password: "********",
database
>= "pubs" and have checked the trusted connection
option.
>Then clicked Finished.
>5. Selected the employee table from pubs, selectedthe>employee id, forename and surname, set groupby
>option: "employeeID" and clicked finish
>6. Then have added in the normal code and clicked go
>
>What am i doing wrong. Have also repeated the above
>operations for the Ole db data source.
>
>Mike
>
>>-----Original Message-----
>>Hi
>>If your using the SQL Server then you need to putthe>>username and password of the sql user.
>>
>>Kind Regards
>>Jorge
>>
>>>-----Original Message-----
>>>Hi Jorge,
>>>
>>>Thanks for the swift reply. I am not specifyingany>>>login information in my code. I am trying to get

the
>>>Crystal Enterprise service to log in (see under
Server
>>>Explorer, Server, Crystal Server).
>>>
>>>Mike.
>>>
>>>>-----Original Message-----
>>>>Hi Michael
>>>>
>>>>Have you tried the .ApplyLogOnInfo method for each>>table
>>>>of the report.
>>>>
>>>>Kind Regards
>>>>Jorge
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>Hi All
>>>>>
>>>>>Am having major problem with crystal

reports...Have
>>>>>designed my report no problem, its when I try to
run
>>>and
>>>>>display ther report that I am getting a "Login
>Failed"
>>>>>message. At first I thought it might have to do
with
>>>>the
>>>>>regristration key, but that ok, when I right

click
>on
>>>>>Servers in the server explorer and then expandthe>>>>>Crystal Server, there is a red x beside the

Crystal
>>>>>Enterprise. When I click on log in, I am asked

for
a
>>>>>username and a password. I don't know what toput>>into
>>>>>these fields, can anyone suggest a solution.
>>>>>
>>>>>Michael
>>>>>
>>>>>.
>>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #18
When i use "sa" as a user id and leave the password field
blank, i get an error message telling me that "sa" is not
a trusted connection.

Mike
-----Original Message-----
the blank password
-----Original Message-----
If you used sa as a user ID, what did you use for the
password???

Michael
-----Original Message-----
Well i am running out of suggestions i did use 'sa'
instead of 'administrator'.

Kind Regards
Jorge
-----Original Message-----
Hi

Am after repeating the steps again for the OLE DB(ADO)and like you I left the integrated integrity

unchecked.
However when I click on finish I get the following
messages: Login failed for user:Administrator, Reason:Not associated with a trusted SQL connection.

Any suggestions, am looking at the securitypermissionsto see if that can help.

Michael O'Donnell.

>-----Original Message-----
>Hi
>I tried to follow the same steps and i get the logon
>failed. I tried to OLE DB (ADO) and removing the
>integrated integrity it works fine i can access the
pubs
>database.
>
>Kind Regards
>Jorge
>>-----Original Message-----
>>Hi Jorge
>>
>>Here are the steps I have followed...
>>1. Created a new Crystal Report
>>2. Have selected the report wizard option
>>3. Selected ODBC (RDO) and from the Data Source
>Selection
>>have selected the SQLServer option.
>>4. For the connection information have Specified the>>username: "Administrator", password: "********",
>database
>>= "pubs" and have checked the trusted connection
>option.
>>Then clicked Finished.
>>5. Selected the employee table from pubs, selected

the
>>employee id, forename and surname, set groupby
>>option: "employeeID" and clicked finish
>>6. Then have added in the normal code and clicked go
>>
>>What am i doing wrong. Have also repeated the above>>operations for the Ole db data source.
>>
>>Mike
>>
>>>-----Original Message-----
>>>Hi
>>>If your using the SQL Server then you need to put

the
>>>username and password of the sql user.
>>>
>>>Kind Regards
>>>Jorge
>>>
>>>>-----Original Message-----
>>>>Hi Jorge,
>>>>
>>>>Thanks for the swift reply. I am not specifying

any
>>>>login information in my code. I am trying to get
the
>>>>Crystal Enterprise service to log in (see under
Server
>>>>Explorer, Server, Crystal Server).
>>>>
>>>>Mike.
>>>>
>>>>>-----Original Message-----
>>>>>Hi Michael
>>>>>
>>>>>Have you tried the .ApplyLogOnInfo method foreach>>>table
>>>>>of the report.
>>>>>
>>>>>Kind Regards
>>>>>Jorge
>>>>>
>>>>>
>>>>>>-----Original Message-----
>>>>>>Hi All
>>>>>>
>>>>>>Am having major problem with crystal
reports...Have
>>>>>>designed my report no problem, its when I try torun
>>>>and
>>>>>>display ther report that I am getting a "Login
>>Failed"
>>>>>>message. At first I thought it might have to do>with
>>>>>the
>>>>>>regristration key, but that ok, when I right
click
>>on
>>>>>>Servers in the server explorer and then expand

the
>>>>>>Crystal Server, there is a red x beside the
Crystal
>>>>>>Enterprise. When I click on log in, I am asked
for
>a
>>>>>>username and a password. I don't know what to

put
>>>into
>>>>>>these fields, can anyone suggest a solution.
>>>>>>
>>>>>>Michael
>>>>>>
>>>>>>.
>>>>>>
>>>>>.
>>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

Nov 21 '05 #19
> Anonymouswrote:
When i use "sa" as a user id and leave the password field
blank, i get an error message telling me that "sa" is not
a trusted connection.


If using the sa login you need to open up your ODBC connection and
change the login details from trusted connection to "use SQL login
name and password". Trusted connection tries to match a Windows
Domain login to associated rights within SQL Server, the other option
just uses internal SQl server authority.

David

Nov 21 '05 #20

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bonj | last post by:
Hi I am trying to create a simple 'hello world' type web application involving a crystal report. I have basically done it the simplest possible way as described in the documentation, by adding a...
0
by: stephan | last post by:
I know that this has been beaten to death but I can't seem to resolve my issues (I have 2 of them). I have created a class that exposes a public method which returns a datatable as a datasource...
2
by: Karun Karunakaran | last post by:
Hi, I am using the Crystal Enterprise .NET assemblies to generate and display a crystal report in a webform. This report connects to an SQL server (running locally) using a specific username and...
2
by: GFro | last post by:
I am getting the following error since we upgraded from .NET Framework 1.0 to 1.1. The reports all ran fine yesterday. I get this error in all apps with reports. The apps run fine but the...
1
by: andy lim | last post by:
Hello all, I'm developing a web application using ASP.NET/VB. I have problem in viewing my CR reports. It returns following exception when I tried to view any CR report. ...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most basic report purely for testing purposes: connect to...
1
by: John Dalberg | last post by:
Running Crystal Reports with the hotfixes and patches & VS 2003. I created a CR report on my development server which has SQL Server. The report runs fine inside Visual Studio. When I switched...
9
by: mollyf | last post by:
I have tried various suggestions that I have found searching the newsgroups and still haven't been able to figure why I keep getting the logon failed error. I created a report in Crystal (not...
3
by: Shawn H. Mesiatowsky | last post by:
I have come across lots of information regarding this, but nothing seems to work. I have created a Crystal Report that access's a SQL server backend for the data, and I want to display the report...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.