Logon Failure

I have W2003 server with Sql running. User is trying to open a report from the database. It was working fine.
Message pops up stating:
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help Logon failure: unknown user name or bad password. Any help would be appreciated.
i am also getting the same issue, if you got any solution please let me know|||I'm also getting the logon failed error when using a data driven subscription to the report and the query validation is succesful, anyone knows how to fix that?
|||

Cehck your data source connection. Make sure the account has enought permissions to access the database.

|||Tried it with sa account, the same error...

Logon failed when attempting to run report

When attempting to run a report, the following error appeared.
What does the following error message mean?
Logon failed.
Logon failure: unknown user name or bad password. (Exception from HRESULT:
0x8007052E)Looks like your report credentials are not set.
Go to Report Manager, navigate to the report, go to properties and make
sure your data sources are all correctly set up

Logon Error ?

The following error is logged in SQL Server 2005 Logfile. Could anyone
explain why this error is happening ?
Message
The server was unable to load the SSL provider library needed to log in; the
connection has been closed. SSL is used to encrypt either the login sequence
or all communications, depending on how the administrator has configured the
server. See Books Online for information on this error message: 0x6d.
[CLIENT: <named pipe>]Hi,
Have you installed an SSL certificate on the SQL Server?
If not then remove any configuration you may have on the server to force
encryption for connections (SQL Server Configuration Manager). You should
also remove any configuration on the client computers requiring them to
connect using encryption (SQL Native Client Configuration).
In BOL, please check
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e1e55519-97ec-4404-81ef-881da3b42006.htm
Nathan H. Omukwenyi
"swami" <swami@.discussions.microsoft.com> wrote in message
news:F4FC882D-DE26-4D8A-AACA-3DC7CF1C5F70@.microsoft.com...
> The following error is logged in SQL Server 2005 Logfile. Could anyone
> explain why this error is happening ?
> Message
> The server was unable to load the SSL provider library needed to log in;
> the
> connection has been closed. SSL is used to encrypt either the login
> sequence
> or all communications, depending on how the administrator has configured
> the
> server. See Books Online for information on this error message: 0x6d.
> [CLIENT: <named pipe>]|||As far as we can see - encryption is not set anywhere, either on the
server or client.
any other clues ?
"Nathan H. Omukwenyi" wrote:
> Hi,
> Have you installed an SSL certificate on the SQL Server?
> If not then remove any configuration you may have on the server to force
> encryption for connections (SQL Server Configuration Manager). You should
> also remove any configuration on the client computers requiring them to
> connect using encryption (SQL Native Client Configuration).
> In BOL, please check
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e1e55519-97ec-4404-81ef-881da3b42006.htm
> Nathan H. Omukwenyi
>
>
> "swami" <swami@.discussions.microsoft.com> wrote in message
> news:F4FC882D-DE26-4D8A-AACA-3DC7CF1C5F70@.microsoft.com...
> > The following error is logged in SQL Server 2005 Logfile. Could anyone
> > explain why this error is happening ?
> >
> > Message
> > The server was unable to load the SSL provider library needed to log in;
> > the
> > connection has been closed. SSL is used to encrypt either the login
> > sequence
> > or all communications, depending on how the administrator has configured
> > the
> > server. See Books Online for information on this error message: 0x6d.
> > [CLIENT: <named pipe>]
>
>

login/security problems

This is a story:
I cannot signin to the new QA db with any existing id
other than ALEX. When I try I get this message "Cannot
open database requested in login ' QA '. Login fails.
Please contact system administrator."
And I can't create any new user ids - I get this
message "User does not have permission to perform this
action" though I'm using my ALEX id, and this message is
followed by a db error. The id gets created, but when I
try to signin with it I get this message "Logon failed
for user ... Please contact system administrator."
How should I fix this problem?Alexl
Perhaps a default database to which the user has been assigined does not
exist.
Can you login as SA and then create users?
"Alex" <anonymous@.discussions.microsoft.com> wrote in message
news:009201c3b434$ad6d8200$a101280a@.phx.gbl...
> This is a story:
> I cannot signin to the new QA db with any existing id
> other than ALEX. When I try I get this message "Cannot
> open database requested in login ' QA '. Login fails.
> Please contact system administrator."
> And I can't create any new user ids - I get this
> message "User does not have permission to perform this
> action" though I'm using my ALEX id, and this message is
> followed by a db error. The id gets created, but when I
> try to signin with it I get this message "Logon failed
> for user ... Please contact system administrator."
> How should I fix this problem?

Login problems when rendering reports

This is a multi-part message in MIME format.
--=_NextPart_000_008D_01C4C8B6.1764EDB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am continually getting the following error when attempting to render = my reports from http://hostname/ReportServer...
An error has occurred during report processing. (rsProcessingAborted) = Get Online Help a.. Cannot create a connection to data source 'DataCollection'. = (rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a = trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource = (integrated, NO Credentials, SQL authentican, etc.), and it still = doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on = Server B:
3. Created a user called ReportUser on BOTH the Reporting Services = server as well as the Datasource. I made sure the user has read access = in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource = connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_008D_01C4C8B6.1764EDB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I am continually getting the following = error when attempting to render my reports from
http://hostname/ReportServer...= .

An error has occurred during report = processing. (rsProcessingAborted) Get Online = Help
Cannot create a connection to data = source 'DataCollection'. (rsErrorOpeningConnection) Get = Online Help
Login failed for user '(null)'. = Reason: Not associated with a trusted SQL Server connection. =

I have tried EVERY possible security = setting for the DataSource (integrated, NO Credentials, SQL authentican, etc.), and = it still doesn't work.
Here is how it's set up:

1. Reporting Services metadata location = on Server A:
2. Datasource (from which I am pulling = data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as = well as the Datasource. I made sure the user has read access in the dbs on = both servers (including adding to the the RSExecRole).
4. I have designed my reports using = ReportUser as the DataSource connection.

Books online is not helping me = troubleshoot this error.

Any ideas?

Thanks,
Dan

--=_NextPart_000_008D_01C4C8B6.1764EDB0--This is a multi-part message in MIME format.
--=_NextPart_000_00AD_01C4C8BB.E4981C30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Okay: I finally got it to work by configuring my datasource to use ="Shared DataSource".
And then: Configuring my datasource (in ReportDesigner) to use a SQL =Authenticated login...
The security model in ReportServices is a bit tough to navigate in my =opinion.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:eMhumkPyEHA.2764@.TK2MSFTNGP10.phx.gbl...
I am continually getting the following error when attempting to render =my reports from http://hostname/ReportServer...
An error has occurred during report processing. (rsProcessingAborted) =Get Online Help a.. Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a =trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource =(integrated, NO Credentials, SQL authentican, etc.), and it still =doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on =Server B:
3. Created a user called ReportUser on BOTH the Reporting Services =server as well as the Datasource. I made sure the user has read access =in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource =connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_00AD_01C4C8BB.E4981C30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Okay: I finally got it to work by =configuring my datasource to use "Shared DataSource".
And then: Configuring my =datasource (in ReportDesigner) to use a SQL Authenticated login...
The security model in ReportServices is =a bit tough to navigate in my opinion.
"Dan Carollo (hotmail)" =wrote in message news:eMhumkPyEHA.2764=@.TK2MSFTNGP10.phx.gbl...
I am continually getting the =following error when attempting to render my reports from
http://hostname/ReportServer">http://hostname/ReportServer...=.

An error has occurred during report =processing. (rsProcessingAborted) Get =Online Help
Cannot create a connection to data =source 'DataCollection'. (rsErrorOpeningConnection) Get =Online Help
Login failed for user '(null)'. =Reason: Not associated with a trusted SQL Server connection. =
I have tried EVERY possible security =setting for the DataSource (integrated, NO Credentials, SQL authentican, etc.), =and it still doesn't work.
Here is how it's set up:

1. Reporting Services metadata =location on Server A:
2. Datasource (from which I am =pulling data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as =well as the Datasource. I made sure the user has read access in the dbs =on both servers (including adding to the the RSExecRole).
4. I have designed my reports using =ReportUser as the DataSource connection.

Books online is not helping me =troubleshoot this error.

Any ideas?

Thanks,
Dan

---

--=_NextPart_000_00AD_01C4C8BB.E4981C30--|||This is a multi-part message in MIME format.
--=_NextPart_000_002C_01C4CB2B.5BA97140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Well: This is odd...
I came back into the office on Monday morning -- attempted to render =the same reports and I'm back to the same error again:
Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a =trusted SQL Server connection.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:#Ba5z7PyEHA.3844@.TK2MSFTNGP12.phx.gbl...
Okay: I finally got it to work by configuring my datasource to use ="Shared DataSource".
And then: Configuring my datasource (in ReportDesigner) to use a SQL =Authenticated login...
The security model in ReportServices is a bit tough to navigate in my =opinion.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:eMhumkPyEHA.2764@.TK2MSFTNGP10.phx.gbl...
I am continually getting the following error when attempting to =render my reports from http://hostname/ReportServer...
An error has occurred during report processing. =(rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with =a trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource =(integrated, NO Credentials, SQL authentican, etc.), and it still =doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on =Server B:
3. Created a user called ReportUser on BOTH the Reporting Services =server as well as the Datasource. I made sure the user has read access =in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource =connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_002C_01C4CB2B.5BA97140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Well: This is =odd...
I came back into the office on Monday =morning -- attempted to render the same reports and I'm back to the same error again:
Cannot =create a connection to data source 'DataCollection'. (rsErrorOpeningConnection) =Get Online =Help
Login failed for user '(null)'. =Reason: Not associated with a trusted SQL Server connection.
"Dan Carollo (hotmail)" =wrote in message news:#Ba5z7PyEHA.3844=@.TK2MSFTNGP12.phx.gbl...
Okay: I finally got it to work =by configuring my datasource to use "Shared DataSource".
And then: Configuring my =datasource (in ReportDesigner) to use a SQL Authenticated login...

The security model in ReportServices =is a bit tough to navigate in my opinion.


"Dan Carollo (hotmail)" =wrote in message news:eMhumkPyEHA.2764=@.TK2MSFTNGP10.phx.gbl...
I am continually getting the =following error when attempting to render my reports from
http://hostname/ReportServer">http://hostname/ReportServer...=.

An error has occurred during =report processing. (rsProcessingAborted) Get =Online Help
Cannot create a connection to =data source 'DataCollection'. (rsErrorOpeningConnection) Get =Online Help
Login failed for user ='(null)'. Reason: Not associated with a trusted SQL Server connection.

I have tried EVERY possible =security setting for the DataSource (integrated, NO Credentials, SQL authentican, =etc.), and it still doesn't work.
Here is how it's set =up:

1. Reporting Services metadata =location on Server A:
2. Datasource (from which I am =pulling data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as =well as the Datasource. I made sure the user has read access in the =dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using =ReportUser as the DataSource connection.

Books online is not helping me =troubleshoot this error.

Any ideas?

Thanks,
Dan

---

--=_NextPart_000_002C_01C4CB2B.5BA97140--

Login problem

I'm trying to connect to sql server 2005 & i'm getting the following error message

"Cannot open database 'XXXX' requested by the login. The login failed. Login failed for user Domain\User"

Ok i tried enabling disabling client protocols , i tried all Surface area configuration settings

I'm running Vista Ultimate With 2 processes & 4 cores

previously i was using xp and it worked untill i dettached & attached

So somewhere between Vista, 4 Cores & Attach Dettach the problem lies

I also tried changing sql server manegment studio security logons & users but that didn't help

Did you check if that user still exists in a domain of the network?|||

check the defult datbase of this particular user. Each user has a default database defined. check which is the default database for this user. it the database does not exists , change the default database of the user to any existing database

Madhu

|||

I suspect that you are using Vista’s UAC (User Account Control) feature. Under this feature, the Windows security token you are using to connect to SQL Server is not really a privileged user, and most likely you are getting access as a regular Windows user (I also assume you installed SQL Server Express in Vista).

Try running the following statement to confirm if my assumption is correct:

SELECT name, usage, type FROM sys.login_token ORDER BY usage, type, name

If you are running as a UAC token, you will see at least one row like the following:

BUILTIN\AdministratorsDENY ONLYWINDOWS GROUP

You should also notice that you are not a member of sysadmin.

For more detailed information on running SQL Server on Windows Vista, please visit BOL (http://msdn2.microsoft.com/en-us/library/Aa905868.aspx)

Quick workaround: Connect using SA login, and explicitly add yourself (or/and any other Windows user or groups you need) to sysadmin server role.

I hope this information helps.

-Raul Garcia

SDE/T

SQL Server Engine

|||

OK thanks to all for trying to help but none of the suggestions were helpfull

as it turns out i changed the name of the database in sql server management studio and then changed it back to the original and it just worked

since i had the excact same symptom on the computer where i was deploying to i tried it and it worked

I think it's very strange for this behaviour to be occuring some of the reasons i think they were occuring is because the attached database

was in the project or the bin\debug folder, also attaching and detaching the database creates problems for the user app to login

|||

I see. Most likely this is the default database for the login, and as it was not available, the connection was terminated early.

As a workaround in the future, you can explicitly specify a DB to connect to override the default DB. I would recommend connecting to master (master should always exist) and fix the default DB problem from there.

Thanks a lot for letting us know what was the root cause of the problem.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Nothing strange in this.. if the default database is not there , you will not be able to login which was already mentioned in the previous post

Madhu