Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts

Thursday, March 29, 2012

error 18456 when trying to connect to 2005 using odbc

Hi all

I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error:

[SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]]

Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility.

any ideas ?

Regards, Waff

I found this out:

The server collation is defined to: Latin1_General_CI_AS

If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should.

How do you use a id in lowercase and connecto via ODBC ?

You need to enable TCP in order for ODBC clients to connect. Check out http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for information about doing this.

Mike

|||

Guess has something to do with the collation. I used Latin1_General_AI_CI.

If I create my login id in lowercase and try then to connect to the db using ODBC, then ODBC will switch my id to uppercase and so I can't logon.

Anyway, somehow, it must be possible to modify the server settings, so that it doesn't matter how I logon. lowercase or uppercase. I tryed with CI and CS but still them same.

ODBC is enabled but think has to do with the collation.

What are you using if you use id's as upper/lower case as Test ?

error 18456 when trying to connect to 2005 using odbc

Hi all

I am using Windows XP SP2 with a Sql server 2005 Express installation. I created a test db with a user called test, schema also test. I gave the permission connect, db_datareader and db_datawriter. I can now connect into this user using WinSQL. But if I want to connect using a application which is using ODBC, then I get the error:

[SQLSTATE=28000 - [Microsoft][SQL Native][SQL Server]Login failed for user 'test'.[Native Error=18456]]

Because I connect using ODBC, I think there must be the problem. But I have to connect with ODBC. There is no other possibility.

any ideas ?

Regards, Waff

I found this out:

The server collation is defined to: Latin1_General_CI_AS

If I create a new login id in lowercase, then ODBC will change it to uppercase and then the server refuse the access. But why. CI means case insensitive, so doesn't matter if upper or lower case. should.

How do you use a id in lowercase and connecto via ODBC ?

You need to enable TCP in order for ODBC clients to connect. Check out http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx for information about doing this.

Mike

|||

Guess has something to do with the collation. I used Latin1_General_AI_CI.

If I create my login id in lowercase and try then to connect to the db using ODBC, then ODBC will switch my id to uppercase and so I can't logon.

Anyway, somehow, it must be possible to modify the server settings, so that it doesn't matter how I logon. lowercase or uppercase. I tryed with CI and CS but still them same.

ODBC is enabled but think has to do with the collation.

What are you using if you use id's as upper/lower case as Test ?

Tuesday, March 27, 2012

Error 18452 Login failed for user <null>. The user account is not

We have a SQL 2005 installation using SQL and Windows Authentication. We
have a login that is mapped to a active directory group and has the
appropriate permissions to the database. However, when we try to create
an ODBC connection to the server from an XP client (and the user is a
member of the appropriate domain group) we get the above mentioned error.
Also logged on the SQL server is the following error:
SSPI handshake failed with error code 0x8009030c...
The only info I can find on this error has to do with IIS
configurations, but I don't see what IIS has to do with this as we are
only trying to make an ODBC connection.Maybe your service account is Local System.
You can change to AD Service account.
"Jan Leste"?? ??? ??:

> We have a SQL 2005 installation using SQL and Windows Authentication. We
> have a login that is mapped to a active directory group and has the
> appropriate permissions to the database. However, when we try to create
> an ODBC connection to the server from an XP client (and the user is a
> member of the appropriate domain group) we get the above mentioned error.
> Also logged on the SQL server is the following error:
> SSPI handshake failed with error code 0x8009030c...
> The only info I can find on this error has to do with IIS
> configurations, but I don't see what IIS has to do with this as we are
> only trying to make an ODBC connection.
>

Thursday, March 22, 2012

Error 1603 on Installation

The SQL Server installation has no default instance. It has an instance
called Reports. On installing RS it allowed selecting an instance so I
thought that everything was fine. When it came to configuring SQL Server
portion of the RS install I got an error 1603. This is Windows 2003 Server
and SQL Server 2000 Standard version 8.00.859
Any ideas of what to do?
Bruce L-CNevermind. I unistalled everything, cleaned up the registry and left over
files. Went into windows 2003 application server configuration and made sure
had everything. Reinstalled SQL Server default install and this time it
worked. Now everything went smoothly with RS installation. I think it didn't
like have no default installation for SQL Server.
Bruce L-C
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u1KifHXdEHA.228@.TK2MSFTNGP11.phx.gbl...
> The SQL Server installation has no default instance. It has an instance
> called Reports. On installing RS it allowed selecting an instance so I
> thought that everything was fine. When it came to configuring SQL Server
> portion of the RS install I got an error 1603. This is Windows 2003 Server
> and SQL Server 2000 Standard version 8.00.859
> Any ideas of what to do?
> Bruce L-C
>sql

Error 1603 installing MS SQL Server 2005 Beta 2 Setup Support

I got this beta and I get the following error upon installation. Has anyone
seen it? Can someone help me?
There is a separate and private NG for the beta - post your questions
there.
"TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
in message news:07FA498A-6B40-4D0E-B6ED-20E91F118C27@.microsoft.com...
> I got this beta and I get the following error upon installation. Has
anyone
> seen it? Can someone help me?
|||Thanks -- can you send me a URL that I can post to? Irocnially, I woke up
this morning and it worked -- weird --
"Scott Morris" wrote:

> There is a separate and private NG for the beta - post your questions
> there.
> "TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
> in message news:07FA498A-6B40-4D0E-B6ED-20E91F118C27@.microsoft.com...
> anyone
>
>
|||No - from what I've read in the newsgroups, that is in the email you
received when you registered.
"TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
in message news:E96800E4-1152-40C6-9568-568720813E19@.microsoft.com...[vbcol=seagreen]
> Thanks -- can you send me a URL that I can post to? Irocnially, I woke up
> this morning and it worked -- weird --
> "Scott Morris" wrote:
wrote[vbcol=seagreen]

Error 1603 installing MS SQL Server 2005 Beta 2 Setup Support

I got this beta and I get the following error upon installation. Has anyone
seen it? Can someone help me?There is a separate and private NG for the beta - post your questions
there.
"TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
in message news:07FA498A-6B40-4D0E-B6ED-20E91F118C27@.microsoft.com...
> I got this beta and I get the following error upon installation. Has
anyone
> seen it? Can someone help me?|||Thanks -- can you send me a URL that I can post to? Irocnially, I woke up
this morning and it worked :) -- weird --
"Scott Morris" wrote:
> There is a separate and private NG for the beta - post your questions
> there.
> "TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
> in message news:07FA498A-6B40-4D0E-B6ED-20E91F118C27@.microsoft.com...
> > I got this beta and I get the following error upon installation. Has
> anyone
> > seen it? Can someone help me?
>
>|||No - from what I've read in the newsgroups, that is in the email you
received when you registered.
"TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com> wrote
in message news:E96800E4-1152-40C6-9568-568720813E19@.microsoft.com...
> Thanks -- can you send me a URL that I can post to? Irocnially, I woke up
> this morning and it worked :) -- weird --
> "Scott Morris" wrote:
> > There is a separate and private NG for the beta - post your questions
> > there.
> >
> > "TryingToFigureItOut" <TryingToFigureItOut@.discussions.microsoft.com>
wrote
> > in message news:07FA498A-6B40-4D0E-B6ED-20E91F118C27@.microsoft.com...
> > > I got this beta and I get the following error upon installation. Has
> > anyone
> > > seen it? Can someone help me?
> >
> >
> >

Error 1603 During Installation

I'm encountering an error 1603 durring installation of Reporting Services
Enterprise Edition. I've read the knowledge base article about installing
without creating virtual directories but during that install, I get another
error. This error states 'This installation package could not be opened.
Verify that the package exists and that you can access it or contact the
application vendor to verify that this is a valid windows installer package.'
I'm pretty sure that I've specified the path to setup.exe and the .msi file
correctly in the command line. I've tried installing as me, a user with
administrative priveleges, and as Administrator and I receive the same error.
There are no log files written that I can see. Can anyone help me with this?
TIA
ErnieErnie,
I had same problem. I did this:
1. copied the the RS setup files to a folder named "ENT" root to the c
drive. This is the same drive as sql is installed.
2. from the command line in the "ENT" folder typed this EXACTLY:
setup /i "C:\ent\setup\rsrun.msi" RSDONOTCREATEVIRTUALDIRECTORIES=True
It worked. Before, I tried several different cominations of paths and
starting locations that did not work. I don't know why but this did the
trick. Hope it helps.
pepe
"ebferro" wrote:
> I'm encountering an error 1603 durring installation of Reporting Services
> Enterprise Edition. I've read the knowledge base article about installing
> without creating virtual directories but during that install, I get another
> error. This error states 'This installation package could not be opened.
> Verify that the package exists and that you can access it or contact the
> application vendor to verify that this is a valid windows installer package.'
> I'm pretty sure that I've specified the path to setup.exe and the .msi file
> correctly in the command line. I've tried installing as me, a user with
> administrative priveleges, and as Administrator and I receive the same error.
> There are no log files written that I can see. Can anyone help me with this?
> TIA
> Ernie|||Pepe:
Thanks for the suggestion but it still crashes with the same error message.
I guess I'm hosed.
Ernie
"pepe" wrote:
> Ernie,
> I had same problem. I did this:
> 1. copied the the RS setup files to a folder named "ENT" root to the c
> drive. This is the same drive as sql is installed.
> 2. from the command line in the "ENT" folder typed this EXACTLY:
> setup /i "C:\ent\setup\rsrun.msi" RSDONOTCREATEVIRTUALDIRECTORIES=True
> It worked. Before, I tried several different cominations of paths and
> starting locations that did not work. I don't know why but this did the
> trick. Hope it helps.
> pepe
>
> "ebferro" wrote:
> > I'm encountering an error 1603 durring installation of Reporting Services
> > Enterprise Edition. I've read the knowledge base article about installing
> > without creating virtual directories but during that install, I get another
> > error. This error states 'This installation package could not be opened.
> > Verify that the package exists and that you can access it or contact the
> > application vendor to verify that this is a valid windows installer package.'
> > I'm pretty sure that I've specified the path to setup.exe and the .msi file
> > correctly in the command line. I've tried installing as me, a user with
> > administrative priveleges, and as Administrator and I receive the same error.
> > There are no log files written that I can see. Can anyone help me with this?
> > TIA
> > Ernie|||Don't quit trying. I must have tried 25 times before it worked.
"ebferro" wrote:
> Pepe:
> Thanks for the suggestion but it still crashes with the same error message.
> I guess I'm hosed.
> Ernie
> "pepe" wrote:
> > Ernie,
> >
> > I had same problem. I did this:
> > 1. copied the the RS setup files to a folder named "ENT" root to the c
> > drive. This is the same drive as sql is installed.
> > 2. from the command line in the "ENT" folder typed this EXACTLY:
> >
> > setup /i "C:\ent\setup\rsrun.msi" RSDONOTCREATEVIRTUALDIRECTORIES=True
> >
> > It worked. Before, I tried several different cominations of paths and
> > starting locations that did not work. I don't know why but this did the
> > trick. Hope it helps.
> >
> > pepe
> >
> >
> > "ebferro" wrote:
> >
> > > I'm encountering an error 1603 durring installation of Reporting Services
> > > Enterprise Edition. I've read the knowledge base article about installing
> > > without creating virtual directories but during that install, I get another
> > > error. This error states 'This installation package could not be opened.
> > > Verify that the package exists and that you can access it or contact the
> > > application vendor to verify that this is a valid windows installer package.'
> > > I'm pretty sure that I've specified the path to setup.exe and the .msi file
> > > correctly in the command line. I've tried installing as me, a user with
> > > administrative priveleges, and as Administrator and I receive the same error.
> > > There are no log files written that I can see. Can anyone help me with this?
> > > TIA
> > > Erniesql

Sunday, February 26, 2012

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.

Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.

Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.

I get following error:

http://localhost/reportserver:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.

Event Viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reporting Services LogFiles:

w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)

Thankful for solution or any idea!

Regards, Jonas

Take a look at this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

|||

Thanks Trish!

If I stop Reporting Services service, restarts the IIS and starts the Reporting Services service again I get following error.

http://localhost/reportserver:

The event source "Report Server" does not exist. (rsEventLogSourceNotFound)

Reporting Services LogFiles:

w3wp!library!1!2006-02-24-16:08:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist.

After some minute I refresh the browser and now I get rsInternalError again.

(This behaviour is repeatable.)

It's possible that I have edit (no change!) the ASP.NET tab under properties for the ReportServer website in IIS 6. Why? Some of my first actions after discovering that the installation didn't work was to look in the IIS 6 MMC...

Any suggestions?

Regards, Jonas

|||

The only way we could fix the problem was to uninstall SQL Server and reinstall it.

We tried everything we could think of but it still didn't help. Now we know not to touch those settings!

|||

After hours of thinking, testing, googleing and head scratching I found a workaround.
I tried to change the Reporting Services application pool identity to a windows account. And it worked. This window account is a member of local administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as application pool identity for Reporting Services.

I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.

Any idea? Anyone?
I really would like to use the Network Service account as recommended by Microsoft.

Regards, Jonas

|||

Try my solution on the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1985313&SiteID=1

Regards

Denis

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.

Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.

Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.

I get following error:

http://localhost/reportserver:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.

Event Viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reporting Services LogFiles:

w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)

Thankful for solution or any idea!

Regards, Jonas

Take a look at this thread.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250225&SiteID=1

|||

Thanks Trish!

If I stop Reporting Services service, restarts the IIS and starts the Reporting Services service again I get following error.

http://localhost/reportserver:

The event source "Report Server" does not exist. (rsEventLogSourceNotFound)

Reporting Services LogFiles:

w3wp!library!1!2006-02-24-16:08:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "Report Server" does not exist.

After some minute I refresh the browser and now I get rsInternalError again.

(This behaviour is repeatable.)

It's possible that I have edit (no change!) the ASP.NET tab under properties for the ReportServer website in IIS 6. Why? Some of my first actions after discovering that the installation didn't work was to look in the IIS 6 MMC...

Any suggestions?

Regards, Jonas

|||

The only way we could fix the problem was to uninstall SQL Server and reinstall it.

We tried everything we could think of but it still didn't help. Now we know not to touch those settings!

|||

After hours of thinking, testing, googleing and head scratching I found a workaround.
I tried to change the Reporting Services application pool identity to a windows account. And it worked. This window account is a member of local administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as application pool identity for Reporting Services.

I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.

Any idea? Anyone?
I really would like to use the Network Service account as recommended by Microsoft.

Regards, Jonas

|||

Try my solution on the following thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1985313&SiteID=1

Regards

Denis

Error (rsInternalError) after installation

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
64bit SP1 Enterprise Edition.
Reporting Services Configuration Manager indicate that everything is ok,
green checks except Encryption Keys and Execution Account.
Reporting Services databases, ReportServer and ReportServerTempDB, is not
"installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
the same domain.
I get following error:
http://localhost/reportserver:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Object reference not set to an instance of an object.
Event Viewer:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2006-02-24
Time: 10:11:35
User: N/A
Computer: PRD128ASAL
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2006-02-24 10:11:35
Event time (UTC): 2006-02-24 09:00:25
Event ID: ac7dc3e0abc2412aab9566d56f81859e
Event sequence: 12
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\ReportServer\
Machine name: XXXXXXXXXX
Process information:
Process ID: 1900
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/reportserver
Request path: /reportserver
User host address: 127.0.0.1
User: DOMAIN\USERID
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at
Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
at
Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
sender, EventArgs e)
at
System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Custom event details:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Reporting Services LogFiles:
w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing. -->
System.NullReferenceException: Object reference not set to an instance of an
object.
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
-- End of inner exception stack trace --
w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
Exception thrown: System.NullReferenceException: Object reference not set to
an instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
Requests DB : System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at
Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
unused)
Thankful for solution or any idea!
Regards, JonasAfter hours of thinking, testing, googleing and head scratching I found a
workaround.
I tried to change the Reporting Services application pool identity to a
windows account. And it worked. This window account is a member of local
administrators. Haven't tried more restricted rights yet.
But documentation from Microsoft recommends to use Network Service as
application pool identity for Reporting Services.
I found this url interesting, http://support.microsoft.com/kb/896861/.
But I tried both workaround descibed whitout success.
Any idea? Anyone?
I really would like to use the Network Service account as recommended by
Microsoft.
Regards, Jonas
"JvG" wrote:
> I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003
> 64bit SP1 Enterprise Edition.
> Reporting Services Configuration Manager indicate that everything is ok,
> green checks except Encryption Keys and Execution Account.
> Reporting Services databases, ReportServer and ReportServerTempDB, is not
> "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in
> the same domain.
> I get following error:
> http://localhost/reportserver:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Object reference not set to an instance of an object.
> Event Viewer:
> Event Type: Warning
> Event Source: ASP.NET 2.0.50727.0
> Event Category: Web Event
> Event ID: 1309
> Date: 2006-02-24
> Time: 10:11:35
> User: N/A
> Computer: PRD128ASAL
> Description:
> Event code: 3005
> Event message: An unhandled exception has occurred.
> Event time: 2006-02-24 10:11:35
> Event time (UTC): 2006-02-24 09:00:25
> Event ID: ac7dc3e0abc2412aab9566d56f81859e
> Event sequence: 12
> Event occurrence: 7
> Event detail code: 0
> Application information:
> Application domain: /LM/W3SVC/1/root/ReportServer-1-127851854434156417
> Trust level: RosettaSrv
> Application Virtual Path: /ReportServer
> Application Path: C:\Program Files\Microsoft SQL
> Server\MSSQL.1\Reporting Services\ReportServer\
> Machine name: XXXXXXXXXX
> Process information:
> Process ID: 1900
> Process name: w3wp.exe
> Account name: NT AUTHORITY\NETWORK SERVICE
> Exception information:
> Exception type: NullReferenceException
> Exception message: Object reference not set to an instance of an object.
> Request information:
> Request URL: http://localhost/reportserver
> Request path: /reportserver
> User host address: 127.0.0.1
> User: DOMAIN\USERID
> Is authenticated: True
> Authentication Type: Negotiate
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Thread information:
> Thread ID: 1
> Thread account name: NT AUTHORITY\NETWORK SERVICE
> Is impersonating: True
> Stack trace: at
> Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object
> sender, EventArgs e)
> at
> System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
>
> Custom event details:
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Reporting Services LogFiles:
> w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException:
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing. -->
> System.NullReferenceException: Object reference not set to an instance of an
> object.
> at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> -- End of inner exception stack trace --
> w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed.
> Exception thrown: System.NullReferenceException: Object reference not set to
> an instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running
> Requests DB : System.NullReferenceException: Object reference not set to an
> instance of an object.
> at
> Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage()
> at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
> at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
> at
> Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object
> unused)
> Thankful for solution or any idea!
> Regards, Jonas

Error (re)installing Sql Server 2000

Hi,
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:

> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi

Error (re)installing Sql Server 2000

Hi,
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
--
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:
> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi