Login failed for user '(null)'

My development environment consists of 2 separate servers (sql 2000 server
and iis6 server).
SQL 2000 Server has everything installed on it per the Microsoft
documentation.
IIS6 Web Server has everything installed on it per the Micorosoft
documentation.
My workstation has VS 2003 with reporting services install in it.
I followed an example in the Wrox SQL Server Reporting Services book.
Everything was easy to follow and managed to deploy the report to the web
server.
I tried to access the report:
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Got the following in return:
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'AdventureWorks2000'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
----
Microsoft Reporting Services
I clicked on the links provided for help and got:
Currently there are no Microsoft Knowledge Base articles available for this
specific error or event message.
I viewed my datasourcedefinition:
--
- <DataSourceDefinition>
<Extension>SQL</Extension>
<ConnectString>data source=DEV-SRV03;initial
catalog=AdventureWorks2000</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
--
What do I need to do? Can someone please help me resolve this problem?
Thanks,
WillsWell here is what I did to resolve the problem.
1. Deleted the 1st attempt.
2. Create a SQL account and gave it access to the 3 dbs: AdventureWorks2000,
ReportServer and ReportServerTempDB (role: sys admin; db access with dbowner).
3. Redid the tutorial and instead of Integrated security, I went with the
sql login account.
4. Next, I had to set OverwriteDataSources to True so that it would
overwrite my existing version.
5.
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Gave me the report I was looking for.
Now my question is on the sql login account. What permissions and security
does my login in account need at a min to do what I just did? I'm sure that I
gave it more than what was needed, but wanted to make sure that it worked.
Thanks,
Wills
"wills" wrote:
> My development environment consists of 2 separate servers (sql 2000 server
> and iis6 server).
> SQL 2000 Server has everything installed on it per the Microsoft
> documentation.
> IIS6 Web Server has everything installed on it per the Micorosoft
> documentation.
> My workstation has VS 2003 with reporting services install in it.
> I followed an example in the Wrox SQL Server Reporting Services book.
> Everything was easy to follow and managed to deploy the report to the web
> server.
> I tried to access the report:
> http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
> Got the following in return:
> Reporting Services Error
> ----
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'AdventureWorks2000'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> ----
> Microsoft Reporting Services
> I clicked on the links provided for help and got:
> Currently there are no Microsoft Knowledge Base articles available for this
> specific error or event message.
> I viewed my datasourcedefinition:
> --
> - <DataSourceDefinition>
> <Extension>SQL</Extension>
> <ConnectString>data source=DEV-SRV03;initial
> catalog=AdventureWorks2000</ConnectString>
> <CredentialRetrieval>Integrated</CredentialRetrieval>
> <Enabled>True</Enabled>
> </DataSourceDefinition>
> --
> What do I need to do? Can someone please help me resolve this problem?
> Thanks,
> Wills

Login failed for user 'miovision'.

Hi I have an ASP.NET application which was being developed using SQL 2005, VS 2005 in a Server 2003 environment and using SQL Server Authentication.I deployed the application in a shared hosted enviroment running SQL Server. I created a new user and changed the connection string in my ASP.NET application to the following:

Server=209.200.235.3;Database=some_database;User ID=some_user; Password=some_password;

When i try to connect to the web page on my hosted site I get the following error:

Server Error in '/' Application. Login failed for user 'miovision'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'miovision'.

Source Error: Line 4:
<html xmlns="http://www.w3.org/1999/xhtml" >Line 5: <head id="Head1" runat="server">Line 6: <title><%=Constants.PRODUCT_NAME %></title>Line 7: <link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />Line 8: <link rel="icon" href="favicon.ico" type="image/x-icon" />

Source File: d:\Inetpub\vhosts\interlyticsonline.officewebsite.net\httpdocs\Default.aspx

Line: 6 Stack Trace: [SqlException (0x80131904): Login failed for user 'miovision'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734931 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107 Miovision.JInterlytics.Common.JAMAR_DevDataSetTableAdapters.procSoftwareConfigurationSelectTableAdapter.Fill(procSoftwareConfigurationSelectDataTable dataTable, Nullable`1 i_SoftwareConfigID, String i_SoftwareConfigName) in C:\My Code OLD\JInterlytics\Miovision.JInterlytics.Common\Miovision.JInterlytics.Common\DataAccess\JAMAR_DevDataSet.Designer.vb:9759 DataAccessSelect.procSoftwareConfigurationSelect(String softConfigName) +80 Constants.SERVER_ADDRESS() +11 Constants..cctor() +274

[TypeInitializationException: The type initializer for 'Constants' threw an exception.] ASP.default_aspx.__Render__control2(HtmlTextWriter __w, Control parameterContainer) in d:\Inetpub\vhosts\interlyticsonline.officewebsite.net\httpdocs\Default.aspx:6 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065851 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24 System.Web.UI.HtmlControls.HtmlTitle.Render(HtmlTextWriter writer) +94 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24 System.Web.UI.HtmlControls.HtmlHead.RenderChildren(HtmlTextWriter writer) +14 System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22 System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24 System.Web.UI.Page.Render(HtmlTextWriter writer) +26 System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25 System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896

I have verified the passwords match. What am I missing?

Thanks.Is "miovision" the actual user ID in your connection string? When you create a login/user, you need grant the login access to its default datebase. Otherwise, login will fail.|||Yes, the user ID is the same in the connection string as it is in the database.|||Hi,

please make sure that the user is enabled and not locked out, the user has the priviledge to access the server and the user has the appropiate right to have access to the server. If the connection possible using other clients than the ASP webpage ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de