When setting up Queued Updating Replication it seems to get hung up. It gets to adding article 445 of 1083 and just stays there for a very long time.
Is there anything I can do or should I just wait it out?
I checked sp_who, I don't see any blocking. Any ideas?
Thanx!
JLS,
as long as there's no timeout I'd wait a while - 1083 is a huge amount of articles. If there is a timeout, you might want to alter the agent's profile.
Regards,
Paul Ibison
Showing posts with label article. Show all posts
Showing posts with label article. Show all posts
Sunday, March 11, 2012
Another Question: Replication
Just another quick question:
When you have published a article is it possible to change a column data type without drop the replication, thanks (Again)Yes, but you have to drop the article first before you change it. After you have made the change, then add the article back in the publication.|||Originally posted by joejcheng
Yes, but you have to drop the article first before you change it. After you have made the change, then add the article back in the publication.
Thanks again. Ed
When you have published a article is it possible to change a column data type without drop the replication, thanks (Again)Yes, but you have to drop the article first before you change it. After you have made the change, then add the article back in the publication.|||Originally posted by joejcheng
Yes, but you have to drop the article first before you change it. After you have made the change, then add the article back in the publication.
Thanks again. Ed
Thursday, March 8, 2012
Another locking question
From this article by
Kalen...http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26922...
she mentioned
"For INSERTS which are blocking, you might want to make sure that your
clustered index is NOT on a column that determines the order that the new
rows are arriving. For example, don't put your clustered index on OrderDate
or OrderNumber, which will always be increasing"
My quesion is why not ?I believe Kalen is just saying that if your inserts are causing blocking you
would not be helping the situation by having an index that uses these same
inserts as the logic to always through the data to the bottom of the last
leaf level of the table (clustered). I think that for inserts that are not
causing blocking it is quite acceptable to use a clustered index on a
sequential key (like an identity column).
Later in that same article Kalen talks about key locks, I've fixed quite a
few blocking issues by adding a clustered index to a table which then would
acquire these key locks. So you would have to test to ensure your inserts
are causing blocking.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OivRkZZhDHA.484@.TK2MSFTNGP12.phx.gbl...
> From this article by
> Kalen...http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26922...
> she mentioned
> "For INSERTS which are blocking, you might want to make sure that your
> clustered index is NOT on a column that determines the order that the new
> rows are arriving. For example, don't put your clustered index on
OrderDate
> or OrderNumber, which will always be increasing"
> My quesion is why not ?
>
Kalen...http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26922...
she mentioned
"For INSERTS which are blocking, you might want to make sure that your
clustered index is NOT on a column that determines the order that the new
rows are arriving. For example, don't put your clustered index on OrderDate
or OrderNumber, which will always be increasing"
My quesion is why not ?I believe Kalen is just saying that if your inserts are causing blocking you
would not be helping the situation by having an index that uses these same
inserts as the logic to always through the data to the bottom of the last
leaf level of the table (clustered). I think that for inserts that are not
causing blocking it is quite acceptable to use a clustered index on a
sequential key (like an identity column).
Later in that same article Kalen talks about key locks, I've fixed quite a
few blocking issues by adding a clustered index to a table which then would
acquire these key locks. So you would have to test to ensure your inserts
are causing blocking.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OivRkZZhDHA.484@.TK2MSFTNGP12.phx.gbl...
> From this article by
> Kalen...http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26922...
> she mentioned
> "For INSERTS which are blocking, you might want to make sure that your
> clustered index is NOT on a column that determines the order that the new
> rows are arriving. For example, don't put your clustered index on
OrderDate
> or OrderNumber, which will always be increasing"
> My quesion is why not ?
>
Another issue with Linked Server
http://support.microsoft.com/?id=814398
I read this article. Maybe Im just plain dumb, but I get this error when I
try to connect to a Linked Access database via sql server. Now the article
states to login using the SQL Server start up account. Im assuming that this
account is the one thats stated in the MSSQLSERVER service under the LogOn
tab.
Well, if it is, then the logon account is "system" in my case. And I cant
physically login to the computer as system now can I?
How difficult can it be to create a linked server to a access database thats
password protected?
Girish
Hi Girish,
From your descriptions, I understood you would like to link an secured
Access mdb file as Linked Server in SQL Server. Have I understood you? If
there is anything misunderstood, please feel free to let me know.
First of all, I would like to answer the question what "system" is. If you
see "System" is selected in LogOn tab of MSSQLServer service, it means
MSSQLServer is started by the account you start Windows. For example,
assuming you are login as "Girish" in you Windows 2003 (or other Windows
Operation System) and "Girish" is in Administartor Group of Windows 2003,
your SQL Server is started as "Girish".
Secondly, I am not sure you encounter exactly the scenario KB:814398
described. Based on my scope, I think the following documents will be
helpful for you.
HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked Server to
Secured Access Databases
http://support.microsoft.com/default...;en-us;Q246255
You receive a "Could not find installable ISAM" error message or some file
types are missing when you import files, export files, or link files in
Access 2000
http://support.microsoft.com/default...;EN-US;Q209805
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks for your reply.
What does SQL Server use to logon to if I do not login interactively?
Its a service so must still run all the time right?
Girish
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:VbRBzDZhEHA.2632@.cpmsftngxa10.phx.gbl...
> Hi Girish,
> From your descriptions, I understood you would like to link an secured
> Access mdb file as Linked Server in SQL Server. Have I understood you? If
> there is anything misunderstood, please feel free to let me know.
> First of all, I would like to answer the question what "system" is. If you
> see "System" is selected in LogOn tab of MSSQLServer service, it means
> MSSQLServer is started by the account you start Windows. For example,
> assuming you are login as "Girish" in you Windows 2003 (or other Windows
> Operation System) and "Girish" is in Administartor Group of Windows 2003,
> your SQL Server is started as "Girish".
> Secondly, I am not sure you encounter exactly the scenario KB:814398
> described. Based on my scope, I think the following documents will be
> helpful for you.
> HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked Server to
> Secured Access Databases
> http://support.microsoft.com/default...;en-us;Q246255
> You receive a "Could not find installable ISAM" error message or some file
> types are missing when you import files, export files, or link files in
> Access 2000
> http://support.microsoft.com/default...;EN-US;Q209805
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Girish,
MSSQLServer is run as a background services, you could also make it started
automatically or manually. In General Tab of MSSQLServer, you could change
"Startup type" between Automatic, Manual and Disable, while you could click
the button under Serivce status to make it start, stop and pause (resume).
If you choose Manual, MSSQLServer will be started only after you click the
"start" button, if Automatic is choosen, MSSQLServer will be started every
time Windows started up.
Additional, we could also use DOS-prompt to start/stop a service like
MSSQLServer. For example, "net start mssqlserver" or "net stop mssqlserver"
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||My mistake... I didnt mean "how" does it start up...
I meant.. when it starts up automatically, what account does it use to login
if I choose "system" and Im NOT interactively logged into the computer.
Im getting confused because my MSSQLServer does run in the background... and
Ive choosen it to login as system... and you said in an earlier email that
system means; if I LOGIN as Girish, then system = Girish. If I login as XYZ,
then system = XYZ.
Now my Q is; if I DONT login at all and MSSQLServer is automatic and a
background service and is set to login as system; then system = ?
Girish
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:cagdUwchEHA.2632@.cpmsftngxa10.phx.gbl...
> Hi Girish,
> MSSQLServer is run as a background services, you could also make it
started
> automatically or manually. In General Tab of MSSQLServer, you could change
> "Startup type" between Automatic, Manual and Disable, while you could
click
> the button under Serivce status to make it start, stop and pause (resume).
> If you choose Manual, MSSQLServer will be started only after you click the
> "start" button, if Automatic is choosen, MSSQLServer will be started every
> time Windows started up.
> Additional, we could also use DOS-prompt to start/stop a service like
> MSSQLServer. For example, "net start mssqlserver" or "net stop
mssqlserver"
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Girish,
I feel sorry for my poor understanding, thanks for your kindest
explaination.
If MSSQLServer is selected to be started as Local System account, it will
be started as NT AUTHORITH\SYSTEM. This account is internal and invisable
no matter what username you choosed to login.
Here are some descriptions fro BOL, which I think will be helpful
explaining it
The local system account does not require a password, does not have network
access rights in Windows NT 4.0, and may restrict your SQL Server
installation from interacting with other servers.
Note In Windows 2000, the local system account does allow network access.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Girish,
I am just checking on your progress regarding the information that was sent
you! If you encounter any difficulty, please do not hesitate to let me
know. Please post here and let me know the status of your issue. Without
your further information, it's very hard for me to continue with the
troubleshooting.
Looking forward to hearing from you soon. Thank you for your patience and
cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I read this article. Maybe Im just plain dumb, but I get this error when I
try to connect to a Linked Access database via sql server. Now the article
states to login using the SQL Server start up account. Im assuming that this
account is the one thats stated in the MSSQLSERVER service under the LogOn
tab.
Well, if it is, then the logon account is "system" in my case. And I cant
physically login to the computer as system now can I?
How difficult can it be to create a linked server to a access database thats
password protected?
Girish
Hi Girish,
From your descriptions, I understood you would like to link an secured
Access mdb file as Linked Server in SQL Server. Have I understood you? If
there is anything misunderstood, please feel free to let me know.
First of all, I would like to answer the question what "system" is. If you
see "System" is selected in LogOn tab of MSSQLServer service, it means
MSSQLServer is started by the account you start Windows. For example,
assuming you are login as "Girish" in you Windows 2003 (or other Windows
Operation System) and "Girish" is in Administartor Group of Windows 2003,
your SQL Server is started as "Girish".
Secondly, I am not sure you encounter exactly the scenario KB:814398
described. Based on my scope, I think the following documents will be
helpful for you.
HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked Server to
Secured Access Databases
http://support.microsoft.com/default...;en-us;Q246255
You receive a "Could not find installable ISAM" error message or some file
types are missing when you import files, export files, or link files in
Access 2000
http://support.microsoft.com/default...;EN-US;Q209805
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks for your reply.
What does SQL Server use to logon to if I do not login interactively?
Its a service so must still run all the time right?
Girish
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:VbRBzDZhEHA.2632@.cpmsftngxa10.phx.gbl...
> Hi Girish,
> From your descriptions, I understood you would like to link an secured
> Access mdb file as Linked Server in SQL Server. Have I understood you? If
> there is anything misunderstood, please feel free to let me know.
> First of all, I would like to answer the question what "system" is. If you
> see "System" is selected in LogOn tab of MSSQLServer service, it means
> MSSQLServer is started by the account you start Windows. For example,
> assuming you are login as "Girish" in you Windows 2003 (or other Windows
> Operation System) and "Girish" is in Administartor Group of Windows 2003,
> your SQL Server is started as "Girish".
> Secondly, I am not sure you encounter exactly the scenario KB:814398
> described. Based on my scope, I think the following documents will be
> helpful for you.
> HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked Server to
> Secured Access Databases
> http://support.microsoft.com/default...;en-us;Q246255
> You receive a "Could not find installable ISAM" error message or some file
> types are missing when you import files, export files, or link files in
> Access 2000
> http://support.microsoft.com/default...;EN-US;Q209805
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Girish,
MSSQLServer is run as a background services, you could also make it started
automatically or manually. In General Tab of MSSQLServer, you could change
"Startup type" between Automatic, Manual and Disable, while you could click
the button under Serivce status to make it start, stop and pause (resume).
If you choose Manual, MSSQLServer will be started only after you click the
"start" button, if Automatic is choosen, MSSQLServer will be started every
time Windows started up.
Additional, we could also use DOS-prompt to start/stop a service like
MSSQLServer. For example, "net start mssqlserver" or "net stop mssqlserver"
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||My mistake... I didnt mean "how" does it start up...
I meant.. when it starts up automatically, what account does it use to login
if I choose "system" and Im NOT interactively logged into the computer.
Im getting confused because my MSSQLServer does run in the background... and
Ive choosen it to login as system... and you said in an earlier email that
system means; if I LOGIN as Girish, then system = Girish. If I login as XYZ,
then system = XYZ.
Now my Q is; if I DONT login at all and MSSQLServer is automatic and a
background service and is set to login as system; then system = ?
Girish
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:cagdUwchEHA.2632@.cpmsftngxa10.phx.gbl...
> Hi Girish,
> MSSQLServer is run as a background services, you could also make it
started
> automatically or manually. In General Tab of MSSQLServer, you could change
> "Startup type" between Automatic, Manual and Disable, while you could
click
> the button under Serivce status to make it start, stop and pause (resume).
> If you choose Manual, MSSQLServer will be started only after you click the
> "start" button, if Automatic is choosen, MSSQLServer will be started every
> time Windows started up.
> Additional, we could also use DOS-prompt to start/stop a service like
> MSSQLServer. For example, "net start mssqlserver" or "net stop
mssqlserver"
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Girish,
I feel sorry for my poor understanding, thanks for your kindest
explaination.
If MSSQLServer is selected to be started as Local System account, it will
be started as NT AUTHORITH\SYSTEM. This account is internal and invisable
no matter what username you choosed to login.
Here are some descriptions fro BOL, which I think will be helpful
explaining it
The local system account does not require a password, does not have network
access rights in Windows NT 4.0, and may restrict your SQL Server
installation from interacting with other servers.
Note In Windows 2000, the local system account does allow network access.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Girish,
I am just checking on your progress regarding the information that was sent
you! If you encounter any difficulty, please do not hesitate to let me
know. Please post here and let me know the status of your issue. Without
your further information, it's very hard for me to continue with the
troubleshooting.
Looking forward to hearing from you soon. Thank you for your patience and
cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Saturday, February 25, 2012
Announcement: MSDN Article "Integrating Analysis Services with Reporting Services" Availab
The following whitepaper is now available on MSDN:
"Integrating Analysis Services with Reporting Services" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp.
Summary: Create a compelling solution for your customer that defines and
manages great-looking Analysis Services reports, and quickly answers
analytical questions to improve traditional reporting scenarios. (33 printed
pages)
The following topics are covered:
Introduction
Developing OLAP Reports Using Analysis Services 2000 and Reporting Services
Datasets and Data Regions in SQL Server 2000 Reporting Services
Defining a Data Source
Building a Static Report with Analysis Services Data
Adding Parameters to an OLAP Report
Adding Additional Interactivity to Reports
Analysis Services Actions
Conclusion
--
Sean Boon
Microsoft Office BI
This posting is provided "AS IS" with no warranties, and confers no rights.In news:OLSM2s7VEHA.1888@.TK2MSFTNGP11.phx.gbl,
Sean Boon [MS] <seanboon@.online.microsoft.com> typed:
> The following whitepaper is now available on MSDN:
> "Integrating Analysis Services with Reporting Services" at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/olapasandrs.asp.
> Summary: Create a compelling solution for your customer
> that defines and
> manages great-looking Analysis Services reports, and
> quickly answers
> analytical questions to improve traditional reporting
> scenarios. (33 printed
> pages)
> The following topics are covered:
> Introduction
> Developing OLAP Reports Using Analysis Services 2000 and
> Reporting Services
> Datasets and Data Regions in SQL Server 2000 Reporting
> Services
> Defining a Data Source
> Building a Static Report with Analysis Services Data
> Adding Parameters to an OLAP Report
> Adding Additional Interactivity to Reports
> Analysis Services Actions
> Conclusion
Am I missing something or does the sample code require anything other than
VS 2003 and RS? I wonder about xxx.RDL.XML, which is not recognized to be a
valid report file by ReportDesigner.
Sorry if I'm too stupid to catch the things.
r.
"Integrating Analysis Services with Reporting Services" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp.
Summary: Create a compelling solution for your customer that defines and
manages great-looking Analysis Services reports, and quickly answers
analytical questions to improve traditional reporting scenarios. (33 printed
pages)
The following topics are covered:
Introduction
Developing OLAP Reports Using Analysis Services 2000 and Reporting Services
Datasets and Data Regions in SQL Server 2000 Reporting Services
Defining a Data Source
Building a Static Report with Analysis Services Data
Adding Parameters to an OLAP Report
Adding Additional Interactivity to Reports
Analysis Services Actions
Conclusion
--
Sean Boon
Microsoft Office BI
This posting is provided "AS IS" with no warranties, and confers no rights.In news:OLSM2s7VEHA.1888@.TK2MSFTNGP11.phx.gbl,
Sean Boon [MS] <seanboon@.online.microsoft.com> typed:
> The following whitepaper is now available on MSDN:
> "Integrating Analysis Services with Reporting Services" at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/olapasandrs.asp.
> Summary: Create a compelling solution for your customer
> that defines and
> manages great-looking Analysis Services reports, and
> quickly answers
> analytical questions to improve traditional reporting
> scenarios. (33 printed
> pages)
> The following topics are covered:
> Introduction
> Developing OLAP Reports Using Analysis Services 2000 and
> Reporting Services
> Datasets and Data Regions in SQL Server 2000 Reporting
> Services
> Defining a Data Source
> Building a Static Report with Analysis Services Data
> Adding Parameters to an OLAP Report
> Adding Additional Interactivity to Reports
> Analysis Services Actions
> Conclusion
Am I missing something or does the sample code require anything other than
VS 2003 and RS? I wonder about xxx.RDL.XML, which is not recognized to be a
valid report file by ReportDesigner.
Sorry if I'm too stupid to catch the things.
r.
Friday, February 24, 2012
ANN: Mobile Database Development Article
My Article on Mobile Database Development was published in the August 2006 edition of Smartphone & Pocket PC Magazine!I have been researching which database engine to use for my Windows Mobile 5 development.Go and buy a copy now!!!
You can read more on my blog (http://www.nantz.org/Blog/tabid/57/EntryID/452/Default.aspx) or software page (http://www.nantz.org/Software/tabid/58/Default.aspx).
Just downloaded the CTR version and the Readme says this won't work on Devices yet, only Tablets and Desktops. Is this still true or do they need to modify the readme file?
Thanks
Harry Simpson
harry.simpson@.phgt.net
|||Which product are you referring to?|||Sql Server Everywhere. I was under the impression that the device dll for SQLCE had changed and was included but it's not
Thanks
Harry
|||please help me for Mobile Database architecture .
tanhk you.
ANN: Mobile Database Development Article
My Article on Mobile Database Development was published in the August 2006 edition of Smartphone & Pocket PC Magazine!I have been researching which database engine to use for my Windows Mobile 5 development.Go and buy a copy now!!!
You can read more on my blog (http://www.nantz.org/Blog/tabid/57/EntryID/452/Default.aspx) or software page (http://www.nantz.org/Software/tabid/58/Default.aspx).
Just downloaded the CTR version and the Readme says this won't work on Devices yet, only Tablets and Desktops. Is this still true or do they need to modify the readme file?
Thanks
Harry Simpson
harry.simpson@.phgt.net
|||Which product are you referring to?|||Sql Server Everywhere. I was under the impression that the device dll for SQLCE had changed and was included but it's not
Thanks
Harry
|||please help me for Mobile Database architecture .
tanhk you.
ANN: Mobile Database Development Article
My Article on Mobile Database Development was published in the August 2006 edition of Smartphone & Pocket PC Magazine!I have been researching which database engine to use for my Windows Mobile 5 development.Go and buy a copy now!!!
You can read more on my blog (http://www.nantz.org/Blog/tabid/57/EntryID/452/Default.aspx) or software page (http://www.nantz.org/Software/tabid/58/Default.aspx).
Just downloaded the CTR version and the Readme says this won't work on Devices yet, only Tablets and Desktops. Is this still true or do they need to modify the readme file?
Thanks
Harry Simpson
harry.simpson@.phgt.net
|||Which product are you referring to?|||Sql Server Everywhere. I was under the impression that the device dll for SQLCE had changed and was included but it's not
Thanks
Harry
|||please help me for Mobile Database architecture .
tanhk you.
Thursday, February 9, 2012
Analysis Services 64-bit clustering
In an article in another usenet group, a few months ago, it was
mentioned that MS were developing an updated document for the steps to
cluster the 64-bit
version of Analysis Services.
I'm the tech lead in one of my countries first implementations of
64-bit SQL,
and this has been an issue for us. We've put time into getting the
clustering going, but didn't want to proceed to far down the path
until MS released a supported procedure.
Can anyone tell me if this document has been finalised, and if so when
it will be released?
Cheers,
Reece.
Post a follow
Reece,
A knowledge base article has been written for the clustering Analysis Services 64-bit. Currently it is being reviewed. I don't know when it will become public. I am trying to find out the release date.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Reece,
Guess what? The KB is public today. Here is the link
How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
http://support.microsoft.com/?kbid=308023
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Uttam,
Thanks for this, but I've already seen this article. I'm after one
which explains how to do the clustering with 64-bit Analysis Services.
As this uses SQL Server instead of an Access mdb.
I could get this done myself most likely, but it would involve
registry hacking, and I would rather have a step by step outline from
MS first. Especially when this is for a client site and I need to have
MS support if things go wrong. Which I doubt would be the case when I
tell them I hacked the registry to get this clustering working.
Cheers,
Reece.
uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
> Reece,
> Guess what? The KB is public today. Here is the link
> How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
> http://support.microsoft.com/?kbid=308023
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
|||I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Reece" wrote:
> Uttam,
> Thanks for this, but I've already seen this article. I'm after one
> which explains how to do the clustering with 64-bit Analysis Services.
> As this uses SQL Server instead of an Access mdb.
> I could get this done myself most likely, but it would involve
> registry hacking, and I would rather have a step by step outline from
> MS first. Especially when this is for a client site and I need to have
> MS support if things go wrong. Which I doubt would be the case when I
> tell them I hacked the registry to get this clustering working.
> Cheers,
> Reece.
>
> uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
>
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Uttam Parui[MS]" wrote:
> I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
mentioned that MS were developing an updated document for the steps to
cluster the 64-bit
version of Analysis Services.
I'm the tech lead in one of my countries first implementations of
64-bit SQL,
and this has been an issue for us. We've put time into getting the
clustering going, but didn't want to proceed to far down the path
until MS released a supported procedure.
Can anyone tell me if this document has been finalised, and if so when
it will be released?
Cheers,
Reece.
Post a follow
Reece,
A knowledge base article has been written for the clustering Analysis Services 64-bit. Currently it is being reviewed. I don't know when it will become public. I am trying to find out the release date.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Reece,
Guess what? The KB is public today. Here is the link
How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
http://support.microsoft.com/?kbid=308023
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Uttam,
Thanks for this, but I've already seen this article. I'm after one
which explains how to do the clustering with 64-bit Analysis Services.
As this uses SQL Server instead of an Access mdb.
I could get this done myself most likely, but it would involve
registry hacking, and I would rather have a step by step outline from
MS first. Especially when this is for a client site and I need to have
MS support if things go wrong. Which I doubt would be the case when I
tell them I hacked the registry to get this clustering working.
Cheers,
Reece.
uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
> Reece,
> Guess what? The KB is public today. Here is the link
> How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
> http://support.microsoft.com/?kbid=308023
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
|||I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Reece" wrote:
> Uttam,
> Thanks for this, but I've already seen this article. I'm after one
> which explains how to do the clustering with 64-bit Analysis Services.
> As this uses SQL Server instead of an Access mdb.
> I could get this done myself most likely, but it would involve
> registry hacking, and I would rather have a step by step outline from
> MS first. Especially when this is for a client site and I need to have
> MS support if things go wrong. Which I doubt would be the case when I
> tell them I hacked the registry to get this clustering working.
> Cheers,
> Reece.
>
> uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
>
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Uttam Parui[MS]" wrote:
> I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
Subscribe to:
Posts (Atom)