I'm running Outlook 2003 on a Win 2kServer machine.
When setting up a rule, what is the purpose of the "this machine only"
option? I did not notice this option in previous versions of Outlook. Why
would someone setup a rule without this option? What is the effect if this
option is not selected? Is it possible to share rules between different
machines?
For the "Stop processing more rules" - I'm assuming that this option is only
executed when the rule matches. For example, if rule #1 says "if sender is
abc@.xyz.com, move this message to xyz folder, and stop processing more
rules", and the message is not from that sender, shouldn't Outlook then move
on to rule #2? Also, if you get a hit on a rule with incoming message
number 1, shouldn't the rules start again from the top for message #2, or
does the "stop processing more rules" keep this from happening? I'm seeing
a situation where, when I get some new messages, it appears that the rules
don't immediately run. I can't tell if one of them is firing then the rules
stop processing the rest of the messages. If I go and click the
Send/Receive button, the rules will all run.
Thanks,
John Schneider
Sorry! I inadvertently posted this to the wrong newsgroup.
"John Schneider" <JohnDONTSPAMME.Schneider@.eWebITNOSPAM.Kom> wrote in
message news:eTTXupW0EHA.2676@.TK2MSFTNGP12.phx.gbl...
> I'm running Outlook 2003 on a Win 2kServer machine.
> When setting up a rule, what is the purpose of the "this machine only"
> option? I did not notice this option in previous versions of Outlook.
Why
> would someone setup a rule without this option? What is the effect if
this
> option is not selected? Is it possible to share rules between different
> machines?
> For the "Stop processing more rules" - I'm assuming that this option is
only
> executed when the rule matches. For example, if rule #1 says "if sender
is
> abc@.xyz.com, move this message to xyz folder, and stop processing more
> rules", and the message is not from that sender, shouldn't Outlook then
move
> on to rule #2? Also, if you get a hit on a rule with incoming message
> number 1, shouldn't the rules start again from the top for message #2, or
> does the "stop processing more rules" keep this from happening? I'm
seeing
> a situation where, when I get some new messages, it appears that the rules
> don't immediately run. I can't tell if one of them is firing then the
rules
> stop processing the rest of the messages. If I go and click the
> Send/Receive button, the rules will all run.
> Thanks,
> John Schneider
>
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Friday, March 16, 2012
"The SQL Server cannot obtain a LOCK resource at this time" error
Hi there,
I am running on my machine the following SQL statements on my (local) SQL
Server:
SET NOCOUNT ON
SET ROWCOUNT 1500
delete_more:
delete table1 where field1 = '1' and field2 = '2'
IF @.@.ROWCOUNT > 0 GOTO delete_more
SET ROWCOUNT 0
The table has arround 5 million records and the DELETE statement would
delete arround 100000 records. I can see by running sp_lock that SQL is
escalating the locks to a table lock.
I am running in paralel the following:
SET ROWCOUNT 100
delete table1 where field1 = '3' and field2 = '2'
SET ROWCOUNT 0
This query is running fine, however the DELETE statement fails with the
error 1204:
"The SQL Server cannot obtain a LOCK resource at this time". Can somebody
shed some light for me here? Am I not able to run two DELETE statements is
paralel or am I doing something wrong?
I am running with the run_value for locks set to 0.
Thank you in advance.You mentioned there is already a table lock on that particular table, as it
is deleting millions of records. You probably need to wait for this
transaction to complete before you execute another delete statement on the
same table.
I suspect changing isolation level would solve your purpose.
"Andrei" wrote:
> Hi there,
> I am running on my machine the following SQL statements on my (local) SQL
> Server:
> SET NOCOUNT ON
> SET ROWCOUNT 1500
> delete_more:
> delete table1 where field1 = '1' and field2 = '2'
> IF @.@.ROWCOUNT > 0 GOTO delete_more
> SET ROWCOUNT 0
> The table has arround 5 million records and the DELETE statement would
> delete arround 100000 records. I can see by running sp_lock that SQL is
> escalating the locks to a table lock.
> I am running in paralel the following:
> SET ROWCOUNT 100
> delete table1 where field1 = '3' and field2 = '2'
> SET ROWCOUNT 0
> This query is running fine, however the DELETE statement fails with the
> error 1204:
> "The SQL Server cannot obtain a LOCK resource at this time". Can somebody
> shed some light for me here? Am I not able to run two DELETE statements is
> paralel or am I doing something wrong?
> I am running with the run_value for locks set to 0.
> Thank you in advance.|||What I want is to run several jobs concurrently, I do not want to wait for
one to finish in order to start the second one.
However I do not understand why I get the error, since the first statement
is suppose to delete 1500 records (so maximum 1500 key locks applied, if
there is no lock escalation) and the second statement is deleting 100
records. Am I missing something here?
"GYK" wrote:
> You mentioned there is already a table lock on that particular table, as it
> is deleting millions of records. You probably need to wait for this
> transaction to complete before you execute another delete statement on the
> same table.
> I suspect changing isolation level would solve your purpose.
> "Andrei" wrote:
> > Hi there,
> >
> > I am running on my machine the following SQL statements on my (local) SQL
> > Server:
> >
> > SET NOCOUNT ON
> >
> > SET ROWCOUNT 1500
> > delete_more:
> > delete table1 where field1 = '1' and field2 = '2'
> > IF @.@.ROWCOUNT > 0 GOTO delete_more
> > SET ROWCOUNT 0
> >
> > The table has arround 5 million records and the DELETE statement would
> > delete arround 100000 records. I can see by running sp_lock that SQL is
> > escalating the locks to a table lock.
> >
> > I am running in paralel the following:
> > SET ROWCOUNT 100
> > delete table1 where field1 = '3' and field2 = '2'
> > SET ROWCOUNT 0
> >
> > This query is running fine, however the DELETE statement fails with the
> > error 1204:
> > "The SQL Server cannot obtain a LOCK resource at this time". Can somebody
> > shed some light for me here? Am I not able to run two DELETE statements is
> > paralel or am I doing something wrong?
> >
> > I am running with the run_value for locks set to 0.
> >
> > Thank you in advance.
I am running on my machine the following SQL statements on my (local) SQL
Server:
SET NOCOUNT ON
SET ROWCOUNT 1500
delete_more:
delete table1 where field1 = '1' and field2 = '2'
IF @.@.ROWCOUNT > 0 GOTO delete_more
SET ROWCOUNT 0
The table has arround 5 million records and the DELETE statement would
delete arround 100000 records. I can see by running sp_lock that SQL is
escalating the locks to a table lock.
I am running in paralel the following:
SET ROWCOUNT 100
delete table1 where field1 = '3' and field2 = '2'
SET ROWCOUNT 0
This query is running fine, however the DELETE statement fails with the
error 1204:
"The SQL Server cannot obtain a LOCK resource at this time". Can somebody
shed some light for me here? Am I not able to run two DELETE statements is
paralel or am I doing something wrong?
I am running with the run_value for locks set to 0.
Thank you in advance.You mentioned there is already a table lock on that particular table, as it
is deleting millions of records. You probably need to wait for this
transaction to complete before you execute another delete statement on the
same table.
I suspect changing isolation level would solve your purpose.
"Andrei" wrote:
> Hi there,
> I am running on my machine the following SQL statements on my (local) SQL
> Server:
> SET NOCOUNT ON
> SET ROWCOUNT 1500
> delete_more:
> delete table1 where field1 = '1' and field2 = '2'
> IF @.@.ROWCOUNT > 0 GOTO delete_more
> SET ROWCOUNT 0
> The table has arround 5 million records and the DELETE statement would
> delete arround 100000 records. I can see by running sp_lock that SQL is
> escalating the locks to a table lock.
> I am running in paralel the following:
> SET ROWCOUNT 100
> delete table1 where field1 = '3' and field2 = '2'
> SET ROWCOUNT 0
> This query is running fine, however the DELETE statement fails with the
> error 1204:
> "The SQL Server cannot obtain a LOCK resource at this time". Can somebody
> shed some light for me here? Am I not able to run two DELETE statements is
> paralel or am I doing something wrong?
> I am running with the run_value for locks set to 0.
> Thank you in advance.|||What I want is to run several jobs concurrently, I do not want to wait for
one to finish in order to start the second one.
However I do not understand why I get the error, since the first statement
is suppose to delete 1500 records (so maximum 1500 key locks applied, if
there is no lock escalation) and the second statement is deleting 100
records. Am I missing something here?
"GYK" wrote:
> You mentioned there is already a table lock on that particular table, as it
> is deleting millions of records. You probably need to wait for this
> transaction to complete before you execute another delete statement on the
> same table.
> I suspect changing isolation level would solve your purpose.
> "Andrei" wrote:
> > Hi there,
> >
> > I am running on my machine the following SQL statements on my (local) SQL
> > Server:
> >
> > SET NOCOUNT ON
> >
> > SET ROWCOUNT 1500
> > delete_more:
> > delete table1 where field1 = '1' and field2 = '2'
> > IF @.@.ROWCOUNT > 0 GOTO delete_more
> > SET ROWCOUNT 0
> >
> > The table has arround 5 million records and the DELETE statement would
> > delete arround 100000 records. I can see by running sp_lock that SQL is
> > escalating the locks to a table lock.
> >
> > I am running in paralel the following:
> > SET ROWCOUNT 100
> > delete table1 where field1 = '3' and field2 = '2'
> > SET ROWCOUNT 0
> >
> > This query is running fine, however the DELETE statement fails with the
> > error 1204:
> > "The SQL Server cannot obtain a LOCK resource at this time". Can somebody
> > shed some light for me here? Am I not able to run two DELETE statements is
> > paralel or am I doing something wrong?
> >
> > I am running with the run_value for locks set to 0.
> >
> > Thank you in advance.
"The process could not connect to Distributor"
Hi, i have the following problem:
i have a publisher and a subscriber in the same sql server 2005 machine. All
the process (the Log Reader Agent and the Snapshot Agent) works fine. Even
the snapshot files are being created in the UNC path (\\Desa5el1\Paso), but
when attempt to run synchronization, the Replication Monitor show me an error
in the Subscription. When i see the details of the error, i see the following:
Error messages:
The process could not read file
'\\Desa5el1\Paso\unc\DESA5EL1$CASCABEL_MC_AREASQL_ PUB_MC_AREASQL_PRUEBA\20070719170351\prueba_2.pre'
due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
Get help: http://help/MSSQL_REPL20024
The account under which the agent runs is db_owner (is an sql account, not
an Windows account) and member of the Publication Access List. I think maybe
the problem it is in this:
"Have read permissions on the snapshot share."
Could someone explain me this point? i need to configure some thing extra?
some permissions to the unc path?
I really appreciate any help.
Thanks in advance
Locate your snapshot share. Do that by issue the following on your
distributor
sp_helpdistributor
The name of your snapshot share should be in the directory column.
Also on your publisher in your publication database do this
sp_helppublication 'pubs' -- where pubs is your publication name
Note the value for alt_snapshot_folder column. If this value is null your
snapshot share is the value for the directory column returned by
sp_helpdistributor. If it is not null the snapshot share is in the
alt_snapshot_folder column.
Using file explorer navigate to this folder and right click on it, select
sharing and security and then make sure that the account which the sql
server agent account runs under has read and list files and folders rights
on this folder. The share permissions are by default always read.
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
"byteman" <byteman@.discussions.microsoft.com> wrote in message
news:9E69C2AD-9AA6-4B12-8B1A-B118123E9F3D@.microsoft.com...
> Hi, i have the following problem:
> i have a publisher and a subscriber in the same sql server 2005 machine.
> All
> the process (the Log Reader Agent and the Snapshot Agent) works fine. Even
> the snapshot files are being created in the UNC path (\\Desa5el1\Paso),
> but
> when attempt to run synchronization, the Replication Monitor show me an
> error
> in the Subscription. When i see the details of the error, i see the
> following:
> Error messages:
> The process could not read file
> '\\Desa5el1\Paso\unc\DESA5EL1$CASCABEL_MC_AREASQL_ PUB_MC_AREASQL_PRUEBA\20070719170351\prueba_2.pre'
> due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
> Get help: http://help/MSSQL_REPL20024
> The account under which the agent runs is db_owner (is an sql account, not
> an Windows account) and member of the Publication Access List. I think
> maybe
> the problem it is in this:
> "Have read permissions on the snapshot share."
> Could someone explain me this point? i need to configure some thing extra?
> some permissions to the unc path?
> I really appreciate any help.
> --
> Thanks in advance
>
|||Thanks for your help, Hilary.
I executed both sp_helpdistributor and sp_helppublication, and the snapshot
share that appears is correct (\\Desa5el1\Paso).
How can i set sharing and security rights for the account under which the
agent runs? The account exists only in sql server. I need to "register" this
account in somewhere out of sql server? How can i do that?
Thanks again.
"Hilary Cotter" wrote:
> Locate your snapshot share. Do that by issue the following on your
> distributor
> sp_helpdistributor
> The name of your snapshot share should be in the directory column.
> Also on your publisher in your publication database do this
> sp_helppublication 'pubs' -- where pubs is your publication name
> Note the value for alt_snapshot_folder column. If this value is null your
> snapshot share is the value for the directory column returned by
> sp_helpdistributor. If it is not null the snapshot share is in the
> alt_snapshot_folder column.
> Using file explorer navigate to this folder and right click on it, select
> sharing and security and then make sure that the account which the sql
> server agent account runs under has read and list files and folders rights
> on this folder. The share permissions are by default always read.
>
> --
> 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
> "byteman" <byteman@.discussions.microsoft.com> wrote in message
> news:9E69C2AD-9AA6-4B12-8B1A-B118123E9F3D@.microsoft.com...
>
>
i have a publisher and a subscriber in the same sql server 2005 machine. All
the process (the Log Reader Agent and the Snapshot Agent) works fine. Even
the snapshot files are being created in the UNC path (\\Desa5el1\Paso), but
when attempt to run synchronization, the Replication Monitor show me an error
in the Subscription. When i see the details of the error, i see the following:
Error messages:
The process could not read file
'\\Desa5el1\Paso\unc\DESA5EL1$CASCABEL_MC_AREASQL_ PUB_MC_AREASQL_PRUEBA\20070719170351\prueba_2.pre'
due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
Get help: http://help/MSSQL_REPL20024
The account under which the agent runs is db_owner (is an sql account, not
an Windows account) and member of the Publication Access List. I think maybe
the problem it is in this:
"Have read permissions on the snapshot share."
Could someone explain me this point? i need to configure some thing extra?
some permissions to the unc path?
I really appreciate any help.
Thanks in advance
Locate your snapshot share. Do that by issue the following on your
distributor
sp_helpdistributor
The name of your snapshot share should be in the directory column.
Also on your publisher in your publication database do this
sp_helppublication 'pubs' -- where pubs is your publication name
Note the value for alt_snapshot_folder column. If this value is null your
snapshot share is the value for the directory column returned by
sp_helpdistributor. If it is not null the snapshot share is in the
alt_snapshot_folder column.
Using file explorer navigate to this folder and right click on it, select
sharing and security and then make sure that the account which the sql
server agent account runs under has read and list files and folders rights
on this folder. The share permissions are by default always read.
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
"byteman" <byteman@.discussions.microsoft.com> wrote in message
news:9E69C2AD-9AA6-4B12-8B1A-B118123E9F3D@.microsoft.com...
> Hi, i have the following problem:
> i have a publisher and a subscriber in the same sql server 2005 machine.
> All
> the process (the Log Reader Agent and the Snapshot Agent) works fine. Even
> the snapshot files are being created in the UNC path (\\Desa5el1\Paso),
> but
> when attempt to run synchronization, the Replication Monitor show me an
> error
> in the Subscription. When i see the details of the error, i see the
> following:
> Error messages:
> The process could not read file
> '\\Desa5el1\Paso\unc\DESA5EL1$CASCABEL_MC_AREASQL_ PUB_MC_AREASQL_PRUEBA\20070719170351\prueba_2.pre'
> due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
> Get help: http://help/MSSQL_REPL20024
> The account under which the agent runs is db_owner (is an sql account, not
> an Windows account) and member of the Publication Access List. I think
> maybe
> the problem it is in this:
> "Have read permissions on the snapshot share."
> Could someone explain me this point? i need to configure some thing extra?
> some permissions to the unc path?
> I really appreciate any help.
> --
> Thanks in advance
>
|||Thanks for your help, Hilary.
I executed both sp_helpdistributor and sp_helppublication, and the snapshot
share that appears is correct (\\Desa5el1\Paso).
How can i set sharing and security rights for the account under which the
agent runs? The account exists only in sql server. I need to "register" this
account in somewhere out of sql server? How can i do that?
Thanks again.
"Hilary Cotter" wrote:
> Locate your snapshot share. Do that by issue the following on your
> distributor
> sp_helpdistributor
> The name of your snapshot share should be in the directory column.
> Also on your publisher in your publication database do this
> sp_helppublication 'pubs' -- where pubs is your publication name
> Note the value for alt_snapshot_folder column. If this value is null your
> snapshot share is the value for the directory column returned by
> sp_helpdistributor. If it is not null the snapshot share is in the
> alt_snapshot_folder column.
> Using file explorer navigate to this folder and right click on it, select
> sharing and security and then make sure that the account which the sql
> server agent account runs under has read and list files and folders rights
> on this folder. The share permissions are by default always read.
>
> --
> 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
> "byteman" <byteman@.discussions.microsoft.com> wrote in message
> news:9E69C2AD-9AA6-4B12-8B1A-B118123E9F3D@.microsoft.com...
>
>
Sunday, March 11, 2012
"String constants must end with a double quote" error
Hi,
I've created a bunch of reports locally on my machine, where they all run
just fine, but when I try to deploy them to a server I run into some
problems.
I only have access to the server through a third party remote desktop
application (NetOp), so I have to do the deployment by manually uploading
the .rdl file in Report Manager. The reports uses MDX queries which I've had
to change into concatenated strings to allow for parameters, but when I try
to upload the files I only get the "BC30648 String constants must end with a
double quote." error.
If I remove the parameters, and the quotes around the whole query the files
upload just fine. Additionally, I've tried uploading the files manually both
on my own machine and a colleague's without getting this error. The reports
also run fine on these two machines after the upload (and configuration of
datasources).
Below is a sample of the query in a report that will throw the error on the
remote machine (for clarity this one doesn't use parameters):
<Query>
<DataSourceName>SullandGruppen</DataSourceName>
<CommandText>="SELECT
{[Measures].[Faktisk denne mnd]} ON COLUMNS,
{[Dato].[All Dato].[2004].[January]} ON ROWS
FROM Finanskube
WHERE
([Avdeling].[Salg],
[Avdelingsstruktur].[All Avdelingsstruktur].[3 Inntekter],
[Firma].[Gjovik Auto])"</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
Does anyone have any idea why this might be happening? This is a fresh
install of Reporting Services, so I haven't tried deploying reports to it
before. It have only got the Server Components and .NET runtime installed.
Many thanks for any input!
-Christian NordbakkWell, my bad this one :o/
I had developed the reports on SP1 but forgotten to upgrade the server. That
caused the report to crash because of the query being split onto multiple
lines, which pre-SP1 doesn't support.
-Christian Nordbakk
"Christian Nordbakk" <cnordbakk@.gmail.com> wrote in message
news:%23hcuOyAwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I've created a bunch of reports locally on my machine, where they all run
> just fine, but when I try to deploy them to a server I run into some
> problems.
> I only have access to the server through a third party remote desktop
> application (NetOp), so I have to do the deployment by manually uploading
> the .rdl file in Report Manager. The reports uses MDX queries which I've
> had to change into concatenated strings to allow for parameters, but when
> I try to upload the files I only get the "BC30648 String constants must
> end with a double quote." error.
> If I remove the parameters, and the quotes around the whole query the
> files upload just fine. Additionally, I've tried uploading the files
> manually both on my own machine and a colleague's without getting this
> error. The reports also run fine on these two machines after the upload
> (and configuration of datasources).
> Below is a sample of the query in a report that will throw the error on
> the remote machine (for clarity this one doesn't use parameters):
> <Query>
> <DataSourceName>SullandGruppen</DataSourceName>
> <CommandText>="SELECT
> {[Measures].[Faktisk denne mnd]} ON COLUMNS,
> {[Dato].[All Dato].[2004].[January]} ON ROWS
> FROM Finanskube
> WHERE
> ([Avdeling].[Salg],
> [Avdelingsstruktur].[All Avdelingsstruktur].[3 Inntekter],
> [Firma].[Gjovik Auto])"</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
>
> Does anyone have any idea why this might be happening? This is a fresh
> install of Reporting Services, so I haven't tried deploying reports to it
> before. It have only got the Server Components and .NET runtime installed.
> Many thanks for any input!
> -Christian Nordbakk
>
I've created a bunch of reports locally on my machine, where they all run
just fine, but when I try to deploy them to a server I run into some
problems.
I only have access to the server through a third party remote desktop
application (NetOp), so I have to do the deployment by manually uploading
the .rdl file in Report Manager. The reports uses MDX queries which I've had
to change into concatenated strings to allow for parameters, but when I try
to upload the files I only get the "BC30648 String constants must end with a
double quote." error.
If I remove the parameters, and the quotes around the whole query the files
upload just fine. Additionally, I've tried uploading the files manually both
on my own machine and a colleague's without getting this error. The reports
also run fine on these two machines after the upload (and configuration of
datasources).
Below is a sample of the query in a report that will throw the error on the
remote machine (for clarity this one doesn't use parameters):
<Query>
<DataSourceName>SullandGruppen</DataSourceName>
<CommandText>="SELECT
{[Measures].[Faktisk denne mnd]} ON COLUMNS,
{[Dato].[All Dato].[2004].[January]} ON ROWS
FROM Finanskube
WHERE
([Avdeling].[Salg],
[Avdelingsstruktur].[All Avdelingsstruktur].[3 Inntekter],
[Firma].[Gjovik Auto])"</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
Does anyone have any idea why this might be happening? This is a fresh
install of Reporting Services, so I haven't tried deploying reports to it
before. It have only got the Server Components and .NET runtime installed.
Many thanks for any input!
-Christian NordbakkWell, my bad this one :o/
I had developed the reports on SP1 but forgotten to upgrade the server. That
caused the report to crash because of the query being split onto multiple
lines, which pre-SP1 doesn't support.
-Christian Nordbakk
"Christian Nordbakk" <cnordbakk@.gmail.com> wrote in message
news:%23hcuOyAwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I've created a bunch of reports locally on my machine, where they all run
> just fine, but when I try to deploy them to a server I run into some
> problems.
> I only have access to the server through a third party remote desktop
> application (NetOp), so I have to do the deployment by manually uploading
> the .rdl file in Report Manager. The reports uses MDX queries which I've
> had to change into concatenated strings to allow for parameters, but when
> I try to upload the files I only get the "BC30648 String constants must
> end with a double quote." error.
> If I remove the parameters, and the quotes around the whole query the
> files upload just fine. Additionally, I've tried uploading the files
> manually both on my own machine and a colleague's without getting this
> error. The reports also run fine on these two machines after the upload
> (and configuration of datasources).
> Below is a sample of the query in a report that will throw the error on
> the remote machine (for clarity this one doesn't use parameters):
> <Query>
> <DataSourceName>SullandGruppen</DataSourceName>
> <CommandText>="SELECT
> {[Measures].[Faktisk denne mnd]} ON COLUMNS,
> {[Dato].[All Dato].[2004].[January]} ON ROWS
> FROM Finanskube
> WHERE
> ([Avdeling].[Salg],
> [Avdelingsstruktur].[All Avdelingsstruktur].[3 Inntekter],
> [Firma].[Gjovik Auto])"</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
>
> Does anyone have any idea why this might be happening? This is a fresh
> install of Reporting Services, so I haven't tried deploying reports to it
> before. It have only got the Server Components and .NET runtime installed.
> Many thanks for any input!
> -Christian Nordbakk
>
Saturday, February 25, 2012
"Multiple IP address in one SQL server" and "authentication problem with AD"
Never use a multihomed server as a DC. So you need to either remove AD off
of this machine or remove one of the NIC's.
The link below has some info on this and I couldn't find the exact article
but I can guarantee you are going to have constant problems with this setup.
http://support.Microsoft.com/default.aspx?scid=kb;en-us;832478
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.ds2.es> wrote in message
news:eQEPzDqUIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi all.
> I really don't known where to post because I don't known what is my
> problem, so let me explain.
> I have a SQL Server with two ethernet cards, one used for me, IT
> Department, and other used by normal users.
> Every card is in a separated network (obviously):
> 192.168.1.100 with "db.domain.com" A record in DNS
> 172.16.10.100 with "db.public.domain.com" A record in DNS
> This server is an AD domain computer with "db.domain.com" name, and the DC
> is in 192.168.1.0/24 network.
> I am in troubles when I try to connect with MSrSQL Management Studio using
> db.public.domain.com... I doesn't works, I get an error similar to "Login
> failed for user ''. The user is not associated with a trusted SQL Server
> connection. [CLIENT: 172.16.10.101]"
> If I change db.public.domain.com to a CNAME record pointing to
> db.domain.com it works, but this is not desired because I want users to
> use their network, 172.16.10.0/24.
> Any issues? Any suggestions? Any idea? Please help me if you can
I
> tried to play with Service Principal Names (SPN's), but I can't manage to
> connect with an A record.
> Thanks in advance,
> Sergio
Sorry for the misunderstanding. I don't specifically see what the problem
is, but does this sql server allow SQL Server and AD authentication? If so
have you tried both methods? What about the Event Log what is the error you
are receiving?
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.noreply.org> wrote in message
news:%23WIKzQtUIHA.1208@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Sorry, I didn't explained well... it is not a DC, it is only a domain
> member.
>
> Paul Bergson [MVP-DS] wrote:
|||Hi
Which domain is machine that you are connecting from in and have you tried
to change it?
Are you using SQL Authentication?
John
"Sergio Garcia" wrote:
> The SQL Server has the next configuration
> _________ _______
> | | | |
> NIC1 --| SQL |-- NIC2 --| DC |
> 10.10.10.1 | | 10.20.10.1 | DNS |
> host.pub.dom.com -- host.dom.com --
> In 10.20.10.0/24 network there is a DC of dom.com domain and a DNS wich
> has both A entries.
> My problem is that in the same SQL Server, I want to connect to
> host.pub.dom.com database server and I can't.
> If I use "host.pub.dom.com" can't connect. KO
> If I use "host.dom.com" I can connect. OK
> If I use "10.10.10.1" address, I can connect. OK
> If I use "10.20.10.1" address, I can connect. OK
> If I change the A record, "host.pub.dom.com", to a CNAME record pointing
> to "host.dom.com"... I can connect.
>
> Also, there is a router linking both networks
> Paul Bergson [MVP-DS] wrote:
>
|||Hi
Who are you logging into the machine as?
John
"Sergio Garcia" wrote:
> That machine is the same SQL Server. I can connect even to "localhost".
> If I use SQL Authentication it works, but with Windows authentication
> doesn't.
> Thanks very much.
> John Bell wrote:
>
|||Hi
If you can connect to host.pub.dom.com as a SQL User it is not the
resolution of the machine that has cause the problem.
If you can connect to host.dom.com as a Windows User host.dom.com\user it is
not the permissions for host.dom.com\user that is the issue.
If you can connect to host.pub.dom.com as a Windows User
host.pub.dom.com\user it is not the permissions for host.dom.com\user that is
the issue.
If you can connect to host.pub.dom.com as a Windows User host.dom.com\user I
suspect that it is something like the trust relationship between the two
domains that is the issue.
John
"Sergio Garcia" wrote:
> Ok, I will try to give you more information
> I am using a user who has permissions enough. It is a domain user, not a
> SQL user.
> Thanks for your help...
>
> John Bell wrote:
>
|||This sql box is not a router and the path host.pub.dom.com is not part of
your domain. The reason the cname works is you have it pointing to the
domain side.
I think you could get this to work if you loaded Routing and Remote Access,
but this is skewed.
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.noreply.org> wrote in message
news:47863DDF.6090604@.noreply.org...[vbcol=seagreen]
> The SQL Server has the next configuration
> _________ _______
> | | | |
> NIC1 --| SQL |-- NIC2 --| DC |
> 10.10.10.1 | | 10.20.10.1 | DNS |
> host.pub.dom.com -- host.dom.com --
> In 10.20.10.0/24 network there is a DC of dom.com domain and a DNS wich
> has both A entries.
> My problem is that in the same SQL Server, I want to connect to
> host.pub.dom.com database server and I can't.
> If I use "host.pub.dom.com" can't connect. KO
> If I use "host.dom.com" I can connect. OK
> If I use "10.10.10.1" address, I can connect. OK
> If I use "10.20.10.1" address, I can connect. OK
> If I change the A record, "host.pub.dom.com", to a CNAME record pointing
> to "host.dom.com"... I can connect.
>
> Also, there is a router linking both networks
> Paul Bergson [MVP-DS] wrote:
of this machine or remove one of the NIC's.
The link below has some info on this and I couldn't find the exact article
but I can guarantee you are going to have constant problems with this setup.
http://support.Microsoft.com/default.aspx?scid=kb;en-us;832478
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.ds2.es> wrote in message
news:eQEPzDqUIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi all.
> I really don't known where to post because I don't known what is my
> problem, so let me explain.
> I have a SQL Server with two ethernet cards, one used for me, IT
> Department, and other used by normal users.
> Every card is in a separated network (obviously):
> 192.168.1.100 with "db.domain.com" A record in DNS
> 172.16.10.100 with "db.public.domain.com" A record in DNS
> This server is an AD domain computer with "db.domain.com" name, and the DC
> is in 192.168.1.0/24 network.
> I am in troubles when I try to connect with MSrSQL Management Studio using
> db.public.domain.com... I doesn't works, I get an error similar to "Login
> failed for user ''. The user is not associated with a trusted SQL Server
> connection. [CLIENT: 172.16.10.101]"
> If I change db.public.domain.com to a CNAME record pointing to
> db.domain.com it works, but this is not desired because I want users to
> use their network, 172.16.10.0/24.
> Any issues? Any suggestions? Any idea? Please help me if you can
I> tried to play with Service Principal Names (SPN's), but I can't manage to
> connect with an A record.
> Thanks in advance,
> Sergio
Sorry for the misunderstanding. I don't specifically see what the problem
is, but does this sql server allow SQL Server and AD authentication? If so
have you tried both methods? What about the Event Log what is the error you
are receiving?
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.noreply.org> wrote in message
news:%23WIKzQtUIHA.1208@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Sorry, I didn't explained well... it is not a DC, it is only a domain
> member.
>
> Paul Bergson [MVP-DS] wrote:
|||Hi
Which domain is machine that you are connecting from in and have you tried
to change it?
Are you using SQL Authentication?
John
"Sergio Garcia" wrote:
> The SQL Server has the next configuration
> _________ _______
> | | | |
> NIC1 --| SQL |-- NIC2 --| DC |
> 10.10.10.1 | | 10.20.10.1 | DNS |
> host.pub.dom.com -- host.dom.com --
> In 10.20.10.0/24 network there is a DC of dom.com domain and a DNS wich
> has both A entries.
> My problem is that in the same SQL Server, I want to connect to
> host.pub.dom.com database server and I can't.
> If I use "host.pub.dom.com" can't connect. KO
> If I use "host.dom.com" I can connect. OK
> If I use "10.10.10.1" address, I can connect. OK
> If I use "10.20.10.1" address, I can connect. OK
> If I change the A record, "host.pub.dom.com", to a CNAME record pointing
> to "host.dom.com"... I can connect.
>
> Also, there is a router linking both networks
> Paul Bergson [MVP-DS] wrote:
>
|||Hi
Who are you logging into the machine as?
John
"Sergio Garcia" wrote:
> That machine is the same SQL Server. I can connect even to "localhost".
> If I use SQL Authentication it works, but with Windows authentication
> doesn't.
> Thanks very much.
> John Bell wrote:
>
|||Hi
If you can connect to host.pub.dom.com as a SQL User it is not the
resolution of the machine that has cause the problem.
If you can connect to host.dom.com as a Windows User host.dom.com\user it is
not the permissions for host.dom.com\user that is the issue.
If you can connect to host.pub.dom.com as a Windows User
host.pub.dom.com\user it is not the permissions for host.dom.com\user that is
the issue.
If you can connect to host.pub.dom.com as a Windows User host.dom.com\user I
suspect that it is something like the trust relationship between the two
domains that is the issue.
John
"Sergio Garcia" wrote:
> Ok, I will try to give you more information
> I am using a user who has permissions enough. It is a domain user, not a
> SQL user.
> Thanks for your help...
>
> John Bell wrote:
>
|||This sql box is not a router and the path host.pub.dom.com is not part of
your domain. The reason the cname works is you have it pointing to the
domain side.
I think you could get this to work if you loaded Routing and Remote Access,
but this is skewed.
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Garcia" <sergio.garcia@.noreply.org> wrote in message
news:47863DDF.6090604@.noreply.org...[vbcol=seagreen]
> The SQL Server has the next configuration
> _________ _______
> | | | |
> NIC1 --| SQL |-- NIC2 --| DC |
> 10.10.10.1 | | 10.20.10.1 | DNS |
> host.pub.dom.com -- host.dom.com --
> In 10.20.10.0/24 network there is a DC of dom.com domain and a DNS wich
> has both A entries.
> My problem is that in the same SQL Server, I want to connect to
> host.pub.dom.com database server and I can't.
> If I use "host.pub.dom.com" can't connect. KO
> If I use "host.dom.com" I can connect. OK
> If I use "10.10.10.1" address, I can connect. OK
> If I use "10.20.10.1" address, I can connect. OK
> If I change the A record, "host.pub.dom.com", to a CNAME record pointing
> to "host.dom.com"... I can connect.
>
> Also, there is a router linking both networks
> Paul Bergson [MVP-DS] wrote:
Sunday, February 19, 2012
"Invalid authorization specification"
Hello,
I have a web application (ISAPI) that accesses a SQL Server 2000 (sp3) database in the same machine as the Web Server (IIS 6). Windows 2003 Standard Edition is the operating System. So, when users access the aplication through the web it runs ok until display the error message "Invalid authorization specification" or, sometimes, another message about failure to inform ODBC DSN, although I dont use ODBC.
When the error occurs, the user press F5 in the browser and the operation goes ok. It's an intermitent and curious error.
Can somebody help me?
Thanks in advance.
Ado.I have no clue
http://www.easysoft.com/products/9999/faq_answer.phtml?ID=123&product=2002
ok, now with the pot shots...
I have a web application (ISAPI) that accesses a SQL Server 2000 (sp3) database in the same machine as the Web Server (IIS 6). Windows 2003 Standard Edition is the operating System. So, when users access the aplication through the web it runs ok until display the error message "Invalid authorization specification" or, sometimes, another message about failure to inform ODBC DSN, although I dont use ODBC.
When the error occurs, the user press F5 in the browser and the operation goes ok. It's an intermitent and curious error.
Can somebody help me?
Thanks in advance.
Ado.I have no clue
http://www.easysoft.com/products/9999/faq_answer.phtml?ID=123&product=2002
ok, now with the pot shots...
"image/jpeg; charset=utf-8", which is not a valid MIMEType
I am trying to use an image with a "Web" source, the url points to an
aspx page on the same machine as the reporting server, this page
returns a jpeg image (a chart) created by some C# code. On the
"Layout" tab of VS.NET the image is displayed but when I switch to the
"Preview" tab I just get the dreaded Red X.
The following warnings are written to the Output window.
Images with external URL references will not display if the report is
published to a report server without an UnattendedExecutionAccount or
the target image(s) are not enabled for anonymous access.
The value of the MIMEType property for the image ?image1' is
"image/jpeg; charset=utf-8", which is not a valid MIMEType.
I have configured the UnattendedExecuionAccount (rsconfig -e...) and
the page which returns the image allows anonymous access but it
doesn't seem to make any difference. What I don't understand is the
message about the invalid MIMEType, the code which returns the image
sets the ContentType="image/jpeg".
Any help much appreciated.I began to get this error right after I installed "Office 2003 Pro".
Do you use MS Office 2003?
"Mark" wrote:
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image â'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.
>
aspx page on the same machine as the reporting server, this page
returns a jpeg image (a chart) created by some C# code. On the
"Layout" tab of VS.NET the image is displayed but when I switch to the
"Preview" tab I just get the dreaded Red X.
The following warnings are written to the Output window.
Images with external URL references will not display if the report is
published to a report server without an UnattendedExecutionAccount or
the target image(s) are not enabled for anonymous access.
The value of the MIMEType property for the image ?image1' is
"image/jpeg; charset=utf-8", which is not a valid MIMEType.
I have configured the UnattendedExecuionAccount (rsconfig -e...) and
the page which returns the image allows anonymous access but it
doesn't seem to make any difference. What I don't understand is the
message about the invalid MIMEType, the code which returns the image
sets the ContentType="image/jpeg".
Any help much appreciated.I began to get this error right after I installed "Office 2003 Pro".
Do you use MS Office 2003?
"Mark" wrote:
> I am trying to use an image with a "Web" source, the url points to an
> aspx page on the same machine as the reporting server, this page
> returns a jpeg image (a chart) created by some C# code. On the
> "Layout" tab of VS.NET the image is displayed but when I switch to the
> "Preview" tab I just get the dreaded Red X.
> The following warnings are written to the Output window.
> Images with external URL references will not display if the report is
> published to a report server without an UnattendedExecutionAccount or
> the target image(s) are not enabled for anonymous access.
> The value of the MIMEType property for the image â'image1' is
> "image/jpeg; charset=utf-8", which is not a valid MIMEType.
> I have configured the UnattendedExecuionAccount (rsconfig -e...) and
> the page which returns the image allows anonymous access but it
> doesn't seem to make any difference. What I don't understand is the
> message about the invalid MIMEType, the code which returns the image
> sets the ContentType="image/jpeg".
> Any help much appreciated.
>
Thursday, February 16, 2012
"Full-Text Index Table" is disabled?
I'm trying to do some local development so I installed Full-Text Indexing as
part of the SQL 2000 Developer Edition on my Windows XP machine.
The MS Search Service is running but the option is still disabled in EM when
I right-click on a table.
Thanks, Dave.
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
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
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BE6EABAB-0F45-40B2-9C9C-1A29A1A8746B@.microsoft.com...
> I'm trying to do some local development so I installed Full-Text Indexing
> as
> part of the SQL 2000 Developer Edition on my Windows XP machine.
> The MS Search Service is running but the option is still disabled in EM
> when
> I right-click on a table.
> Thanks, Dave.
part of the SQL 2000 Developer Edition on my Windows XP machine.
The MS Search Service is running but the option is still disabled in EM when
I right-click on a table.
Thanks, Dave.
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
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
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BE6EABAB-0F45-40B2-9C9C-1A29A1A8746B@.microsoft.com...
> I'm trying to do some local development so I installed Full-Text Indexing
> as
> part of the SQL 2000 Developer Edition on my Windows XP machine.
> The MS Search Service is running but the option is still disabled in EM
> when
> I right-click on a table.
> Thanks, Dave.
"File not in a recognizeable format" when rendering to excel
I am using a WinXP SP2 machine with SQL2000 SP4, and using Reporting
Services SP2 when I get "File not in a recognizeable format" when
rendering to excel. Same goes for trying to render to PDF.
The weird thing is that on a virtual I have with Reporting Services
RTM, the excel opens fine...so I don't know what is going on.
The way I am generating the report is by manually creating a
request/response, adding on the POST vars, and then writing the output
to the browser (changing the content-type to excel, pdf, etc). As I
said, with the RTM version, the excel generates fine, but with SP2 it
doesnt.
Here are the parameters that I am adding onto the URL when I make the
request, along with my custom params.
//SQL REPORTING SERVICES SPECIAL PARAMS
sb.Append("&rs:Command=Render");
sb.Append("&rs:Format=" + exportType);
sb.Append("&rc:Parameters=false");
sb.Append("&rc:Toolbar=false&rs:Encoding=ASCII&rc:NoHeader=true");
I then I generate and return the request with the code below
(GeneratePostData() basically just creates the POST vars from above)
public static string generateReport(string url)
{
String result = "";
//get the data to post.
string postData = GeneratePostData();
System.IO.StreamWriter myWriter = null;
HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url);
objRequest.PreAuthenticate = true;
// Way 1:
//objRequest.Credentials = CredentialCache.DefaultCredentials;
// Way 2:
objRequest.Credentials = new
NetworkCredential(REPORT_USER,REPORT_PASS,REPORT_DOMAIN);
objRequest.Method = "POST";
objRequest.ContentLength = postData.Length;
objRequest.ContentType = "application/x-www-form-urlencoded";
try
{
myWriter = new
System.IO.StreamWriter(objRequest.GetRequestStream());
myWriter.Write(postData);
}
catch (Exception e)
{
return e.Message;
}
finally
{
myWriter.Close();
}
try
{
HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
using(System.IO.StreamReader sr = new
System.IO.StreamReader(objResponse.GetResponseStream()) )
{
result = sr.ReadToEnd();
// Close and clean up the StreamReader
sr.Close();
}
}
catch (Exception e)
{
return "An error occured while generating your report.\n" +
e.Message;
}
return result;
}
anyone have any ideas/things I can try because I am at a loss. Thanks
in advance.I figured out my problem.
I was taking the stream reader and passing the results back to the
output stream and writing it out just using Response.Write. This
worked fine for Reporting Svcs RTM, but NOT for SP2.
After going through various postings, I gather a few ways that others
did similar web request/response calls and found that if I just passed
the raw response stream and wrote it out with
Response.outputstream.write that it worked for BOTH RTM and SP2..
System.IO.Stream rs =ReportBuilder.generateReportStream(ReportBuilder.ReportViewerFullPath);
Byte[] read = new Byte[1024];
int count = rs.Read(read, 0, read.Length);
while(count > 0)
{
Response.OutputStream.Write(read, 0, count);
count = rs.Read(read, 0, count);
}
Services SP2 when I get "File not in a recognizeable format" when
rendering to excel. Same goes for trying to render to PDF.
The weird thing is that on a virtual I have with Reporting Services
RTM, the excel opens fine...so I don't know what is going on.
The way I am generating the report is by manually creating a
request/response, adding on the POST vars, and then writing the output
to the browser (changing the content-type to excel, pdf, etc). As I
said, with the RTM version, the excel generates fine, but with SP2 it
doesnt.
Here are the parameters that I am adding onto the URL when I make the
request, along with my custom params.
//SQL REPORTING SERVICES SPECIAL PARAMS
sb.Append("&rs:Command=Render");
sb.Append("&rs:Format=" + exportType);
sb.Append("&rc:Parameters=false");
sb.Append("&rc:Toolbar=false&rs:Encoding=ASCII&rc:NoHeader=true");
I then I generate and return the request with the code below
(GeneratePostData() basically just creates the POST vars from above)
public static string generateReport(string url)
{
String result = "";
//get the data to post.
string postData = GeneratePostData();
System.IO.StreamWriter myWriter = null;
HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url);
objRequest.PreAuthenticate = true;
// Way 1:
//objRequest.Credentials = CredentialCache.DefaultCredentials;
// Way 2:
objRequest.Credentials = new
NetworkCredential(REPORT_USER,REPORT_PASS,REPORT_DOMAIN);
objRequest.Method = "POST";
objRequest.ContentLength = postData.Length;
objRequest.ContentType = "application/x-www-form-urlencoded";
try
{
myWriter = new
System.IO.StreamWriter(objRequest.GetRequestStream());
myWriter.Write(postData);
}
catch (Exception e)
{
return e.Message;
}
finally
{
myWriter.Close();
}
try
{
HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
using(System.IO.StreamReader sr = new
System.IO.StreamReader(objResponse.GetResponseStream()) )
{
result = sr.ReadToEnd();
// Close and clean up the StreamReader
sr.Close();
}
}
catch (Exception e)
{
return "An error occured while generating your report.\n" +
e.Message;
}
return result;
}
anyone have any ideas/things I can try because I am at a loss. Thanks
in advance.I figured out my problem.
I was taking the stream reader and passing the results back to the
output stream and writing it out just using Response.Write. This
worked fine for Reporting Svcs RTM, but NOT for SP2.
After going through various postings, I gather a few ways that others
did similar web request/response calls and found that if I just passed
the raw response stream and wrote it out with
Response.outputstream.write that it worked for BOTH RTM and SP2..
System.IO.Stream rs =ReportBuilder.generateReportStream(ReportBuilder.ReportViewerFullPath);
Byte[] read = new Byte[1024];
int count = rs.Read(read, 0, read.Length);
while(count > 0)
{
Response.OutputStream.Write(read, 0, count);
count = rs.Read(read, 0, count);
}
Thursday, February 9, 2012
"Cluster-aware" Applications
If a customer has a na application that accesses SQL
server running on a single machine (Windows 2003 Server)
and then decided to implement an active/passive server
cluster with SQL Server Enterprise, does the application
that accesses the database need to change? I am not sure
what is meant by "cluster-aware applications". Isn't
clustering supposed to be transparent to the application?
I read a line in "Server Clusters: Architectural Overview"
that said:
"Server clusters also provide the --> APPLICATION
INTERFACES <-- and tools needed to develop new cluster-
aware aaplications that can take advantage of the high
availability features of server clusters"
Thanks,
Todd
Hi
The biggest issue is when the cluster fails over from one node to another.
The client application must re-connect to the cluster again as the
connection will be broken when the failover occurs.
Any transaction that was running on behalf of the client would have been
rolled back and the application will have to re-submit it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
<anonymous@.discussions.microsoft.com> wrote in message
news:1db6401c4546b$89e3d460$a101280a@.phx.gbl...
> If a customer has a na application that accesses SQL
> server running on a single machine (Windows 2003 Server)
> and then decided to implement an active/passive server
> cluster with SQL Server Enterprise, does the application
> that accesses the database need to change? I am not sure
> what is meant by "cluster-aware applications". Isn't
> clustering supposed to be transparent to the application?
> I read a line in "Server Clusters: Architectural Overview"
> that said:
> "Server clusters also provide the --> APPLICATION
> INTERFACES <-- and tools needed to develop new cluster-
> aware aaplications that can take advantage of the high
> availability features of server clusters"
> Thanks,
> Todd
>
|||A cluster aware application is an application that will function on a
cluster and failover when necessary. As an example, a virtual SQL Server
2000 server is cluster aware iin that it will fail back and forth. By the
same token, Excel is not. If SQL Server 2000 and Excel are both running on
node 1 and node 1 crashes SQL Server will failover to node 2, but Excel
will not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Cluster-aware Applications
===========================
An application is capable of being cluster-aware if it has the following characteristics:
* It uses TCP/IP as a network protocol.
* It maintains data in a configurable location.
* It supports transaction processing.
Most database applications, transaction processing applications, file and print server applications, and other groupware applications are capable of being made cluster-aware.
There are two types of cluster-aware applications:
* Applications that are managed as highly available cluster resources by a custom resource type. If you want your application to be highly available, to fail over, to benefit from customized failure detection
policies, or to be made available to clients on a virtual server, your application needs to be managed as a cluster resource. This means that in addition to any cluster-awareness you want to add to the application,
you will need to create a custom resource type to manage the application.
* Applications that interact with the cluster but are not cluster resources. Cluster Administrator is an example of such an application. This category also includes cluster-aware performance monitors, configuration
tools, setup applications, event handlers, and cluster management applications.
Cluster-Unaware Applications
===========================
The following features distinguish a cluster-unaware application:
* The application does not use the Server Cluster API. Therefore, it cannot discover information about the cluster environment, interact with cluster objects, detect that it is running in a cluster, or change its behavior
between clustered and non-clustered systems.
* If the application is managed as a cluster resource, it is managed as a Generic Application resource type or Generic Service resource type. These resource types provide very basic routines for failure
detection and application shutdown. Therefore, a cluster-unaware application might not be able to perform the initialization and cleanup tasks needed for it to be consistently available in the cluster.
Older applications are cluster-unaware. However, a cluster-unaware application can be made cluster-aware by creating resource types to manage the application. A custom resource type provides the
initialization, cleanup, and management routines specific to the needs of the application.
There is nothing inherently wrong with cluster-unaware applications. As long as they are functioning and highly available to cluster resources when managed as Generic Applications or Generic Services, there is
no need to make them cluster-aware. However, if an application does not start, stop, or failover consistently when managed by the generic types, it should be made cluster-aware.
Additional Information
======================
Platform SDK: Windows Clustering
http://msdn.microsoft.com/library/de...nformation.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
server running on a single machine (Windows 2003 Server)
and then decided to implement an active/passive server
cluster with SQL Server Enterprise, does the application
that accesses the database need to change? I am not sure
what is meant by "cluster-aware applications". Isn't
clustering supposed to be transparent to the application?
I read a line in "Server Clusters: Architectural Overview"
that said:
"Server clusters also provide the --> APPLICATION
INTERFACES <-- and tools needed to develop new cluster-
aware aaplications that can take advantage of the high
availability features of server clusters"
Thanks,
Todd
Hi
The biggest issue is when the cluster fails over from one node to another.
The client application must re-connect to the cluster again as the
connection will be broken when the failover occurs.
Any transaction that was running on behalf of the client would have been
rolled back and the application will have to re-submit it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
<anonymous@.discussions.microsoft.com> wrote in message
news:1db6401c4546b$89e3d460$a101280a@.phx.gbl...
> If a customer has a na application that accesses SQL
> server running on a single machine (Windows 2003 Server)
> and then decided to implement an active/passive server
> cluster with SQL Server Enterprise, does the application
> that accesses the database need to change? I am not sure
> what is meant by "cluster-aware applications". Isn't
> clustering supposed to be transparent to the application?
> I read a line in "Server Clusters: Architectural Overview"
> that said:
> "Server clusters also provide the --> APPLICATION
> INTERFACES <-- and tools needed to develop new cluster-
> aware aaplications that can take advantage of the high
> availability features of server clusters"
> Thanks,
> Todd
>
|||A cluster aware application is an application that will function on a
cluster and failover when necessary. As an example, a virtual SQL Server
2000 server is cluster aware iin that it will fail back and forth. By the
same token, Excel is not. If SQL Server 2000 and Excel are both running on
node 1 and node 1 crashes SQL Server will failover to node 2, but Excel
will not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Cluster-aware Applications
===========================
An application is capable of being cluster-aware if it has the following characteristics:
* It uses TCP/IP as a network protocol.
* It maintains data in a configurable location.
* It supports transaction processing.
Most database applications, transaction processing applications, file and print server applications, and other groupware applications are capable of being made cluster-aware.
There are two types of cluster-aware applications:
* Applications that are managed as highly available cluster resources by a custom resource type. If you want your application to be highly available, to fail over, to benefit from customized failure detection
policies, or to be made available to clients on a virtual server, your application needs to be managed as a cluster resource. This means that in addition to any cluster-awareness you want to add to the application,
you will need to create a custom resource type to manage the application.
* Applications that interact with the cluster but are not cluster resources. Cluster Administrator is an example of such an application. This category also includes cluster-aware performance monitors, configuration
tools, setup applications, event handlers, and cluster management applications.
Cluster-Unaware Applications
===========================
The following features distinguish a cluster-unaware application:
* The application does not use the Server Cluster API. Therefore, it cannot discover information about the cluster environment, interact with cluster objects, detect that it is running in a cluster, or change its behavior
between clustered and non-clustered systems.
* If the application is managed as a cluster resource, it is managed as a Generic Application resource type or Generic Service resource type. These resource types provide very basic routines for failure
detection and application shutdown. Therefore, a cluster-unaware application might not be able to perform the initialization and cleanup tasks needed for it to be consistently available in the cluster.
Older applications are cluster-unaware. However, a cluster-unaware application can be made cluster-aware by creating resource types to manage the application. A custom resource type provides the
initialization, cleanup, and management routines specific to the needs of the application.
There is nothing inherently wrong with cluster-unaware applications. As long as they are functioning and highly available to cluster resources when managed as Generic Applications or Generic Services, there is
no need to make them cluster-aware. However, if an application does not start, stop, or failover consistently when managed by the generic types, it should be made cluster-aware.
Additional Information
======================
Platform SDK: Windows Clustering
http://msdn.microsoft.com/library/de...nformation.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Friday, January 27, 2012
"...remote name could not be resolved" when using custom Web App
Hi all,
I'm getting a headache trying to figure out what is going on here. I've set
up Reporting Services on 1 dev machine and 2 servers and using a Web
Application that I am developing to access Reporting Services to generate a
report for me. Everything works fine on both my development machine and one
of the servers, but the other server keeps on producing this error:
"The underlying connection was closed: The remote name could not be resolved."
As far as I can remember, every instance of RS was installed identically.
Also, I can use the Report Manager from the server and from networked
computers to generate reports with no issues. Its only upon my Web Apps
access to the RS that I get this error. Is this similar to the SSL issues a
lot of people have been discussing? I'm still quite a newbie when it comes to
sql server and iis, so if this has been answered elsewhere already, I'd
appreciate a link :)
AndreAfter a bit of debugging I found that the problem was actually just that a
static web refference to the report server was being used, and that was
pointing at the other server still.
All works fine now.
I'm getting a headache trying to figure out what is going on here. I've set
up Reporting Services on 1 dev machine and 2 servers and using a Web
Application that I am developing to access Reporting Services to generate a
report for me. Everything works fine on both my development machine and one
of the servers, but the other server keeps on producing this error:
"The underlying connection was closed: The remote name could not be resolved."
As far as I can remember, every instance of RS was installed identically.
Also, I can use the Report Manager from the server and from networked
computers to generate reports with no issues. Its only upon my Web Apps
access to the RS that I get this error. Is this similar to the SSL issues a
lot of people have been discussing? I'm still quite a newbie when it comes to
sql server and iis, so if this has been answered elsewhere already, I'd
appreciate a link :)
AndreAfter a bit of debugging I found that the problem was actually just that a
static web refference to the report server was being used, and that was
pointing at the other server still.
All works fine now.
Hello All,
I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.
There is a domain account domain\user.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.
Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.
Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.
In Control Panel - Mail - Profiles: Outlook is the profile used.
In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"
I looked at
http://support.microsoft.com/?id=263556
I could not figured it out
Any help please?
Thanks,
Ven
You need a mapi email client such as Outlook 2000.
I have around 17 SQL/Server 2000's using Domino 6.5 email accounts. Here is the scoop:
Log on to the server as the account that is used for the SQL Service account and install Outlook 2000 (with no service pack). Launch Outlook 2000 and create a mail profile that points to your Domino server. Call this email account SQLMail. Create another Outlook 2000 profile with the name SQLAgentMail and test it (this can be the same Domino account). Then log off the server and log back on using the login account that you normally run the server with. Restart SQL Server (and SQL Server Agent) and then the mapi email profiles created earlier will be available. Set SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. That's it!
DeWayne
|||-
|||DeWayne,
Thanks for your help.
I have other question:
While am setting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile.
Receiving the following error.
Error 22022
If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error.
Failed to create new MAPI profile. Error creating personal Folders service
Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode.
Setup encountered an error and failed to create a MAPI profile.
You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook
(Already we removed and reinstalled)
Any help please?
Ven
|||
DeWayne,
Sorry for the inconvenience,
Restarted SQL Server (and SQL Server Agent) ,the mapi email profiles created earlier still not available.
Can you please help me?
|||Sure!
You don't need the Notes client installed on the Server at all as you will be using a POP3 email account to connect to the Domino Server (at least that is the way that I run it.)
Sign back on as the SQL Server service account then launch Outlook 2000. Click Tools, Options, click the Mail Services Tab, then click Reconfigure Mail Support and select the Corporate Workgroup option. You may have to setup the mail profile/accounts again if needed (choose POP3 when creating the mail accounts). Be sure to set Outlook to use each profile that you created and launch Outlook and click send/receive to test the email accounts.) Then logoff and sign back in as the normal Server user then restart SQL Server again...
|||DeWayne,
Thanks you so much. It is working now.
I have other question.
we have five different sql servers.
Is it okif I use the same ( single )mail box for different profiles? instead of creating different mail box on each server?
Or does it works like a mail realy?.
Please help?
Thanks,
Ven
|||
Ven,
I create a new email account for each Server so that any emails from a SQL Server are easily identified. For example, a server named "Boston" I would create an email account named "Boston Server". If SQL is only SENDING emails then you could use one email box for everything; however, I would not want to set up my environment that way...
p.s. I am glad that everything is working correctly!!!
DeWayne
Hello All,
I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.
There is a domain account domain\user.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.
Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.
Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.
In Control Panel - Mail - Profiles: Outlook is the profile used.
In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"
I looked at
http://support.microsoft.com/?id=263556
I could not figured it out
Any help please?
Thanks,
Ven
You need a mapi email client such as Outlook 2000.
I have around 17 SQL/Server 2000's using Domino 6.5 email accounts. Here is the scoop:
Log on to the server as the account that is used for the SQL Service account and install Outlook 2000 (with no service pack). Launch Outlook 2000 and create a mail profile that points to your Domino server. Call this email account SQLMail. Create another Outlook 2000 profile with the name SQLAgentMail and test it (this can be the same Domino account). Then log off the server and log back on using the login account that you normally run the server with. Restart SQL Server (and SQL Server Agent) and then the mapi email profiles created earlier will be available. Set SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. That's it!
DeWayne
|||-
|||DeWayne,
Thanks for your help.
I have other question:
While am setting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile.
Receiving the following error.
Error 22022
If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error.
Failed to create new MAPI profile. Error creating personal Folders service
Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode.
Setup encountered an error and failed to create a MAPI profile.
You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook
(Already we removed and reinstalled)
Any help please?
Ven
|||
DeWayne,
Sorry for the inconvenience,
Restarted SQL Server (and SQL Server Agent) ,the mapi email profiles created earlier still not available.
Can you please help me?
|||Sure!
You don't need the Notes client installed on the Server at all as you will be using a POP3 email account to connect to the Domino Server (at least that is the way that I run it.)
Sign back on as the SQL Server service account then launch Outlook 2000. Click Tools, Options, click the Mail Services Tab, then click Reconfigure Mail Support and select the Corporate Workgroup option. You may have to setup the mail profile/accounts again if needed (choose POP3 when creating the mail accounts). Be sure to set Outlook to use each profile that you created and launch Outlook and click send/receive to test the email accounts.) Then logoff and sign back in as the normal Server user then restart SQL Server again...
|||DeWayne,
Thanks you so much. It is working now.
I have other question.
we have five different sql servers.
Is it okif I use the same ( single )mail box for different profiles? instead of creating different mail box on each server?
Or does it works like a mail realy?.
Please help?
Thanks,
Ven
|||
Ven,
I create a new email account for each Server so that any emails from a SQL Server are easily identified. For example, a server named "Boston" I would create an email account named "Boston Server". If SQL is only SENDING emails then you could use one email box for everything; however, I would not want to set up my environment that way...
p.s. I am glad that everything is working correctly!!!
DeWayne
Subscribe to:
Posts (Atom)
