Crystal Reports and Logon Failed.

[Michael O'Donnell]

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

[Jorge]

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

.

[Jorge]

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

.

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

.

.

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

.

.

[Jorge]

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

.

.

.

[Jorge]

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

.

.

.

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

.

.

.

.

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

.

.

.

.

[Jorge]

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
>
>.
>
.

.

.

.

[Jorge]

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
>
>.
>
.

.

.

.

[Michael O'Donnell.]

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
>>
>>.
>>
>.
>
.

.

.

.

[Michael O'Donnell.]

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
>>
>>.
>>
>.
>
.

.

.

.

[Jorge]

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
>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

[Jorge]

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
>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

[Michael O'Donnell]

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
>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

[Michael O'Donnell]

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
>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

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
>>>>>
>>>>>.
>>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

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
>>>>>>
>>>>>>.
>>>>>>
>>>>>.
>>>>>
>>>>.
>>>>
>>>.
>>>
>>.
>>
>.
>
.

.

.

.

[neuromancer]

> 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