Showing posts with label sqlserver. Show all posts

Tuesday, March 27, 2012

analysis services

Which version of the sqlserver comes with analysis server? how do we setupAnalysis services comes with SQL 7 and SQL 2k..
Simply load the CD ( with autorun set) and you will get an option to setup
SQL Server or Analysis services...
"jbomma" <jbomma@.clayton.com> wrote in message
news:uWAQFXz6DHA.1556@.tk2msftngp13.phx.gbl...
> Which version of the sqlserver comes with analysis server? how do we setup
>sql

Analysis Services

I was at a Microsoft sales presentation last week for the new version
of SQL Server, Yukon. They had an extensive presentation on SQL
Server and Reporting Services but didn't mention Analysis Services.
When I asked about the future of the product the MS Sales rep couldn't
give me any info. When I looked at the big product chart I got at the
presntation, Analysis Services wasn't on it. There was just box
refering to Reporting Services and XML. Does anyone know what or if
there is a future for Analysis Services?BruceGilpin (brucegilpin@.ameritech.net) writes:
> I was at a Microsoft sales presentation last week for the new version
> of SQL Server, Yukon. They had an extensive presentation on SQL
> Server and Reporting Services but didn't mention Analysis Services.
> When I asked about the future of the product the MS Sales rep couldn't
> give me any info. When I looked at the big product chart I got at the
> presntation, Analysis Services wasn't on it. There was just box
> refering to Reporting Services and XML. Does anyone know what or if
> there is a future for Analysis Services?

I'm not into Analysis Services myself, but on the Yukon events I have
been, there have been plenty of sessions about Analysis Services, so
I'm confident to say that it has a bright and lively future.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

Sunday, March 25, 2012

analysis services

quote:

> Which version of the sqlserver comes with analysis server? how do we setup
>

sql

Analysis server for Business people

How can we impliment the sqlserver analysis to the customer site for analysing the transaction. Please provide me the solution for this. Is it possible for the business people use this analysis server for their transaction. What we have to do to impliment this in customer site .

Please kindly advice

Try to talk to microsoft consulting serivces in your area for help with implementing solution to analyze your transactional data. I am sure they would help you to come up with some ideas and will help you implementing them.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Tuesday, March 20, 2012

An up-to-the-point recovery .Is it possible with MS SQLserver?

I asked how to apply the latest log when DB is crashed.
Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
But if both .mdf and .ldf are not avaible.what to do..
Informix way of backup
1)automaticaly backup its log when the log is full,(instead of based on
schedule)
2)backup its log when the server is crashed.
I hope Sql-server can handle it this way.is it possible?
Thanks!If the server has crashed how could it reliably make a backup? If you have
lost your disks or files, then you have no option but to go to a tape (or
other remote location) for a backup file(s). Which is why it is so
important to use a fault tolerant disk subsystem.
If you haven't lost the files, then you should be able to make a backup of
the log using the NO_TRUNCATE option and then use that backup and any
previous log backup files to recover to the point of the crash.
"Straight" <someone@.> wrote in message
news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> I asked how to apply the latest log when DB is crashed.
> Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE option"
> But if both .mdf and .ldf are not avaible.what to do..
> Informix way of backup
> 1)automaticaly backup its log when the log is full,(instead of based on
> schedule)
> 2)backup its log when the server is crashed.
> I hope Sql-server can handle it this way.is it possible?
> Thanks!
>|||If i split .mdf and .ldf on diffrent disks.
.mdf was damaged ,.ldf was fine
I restore the latest DB backup ,can i rollfoward with the intact .ldf on the
diffrent good disk ?.
How ?because i found £¢backup log with no_truncate£¢ is impossible while the
DB is not running.
Thank you!
"Don Peterson" <no1@.nunya.com> Ð´ÈëÓÊ¼þ
news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> If the server has crashed how could it reliably make a backup? If you
have
> lost your disks or files, then you have no option but to go to a tape (or
> other remote location) for a backup file(s). Which is why it is so
> important to use a fault tolerant disk subsystem.
> If you haven't lost the files, then you should be able to make a backup of
> the log using the NO_TRUNCATE option and then use that backup and any
> previous log backup files to recover to the point of the crash.
> "Straight" <someone@.> wrote in message
> news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > I asked how to apply the latest log when DB is crashed.
> > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
option"
> > But if both .mdf and .ldf are not avaible.what to do..
> >
> > Informix way of backup
> > 1)automaticaly backup its log when the log is full,(instead of based on
> > schedule)
> > 2)backup its log when the server is crashed.
> >
> > I hope Sql-server can handle it this way.is it possible?
> >
> > Thanks!
> >
> >
>|||Backup log with no truncate behaves correctly at sql server 2000, in as =much as you can back up the lock even when the mdf is unavailable. =(provided you are in full recovery model - in bulk logged the mdf will =be required if any statements that operate in minimally_logged mode have =occured since the changes for these will need to be extracted by using =the bulk-change-map from the mdf). At 7 the primary filegroup mdf was =also required since the table sysfiles was stored there which has =details of what files make up the db - this was modified at 2000 by =introducing sysaltfiles in the master db to shadow the contents of =sysfiles.
So - backup log with no truncate WILL be fine provided one of master or =the primary mdf is available. To ensure this put master on different =drive to user databases, and put logs on raid 1 so at least one copy of =the log will survive a disc failure, (Logs on separate spindle to mdf as =well of course)
Mike John
"Straight" <someone@.> wrote in message =news:eS0FB4OLEHA.1192@.TK2MSFTNGP11.phx.gbl...
> If i split .mdf and .ldf on diffrent disks.
> .mdf was damaged ,.ldf was fine
> I restore the latest DB backup ,can i rollfoward with the intact .ldf =on the
> diffrent good disk ?.
> > How ?because i found =A3=A2backup log with no_truncate=A3=A2 is =impossible while the
> DB is not running.
> > Thank you!
> > > > "Don Peterson" <no1@.nunya.com> =D0=B4=C8=EB=D3=CA=BC=FE
> news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> > If the server has crashed how could it reliably make a backup? If =you
> have
> > lost your disks or files, then you have no option but to go to a =tape (or
> > other remote location) for a backup file(s). Which is why it is so
> > important to use a fault tolerant disk subsystem.
> >
> > If you haven't lost the files, then you should be able to make a =backup of
> > the log using the NO_TRUNCATE option and then use that backup and =any
> > previous log backup files to recover to the point of the crash.
> >
> > "Straight" <someone@.> wrote in message
> > news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > > I asked how to apply the latest log when DB is crashed.
> > > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
> option"
> > > But if both .mdf and .ldf are not avaible.what to do..
> > >
> > > Informix way of backup
> > > 1)automaticaly backup its log when the log is full,(instead of =based on
> > > schedule)
> > > 2)backup its log when the server is crashed.
> > >
> > > I hope Sql-server can handle it this way.is it possible?
> > >
> > > Thanks!
> > >
> > >
> >
> >
> >|||Also, if the whole SQL Server goes down (cannot start it), then you can still get up to minute recovery. You
take another SQL Server installation, create a database with same file structure. Stop that SQL Server. Delete
the database file. Then "slide" in the log file from the crashed SQL Server, and then do the log backup using
the no_truncate option. There's a KB on this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:e5yHLTPLEHA.2260@.TK2MSFTNGP09.phx.gbl...
Backup log with no truncate behaves correctly at sql server 2000, in as much as you can back up the lock even
when the mdf is unavailable. (provided you are in full recovery model - in bulk logged the mdf will be
required if any statements that operate in minimally_logged mode have occured since the changes for these will
need to be extracted by using the bulk-change-map from the mdf). At 7 the primary filegroup mdf was also
required since the table sysfiles was stored there which has details of what files make up the db - this was
modified at 2000 by introducing sysaltfiles in the master db to shadow the contents of sysfiles.
So - backup log with no truncate WILL be fine provided one of master or the primary mdf is available. To
ensure this put master on different drive to user databases, and put logs on raid 1 so at least one copy of
the log will survive a disc failure, (Logs on separate spindle to mdf as well of course)
Mike John
"Straight" <someone@.> wrote in message news:eS0FB4OLEHA.1192@.TK2MSFTNGP11.phx.gbl...
> If i split .mdf and .ldf on diffrent disks.
> .mdf was damaged ,.ldf was fine
> I restore the latest DB backup ,can i rollfoward with the intact .ldf on the
> diffrent good disk ?.
> How ?because i found £¢backup log with no_truncate£¢ is impossible while the
> DB is not running.
> Thank you!
>
> "Don Peterson" <no1@.nunya.com> Ð´ÈëÓÊ¼þ
> news:ezcF34MLEHA.1120@.TK2MSFTNGP11.phx.gbl...
> > If the server has crashed how could it reliably make a backup? If you
> have
> > lost your disks or files, then you have no option but to go to a tape (or
> > other remote location) for a backup file(s). Which is why it is so
> > important to use a fault tolerant disk subsystem.
> >
> > If you haven't lost the files, then you should be able to make a backup of
> > the log using the NO_TRUNCATE option and then use that backup and any
> > previous log backup files to recover to the point of the crash.
> >
> > "Straight" <someone@.> wrote in message
> > news:uUjm5sMLEHA.340@.TK2MSFTNGP11.phx.gbl...
> > > I asked how to apply the latest log when DB is crashed.
> > > Tibor Karaszi suggested to "do a log backup using the NO_TRUNCATE
> option"
> > > But if both .mdf and .ldf are not avaible.what to do..
> > >
> > > Informix way of backup
> > > 1)automaticaly backup its log when the log is full,(instead of based on
> > > schedule)
> > > 2)backup its log when the server is crashed.
> > >
> > > I hope Sql-server can handle it this way.is it possible?
> > >
> > > Thanks!
> > >
> > >
> >
> >
>

An OLE DB error has occurred - Description: "Class not registered"

I have a package the connection of which is defined in a config file. When the source is on SQLserver, the package executes fine but when i change the connection to Oracle then i am getting this error.

TITLE: Microsoft Visual Studio

Error at DMND_PROBS_EXTRACT [Connection manager "DLWSDV18.PM"]: An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error at DMND_PROBS_EXTRACT [DEMANDPROBLEMDETAILS [1]]: The AcquireConnection method call to the connection manager "DLWSDV18.PM" failed with error code 0xC0202009.

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

Please let me know if theres any solutions.

Thanks,

Vipul

Do you have the Oracle client tools installed?|||Yes Phil, there was some problem with my oracle install. I re-installed it and it worked.

Monday, March 19, 2012

An internal error occurred on the report server. See the error log for more details. (rsInternal

Hello everybody,

I am trying to use the reporting services on Windows 2003 with SQLServer 2005. Everything works fine in the report manager and I can access and render the reports without any problem. But when I try to access the reports directly with the URL from the ReportServer, I get the following error :

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found

SQL Server Reporting Services

So I went to see the error log, and here is what it says :

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_10_2006_13_43_22.log</Path>
<SystemName>VODAFONE</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!5!11/10/2006-13:43:23:: i INFO: Reporting Web Server started
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!10/11/2006-13:43:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!5!10/11/2006-13:43:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
End of inner exception stack trace
w3wp!library!5!10/11/2006-13:43:25:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!10/11/2006-13:43:26:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!webserver!5!11/10/2006-13:43:34:: i INFO: Reporting Web Server stopped

Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?

Thanks very much in advance.

[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]

Have you added / defined a ReportViewerServerConnection key in the <appSettings> for ReportServer's web.config file?

If yes, can you remove it and try agan?

thanx,
Prash

|||

Hi,

First, thank you for answering.

Actually I haven't any <appsetings> in the ReportServer's web.config file. I have that in the ReportManager, which works fine, but not in the ReportServer.

Here is my web.config file for the Report Server :

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

<system.diagnostics>

</switches>

</system.diagnostics>

</RStrace>

<system.web>

</assemblies>

</compilation>

</httpHandlers>

</securityPolicy>

</system.web>

<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"

publicKeyToken="89845dcd8080cc91"

culture="neutral" />

<bindingRedirect oldVersion="8.0.242.0"

newVersion="9.0.242.0"/>

9.00.1399.00

</dependentAssembly>

</assemblyBinding>

</runtime>

</configuration>

If any of you has any suggestion, I already spent a few hours on that problem...

|||

Found a solution here

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/a22799e1a354ea79/9aca125282998795

This fix works assuming that the IIS virtual server that reporting services is installed on uses the same home directory as the Report Manager (in which case the ReportServer web.config inherits the settings from its parent).

An internal error occurred on the report server. See the error log for more details. (rsInternal

Hello everybody,

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found

SQL Server Reporting Services

So I went to see the error log, and here is what it says :

Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?

Thanks very much in advance.

[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]

Have you added / defined a ReportViewerServerConnection key in the <appSettings> for ReportServer's web.config file?

If yes, can you remove it and try agan?

thanx,
Prash

|||

Hi,

First, thank you for answering.

Actually I haven't any <appsetings> in the ReportServer's web.config file. I have that in the ReportManager, which works fine, but not in the ReportServer.

Here is my web.config file for the Report Server :

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

<system.diagnostics>

</switches>

</system.diagnostics>

</RStrace>

<system.web>

</assemblies>

</compilation>

</httpHandlers>

</securityPolicy>

</system.web>

<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"

publicKeyToken="89845dcd8080cc91"

culture="neutral" />

<bindingRedirect oldVersion="8.0.242.0"

newVersion="9.0.242.0"/>

9.00.1399.00

</dependentAssembly>

</assemblyBinding>

</runtime>

</configuration>

If any of you has any suggestion, I already spent a few hours on that problem...

|||

Found a solution here

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/a22799e1a354ea79/9aca125282998795

An internal error occurred on the report server. See the error log for more details. (rsInte

Hello everybody,

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

SQL Server Reporting Services

So I went to see the error log, and here is what it says :

Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?

Thanks very much in advance.

[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]

Have you added / defined a ReportViewerServerConnection key in the <appSettings> for ReportServer's web.config file?

If yes, can you remove it and try agan?

thanx,
Prash

|||

Hi,

First, thank you for answering.

Actually I haven't any <appsetings> in the ReportServer's web.config file. I have that in the ReportManager, which works fine, but not in the ReportServer.

Here is my web.config file for the Report Server :

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

<system.diagnostics>

</switches>

</system.diagnostics>

</RStrace>

<system.web>

</assemblies>

</compilation>

</httpHandlers>

</securityPolicy>

</system.web>

<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"

publicKeyToken="89845dcd8080cc91"

culture="neutral" />

<bindingRedirect oldVersion="8.0.242.0"

newVersion="9.0.242.0"/>

9.00.1399.00

</dependentAssembly>

</assemblyBinding>

</runtime>

</configuration>

If any of you has any suggestion, I already spent a few hours on that problem...

|||

Found a solution here

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/a22799e1a354ea79/9aca125282998795

Sunday, March 11, 2012

An EXCEPTION_ACCESS_VIOLATION during a DELETE...

quote:

> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.

The

quote:

> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for

your

quote:

> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>

An EXCEPTION_ACCESS_VIOLATION during a DELETE...

Our customers server uses SQLServer 7sp4. I don't know too much about the
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.
The
> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for
your
> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>

Thursday, March 8, 2012

An error has occurred while establishing a connection to the server

Hi I have just reinstalled .Net and SqlServer2005. I am running my application from local machine and sqlserver is also install local machine. but when I run application. Get follwing Error Message Sad

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What was the application trying to do when you got this message? It may be that the connection string is not correct, it may be that the server is setup for only windows authentication.

|||

From your description, it seems that you met error when you are trying to connect to your SQLServer,right?

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

For this kind of issue, we should use the following steps to diagnose the problem.

First, you also should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.

Generally, you can try the following ways to handle your problem.

1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall

More details for each step, you may see the following link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Thanks.

Wednesday, March 7, 2012

An architecture question on replication

I have a large central server. I need to replicate the data to around 50
smaller sqlserver at various locations. The subscription is decided by a join
between two tables and the where clause is a specific location_id. The larger
table in central DB is around 200 million rows and the local DB is 200/50= 4
million rows/local DB.
Since i need to do a join two tables, i think i cannot use transaction
replication, need to go with merge replication. What i found is when i create
multiple publication(right now just 2) and all merge agents running on
publisher, it takes out too much resource. So i am worried about going with
an approach of 50 publications .
I tried the option of running merge agents at subscriber, a single
publication differentiate by HOST_NAME. I couldn't make it work.
Please give your thoughts, what could be my best approach for this problem.
(or i could go a .net solution using msmq or SSB)
You can do a join as part of a filter in transactional replication. Please
provide more info about the join and I can write a udf to do it.
For merge replication you need to limit the number of concurrent merge
agents, and possibly use a hierarchy.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"skv" <skv@.discussions.microsoft.com> wrote in message
news:89ADE585-E17C-4C9C-9A5A-6A49305AA398@.microsoft.com...
>I have a large central server. I need to replicate the data to around 50
> smaller sqlserver at various locations. The subscription is decided by a
> join
> between two tables and the where clause is a specific location_id. The
> larger
> table in central DB is around 200 million rows and the local DB is 200/50=
> 4
> million rows/local DB.
> Since i need to do a join two tables, i think i cannot use transaction
> replication, need to go with merge replication. What i found is when i
> create
> multiple publication(right now just 2) and all merge agents running on
> publisher, it takes out too much resource. So i am worried about going
> with
> an approach of 50 publications .
> I tried the option of running merge agents at subscriber, a single
> publication differentiate by HOST_NAME. I couldn't make it work.
> Please give your thoughts, what could be my best approach for this
> problem.
> (or i could go a .net solution using msmq or SSB)
>
|||Dynamic filtering is now pretty straightforward in SQL 2005. Please see this
article for some relevant info and screenshots:
http://www.replicationanswers.com/MergeChangesArticle1.asp
To minimise proc congestion, you could have the merge agents run on the
subscribers (pull), stagger the sync times and as Hilary mentions limit the
number of concurrent merge agents.
HTH,
Paul Ibison
|||query1
select *
from customer
where base_loc=1
query2
select B.*
from customer A,customer_preference B
where A.customer_id=B.customer_id
and A.base_loc=1
this select will return 4 million and customer_preference table will have
200 million rows . I need to create 50 transactional replication/or merge
replication to replicate to 50 locations. What are your thoughts about
performance.
Thanks
"Hilary Cotter" wrote:

> You can do a join as part of a filter in transactional replication. Please
> provide more info about the join and I can write a udf to do it.
> For merge replication you need to limit the number of concurrent merge
> agents, and possibly use a hierarchy.
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "skv" <skv@.discussions.microsoft.com> wrote in message
> news:89ADE585-E17C-4C9C-9A5A-6A49305AA398@.microsoft.com...
>
>
|||Given that you have a large number of records and a largish number of
subscribers I'd create 50 publications each with a static filter. Dynamic
filters are not as optimised and this route could end up being slow. 50
publications is not unmanageable and the processing could be offloaded by
having the subscriptions all set up as pull ones.
HTH,
Paul Ibison
|||So you are recommending me a merge replication with the merge agent running
on subscriber.
What are the advantages of merge over transactional replication for my
scenario. (still i have not figured out how to create a join for
transactional replication)
Thanks
"Paul Ibison" wrote:

> Given that you have a large number of records and a largish number of
> subscribers I'd create 50 publications each with a static filter. Dynamic
> filters are not as optimised and this route could end up being slow. 50
> publications is not unmanageable and the processing could be offloaded by
> having the subscriptions all set up as pull ones.
> HTH,
> Paul Ibison
>
|||I'm assuming that you have updating subscribers. For such a large number of
updating subscribers, merge is the preference. There are other advantages
over queued updating subscribers inc it handles updates to BLOBS, has more
conflict resolvers.
HTH,
Paul Ibison
|||thanks for the reply. i am surprised to see insert/update/delete triggers on
the table for merge replication. This can cause performance issue.
Can we use transactional replication with joins, which doesn't use triggers.
Your thoughts.
Thanks
"Paul Ibison" wrote:

> I'm assuming that you have updating subscribers. For such a large number of
> updating subscribers, merge is the preference. There are other advantages
> over queued updating subscribers inc it handles updates to BLOBS, has more
> conflict resolvers.
> HTH,
> Paul Ibison
|||But we are designing the sytem such a way that subscriber never will change
the data, so we can avoid merges. I like to see less overhead on publisher,
because it needs to handle 50 publication. Your thoughts.
Thanks
skv
"Paul Ibison" wrote:

> For either method (merge or transactional with updating subscribers) there
> will be an overhead at the subscriber end. Can I just confirm that the
> subscribers will be editing data?
> Cheers,
> Paul Ibison
>
>
|||OK - as far as I can tell from your explanations, you have 50 subscribers
which don't update data and which each have a different subset of data. In
this case I'd set up 50 Transactional publications, each having one
subscriber and each defined to take a different set of data.
HTH,
Paul Ibison

Sunday, February 19, 2012

Amending a stored procedure

I have a stored procedure that I have deployed with a database to an sqlserver. To access the database and the stored procedure I am now using SQL Server Management Studio Express. When I was amending the stored procedure locally, I simply "opened" it, made the amendments and then "saved" it. With S.M.S.E. if you click on "modify" a SQLQuery opens up and then after making the amendments you can save the SQLQuery. How do you go from here to effect that change to the stored procedure resident on the sqlserver.

Chris

I've worked out that all I have to do is run the query after amending the stored procedure detail.

Chris

|||

When you click the Modify button, it should show you the stored procedure and it will have an ALTER PROCEDURE command at the top. This just tells the database that you want to overwrite the existing stored procedure with whatever text follows. So, if you click the Execute button (it should have an exclamation mark next to it) the command should execute against the database and your stored procedure will be updated.

Tuesday, March 27, 2012

analysis services

Analysis Services

Sunday, March 25, 2012

analysis services

Analysis server for Business people

Tuesday, March 20, 2012

An up-to-the-point recovery .Is it possible with MS SQLserver?

An up-to-the-point recovery .Is it possible with MS SQLserver?

An up-to-the-point recovery .Is it possible with MS SQLserver?

An OLE DB error has occurred - Description: "Class not registered"

Monday, March 19, 2012

An internal error occurred on the report server. See the error log for more details. (rsInternal

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternal

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInte

Reporting Services Error

Sunday, March 11, 2012

An EXCEPTION_ACCESS_VIOLATION during a DELETE...

An EXCEPTION_ACCESS_VIOLATION during a DELETE...

Thursday, March 8, 2012

An error has occurred while establishing a connection to the server

Wednesday, March 7, 2012

An architecture question on replication

Sunday, February 19, 2012

Amending a stored procedure

SQL Alternative to cursor

Blog Archive

About Me