Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts

Friday, March 23, 2012

Login failed for user (null) , any ideas

I try to connect to the pubs database but get the following error:
Server Error in '/myWebApp' Application.
----
--
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rver connection.
Im logged in as myself, and also I've created a SQLUSER login to access the
data, and assiged SQLUSER to userid but still no luck
any ideas?Check on the server that Authentication is so to "SQL Server and Windows"
and not just "Windows"
In Enterprise Manager, right click on the server > Properties > Security
Tab.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:681F9E28-3428-4805-A062-CFD362FE4370@.microsoft.com...
quote:

> I try to connect to the pubs database but get the following error:
> Server Error in '/myWebApp' Application.
> ----

--
quote:

> Login failed for user '(null)'. Reason: Not associated with a trusted SQL

Server connection.
quote:

> Im logged in as myself, and also I've created a SQLUSER login to access

the data, and assiged SQLUSER to userid but still no luck
quote:

> any ideas?
|||Security is fine. and other ideas?
Lee|||> I try to connect to the pubs database
How? Could you show your code?

Monday, March 12, 2012

Login failed

I get this message using windows authentification. Any Ideas?
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'NKRIM105_DB'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
----
--
If you wait for an opportunity the opportunity will pass u by!Hi,
1) Please give your user approperiate access to database by add user to
database you are attempting to connect.
2) Your user must have appropriate access to reports deployed at report
server. Goto Report manager and add above user
Regards,
Ayaz Ahmad|||Hi,
1) Please give your user approperiate access to database by add user to
database you are attempting to connect.
2) Your user must have appropriate access to reports deployed at report
server. Goto Report manager and add above user
Regards,
Ayaz Ahmad