469,312 Members | 2,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,312 developers. It's quick & easy.

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 4047
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bonj | last post: by
2 posts views Thread by Karun Karunakaran | last post: by
2 posts views Thread by GFro | last post: by
1 post views Thread by andy lim | last post: by
3 posts views Thread by Milan Todorovic | last post: by
9 posts views Thread by mollyf | last post: by
3 posts views Thread by Shawn H. Mesiatowsky | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.