Hi Everybody,
I'm working on a new database of 25GB in size with an expected 25% growth per year and an estimated 1000 TPS. Since I need to retain the old data for atleast 7 years. I would like to know whether I should Archive the database or is there any other means of storing the data, which will be used just to generate reports. Also pl. do let me know the advantages/disadvantages.
Thanks
KishoreYou said 7 years of total retention. But how old should the data be in your production environment? If 7 years as well, - you're looking at 200GB worth of data (I am yet to see an app that survives that long, but it's possible ;))|||archiving is dependent on your query requirements.
if your working set is getdate() - 6 months then archive
but if you report CONSISTENTLY all the way back. there obviously is no need to archive.
250GB is nothing to sneeze at but you can easily manage a db of that size with sql server 2k or any othe enterprise class db for that matter.
archiving really causes more headaches than it is worth.|||In production we need atleast 1 year old data and the rest can be archived which will be used to generate reports|||If 1 year is a working set then I'd recommed to have a reporting server where the archived data would be transferred to. You can also set this server as a linked server in your prod environment, and create additional views/stored procedures to have an easier access to the archived data without having to explicitly connect to a different server.
Showing posts with label working. Show all posts
Showing posts with label working. Show all posts
Sunday, March 25, 2012
architecture question
I asked this in the C# forum and got some input from some developers, now
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the business
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp table
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hits
> when doing logic such as this on the database side, so my question is, which
> would be the best solution for this?
>
You may want to look at http://msdn2.microsoft.com/en-us/library/ms973279.aspx
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
John
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the business
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp table
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hits
> when doing logic such as this on the database side, so my question is, which
> would be the best solution for this?
>
You may want to look at http://msdn2.microsoft.com/en-us/library/ms973279.aspx
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
John
Thursday, March 22, 2012
architecture question
I asked this in the C# forum and got some input from some developers, now
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?
Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the business
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp table
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hits
> when doing logic such as this on the database side, so my question is, which
> would be the best solution for this?
>
You may want to look at http://msdn2.microsoft.com/en-us/library/ms973279.aspx
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
John
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?
Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the business
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp table
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hits
> when doing logic such as this on the database side, so my question is, which
> would be the best solution for this?
>
You may want to look at http://msdn2.microsoft.com/en-us/library/ms973279.aspx
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
John
architecture question
I asked this in the C# forum and got some input from some developers, now
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the busine
ss
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp tabl
e
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hit
s
> when doing logic such as this on the database side, so my question is, whi
ch
> would be the best solution for this?
>
You may want to look at [url]http://msdn2.microsoft.com/en-us/library/ms973279.aspx[/ur
l]
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
Johnsql
I'm looking for some input from DBA's.
thanks
I'm working on a project and the lead developer wants to put all of the
business logic on the database side. He wants the proc to do all of the
logic and create XML on the fly, parse out data, etc, and then return the
final result to the business layer. I pushed back and said that the business
layer should do all of the logic, just have SQL return the data needed and
then have the code do all of the XML creation, parsing of data, etc. I was
told I was wrong and thats not the best practice.
Now, this app can hit the db by a total of 100-500 users a day, and having
the db do all of the processing can have a performance hit. Then he
mentioned something about using temp table in the database side, do a
select, then insert into the temp table, then do a select on the temp table
and do the business logic. I pushed back on that as well..
Now, I'm not a DBA but a developer and I've seen DB's take performance hits
when doing logic such as this on the database side, so my question is, which
would be the best solution for this?Hi
"Jon" wrote:
> I asked this in the C# forum and got some input from some developers, now
> I'm looking for some input from DBA's.
> thanks
> I'm working on a project and the lead developer wants to put all of the
> business logic on the database side. He wants the proc to do all of the
> logic and create XML on the fly, parse out data, etc, and then return the
> final result to the business layer. I pushed back and said that the busine
ss
> layer should do all of the logic, just have SQL return the data needed and
> then have the code do all of the XML creation, parsing of data, etc. I was
> told I was wrong and thats not the best practice.
> Now, this app can hit the db by a total of 100-500 users a day, and having
> the db do all of the processing can have a performance hit. Then he
> mentioned something about using temp table in the database side, do a
> select, then insert into the temp table, then do a select on the temp tabl
e
> and do the business logic. I pushed back on that as well..
> Now, I'm not a DBA but a developer and I've seen DB's take performance hit
s
> when doing logic such as this on the database side, so my question is, whi
ch
> would be the best solution for this?
>
You may want to look at [url]http://msdn2.microsoft.com/en-us/library/ms973279.aspx[/ur
l]
With client-server applications you can put business logic into the
database, but implementing a n-tier architecture you are moving away from
this and the business logic resides in one of the tiers.
As far as XML is concerned SQL Server can create and store XML data, you
would need to determine if the interface would work be better as a recordset
or XML and how much load the different methods would create.
Johnsql
Apriori algorithm [SQL Server 2005 and ASP.NET]
Hi
I am working on academic project using SQL Server 2005 & Visual studio 2005. Using Apriori algorithm to find the association between Patient City and likely diseases.
I have created PATIENT table with Patient_Id, Patient_name, Age, City attributes and Diseases table with Disease_Id, Disease_name. Connected these two tables, MANY - MANY [M:N]. Got a third relation with Patient_Id and Disease_Id attributes.
I am just inputting some dummy data into patient table and disease tables to make Apriori algorithm work. When a new Patient City is entered into patient table, System checks Patient table for same City previously stored and using Third relation, pulls Disease that associated with the City.
Here are my tables with attributes:
PATIENT ( Patient_Id, Patient_name, Age, City)
Diseases(Disease_Id, Disease_name)
[M:N] Got third below third relation bcz its Many to Many relationship
PATIENT_DISEASES(Patient_Id, Disease_Id)
I do think and believe that there is an efficient way of doing , instead of usin dummy data or using this relationships. I did check Microsoft Association algorithm and realised it is not Apriori algorithm.
Could you suggest the best or efficient way of doing this using SQL Server 2005?
Your help and insight into this matter is highly appreciated.
Regards
Sukumar Raju
The Association Rules is Apriori. What kind of rules are you looking for? Disease --> Disease, City --> Disease, Age -->Disease? All of the above?|||
Thank you.
Looking for association between City --> Disease.
I am just inputting some dummy data into patient table and disease table to make Apriori algorithm work. When a new Patient City is entered into patient table, System checks Patient table for same City previously stored and using Third relation, pulls Disease that associated with the City.
I think i have to write T-SQL statements to get the above algorithm work. Is there other way to achieve?
Is there best way other than simply writing T-SQL statements to implement Apriori algorithm work! Am i going in the right way?
Your suggestion and help is appreciated
regards
Sukumar raju
|||You need to use SQL Server Analysis Services to use the Association Rules algorithm. You will launch BI Dev Studio and create a Analysis Services project containing a data source, data source view, and data mining structure - there are UI tools to do all of this - you don't need to write any TSQL.
I recommend checking out the resources at www.sqlserverdatamining.com - in particular the tutorial to learn how to use the DM functionality in SQL Server.
Thanks
-Jamie
|||Thank you Mr.Jammie
I would do that. Could you give any resources that are useful to achieve my objective?
regards
Sukumar Raju
|||You can try the book I wrote with Zhaohui Tang - Data Mining with SQL Server 2005 - as a starting point. It describes how to create models of the type you need.|||
Thank you!
Your help and information is much appreciated. Can I retrieve this particular association model on web page? i m using asp.net for my web interface. I think i can
1) Create association model using BI in SQL Server 2005
2) Access this model on web interface, such a way when i enter patient city in PATIENT table from Web interface, get a prompt message showing "more likely diseases" from Diseases table , that associated with the entered City.
hoping i m going in the right way. I have ordered the book writeen by you Data mining with SQL Server 2005. Shouldbe getting in couple of days.
your suggestion and help is appreciated. Please advise.
regards
Sukumar Raju
|||Sukumar Raju wrote:
Thank you! Jamie!
Your help and information is much appreciated. Can I retrieve this particular association model on web page? i m using asp.net for my web interface. I think i can
1) Create association model using BI in SQL Server 2005
2) Access this model on web interface, such a way when i enter patient city in PATIENT table from Web interface, get a prompt message showing "more likely diseases" from Diseases table , that associated with the entered City.
hoping i m going in the right way. I have ordered the book writeen by you Data mining with SQL Server 2005. Getting late...As my project submission date is just 5 days away.
your suggestion and help is appreciated. Please advise.
regards
Sukumar Raju
Apps cannot connect to SQL after server upgrade to 2003 R2
I had a working SQL Server 2005 install based on an evaluation of Windows
Server 2003 SP2 Ent. I have several other servers running MOSS 07 and WSUS.
I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation had
9 days before expiry.
However after the upgrade other machines cannot connect to the databases in
SQL, yet i can connect locally using SQL server management studio, the
databases are all intact and permissions have not been changed.
Any ideas would be gratefully received as I have my A Level coursework
stored in a a sharepoint site in one of these Databases!!!!!
AdamDid you check your Windows Firewall settings in your upgraded machine?
If it's not the problem, what's the error message exactly?
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:2997350C-2891-46FB-AC33-010DBA43C807@.microsoft.com...
>I had a working SQL Server 2005 install based on an evaluation of Windows
> Server 2003 SP2 Ent. I have several other servers running MOSS 07 and
> WSUS.
> I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation
> had
> 9 days before expiry.
> However after the upgrade other machines cannot connect to the databases
> in
> SQL, yet i can connect locally using SQL server management studio, the
> databases are all intact and permissions have not been changed.
> Any ideas would be gratefully received as I have my A Level coursework
> stored in a a sharepoint site in one of these Databases!!!!!
> Adam|||windows firewall is off - i get error message when i try to access sharepoint
pages - "cannot connect to configuration database" and WSUS gives similar
error.
I can see no errrors in the application logs on the SQL server.|||Then go to SQL Server Configuration Manager and check out your protocols.
Ensure they are enabled and configured correctly.
Also, You did not mention which SQL Server Edition you have, however SQL
Server 2005 Express and Developer Editions are configured Remote Connections
disabled by default. You could check it from SQL Server Surface Area
Configuration tool.
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> windows firewall is off - i get error message when i try to access
> sharepoint
> pages - "cannot connect to configuration database" and WSUS gives similar
> error.
> I can see no errrors in the application logs on the SQL server.|||I have SQL Server 2005 SP2 Enterprise.
All remote protocols are enabled apart from VIA as the service wont start
with it enabled.
"Ekrem Ã?nsoy" wrote:
> Then go to SQL Server Configuration Manager and check out your protocols.
> Ensure they are enabled and configured correctly.
> Also, You did not mention which SQL Server Edition you have, however SQL
> Server 2005 Express and Developer Editions are configured Remote Connections
> disabled by default. You could check it from SQL Server Surface Area
> Configuration tool.
> --
> Ekrem Ã?nsoy
>
> "Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
> news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> > windows firewall is off - i get error message when i try to access
> > sharepoint
> > pages - "cannot connect to configuration database" and WSUS gives similar
> > error.
> >
> > I can see no errrors in the application logs on the SQL server.
>
Server 2003 SP2 Ent. I have several other servers running MOSS 07 and WSUS.
I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation had
9 days before expiry.
However after the upgrade other machines cannot connect to the databases in
SQL, yet i can connect locally using SQL server management studio, the
databases are all intact and permissions have not been changed.
Any ideas would be gratefully received as I have my A Level coursework
stored in a a sharepoint site in one of these Databases!!!!!
AdamDid you check your Windows Firewall settings in your upgraded machine?
If it's not the problem, what's the error message exactly?
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:2997350C-2891-46FB-AC33-010DBA43C807@.microsoft.com...
>I had a working SQL Server 2005 install based on an evaluation of Windows
> Server 2003 SP2 Ent. I have several other servers running MOSS 07 and
> WSUS.
> I upgraded the SQL server machine to 2003 R2 SP2 Ent. as the evaluation
> had
> 9 days before expiry.
> However after the upgrade other machines cannot connect to the databases
> in
> SQL, yet i can connect locally using SQL server management studio, the
> databases are all intact and permissions have not been changed.
> Any ideas would be gratefully received as I have my A Level coursework
> stored in a a sharepoint site in one of these Databases!!!!!
> Adam|||windows firewall is off - i get error message when i try to access sharepoint
pages - "cannot connect to configuration database" and WSUS gives similar
error.
I can see no errrors in the application logs on the SQL server.|||Then go to SQL Server Configuration Manager and check out your protocols.
Ensure they are enabled and configured correctly.
Also, You did not mention which SQL Server Edition you have, however SQL
Server 2005 Express and Developer Editions are configured Remote Connections
disabled by default. You could check it from SQL Server Surface Area
Configuration tool.
--
Ekrem Ã?nsoy
"Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> windows firewall is off - i get error message when i try to access
> sharepoint
> pages - "cannot connect to configuration database" and WSUS gives similar
> error.
> I can see no errrors in the application logs on the SQL server.|||I have SQL Server 2005 SP2 Enterprise.
All remote protocols are enabled apart from VIA as the service wont start
with it enabled.
"Ekrem Ã?nsoy" wrote:
> Then go to SQL Server Configuration Manager and check out your protocols.
> Ensure they are enabled and configured correctly.
> Also, You did not mention which SQL Server Edition you have, however SQL
> Server 2005 Express and Developer Editions are configured Remote Connections
> disabled by default. You could check it from SQL Server Surface Area
> Configuration tool.
> --
> Ekrem Ã?nsoy
>
> "Adam Gent" <AdamGent@.discussions.microsoft.com> wrote in message
> news:654B7ED7-35C6-4854-8DBA-128757AAC45F@.microsoft.com...
> > windows firewall is off - i get error message when i try to access
> > sharepoint
> > pages - "cannot connect to configuration database" and WSUS gives similar
> > error.
> >
> > I can see no errrors in the application logs on the SQL server.
>
Sunday, March 11, 2012
Apply or OK buttons not working after client - server installtion
Hi hoping someone can help me...
We Were running a stand alone version of RS fine on a laptop.
the IT guys have completed a server installtion of RS. when I get to Report
Manager home page and click on a report view the properties , and change the
name of the report. I click Apply and nothing happens at all... it just sits
there' if I refresh the page the original name of the report is loaded up.
This is happening with all the apply and ok buttons in reportmanager. but
the reports that are deployed do run and work fine. As none of the buttons
work I cannot give peopla access to view the report' no can I set or apply
any execution properties....
Help gretly appreciated!!
--
Technical Data Analyst
Hammersmith & W London CollegeDo you have appropriate permissions to do the things you wish?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> Hi hoping someone can help me...
> We Were running a stand alone version of RS fine on a laptop.
> the IT guys have completed a server installtion of RS. when I get to
Report
> Manager home page and click on a report view the properties , and change
the
> name of the report. I click Apply and nothing happens at all... it just
sits
> there' if I refresh the page the original name of the report is loaded
up.
> This is happening with all the apply and ok buttons in reportmanager. but
> the reports that are deployed do run and work fine. As none of the buttons
> work I cannot give peopla access to view the report' no can I set or
apply
> any execution properties....
> Help gretly appreciated!!
> --
> Technical Data Analyst
> Hammersmith & W London College|||Yes I have dbo permission on the databases and have Bultin\admin Contents
manager. Even the OK button on the Assign New Role Screen doesnt work so I
cant add any new users.
Help greatly appreciated...
"Wayne Snyder" wrote:
> Do you have appropriate permissions to do the things you wish?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > Hi hoping someone can help me...
> > We Were running a stand alone version of RS fine on a laptop.
> > the IT guys have completed a server installtion of RS. when I get to
> Report
> > Manager home page and click on a report view the properties , and change
> the
> > name of the report. I click Apply and nothing happens at all... it just
> sits
> > there' if I refresh the page the original name of the report is loaded
> up.
> > This is happening with all the apply and ok buttons in reportmanager. but
> > the reports that are deployed do run and work fine. As none of the buttons
> > work I cannot give peopla access to view the report' no can I set or
> apply
> > any execution properties....
> > Help gretly appreciated!!
> > --
> > Technical Data Analyst
> > Hammersmith & W London College
>
>|||Did you enable Acitve Scripting?
"Munish RaasmaanDaas" wrote:
> Yes I have dbo permission on the databases and have Bultin\admin Contents
> manager. Even the OK button on the Assign New Role Screen doesnt work so I
> cant add any new users.
> Help greatly appreciated...
>
> "Wayne Snyder" wrote:
> > Do you have appropriate permissions to do the things you wish?
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > Hi hoping someone can help me...
> > > We Were running a stand alone version of RS fine on a laptop.
> > > the IT guys have completed a server installtion of RS. when I get to
> > Report
> > > Manager home page and click on a report view the properties , and change
> > the
> > > name of the report. I click Apply and nothing happens at all... it just
> > sits
> > > there' if I refresh the page the original name of the report is loaded
> > up.
> > > This is happening with all the apply and ok buttons in reportmanager. but
> > > the reports that are deployed do run and work fine. As none of the buttons
> > > work I cannot give peopla access to view the report' no can I set or
> > apply
> > > any execution properties....
> > > Help gretly appreciated!!
> > > --
> > > Technical Data Analyst
> > > Hammersmith & W London College
> >
> >
> >|||Do I enable the Active scritpting on the server or the Client'
Thanks Bjorn
"Björn Grünberg" wrote:
> Did you enable Acitve Scripting?
> "Munish RaasmaanDaas" wrote:
> > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > cant add any new users.
> > Help greatly appreciated...
> >
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Do you have appropriate permissions to do the things you wish?
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > Hi hoping someone can help me...
> > > > We Were running a stand alone version of RS fine on a laptop.
> > > > the IT guys have completed a server installtion of RS. when I get to
> > > Report
> > > > Manager home page and click on a report view the properties , and change
> > > the
> > > > name of the report. I click Apply and nothing happens at all... it just
> > > sits
> > > > there' if I refresh the page the original name of the report is loaded
> > > up.
> > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > work I cannot give peopla access to view the report' no can I set or
> > > apply
> > > > any execution properties....
> > > > Help gretly appreciated!!
> > > > --
> > > > Technical Data Analyst
> > > > Hammersmith & W London College
> > >
> > >
> > >|||The client is already set to enable active scripting'
"Munish RaasmaanDaas" wrote:
> Do I enable the Active scritpting on the server or the Client'
> Thanks Bjorn
> "Björn Grünberg" wrote:
> > Did you enable Acitve Scripting?
> >
> > "Munish RaasmaanDaas" wrote:
> >
> > > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > > cant add any new users.
> > > Help greatly appreciated...
> > >
> > >
> > >
> > > "Wayne Snyder" wrote:
> > >
> > > > Do you have appropriate permissions to do the things you wish?
> > > >
> > > > --
> > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > Mariner, Charlotte, NC
> > > > www.mariner-usa.com
> > > > (Please respond only to the newsgroups.)
> > > >
> > > > I support the Professional Association of SQL Server (PASS) and it's
> > > > community of SQL Server professionals.
> > > > www.sqlpass.org
> > > >
> > > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > > Hi hoping someone can help me...
> > > > > We Were running a stand alone version of RS fine on a laptop.
> > > > > the IT guys have completed a server installtion of RS. when I get to
> > > > Report
> > > > > Manager home page and click on a report view the properties , and change
> > > > the
> > > > > name of the report. I click Apply and nothing happens at all... it just
> > > > sits
> > > > > there' if I refresh the page the original name of the report is loaded
> > > > up.
> > > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > > work I cannot give peopla access to view the report' no can I set or
> > > > apply
> > > > > any execution properties....
> > > > > Help gretly appreciated!!
> > > > > --
> > > > > Technical Data Analyst
> > > > > Hammersmith & W London College
> > > >
> > > >
> > > >|||You have to enable Active Scripting in the Browser, you use to work with the
Report Manager (Internet Options - Security - Custom Level - Scripting:
Active Scripting Enable)
I got the same problem like you, and solved it by this.
Good luck!!!
Björn
"Munish RaasmaanDaas" wrote:
> The client is already set to enable active scripting'
> "Munish RaasmaanDaas" wrote:
> > Do I enable the Active scritpting on the server or the Client'
> > Thanks Bjorn
> >
> > "Björn Grünberg" wrote:
> >
> > > Did you enable Acitve Scripting?
> > >
> > > "Munish RaasmaanDaas" wrote:
> > >
> > > > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > > > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > > > cant add any new users.
> > > > Help greatly appreciated...
> > > >
> > > >
> > > >
> > > > "Wayne Snyder" wrote:
> > > >
> > > > > Do you have appropriate permissions to do the things you wish?
> > > > >
> > > > > --
> > > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > > Mariner, Charlotte, NC
> > > > > www.mariner-usa.com
> > > > > (Please respond only to the newsgroups.)
> > > > >
> > > > > I support the Professional Association of SQL Server (PASS) and it's
> > > > > community of SQL Server professionals.
> > > > > www.sqlpass.org
> > > > >
> > > > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > > > Hi hoping someone can help me...
> > > > > > We Were running a stand alone version of RS fine on a laptop.
> > > > > > the IT guys have completed a server installtion of RS. when I get to
> > > > > Report
> > > > > > Manager home page and click on a report view the properties , and change
> > > > > the
> > > > > > name of the report. I click Apply and nothing happens at all... it just
> > > > > sits
> > > > > > there' if I refresh the page the original name of the report is loaded
> > > > > up.
> > > > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > > > work I cannot give peopla access to view the report' no can I set or
> > > > > apply
> > > > > > any execution properties....
> > > > > > Help gretly appreciated!!
> > > > > > --
> > > > > > Technical Data Analyst
> > > > > > Hammersmith & W London College
> > > > >
> > > > >
> > > > >|||Munish, did you find a solution? I have the same problem and I have active
scripting enabled.
Thanks
Dave
"Munish RaasmaanDaas" wrote:
> Hi hoping someone can help me...
> We Were running a stand alone version of RS fine on a laptop.
> the IT guys have completed a server installtion of RS. when I get to Report
> Manager home page and click on a report view the properties , and change the
> name of the report. I click Apply and nothing happens at all... it just sits
> there' if I refresh the page the original name of the report is loaded up.
> This is happening with all the apply and ok buttons in reportmanager. but
> the reports that are deployed do run and work fine. As none of the buttons
> work I cannot give peopla access to view the report' no can I set or apply
> any execution properties....
> Help gretly appreciated!!
> --
> Technical Data Analyst
> Hammersmith & W London College
We Were running a stand alone version of RS fine on a laptop.
the IT guys have completed a server installtion of RS. when I get to Report
Manager home page and click on a report view the properties , and change the
name of the report. I click Apply and nothing happens at all... it just sits
there' if I refresh the page the original name of the report is loaded up.
This is happening with all the apply and ok buttons in reportmanager. but
the reports that are deployed do run and work fine. As none of the buttons
work I cannot give peopla access to view the report' no can I set or apply
any execution properties....
Help gretly appreciated!!
--
Technical Data Analyst
Hammersmith & W London CollegeDo you have appropriate permissions to do the things you wish?
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> Hi hoping someone can help me...
> We Were running a stand alone version of RS fine on a laptop.
> the IT guys have completed a server installtion of RS. when I get to
Report
> Manager home page and click on a report view the properties , and change
the
> name of the report. I click Apply and nothing happens at all... it just
sits
> there' if I refresh the page the original name of the report is loaded
up.
> This is happening with all the apply and ok buttons in reportmanager. but
> the reports that are deployed do run and work fine. As none of the buttons
> work I cannot give peopla access to view the report' no can I set or
apply
> any execution properties....
> Help gretly appreciated!!
> --
> Technical Data Analyst
> Hammersmith & W London College|||Yes I have dbo permission on the databases and have Bultin\admin Contents
manager. Even the OK button on the Assign New Role Screen doesnt work so I
cant add any new users.
Help greatly appreciated...
"Wayne Snyder" wrote:
> Do you have appropriate permissions to do the things you wish?
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > Hi hoping someone can help me...
> > We Were running a stand alone version of RS fine on a laptop.
> > the IT guys have completed a server installtion of RS. when I get to
> Report
> > Manager home page and click on a report view the properties , and change
> the
> > name of the report. I click Apply and nothing happens at all... it just
> sits
> > there' if I refresh the page the original name of the report is loaded
> up.
> > This is happening with all the apply and ok buttons in reportmanager. but
> > the reports that are deployed do run and work fine. As none of the buttons
> > work I cannot give peopla access to view the report' no can I set or
> apply
> > any execution properties....
> > Help gretly appreciated!!
> > --
> > Technical Data Analyst
> > Hammersmith & W London College
>
>|||Did you enable Acitve Scripting?
"Munish RaasmaanDaas" wrote:
> Yes I have dbo permission on the databases and have Bultin\admin Contents
> manager. Even the OK button on the Assign New Role Screen doesnt work so I
> cant add any new users.
> Help greatly appreciated...
>
> "Wayne Snyder" wrote:
> > Do you have appropriate permissions to do the things you wish?
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > Hi hoping someone can help me...
> > > We Were running a stand alone version of RS fine on a laptop.
> > > the IT guys have completed a server installtion of RS. when I get to
> > Report
> > > Manager home page and click on a report view the properties , and change
> > the
> > > name of the report. I click Apply and nothing happens at all... it just
> > sits
> > > there' if I refresh the page the original name of the report is loaded
> > up.
> > > This is happening with all the apply and ok buttons in reportmanager. but
> > > the reports that are deployed do run and work fine. As none of the buttons
> > > work I cannot give peopla access to view the report' no can I set or
> > apply
> > > any execution properties....
> > > Help gretly appreciated!!
> > > --
> > > Technical Data Analyst
> > > Hammersmith & W London College
> >
> >
> >|||Do I enable the Active scritpting on the server or the Client'
Thanks Bjorn
"Björn Grünberg" wrote:
> Did you enable Acitve Scripting?
> "Munish RaasmaanDaas" wrote:
> > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > cant add any new users.
> > Help greatly appreciated...
> >
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Do you have appropriate permissions to do the things you wish?
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > Hi hoping someone can help me...
> > > > We Were running a stand alone version of RS fine on a laptop.
> > > > the IT guys have completed a server installtion of RS. when I get to
> > > Report
> > > > Manager home page and click on a report view the properties , and change
> > > the
> > > > name of the report. I click Apply and nothing happens at all... it just
> > > sits
> > > > there' if I refresh the page the original name of the report is loaded
> > > up.
> > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > work I cannot give peopla access to view the report' no can I set or
> > > apply
> > > > any execution properties....
> > > > Help gretly appreciated!!
> > > > --
> > > > Technical Data Analyst
> > > > Hammersmith & W London College
> > >
> > >
> > >|||The client is already set to enable active scripting'
"Munish RaasmaanDaas" wrote:
> Do I enable the Active scritpting on the server or the Client'
> Thanks Bjorn
> "Björn Grünberg" wrote:
> > Did you enable Acitve Scripting?
> >
> > "Munish RaasmaanDaas" wrote:
> >
> > > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > > cant add any new users.
> > > Help greatly appreciated...
> > >
> > >
> > >
> > > "Wayne Snyder" wrote:
> > >
> > > > Do you have appropriate permissions to do the things you wish?
> > > >
> > > > --
> > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > Mariner, Charlotte, NC
> > > > www.mariner-usa.com
> > > > (Please respond only to the newsgroups.)
> > > >
> > > > I support the Professional Association of SQL Server (PASS) and it's
> > > > community of SQL Server professionals.
> > > > www.sqlpass.org
> > > >
> > > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > > Hi hoping someone can help me...
> > > > > We Were running a stand alone version of RS fine on a laptop.
> > > > > the IT guys have completed a server installtion of RS. when I get to
> > > > Report
> > > > > Manager home page and click on a report view the properties , and change
> > > > the
> > > > > name of the report. I click Apply and nothing happens at all... it just
> > > > sits
> > > > > there' if I refresh the page the original name of the report is loaded
> > > > up.
> > > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > > work I cannot give peopla access to view the report' no can I set or
> > > > apply
> > > > > any execution properties....
> > > > > Help gretly appreciated!!
> > > > > --
> > > > > Technical Data Analyst
> > > > > Hammersmith & W London College
> > > >
> > > >
> > > >|||You have to enable Active Scripting in the Browser, you use to work with the
Report Manager (Internet Options - Security - Custom Level - Scripting:
Active Scripting Enable)
I got the same problem like you, and solved it by this.
Good luck!!!
Björn
"Munish RaasmaanDaas" wrote:
> The client is already set to enable active scripting'
> "Munish RaasmaanDaas" wrote:
> > Do I enable the Active scritpting on the server or the Client'
> > Thanks Bjorn
> >
> > "Björn Grünberg" wrote:
> >
> > > Did you enable Acitve Scripting?
> > >
> > > "Munish RaasmaanDaas" wrote:
> > >
> > > > Yes I have dbo permission on the databases and have Bultin\admin Contents
> > > > manager. Even the OK button on the Assign New Role Screen doesnt work so I
> > > > cant add any new users.
> > > > Help greatly appreciated...
> > > >
> > > >
> > > >
> > > > "Wayne Snyder" wrote:
> > > >
> > > > > Do you have appropriate permissions to do the things you wish?
> > > > >
> > > > > --
> > > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > > Mariner, Charlotte, NC
> > > > > www.mariner-usa.com
> > > > > (Please respond only to the newsgroups.)
> > > > >
> > > > > I support the Professional Association of SQL Server (PASS) and it's
> > > > > community of SQL Server professionals.
> > > > > www.sqlpass.org
> > > > >
> > > > > "Munish RaasmaanDaas" <MunishRaasmaanDaas@.hotmail.com> wrote in message
> > > > > news:6548A2C9-4345-4C64-BBDD-C895D977BB8C@.microsoft.com...
> > > > > > Hi hoping someone can help me...
> > > > > > We Were running a stand alone version of RS fine on a laptop.
> > > > > > the IT guys have completed a server installtion of RS. when I get to
> > > > > Report
> > > > > > Manager home page and click on a report view the properties , and change
> > > > > the
> > > > > > name of the report. I click Apply and nothing happens at all... it just
> > > > > sits
> > > > > > there' if I refresh the page the original name of the report is loaded
> > > > > up.
> > > > > > This is happening with all the apply and ok buttons in reportmanager. but
> > > > > > the reports that are deployed do run and work fine. As none of the buttons
> > > > > > work I cannot give peopla access to view the report' no can I set or
> > > > > apply
> > > > > > any execution properties....
> > > > > > Help gretly appreciated!!
> > > > > > --
> > > > > > Technical Data Analyst
> > > > > > Hammersmith & W London College
> > > > >
> > > > >
> > > > >|||Munish, did you find a solution? I have the same problem and I have active
scripting enabled.
Thanks
Dave
"Munish RaasmaanDaas" wrote:
> Hi hoping someone can help me...
> We Were running a stand alone version of RS fine on a laptop.
> the IT guys have completed a server installtion of RS. when I get to Report
> Manager home page and click on a report view the properties , and change the
> name of the report. I click Apply and nothing happens at all... it just sits
> there' if I refresh the page the original name of the report is loaded up.
> This is happening with all the apply and ok buttons in reportmanager. but
> the reports that are deployed do run and work fine. As none of the buttons
> work I cannot give peopla access to view the report' no can I set or apply
> any execution properties....
> Help gretly appreciated!!
> --
> Technical Data Analyst
> Hammersmith & W London College
Thursday, March 8, 2012
Application unable to connect Sql Server 2005
Hi,
We recently installed Sql 2005 server and it was working fine. But today one of our user reported that they could not able to connect the sql server 2005 from the application. When I checked the error log, I found the following error for every one minute. We restarted the sql service on this sql 2005 instance but still we are getting the same error.
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed.
Could any one help us on that?
Regards,
Sankar
Hello Sankar. There appears to be several possibilities as to what is going on so i will provide the links that I think are the most relevant.
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
http://support.microsoft.com/kb/247931/en-us
OJ has suggested this as a possible means for tracing it - I am not sure of your setup so it may or may not be useful.
0x80090311 error refers to "No authority could be contacted for authentication" which means the user cannot contact AD to get a ticket. I suggest turning on Kerberos logging and using Netmon to trace the authentication routes. You can find detailed info on how to troubleshoot Kerberos here.
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx
Let us know if you have any further questions or if this helps. If you do have further questions/problems please try specifying more details about your setup, e.g. are db and web server on same server? what os? what update revisions, etc.
|||
Hi, SanKar
Is your computer in a Domain? If so, it seems the problem that no KDC can be contacted. Suggest:
1) Disjoin the domain and rejoin your computer to the domain.
2) nslookup
type " <FQDN> of your client computer " see which DC returned.
3) ping <KDCname> if you know the hostname of your DC.
ping -a <ipaddress of your DC>, see whether FQDN returned.
4) Try use "SetSpn.exe" to manually register SPN, see whether it succeeds.
5) Or restart your client computer, try to use a domain account to log on, see what happens.
Good Luck!
Ming.
|||Thanks all for your reply.
We rebooted the sql server. The error is not getting displayed after the server reboot.
Saturday, February 25, 2012
Application of HTMLviewer.css to reports called through Report Man
We are customizing Report Manager and have been able to get the
reportingservices.css style sheet working well.
As we will be calling reports from within Report Manager, we would like to
apply the HTMLviewer.css file to every report called through Report Manger.
This would enable us to get the same look and feel in the Report Manager as
well as the parameter area / HTML viewer.
Does anyone know if it is possible to implement this?
Thanks
DarrenHi!
Really, you have to snag the report call inside the report manager and to
replace it with your url (a call to report server which differs from the one
generated by report manager only in that it the name of css file as a
parameter - rs:StylSheet it seems to me). It's not very difficult, but
requires concentration. I can recommend a book - Hitchiker's guide to
Reporting Services by Peter Blackburn. It can be very helpful.
Regards, Ailil
"Darren" wrote:
> We are customizing Report Manager and have been able to get the
> reportingservices.css style sheet working well.
> As we will be calling reports from within Report Manager, we would like to
> apply the HTMLviewer.css file to every report called through Report Manger.
> This would enable us to get the same look and feel in the Report Manager as
> well as the parameter area / HTML viewer.
> Does anyone know if it is possible to implement this?
> Thanks
> Darren
>|||Great,
Thanks Ailil - so it can be done! I've actually got that book, but not
knowing Java, got a bit lost. I'll get our Java person to have a look at it
- hopefully it will be possible to pass the report string as a variable and
simply add the stylesheet command to the end.
Darren
"Ailil" wrote:
> Hi!
> Really, you have to snag the report call inside the report manager and to
> replace it with your url (a call to report server which differs from the one
> generated by report manager only in that it the name of css file as a
> parameter - rs:StylSheet it seems to me). It's not very difficult, but
> requires concentration. I can recommend a book - Hitchiker's guide to
> Reporting Services by Peter Blackburn. It can be very helpful.
> Regards, Ailil
> "Darren" wrote:
> > We are customizing Report Manager and have been able to get the
> > reportingservices.css style sheet working well.
> >
> > As we will be calling reports from within Report Manager, we would like to
> > apply the HTMLviewer.css file to every report called through Report Manger.
> > This would enable us to get the same look and feel in the Report Manager as
> > well as the parameter area / HTML viewer.
> >
> > Does anyone know if it is possible to implement this?
> >
> > Thanks
> > Darren
> >
> >|||Hello!
Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
Report Manager? It can be quite ok without java :), particularly if you
already have the book.
Regards, Ailil
"Darren" wrote:
> Great,
> Thanks Ailil - so it can be done! I've actually got that book, but not
> knowing Java, got a bit lost. I'll get our Java person to have a look at it
> - hopefully it will be possible to pass the report string as a variable and
> simply add the stylesheet command to the end.
> Darren
> "Ailil" wrote:
> > Hi!
> >
> > Really, you have to snag the report call inside the report manager and to
> > replace it with your url (a call to report server which differs from the one
> > generated by report manager only in that it the name of css file as a
> > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > requires concentration. I can recommend a book - Hitchiker's guide to
> > Reporting Services by Peter Blackburn. It can be very helpful.
> >
> > Regards, Ailil
> >
> > "Darren" wrote:
> >
> > > We are customizing Report Manager and have been able to get the
> > > reportingservices.css style sheet working well.
> > >
> > > As we will be calling reports from within Report Manager, we would like to
> > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > This would enable us to get the same look and feel in the Report Manager as
> > > well as the parameter area / HTML viewer.
> > >
> > > Does anyone know if it is possible to implement this?
> > >
> > > Thanks
> > > Darren
> > >
> > >|||Hi Ailil,
I figured that we would have to intercept the call to the Report Server as
shown on page 533, to replace the standard URL call generated by Report
Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
to the end.
Thanks
Darren
"Ailil" wrote:
> Hello!
> Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> Report Manager? It can be quite ok without java :), particularly if you
> already have the book.
> Regards, Ailil
> "Darren" wrote:
> > Great,
> >
> > Thanks Ailil - so it can be done! I've actually got that book, but not
> > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > - hopefully it will be possible to pass the report string as a variable and
> > simply add the stylesheet command to the end.
> >
> > Darren
> >
> > "Ailil" wrote:
> >
> > > Hi!
> > >
> > > Really, you have to snag the report call inside the report manager and to
> > > replace it with your url (a call to report server which differs from the one
> > > generated by report manager only in that it the name of css file as a
> > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > Reporting Services by Peter Blackburn. It can be very helpful.
> > >
> > > Regards, Ailil
> > >
> > > "Darren" wrote:
> > >
> > > > We are customizing Report Manager and have been able to get the
> > > > reportingservices.css style sheet working well.
> > > >
> > > > As we will be calling reports from within Report Manager, we would like to
> > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > This would enable us to get the same look and feel in the Report Manager as
> > > > well as the parameter area / HTML viewer.
> > > >
> > > > Does anyone know if it is possible to implement this?
> > > >
> > > > Thanks
> > > > Darren
> > > >
> > > >|||Hi!
Hey :). You mean JavaScript :). It's a bit different thing )
Regards, Ailil
"Darren" wrote:
> Hi Ailil,
> I figured that we would have to intercept the call to the Report Server as
> shown on page 533, to replace the standard URL call generated by Report
> Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
> to the end.
> Thanks
> Darren
> "Ailil" wrote:
> > Hello!
> > Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> > Report Manager? It can be quite ok without java :), particularly if you
> > already have the book.
> >
> > Regards, Ailil
> >
> > "Darren" wrote:
> >
> > > Great,
> > >
> > > Thanks Ailil - so it can be done! I've actually got that book, but not
> > > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > > - hopefully it will be possible to pass the report string as a variable and
> > > simply add the stylesheet command to the end.
> > >
> > > Darren
> > >
> > > "Ailil" wrote:
> > >
> > > > Hi!
> > > >
> > > > Really, you have to snag the report call inside the report manager and to
> > > > replace it with your url (a call to report server which differs from the one
> > > > generated by report manager only in that it the name of css file as a
> > > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > > Reporting Services by Peter Blackburn. It can be very helpful.
> > > >
> > > > Regards, Ailil
> > > >
> > > > "Darren" wrote:
> > > >
> > > > > We are customizing Report Manager and have been able to get the
> > > > > reportingservices.css style sheet working well.
> > > > >
> > > > > As we will be calling reports from within Report Manager, we would like to
> > > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > > This would enable us to get the same look and feel in the Report Manager as
> > > > > well as the parameter area / HTML viewer.
> > > > >
> > > > > Does anyone know if it is possible to implement this?
> > > > >
> > > > > Thanks
> > > > > Darren
> > > > >
> > > > >|||Yeah - meant JavaScript not Java.
I've posted another message re changing the default htmlviewer style sheet
as the SP2 readme file says that there is a config setting where you can
change the default style sheet.
Thanks for your help.
Darren
"Ailil" wrote:
> Hi!
> Hey :). You mean JavaScript :). It's a bit different thing )
> Regards, Ailil
> "Darren" wrote:
> > Hi Ailil,
> >
> > I figured that we would have to intercept the call to the Report Server as
> > shown on page 533, to replace the standard URL call generated by Report
> > Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
> > to the end.
> >
> > Thanks
> > Darren
> >
> > "Ailil" wrote:
> >
> > > Hello!
> > > Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> > > Report Manager? It can be quite ok without java :), particularly if you
> > > already have the book.
> > >
> > > Regards, Ailil
> > >
> > > "Darren" wrote:
> > >
> > > > Great,
> > > >
> > > > Thanks Ailil - so it can be done! I've actually got that book, but not
> > > > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > > > - hopefully it will be possible to pass the report string as a variable and
> > > > simply add the stylesheet command to the end.
> > > >
> > > > Darren
> > > >
> > > > "Ailil" wrote:
> > > >
> > > > > Hi!
> > > > >
> > > > > Really, you have to snag the report call inside the report manager and to
> > > > > replace it with your url (a call to report server which differs from the one
> > > > > generated by report manager only in that it the name of css file as a
> > > > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > > > Reporting Services by Peter Blackburn. It can be very helpful.
> > > > >
> > > > > Regards, Ailil
> > > > >
> > > > > "Darren" wrote:
> > > > >
> > > > > > We are customizing Report Manager and have been able to get the
> > > > > > reportingservices.css style sheet working well.
> > > > > >
> > > > > > As we will be calling reports from within Report Manager, we would like to
> > > > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > > > This would enable us to get the same look and feel in the Report Manager as
> > > > > > well as the parameter area / HTML viewer.
> > > > > >
> > > > > > Does anyone know if it is possible to implement this?
> > > > > >
> > > > > > Thanks
> > > > > > Darren
> > > > > >
> > > > > >
reportingservices.css style sheet working well.
As we will be calling reports from within Report Manager, we would like to
apply the HTMLviewer.css file to every report called through Report Manger.
This would enable us to get the same look and feel in the Report Manager as
well as the parameter area / HTML viewer.
Does anyone know if it is possible to implement this?
Thanks
DarrenHi!
Really, you have to snag the report call inside the report manager and to
replace it with your url (a call to report server which differs from the one
generated by report manager only in that it the name of css file as a
parameter - rs:StylSheet it seems to me). It's not very difficult, but
requires concentration. I can recommend a book - Hitchiker's guide to
Reporting Services by Peter Blackburn. It can be very helpful.
Regards, Ailil
"Darren" wrote:
> We are customizing Report Manager and have been able to get the
> reportingservices.css style sheet working well.
> As we will be calling reports from within Report Manager, we would like to
> apply the HTMLviewer.css file to every report called through Report Manger.
> This would enable us to get the same look and feel in the Report Manager as
> well as the parameter area / HTML viewer.
> Does anyone know if it is possible to implement this?
> Thanks
> Darren
>|||Great,
Thanks Ailil - so it can be done! I've actually got that book, but not
knowing Java, got a bit lost. I'll get our Java person to have a look at it
- hopefully it will be possible to pass the report string as a variable and
simply add the stylesheet command to the end.
Darren
"Ailil" wrote:
> Hi!
> Really, you have to snag the report call inside the report manager and to
> replace it with your url (a call to report server which differs from the one
> generated by report manager only in that it the name of css file as a
> parameter - rs:StylSheet it seems to me). It's not very difficult, but
> requires concentration. I can recommend a book - Hitchiker's guide to
> Reporting Services by Peter Blackburn. It can be very helpful.
> Regards, Ailil
> "Darren" wrote:
> > We are customizing Report Manager and have been able to get the
> > reportingservices.css style sheet working well.
> >
> > As we will be calling reports from within Report Manager, we would like to
> > apply the HTMLviewer.css file to every report called through Report Manger.
> > This would enable us to get the same look and feel in the Report Manager as
> > well as the parameter area / HTML viewer.
> >
> > Does anyone know if it is possible to implement this?
> >
> > Thanks
> > Darren
> >
> >|||Hello!
Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
Report Manager? It can be quite ok without java :), particularly if you
already have the book.
Regards, Ailil
"Darren" wrote:
> Great,
> Thanks Ailil - so it can be done! I've actually got that book, but not
> knowing Java, got a bit lost. I'll get our Java person to have a look at it
> - hopefully it will be possible to pass the report string as a variable and
> simply add the stylesheet command to the end.
> Darren
> "Ailil" wrote:
> > Hi!
> >
> > Really, you have to snag the report call inside the report manager and to
> > replace it with your url (a call to report server which differs from the one
> > generated by report manager only in that it the name of css file as a
> > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > requires concentration. I can recommend a book - Hitchiker's guide to
> > Reporting Services by Peter Blackburn. It can be very helpful.
> >
> > Regards, Ailil
> >
> > "Darren" wrote:
> >
> > > We are customizing Report Manager and have been able to get the
> > > reportingservices.css style sheet working well.
> > >
> > > As we will be calling reports from within Report Manager, we would like to
> > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > This would enable us to get the same look and feel in the Report Manager as
> > > well as the parameter area / HTML viewer.
> > >
> > > Does anyone know if it is possible to implement this?
> > >
> > > Thanks
> > > Darren
> > >
> > >|||Hi Ailil,
I figured that we would have to intercept the call to the Report Server as
shown on page 533, to replace the standard URL call generated by Report
Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
to the end.
Thanks
Darren
"Ailil" wrote:
> Hello!
> Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> Report Manager? It can be quite ok without java :), particularly if you
> already have the book.
> Regards, Ailil
> "Darren" wrote:
> > Great,
> >
> > Thanks Ailil - so it can be done! I've actually got that book, but not
> > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > - hopefully it will be possible to pass the report string as a variable and
> > simply add the stylesheet command to the end.
> >
> > Darren
> >
> > "Ailil" wrote:
> >
> > > Hi!
> > >
> > > Really, you have to snag the report call inside the report manager and to
> > > replace it with your url (a call to report server which differs from the one
> > > generated by report manager only in that it the name of css file as a
> > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > Reporting Services by Peter Blackburn. It can be very helpful.
> > >
> > > Regards, Ailil
> > >
> > > "Darren" wrote:
> > >
> > > > We are customizing Report Manager and have been able to get the
> > > > reportingservices.css style sheet working well.
> > > >
> > > > As we will be calling reports from within Report Manager, we would like to
> > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > This would enable us to get the same look and feel in the Report Manager as
> > > > well as the parameter area / HTML viewer.
> > > >
> > > > Does anyone know if it is possible to implement this?
> > > >
> > > > Thanks
> > > > Darren
> > > >
> > > >|||Hi!
Hey :). You mean JavaScript :). It's a bit different thing )
Regards, Ailil
"Darren" wrote:
> Hi Ailil,
> I figured that we would have to intercept the call to the Report Server as
> shown on page 533, to replace the standard URL call generated by Report
> Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
> to the end.
> Thanks
> Darren
> "Ailil" wrote:
> > Hello!
> > Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> > Report Manager? It can be quite ok without java :), particularly if you
> > already have the book.
> >
> > Regards, Ailil
> >
> > "Darren" wrote:
> >
> > > Great,
> > >
> > > Thanks Ailil - so it can be done! I've actually got that book, but not
> > > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > > - hopefully it will be possible to pass the report string as a variable and
> > > simply add the stylesheet command to the end.
> > >
> > > Darren
> > >
> > > "Ailil" wrote:
> > >
> > > > Hi!
> > > >
> > > > Really, you have to snag the report call inside the report manager and to
> > > > replace it with your url (a call to report server which differs from the one
> > > > generated by report manager only in that it the name of css file as a
> > > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > > Reporting Services by Peter Blackburn. It can be very helpful.
> > > >
> > > > Regards, Ailil
> > > >
> > > > "Darren" wrote:
> > > >
> > > > > We are customizing Report Manager and have been able to get the
> > > > > reportingservices.css style sheet working well.
> > > > >
> > > > > As we will be calling reports from within Report Manager, we would like to
> > > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > > This would enable us to get the same look and feel in the Report Manager as
> > > > > well as the parameter area / HTML viewer.
> > > > >
> > > > > Does anyone know if it is possible to implement this?
> > > > >
> > > > > Thanks
> > > > > Darren
> > > > >
> > > > >|||Yeah - meant JavaScript not Java.
I've posted another message re changing the default htmlviewer style sheet
as the SP2 readme file says that there is a config setting where you can
change the default style sheet.
Thanks for your help.
Darren
"Ailil" wrote:
> Hi!
> Hey :). You mean JavaScript :). It's a bit different thing )
> Regards, Ailil
> "Darren" wrote:
> > Hi Ailil,
> >
> > I figured that we would have to intercept the call to the Report Server as
> > shown on page 533, to replace the standard URL call generated by Report
> > Manager, with a URL where the parameter 'rc:Stylesheet = htmlviewer' is added
> > to the end.
> >
> > Thanks
> > Darren
> >
> > "Ailil" wrote:
> >
> > > Hello!
> > > Now I'm a bit lost ;). Why Java? Where are you going to use Java in the
> > > Report Manager? It can be quite ok without java :), particularly if you
> > > already have the book.
> > >
> > > Regards, Ailil
> > >
> > > "Darren" wrote:
> > >
> > > > Great,
> > > >
> > > > Thanks Ailil - so it can be done! I've actually got that book, but not
> > > > knowing Java, got a bit lost. I'll get our Java person to have a look at it
> > > > - hopefully it will be possible to pass the report string as a variable and
> > > > simply add the stylesheet command to the end.
> > > >
> > > > Darren
> > > >
> > > > "Ailil" wrote:
> > > >
> > > > > Hi!
> > > > >
> > > > > Really, you have to snag the report call inside the report manager and to
> > > > > replace it with your url (a call to report server which differs from the one
> > > > > generated by report manager only in that it the name of css file as a
> > > > > parameter - rs:StylSheet it seems to me). It's not very difficult, but
> > > > > requires concentration. I can recommend a book - Hitchiker's guide to
> > > > > Reporting Services by Peter Blackburn. It can be very helpful.
> > > > >
> > > > > Regards, Ailil
> > > > >
> > > > > "Darren" wrote:
> > > > >
> > > > > > We are customizing Report Manager and have been able to get the
> > > > > > reportingservices.css style sheet working well.
> > > > > >
> > > > > > As we will be calling reports from within Report Manager, we would like to
> > > > > > apply the HTMLviewer.css file to every report called through Report Manger.
> > > > > > This would enable us to get the same look and feel in the Report Manager as
> > > > > > well as the parameter area / HTML viewer.
> > > > > >
> > > > > > Does anyone know if it is possible to implement this?
> > > > > >
> > > > > > Thanks
> > > > > > Darren
> > > > > >
> > > > > >
Application need Date without Time
Hello,
We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.
We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.
How I can resolve this issue I didn't get any solution in short way.
Thanks in advance to every particapetience.
R.MallYou do know that datetime data always stores both. right?
If no time is supplied the default time is 0, or midnight.
We are managing industry standard application for solvent business need and it is working fine as per requirement but after replication we got some problem with date type data.
We have stored date data through application in dd/mm/yy format only, we didn't used time data so it is truncated in overall application but after implementation for replication (Merge Model) from multiple location some date field automatically get time with date value, so some time application not retrieving data from database owing to stored time with date.
How I can resolve this issue I didn't get any solution in short way.
Thanks in advance to every particapetience.
R.MallYou do know that datetime data always stores both. right?
If no time is supplied the default time is 0, or midnight.
Application is closed during second synchronization
My Merge Replication was working correctly till New Year.
The initial synchronization is always synchronous (I must have a
database in order to start my application) and the rest of them are
asynchronous. This scenarios was working perfectly.
Now, without making any changes, initial replication (copy of the whole
database) is correctly done, but subsequent replication calls fail, and
fail without giving any error! I've got a catch block where I display a
messagebox with the thrown exception but this code is never reached. An
aplication is completely closed without any error message.
What can be happening? It's really strange and very urgent. I promise
you this code was perfecty working before Christmas.
Ah! I've also tried making a synchronous replication second time, but
same thing occurs.I've deleted the local database, created again the
publication on the server.........
I would really appreciate any help on this. Thanks very much.
Can you successfully run the merge agent from SSMS? If not, is there any
message sent?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I've now checked another thing: when I've already got a local database,
second, third, fourth and subsequent synchronizations are correctly
done, and they ar ein asynchronous mode.
The problems is starting the application for the first time, with no
database. Database is correctly downloaded first time, but second time,
my application exits without any error message.
Sorry for my poor SQL Server knowledge, but how do I run the Merge
Agent from Management Studio?
Really strange.......thanks for your help.
|||To start the merge agent in SQL Server 2000, open Enterprise Manager,
Replication Monitor, Expand the publication and on the RHS you'll see the
related agents. Right-clicking on it will allow you to start the agent. In
SSMS (SQL Server 2005) the process is similar, but Replication Monitor is a
separate application that is started by right-clicking the replication
folder.
Also, I proobably need a little more clarification about some of your
descriptions. You mention starting the application when you don't have a
local database. Does your application create a local database and then
create the publication, subscription and then initialize the subscription?
Also, you're using asychronous and synchronous processing - are you
referring to MSMQ, Service Broker or some such mechanism?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I've been able to start the Merge Agent from SQL Server 2005 Management
Studio. Agent runs correctly.
Some clarifications:
I use always Merge Replication.
My application initially checks if there is a local database
(downloaded before maybe); if there is, the synchronization is
asynchronous because we have data to play with.
If there is no database, I make a synchronous call with Synchronize()
method and wait. Then, I again have got data to play with. Next calls
will also be asynchronous.
This is the merge replication code I'm using. Really simple:
private void CheckReplicationStatus(object sender, EventArgs e)
{
if (true)
{
try
{
ConfigureReplicationManager();
if (replicationManager !=3D null &&
systemCanReplicate)
{
replicationManager.HostName =3D userId;
// Check if the database file already exists
if
(!System.IO.File.Exists(Constants.DatabaseFilePath ))
{
// Add a new subscripton and create the
local database file
replicationManager.AddSubscription(AddOption.Creat eDatabase);
// La replicaci=F3n inicial es
necesariamente s=EDncrona ya que no existe la BD en local
replicationManager.Synchronize();
replicationManager.Dispose();
}
else
{
// Replicaci=F3n as=EDncrona
IAsyncResult ar =3D
replicationManager.BeginSynchronize(new
AsyncCallback(SyncCompletedCallback), replicationManager);
}
}
else // No ha sido capaz de leer los ficheros de
configuraci=F3n y no ha podido configurar la replicaci=F3n
{
// La idea es ver si la BD existe en el
dispositivo --> Se le deja continuar ejecutando la aplicaci=F3n
// pero se cancela la replicaci=F3n. Pero no hay
manera ya que el path de la BD est=E1 tambi=E9n en los ficheros de
configuraci=F3n
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_CannotRea=
dConfigurationFiles);
Application.Exit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToUpper());
replicationManager.Dispose();
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_InitialSy=
nchronizationFailed);
// TODO: BORRAR LA BD YA QUE NO ES UNA BD OPERATIVA
Application.Exit();
}
}
}
/// <summary>
/// Evento que recoge los resultados de la sincronizaci=F3n
as=EDncrona
/// </summary>
/// <param name=3D"ar"></param>
public void SyncCompletedCallback(IAsyncResult ar)
{
try
{
SqlCeReplication repl =3D
(SqlCeReplication)ar.AsyncState;
replicationManager =3D (SqlCeReplication)ar.AsyncState;
replicationManager.EndSynchronize(ar);
}
catch (SqlCeException exc)
{
// Fallo en la sincronizaci=F3n as=EDncrona --> La
aplicaci=F3n sigue corriendo ya que tenemos BD en local
replicationManager.CancelSynchronize();
}
finally
{
replicationManager.Dispose();
}
}
This is all what I have Paul. Don't know what to do yet! It was working
and I'm spending my second day after a solution for this.
What do you think? Seems SQL Server's fault to me but cannot explain
why only fails second synchronization after first synchronization in
which I download all database.
Thanks for your time. Regards.
|||Hi again Paul,
I've tried to debug but I loose debugger when executing Synchronize()
method for the second time. I'm suffering this problem with the
debugger. It tells me:
"The remote connection to the device has been lost. Please verify the
device connection and restart debugging".
I saw a solution for this error on the internet and although I don't
know if it's related, I installed "Virtual Machine Network Driver for
Microsoft Device Emulator".
But debugger continues failing.
I don't know what else could I do. What frustrating is this situation!
Thanks.
|||If the merge agent can be successfully run in the case of the Synchronous
setup, then it seems to point to an application issue. Sorry, but
unfortunately I'm probably not the best to help in terms of debugging the C#
code (and debugging the debugger itself
), so hopefully someone else can
continue the thread. If not, I'd recommend posting this in the C# newsgroup.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Starting the application without database and debugging, first
synchronization is correctly done. Second one crashes again my
debugger.
Starting the application with the database downloaded in the first try,
first synchronization is again correct. Second crashes again my
debugger.
Thanks Paul for your interest. Don't know exactly how but I suddenly
received just before having lunch this error from the application:
"A call to SQL Server Reconciler failed. Try to resynchronize.; The
Subscriber's schema version information is inconsistent with the
Publisher's schema version information. It is likely that the Publisher
has been restored from a backup whose schema change version is
different from the Subscriber. Rerun the Snapshot agent and
reinitialize the subscriptions. The Publisher and Subscriber schema
guids and version are:
'FFE575BF-5368-41BE-A451-10723451634B',272,'892E72E7-962F-437A-9228-F757FED7ECB9',272
respectively.}"
I've never seen that error before but I understand deleting and
generating again the publication will solve it.
Thanks for your time.
|||Your schema versions do not match. If you reinitialize, it will clean this
up.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1136285094.858729.123150@.g49g2000cwa.googlegr oups.com...
I've been able to start the Merge Agent from SQL Server 2005 Management
Studio. Agent runs correctly.
Some clarifications:
I use always Merge Replication.
My application initially checks if there is a local database
(downloaded before maybe); if there is, the synchronization is
asynchronous because we have data to play with.
If there is no database, I make a synchronous call with Synchronize()
method and wait. Then, I again have got data to play with. Next calls
will also be asynchronous.
This is the merge replication code I'm using. Really simple:
private void CheckReplicationStatus(object sender, EventArgs e)
{
if (true)
{
try
{
ConfigureReplicationManager();
if (replicationManager != null &&
systemCanReplicate)
{
replicationManager.HostName = userId;
// Check if the database file already exists
if
(!System.IO.File.Exists(Constants.DatabaseFilePath ))
{
// Add a new subscripton and create the
local database file
replicationManager.AddSubscription(AddOption.Creat eDatabase);
// La replicacin inicial es
necesariamente sncrona ya que no existe la BD en local
replicationManager.Synchronize();
replicationManager.Dispose();
}
else
{
// Replicacin asncrona
IAsyncResult ar =
replicationManager.BeginSynchronize(new
AsyncCallback(SyncCompletedCallback), replicationManager);
}
}
else // No ha sido capaz de leer los ficheros de
configuracin y no ha podido configurar la replicacin
{
// La idea es ver si la BD existe en el
dispositivo --> Se le deja continuar ejecutando la aplicacin
// pero se cancela la replicacin. Pero no hay
manera ya que el path de la BD est tambin en los ficheros de
configuracin
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_CannotReadConfigurationFiles);
Application.Exit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToUpper());
replicationManager.Dispose();
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_InitialSynchronizationFailed);
// TODO: BORRAR LA BD YA QUE NO ES UNA BD OPERATIVA
Application.Exit();
}
}
}
/// <summary>
/// Evento que recoge los resultados de la sincronizacin
asncrona
/// </summary>
/// <param name="ar"></param>
public void SyncCompletedCallback(IAsyncResult ar)
{
try
{
SqlCeReplication repl =
(SqlCeReplication)ar.AsyncState;
replicationManager = (SqlCeReplication)ar.AsyncState;
replicationManager.EndSynchronize(ar);
}
catch (SqlCeException exc)
{
// Fallo en la sincronizacin asncrona --> La
aplicacin sigue corriendo ya que tenemos BD en local
replicationManager.CancelSynchronize();
}
finally
{
replicationManager.Dispose();
}
}
This is all what I have Paul. Don't know what to do yet! It was working
and I'm spending my second day after a solution for this.
What do you think? Seems SQL Server's fault to me but cannot explain
why only fails second synchronization after first synchronization in
which I download all database.
Thanks for your time. Regards.
The initial synchronization is always synchronous (I must have a
database in order to start my application) and the rest of them are
asynchronous. This scenarios was working perfectly.
Now, without making any changes, initial replication (copy of the whole
database) is correctly done, but subsequent replication calls fail, and
fail without giving any error! I've got a catch block where I display a
messagebox with the thrown exception but this code is never reached. An
aplication is completely closed without any error message.
What can be happening? It's really strange and very urgent. I promise
you this code was perfecty working before Christmas.
Ah! I've also tried making a synchronous replication second time, but
same thing occurs.I've deleted the local database, created again the
publication on the server.........
I would really appreciate any help on this. Thanks very much.
Can you successfully run the merge agent from SSMS? If not, is there any
message sent?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I've now checked another thing: when I've already got a local database,
second, third, fourth and subsequent synchronizations are correctly
done, and they ar ein asynchronous mode.
The problems is starting the application for the first time, with no
database. Database is correctly downloaded first time, but second time,
my application exits without any error message.
Sorry for my poor SQL Server knowledge, but how do I run the Merge
Agent from Management Studio?
Really strange.......thanks for your help.
|||To start the merge agent in SQL Server 2000, open Enterprise Manager,
Replication Monitor, Expand the publication and on the RHS you'll see the
related agents. Right-clicking on it will allow you to start the agent. In
SSMS (SQL Server 2005) the process is similar, but Replication Monitor is a
separate application that is started by right-clicking the replication
folder.
Also, I proobably need a little more clarification about some of your
descriptions. You mention starting the application when you don't have a
local database. Does your application create a local database and then
create the publication, subscription and then initialize the subscription?
Also, you're using asychronous and synchronous processing - are you
referring to MSMQ, Service Broker or some such mechanism?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I've been able to start the Merge Agent from SQL Server 2005 Management
Studio. Agent runs correctly.
Some clarifications:
I use always Merge Replication.
My application initially checks if there is a local database
(downloaded before maybe); if there is, the synchronization is
asynchronous because we have data to play with.
If there is no database, I make a synchronous call with Synchronize()
method and wait. Then, I again have got data to play with. Next calls
will also be asynchronous.
This is the merge replication code I'm using. Really simple:
private void CheckReplicationStatus(object sender, EventArgs e)
{
if (true)
{
try
{
ConfigureReplicationManager();
if (replicationManager !=3D null &&
systemCanReplicate)
{
replicationManager.HostName =3D userId;
// Check if the database file already exists
if
(!System.IO.File.Exists(Constants.DatabaseFilePath ))
{
// Add a new subscripton and create the
local database file
replicationManager.AddSubscription(AddOption.Creat eDatabase);
// La replicaci=F3n inicial es
necesariamente s=EDncrona ya que no existe la BD en local
replicationManager.Synchronize();
replicationManager.Dispose();
}
else
{
// Replicaci=F3n as=EDncrona
IAsyncResult ar =3D
replicationManager.BeginSynchronize(new
AsyncCallback(SyncCompletedCallback), replicationManager);
}
}
else // No ha sido capaz de leer los ficheros de
configuraci=F3n y no ha podido configurar la replicaci=F3n
{
// La idea es ver si la BD existe en el
dispositivo --> Se le deja continuar ejecutando la aplicaci=F3n
// pero se cancela la replicaci=F3n. Pero no hay
manera ya que el path de la BD est=E1 tambi=E9n en los ficheros de
configuraci=F3n
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_CannotRea=
dConfigurationFiles);
Application.Exit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToUpper());
replicationManager.Dispose();
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_InitialSy=
nchronizationFailed);
// TODO: BORRAR LA BD YA QUE NO ES UNA BD OPERATIVA
Application.Exit();
}
}
}
/// <summary>
/// Evento que recoge los resultados de la sincronizaci=F3n
as=EDncrona
/// </summary>
/// <param name=3D"ar"></param>
public void SyncCompletedCallback(IAsyncResult ar)
{
try
{
SqlCeReplication repl =3D
(SqlCeReplication)ar.AsyncState;
replicationManager =3D (SqlCeReplication)ar.AsyncState;
replicationManager.EndSynchronize(ar);
}
catch (SqlCeException exc)
{
// Fallo en la sincronizaci=F3n as=EDncrona --> La
aplicaci=F3n sigue corriendo ya que tenemos BD en local
replicationManager.CancelSynchronize();
}
finally
{
replicationManager.Dispose();
}
}
This is all what I have Paul. Don't know what to do yet! It was working
and I'm spending my second day after a solution for this.
What do you think? Seems SQL Server's fault to me but cannot explain
why only fails second synchronization after first synchronization in
which I download all database.
Thanks for your time. Regards.
|||Hi again Paul,
I've tried to debug but I loose debugger when executing Synchronize()
method for the second time. I'm suffering this problem with the
debugger. It tells me:
"The remote connection to the device has been lost. Please verify the
device connection and restart debugging".
I saw a solution for this error on the internet and although I don't
know if it's related, I installed "Virtual Machine Network Driver for
Microsoft Device Emulator".
But debugger continues failing.
I don't know what else could I do. What frustrating is this situation!
Thanks.
|||If the merge agent can be successfully run in the case of the Synchronous
setup, then it seems to point to an application issue. Sorry, but
unfortunately I'm probably not the best to help in terms of debugging the C#
code (and debugging the debugger itself
), so hopefully someone else cancontinue the thread. If not, I'd recommend posting this in the C# newsgroup.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Starting the application without database and debugging, first
synchronization is correctly done. Second one crashes again my
debugger.
Starting the application with the database downloaded in the first try,
first synchronization is again correct. Second crashes again my
debugger.
Thanks Paul for your interest. Don't know exactly how but I suddenly
received just before having lunch this error from the application:
"A call to SQL Server Reconciler failed. Try to resynchronize.; The
Subscriber's schema version information is inconsistent with the
Publisher's schema version information. It is likely that the Publisher
has been restored from a backup whose schema change version is
different from the Subscriber. Rerun the Snapshot agent and
reinitialize the subscriptions. The Publisher and Subscriber schema
guids and version are:
'FFE575BF-5368-41BE-A451-10723451634B',272,'892E72E7-962F-437A-9228-F757FED7ECB9',272
respectively.}"
I've never seen that error before but I understand deleting and
generating again the publication will solve it.
Thanks for your time.
|||Your schema versions do not match. If you reinitialize, it will clean this
up.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1136285094.858729.123150@.g49g2000cwa.googlegr oups.com...
I've been able to start the Merge Agent from SQL Server 2005 Management
Studio. Agent runs correctly.
Some clarifications:
I use always Merge Replication.
My application initially checks if there is a local database
(downloaded before maybe); if there is, the synchronization is
asynchronous because we have data to play with.
If there is no database, I make a synchronous call with Synchronize()
method and wait. Then, I again have got data to play with. Next calls
will also be asynchronous.
This is the merge replication code I'm using. Really simple:
private void CheckReplicationStatus(object sender, EventArgs e)
{
if (true)
{
try
{
ConfigureReplicationManager();
if (replicationManager != null &&
systemCanReplicate)
{
replicationManager.HostName = userId;
// Check if the database file already exists
if
(!System.IO.File.Exists(Constants.DatabaseFilePath ))
{
// Add a new subscripton and create the
local database file
replicationManager.AddSubscription(AddOption.Creat eDatabase);
// La replicacin inicial es
necesariamente sncrona ya que no existe la BD en local
replicationManager.Synchronize();
replicationManager.Dispose();
}
else
{
// Replicacin asncrona
IAsyncResult ar =
replicationManager.BeginSynchronize(new
AsyncCallback(SyncCompletedCallback), replicationManager);
}
}
else // No ha sido capaz de leer los ficheros de
configuracin y no ha podido configurar la replicacin
{
// La idea es ver si la BD existe en el
dispositivo --> Se le deja continuar ejecutando la aplicacin
// pero se cancela la replicacin. Pero no hay
manera ya que el path de la BD est tambin en los ficheros de
configuracin
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_CannotReadConfigurationFiles);
Application.Exit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToUpper());
replicationManager.Dispose();
GeneralBehaviour.ShowErrorMessage(Properties.Resou rces.MasterForm_InitialSynchronizationFailed);
// TODO: BORRAR LA BD YA QUE NO ES UNA BD OPERATIVA
Application.Exit();
}
}
}
/// <summary>
/// Evento que recoge los resultados de la sincronizacin
asncrona
/// </summary>
/// <param name="ar"></param>
public void SyncCompletedCallback(IAsyncResult ar)
{
try
{
SqlCeReplication repl =
(SqlCeReplication)ar.AsyncState;
replicationManager = (SqlCeReplication)ar.AsyncState;
replicationManager.EndSynchronize(ar);
}
catch (SqlCeException exc)
{
// Fallo en la sincronizacin asncrona --> La
aplicacin sigue corriendo ya que tenemos BD en local
replicationManager.CancelSynchronize();
}
finally
{
replicationManager.Dispose();
}
}
This is all what I have Paul. Don't know what to do yet! It was working
and I'm spending my second day after a solution for this.
What do you think? Seems SQL Server's fault to me but cannot explain
why only fails second synchronization after first synchronization in
which I download all database.
Thanks for your time. Regards.
Sunday, February 19, 2012
Append to a field in a database
Hey guys,
I am working on some ASP stuff, and I have an html table which displays records from a SQL table.There is one field for adding notes which i want to append to. Basically I have a textbox, in which if a user enters information, it should be appended to a field (rNotes) in my database table. Right now all i can get it to do is overwrite the current information as i'm using an UPDATE query. Any ideas?In update statement you should use:
Personally, I would create a notes table, and add records. This way, you can also store things like date/time, user id, etc. You can then just display them in sequential order. I do this with ASP all the time. Just did it yesterday, as a matter of fact. The client loved it.
I am working on some ASP stuff, and I have an html table which displays records from a SQL table.There is one field for adding notes which i want to append to. Basically I have a textbox, in which if a user enters information, it should be appended to a field (rNotes) in my database table. Right now all i can get it to do is overwrite the current information as i'm using an UPDATE query. Any ideas?In update statement you should use:
Update table_name set
column_name = column_name + new_data
where ....|||
Quote:
Originally Posted by nikhil86
Hey guys,
I am working on some ASP stuff, and I have an html table which displays records from a SQL table.There is one field for adding notes which i want to append to. Basically I have a textbox, in which if a user enters information, it should be appended to a field (rNotes) in my database table. Right now all i can get it to do is overwrite the current information as i'm using an UPDATE query. Any ideas?
Personally, I would create a notes table, and add records. This way, you can also store things like date/time, user id, etc. You can then just display them in sequential order. I do this with ASP all the time. Just did it yesterday, as a matter of fact. The client loved it.
Good luck,
Michael C. Gates
Thursday, February 9, 2012
anyone use a 3rd party product to load balance SQL Server?
I'm working on a project needing a high-end large mission critical database
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?
HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?
HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.
anyone use a 3rd party product to load balance SQL Server?
I'm working on a project needing a high-end large mission critical database
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.
Subscribe to:
Posts (Atom)