Wednesday, March 7, 2012
Error with Report Manager
"localhost/reportserver" is all right.
But With "localhost/reports" i have the following error:
--"The underlying connection was closed: The remote name could not be
resolved."
I have no more idea. Thanks !!Hello MIB,
Try accessing the Report Manager with https://<machinename>/Reports or
http://<machinename>/Reports
Peter Blackburn
www.sqlreportingservices.net
"MIB" <MIB@.discussions.microsoft.com> wrote in message
news:CB391524-0F0E-4FAB-A5D5-17467F120B02@.microsoft.com...
> Hi,
> "localhost/reportserver" is all right.
> But With "localhost/reports" i have the following error:
> --"The underlying connection was closed: The remote name could not be
> resolved."
> I have no more idea. Thanks !!|||Thanks for your helps.
I tried to access with the machinename, but it doesn't work.
I'm using Wondows Server 2003 (FAT 32 - It's stupid I know but i haven't
choose this configuration).
At the end of RS install, I had the following message : launch manually
report manager (How to do it?).
I need to access to the report mnager, i tried so many things and i have no
more idea.
"Peter Blackburn (www.sqlreportingservice" wrote:
> Hello MIB,
> Try accessing the Report Manager with https://<machinename>/Reports or
> http://<machinename>/Reports
> Peter Blackburn
> www.sqlreportingservices.net
> "MIB" <MIB@.discussions.microsoft.com> wrote in message
> news:CB391524-0F0E-4FAB-A5D5-17467F120B02@.microsoft.com...
> > Hi,
> > "localhost/reportserver" is all right.
> > But With "localhost/reports" i have the following error:
> >
> > --"The underlying connection was closed: The remote name could not be
> > resolved."
> >
> > I have no more idea. Thanks !!
>
>
Error with Registering a SQL Server 2000.
SQL Server from Enterprise Manager Standard 2000 client.
Invalid attribute/Option Identifier. If so, how have you
resolved it?
The error is usually related to an MDAC issue. Try
reapplying SP3a.
-Sue
On Wed, 24 Mar 2004 12:58:00 -0800, "Jackson_Greg"
<anonymous@.discussions.microsoft.com> wrote:
>Anyone heard of this error when attempting to Register a
>SQL Server from Enterprise Manager Standard 2000 client.
>Invalid attribute/Option Identifier. If so, how have you
>resolved it?
Error with Registering a SQL Server 2000.
SQL Server from Enterprise Manager Standard 2000 client.
Invalid attribute/Option Identifier. If so, how have you
resolved it?The error is usually related to an MDAC issue. Try
reapplying SP3a.
-Sue
On Wed, 24 Mar 2004 12:58:00 -0800, "Jackson_Greg"
<anonymous@.discussions.microsoft.com> wrote:
>Anyone heard of this error when attempting to Register a
>SQL Server from Enterprise Manager Standard 2000 client.
>Invalid attribute/Option Identifier. If so, how have you
>resolved it?
Sunday, February 26, 2012
Error with a fieldname that does not exist anymore.
[Microsoft][ODBC SQL Server Driver}[SQL Server]Invalid column name
'oldfieldname_eid'
While inserting in the Enterprise Manager. The 'oldfieldname_eid' does not
exist in any table of the target database. The error only occurs if an
insert trigger is defined. The insert trigger does not contain a string
resembling the 'oldfieldname_eid'. The name has been used in the past for a
field.
The error does reproduce, after a reset of the client, after setting the
database offline and online again.
The error does disappear when the trigger is 'removed' but reappears
again when the trigger is recreated. The error does not appear when
a 'dummy' trigger is used, only containing "print 'hello'"
Does anybody have a suggestion ?
ben brugmanIt would have been quite helpful if you had posted the text of the trigger,
because that seems to be where the problem is, now we have to make a guess.
One thing I can think of is if you have a view on the table that contained
the 'oldfieldname_eid' column, and that view contains SELECT *. The
definition of a view is not updated automatically when the underlying table
changes, so the column might still exist in the view definition.
Try SELECT table_name FROM information_schema.columns
WHERE column_name = 'oldfieldname_eid'
to find a view or table that includes a column with that name.
--
Jacco Schalkwijk
SQL Server MVP
"ben brugman" <ben@.niethier.nl> wrote in message
news:O$T6PNioDHA.2512@.TK2MSFTNGP09.phx.gbl...
> I get an :
> [Microsoft][ODBC SQL Server Driver}[SQL Server]Invalid column name
> 'oldfieldname_eid'
> While inserting in the Enterprise Manager. The 'oldfieldname_eid' does not
> exist in any table of the target database. The error only occurs if an
> insert trigger is defined. The insert trigger does not contain a string
> resembling the 'oldfieldname_eid'. The name has been used in the past for
a
> field.
> The error does reproduce, after a reset of the client, after setting the
> database offline and online again.
> The error does disappear when the trigger is 'removed' but reappears
> again when the trigger is recreated. The error does not appear when
> a 'dummy' trigger is used, only containing "print 'hello'"
> Does anybody have a suggestion ?
> ben brugman
>
>|||> Try SELECT table_name FROM information_schema.columns
> WHERE column_name = 'oldfieldname_eid'
The field 'oldfieldname_eid' does not appear in any View/table or trigger.
It does not appear anywhere anymore in the complete database.
There does not exist a field 'oldfieldname_eid'.
If we change the fieldname into 'AAAAAA' we get the following error
that the field 'newfieldname_eid' does not exist
> > [Microsoft][ODBC SQL Server Driver}[SQL Server]Invalid column name
> > 'newfieldname_eid'
> It would have been quite helpful if you had posted the text of the
trigger,
> because that seems to be where the problem is, now we have to make a
guess.
For the trigger see the end of the message.
Adding a new column to the table with 'newfieldname_eid' next to 'AAAAAA'
and
then deleting the 'AAAAAA' field did solve the problem. We expect that the
count
of columns did have a mismatch in the internal meta data and that this was
solved
by adding and deletion of columns. (But this is a guess).
(The table appears to be exactly as when the error occured but the error is
'gone').
(probably a bug).
We still would like to know what happened !
ben brugman
The trigger.
The trigger :
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER [TR_I_Tabel2] ON dbo.Tabel1
FOR INSERT
NOT FOR REPLICATION
AS
INSERT INTO
Tabel2 (Field1, Field2, Field3, Field4, Field5, Field6)
SELECT
Field1, Field2, Field3, current_Field4, current_Field5, current_Field6
FROM inserted
UPDATE
Tabel1
SET
Field7 =NULL
FROM
Tabel1
INNER JOIN
inserted
ON
Tabel1.Field3 = inserted.Field3
INNER JOIN
Table3
ON
Table3.Field4 = inserted.current_Field4
WHERE
Table3.status_nbr >= 50
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
> Jacco Schalkwijk
> SQL Server MVP
>
> "ben brugman" <ben@.niethier.nl> wrote in message
> news:O$T6PNioDHA.2512@.TK2MSFTNGP09.phx.gbl...
> > I get an :
> >
> > [Microsoft][ODBC SQL Server Driver}[SQL Server]Invalid column name
> > 'oldfieldname_eid'
> >
> > While inserting in the Enterprise Manager. The 'oldfieldname_eid' does
not
> > exist in any table of the target database. The error only occurs if an
> > insert trigger is defined. The insert trigger does not contain a string
> > resembling the 'oldfieldname_eid'. The name has been used in the past
for
> a
> > field.
> > The error does reproduce, after a reset of the client, after setting the
> > database offline and online again.
> >
> > The error does disappear when the trigger is 'removed' but reappears
> > again when the trigger is recreated. The error does not appear when
> > a 'dummy' trigger is used, only containing "print 'hello'"
> >
> > Does anybody have a suggestion ?
> >
> > ben brugman
> >
> >
> >
>
Error whils accessing Report Manager through browser
Hi friends ,
We are using SQL Server Reporting Services 2005. When I want to access Report Server through browser I am giving IP address as
http://<servername>/ReportServer
this is working fine
but when I want to access Report Manager and when I am giving IP address as
http://<servername>/Reports
I am getting error as followes :
The configuration file contains an element that is not valid. The configuration element is not a configuration file element.
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.Exception: The configuration file contains an element that is not valid. The configuration element is not a configuration file element.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[Exception: The configuration file contains an element that is not valid. The configuration element is not a configuration file element.] Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +135
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Where I am going wrong.
we are now in the stage of deploying and we are getting this kind of errors
can you help me out ?
sandeey
Hi,
seems that you screwed up the configuration files. To see which one is corrupted (your web services seems to work), navigate to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager or the appropiate path in your installation and validate the XML files by the schema mentioned in the header of the file.
If you have no tools to validate through the schema, you can also take a fresh and working file from antoher instalaltion and look for typos or any things that are different to your damaged file.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Friday, February 24, 2012
Error while trying to open/create a DTS - urgent
I have MSDE SP3 installed and the only thing that I have changed
recently is my Windows login Password.
In the Enterprise Manager the SQL server is registered using mixed
authentication.
When I try to open any DTS in Design mode, I get an error dialog with
the title 'DTS Design error' and saying that:
"Error occured during creation of a DTS package"
and then when I click on the OKAY button I get the 2nd error dialog
saying:
"The selected package cannot be opened. The DTS designer has been
closed."
I am getting the same message when I try to create a new package

Can someone PLEASE help me out here.
Thanks.
Re-register the DTS dlls.
You can find them listed here
Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Learner" <wantnospam@.email.com> wrote in message
news:MPG.1bc14741c6d2435e989747@.msnews.microsoft.c om...
> Hi,
> I have MSDE SP3 installed and the only thing that I have changed
> recently is my Windows login Password.
> In the Enterprise Manager the SQL server is registered using mixed
> authentication.
> When I try to open any DTS in Design mode, I get an error dialog with
> the title 'DTS Design error' and saying that:
> "Error occured during creation of a DTS package"
>
> and then when I click on the OKAY button I get the 2nd error dialog
> saying:
> "The selected package cannot be opened. The DTS designer has been
> closed."
>
> I am getting the same message when I try to create a new package

> Can someone PLEASE help me out here.
> --
> Thanks.
|||Many thanks Allan. Appreciate your help.
Regards.
> | Re-register the DTS dlls.
> |
> | You can find them listed here
> |
> | Redistributing DTS with your program
> | (http://www.sqldts.com/Default.aspx?225)
> |
> |
Friday, February 17, 2012
Error while i register from Enterprise manager
Although i have a login account in the SQL server and also i am able
to connect via my application, but somehow when i try to register the
server from the enterprise manager i get the following message
SQL Server registration failed because of the connection failure
displayed below. Do you wish to Register anyway ?
[SQL-DMO]Code execution exception: exception_access_violation"
I am stuck up..
Can anyone suggest me a solution for this problem.
Kind Regards,
Amit KumarThere is an exception logged in the SQL Server errorlog. There probably
will not be much there to help you resolve the problem but Microsoft
support can probably decipher it.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Wednesday, February 15, 2012
Error while executing reports from report manager
Hi..
I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as I click on any report on the report manager.
I am not able to find the cause of the error.
Does anybody have any suggestions?
Thanks ,
Viva
Viva1
Try checking your C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config and make sure you have the below settings:
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</appSettings>
Ham
|||Hi.
Thanks for your reply. I checked the web.config.. It has the settings that you have specified.
Still it does not work.
Any other suggestions for the problem?
Viva
|||Viva1
In the directory C:\Program Files\Microsoft SQL Server\MSSQL.1 is a logfile directory for Reporting Service. In this directory, is a reporting service application log file and normally contains a more descriptive error message. It would be helpful to know what its contains.
Ham
|||Ham,
Thanks for that. I shall take a look into that file and try to find out the issue.
ViVa
Error while connecting Analysis Manager
I try to connect a distant analysis manager server. My user is declared as Administrators in the distant server. I'm Administartor too on my PC
When I try to connect this server (via IP adress) a error appears :
Cannot connect to the repository
Analysis server : ip adress here
Error:
'\\<nameOfDistantServer>\MSOLAPRepository$\msdrep.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on wich the file resides.
Someone can help me ?
Thanks
moustachuRefer to the registry for the key [HKLM\Software\Microsoft\OLAP Server\Server ConnectionInfo\RemoteRepositoryConnectionString] and edit the value with the valid path.|||I will try as soon as possible
Thanks
Error while connecting after restarting the PC
Hi,
I am running SQL Server Enterprise manager. I was able to connected to the database properly. But after restarting the PC I am getting the following error.
"System.NullReferenceException: Object reference not set to an instance of an object"
The following event where logged in event viewer.
under security: 560, 562, 538, 528.
under system: 7035, 7036
could anbody give hint how to solve this issue?
Do you have the call stack for the exception? If so, can you post it here. It might be helpful to identify the issue.
Thanks,
Junfeng
|||Hi,
Thanks for taking interest.Please see the description below.
We are using the tool sequencer. which will be running in the client & server.
It will get informations from the sql server database.
There is a field in database to set the PCID. I don't know, there is some problem in updating the PCID field in database.
See the below call stack exceptions.
I am not getting this problem from all the PC. I am able to access sucessfully from 2 PC. (Any how I haven't restarted these PC's).
04 May 2007 12:10:39,841 [2676] INFO Sequencer.Backend.Perspective.Configuration (null) - Set active database to server=BLRKCCBD.in002.siemens.net;Integrated Security=SSPI;database=Sequencer VIL DB
04 May 2007 12:10:39,841 [2676] INFO Sequencer.Backend.Perspective.Configuration (null) - Set language to english
04 May 2007 12:10:39,841 [2676] INFO Sequencer.Backend.Perspective.Configuration (null) - Set testling version to IMP version 01.02.01.T208 at 09.06.2005
04 May 2007 12:10:47,435 [2676] FATAL Sequencer.Backend.DBAccess.TestElementPool (null) - Error setting PCID for user.
System.NullReferenceException: Object reference not set to an instance of an object.
at Sequencer.Backend.DBAccess.UserPool.SetUserPCID(String pcid)
04 May 2007 12:10:47,716 [2676] FATAL Sequencer.Backend.DBAccess.TestElementPool (null) - Error on loading TestElement data.
System.Exception: error: > System.NullReferenceException: Object reference not set to an instance of an object.
at Sequencer.Backend.DBAccess.UserPool.SetUserPCID(String pcid)
End of inner exception stack trace
at Sequencer.Backend.DBAccess.UserPool.SetUserPCID(String pcid)
at Sequencer.Backend.DBAccess.UserPool.GetInstance(Int32 dbId)
at Sequencer.Backend.DBAccess.TestElementPool.LoadData(Int32 dbId)
04 May 2007 12:12:44,728 [2676] FATAL Sequencer.UI.MainWindow (null) - Error in system
System.Exception: Error during startup!! > System.Exception: error: > System.Exception: error: > System.NullReferenceException: Object reference not set to an instance of an object.
at Sequencer.Backend.DBAccess.UserPool.SetUserPCID(String pcid)
End of inner exception stack trace
at Sequencer.Backend.DBAccess.UserPool.SetUserPCID(String pcid)
at Sequencer.Backend.DBAccess.UserPool.GetInstance(Int32 dbId)
at Sequencer.Backend.DBAccess.TestElementPool.LoadData(Int32 dbId)
End of inner exception stack trace
at Sequencer.Backend.DBAccess.TestElementPool.LoadData(Int32 dbId)
at Sequencer.Backend.DBAccess.TestElementPool.GetInstance(Int32 dbId)
at Sequencer.Backend.DBAccess.TestElementPool.GetInstance(String dbName)
at Sequencer.UI.MainWindow.GetInstance()
End of inner exception stack trace
at Sequencer.UI.MainWindow.GetInstance()
at Sequencer.UI.MainWindow.Main()
Kind Regards
Siva.P