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 19 4178
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 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 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 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
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
tableof 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
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
intothese fields, can anyone suggest a solution.
Michael
. . .
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
tableof 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
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
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 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
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 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
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
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 tableof 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 > >. > .
. . .
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 tableof 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 > >. > .
. . .
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 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
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 >> >>. >> >. > .
. . .
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 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
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 >> >>. >> >. > .
. . .
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 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 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 >>> >>>. >>> >>. >> >. > .
. . .
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 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 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 >>> >>>. >>> >>. >> >. > .
. . .
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 >>>> >>>>. >>>> >>>. >>> >>. >> >. > .
. . .
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 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, 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 fora >>>>>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 >>>>>> >>>>>>. >>>>>> >>>>>. >>>>> >>>>. >>>> >>>. >>> >>. >> >. > .
. . .
> 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 This discussion thread is closed Replies have been disabled for this discussion. Similar topics
reply
views
Thread by Bonj |
last post: by
|
reply
views
Thread by stephan |
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
|
1 post
views
Thread by John Dalberg |
last post: by
|
9 posts
views
Thread by mollyf |
last post: by
|
3 posts
views
Thread by Shawn H. Mesiatowsky |
last post: by
| | | | | | | | | | |