A snippet from
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
says:
How To Set Up SQL Mail With An Internet Mail Server
WARNING: Unless you can guarantee 100% connectivity to your Internet mail
server without the need to reauthenticate your mail logon, SQL Mail can
hang, forcing you to stop and restart SQL Server. Use of an Internet mail
server is not a recommended solution but may be the only alternative in some
cases.
The procedure for setting up SQL Mail with an Internet mail server
(POP3/SMTP server) is similar to that for setting up SQL Mail with an
Exchange Server:
I was wondering if anyone has experienced similar downfalls to using
xp_smtp_sendmail if the SMTP box is unavailable for a while?
TIA, ChrisR> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
Nope.
Keith
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>|||The problem with sp_sendmail has to do with using Outlook as a Service.
Outlook will try and pop up a dialog box. Since there is normally no UI,
this fails and hangs the MAPI session. The only way to recover is to drop
both ends of the MAPI session with a SQL server restart.
Xp_smtp_sendmail simply times out and returns an error code to the procedure
caller.
In short, the same problem does not and cannot occur. This is the number
one reason I use xp_smtp_sendmail.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>|||Another way to use CDO: CDO.Message
with sp_OA...
If you want I can post example.
Regards,
SkyWalker.
"ChrisR" wrote:
> A snippet from
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in some
> cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>
>|||Im good now, thanks.
"SkyWalker" <SkyWalker@.discussions.microsoft.com> wrote in message
news:1B4578C6-776D-4D26-9B1C-1D3DD9629CC1@.microsoft.com...
> Another way to use CDO: CDO.Message
> with sp_OA...
> If you want I can post example.
> Regards,
> SkyWalker.
> "ChrisR" wrote:
>> A snippet from
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
>> says:
>> How To Set Up SQL Mail With An Internet Mail Server
>> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
>> server without the need to reauthenticate your mail logon, SQL Mail can
>> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
>> server is not a recommended solution but may be the only alternative in
>> some
>> cases.
>> The procedure for setting up SQL Mail with an Internet mail server
>> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
>> Exchange Server:
>>
>> I was wondering if anyone has experienced similar downfalls to using
>> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>>
>> TIA, ChrisR
>>
>>|||Thanks to all, Im alot more comfortable with this now.
ChrisR
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>sql
Showing posts with label http. Show all posts
Showing posts with label http. Show all posts
Tuesday, March 20, 2012
Sunday, March 11, 2012
another question about bind object to Report
hi,all
I download the Sample from http://www.gotreportviewer.com
in the "InvoiceMaker" sample,
the object like Custome can be bind to the Report directly,
but in the "Object Data Source" Sample ,I Modify the
" reportViewer.LocalReport.DataSources.Add(
new ReportDataSource("Product", merchant.GetProducts()));"
to "reportViewer.LocalReport.DataSources.Add(
new ReportDataSource("Product", new new Product("Pencil", 30)))"
there was an Exception with infomation:"Value does not fall within the expected range "
what's wrong with it?
LocalReport.DataSources takes a collection of objects, it doesn't allow a single element - that's why you get the error.
The reason why the InvoiceMaker works with a single element is because it uses a System.Windows.Forms.BindingSource - which can take either a list, an object or a type.
Here's the "magic" that makes it work in InvoiceMaker
Me.CustomerBindingSource = New System.Windows.Forms.BindingSource(Me.components)
...
Me.CustomerBindingSource.DataSource = GetType(ReportFromGrid.Customer)
...
ReportDataSource1.Value = Me.CustomerBindingSource
...
Me.CustomerBindingSource.DataSource = New Customer()
The ObjectDataSource sample takes a shortcut, and shows you how to use a collection directly, w/o going through the binding. That makes things simpler but removes some of the syntactic sugar that makes it easier to use.
Hope that helps,
Tudor Trufinescu
|||I know,thanks！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!
Friday, February 24, 2012
ANN: SQL Monitor Version 2 has just been released
SQL Monitor version 2.0 has just been released.
Ops. lol.
http://dbmonitor.tripod.com
SQL Monitor is an application that displays performance statistics for
sessions running on SQL Server databases. It has a very small
footprint on the server yet displays all the information required for
a DBA or database developer to see the impact individual sessions have
on a database server.
Features include:
Email alerts for performance issues or unexpected disconnects on
database servers
Logging of performance figures and individual session connects/
disconnects
Multi-server graph display showing all connected servers on the one
screen
Process information broken down into database/ user or session lists
Locking panel to display locking information
Simple one click server login
Adjustable server refresh from 1 second to two minutes
No time limit on trial (Restricted to max of 2 servers concurrently
connected)
Ability to sort the session lists based on activity between sessions
NOTE: This is a total rewrite of the previous version of DBMonitor.
All the excellent features of the previous application have been
incorporated and expanded into the new application.
The link is down.
Other links?|||On May 29, 7:13 pm, Trevize <jbg...@.gmail.comwrote:
Quote:
Originally Posted by
The link is down.
Other links?
Ops. lol.
The download link is now working.
Sunday, February 19, 2012
Anaylsis Services over HTTP
Hi guys,
I am hoping this will be a quick one. I am using Analysis Services 2000 with SP4 on Windows XP. It is the Developer Edition so I should have all the functionality of the Enterprise Edition without the scalability.
Ok, so I have followed the “INF: How to Connect to Analysis Server 2000 By Using HTTP Connection” (http://support.microsoft.com/?kbid=279489) article on MSDN. On completing the steps I did see a blank page, which suggests everything is working properly. However, when I try to connect to Analysis Services via HTTP it is unable to see the OLAP database. I have tried this with the MDX Sample Application, Excel and an OLAP Report web application and neither can connect to the database using HTTP. I can, however, connect to the OLAP database if I connect to the server without using HTTP.
I could well be missing something very simple and if that’s the case then great. I have tried changing the security of IIS to use anonymous, basic authentication and windows integrated authentication but neither affect the visibility of the OLAP database. I have also examined the IIS log files but there is nothing that indicates errors.
Any help would be gratefully appreciated.
Let's try to get this straight:
- you can connect to the server over HTTP
- but you can't see any databases
Is that accurate? If yes, then most likely it is a permissions issue -- turn *off* the Anonymous access and turn *on* Integrated authentication. Then try again.
HTH,
Akshai
Subscribe to:
Posts (Atom)