Another Date Question

There is no "Last business day of the month" option in SQL
Server job schedular. What is the best way to achive
this ?. Is there any code out there to get this ?
Thanks.
Todd wrote:
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this ?. Is there any code out there to get this ?
> Thanks.
Calculate the first day of the next month by adding a month to the
current month, using Day 1, and using the year as it returned from the
add of the month. Then dateadd a -1 day and you are on the last day of
the current month. In a loop, check the day of the week using
datepart(dw,...) and if Sat or Sun keep subtracting one day until you
find the correct day.
A calendar table would also be useful here as it could be used to hold
holidays as well.
David Gugick
Imceda Software
www.imceda.com
|||Are holidays considered a business day?
Jeff
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this ?. Is there any code out there to get this ?
> Thanks.
|||http://www.aspfaq.com/show.asp?id=2519
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this ?. Is there any code out there to get this ?
> Thanks.

Another Date Question

There is no "Last business day of the month" option in SQL
Server job schedular. What is the best way to achive
this '. Is there any code out there to get this '
Thanks.Todd wrote:
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.
Calculate the first day of the next month by adding a month to the
current month, using Day 1, and using the year as it returned from the
add of the month. Then dateadd a -1 day and you are on the last day of
the current month. In a loop, check the day of the week using
datepart(dw,...) and if Sat or Sun keep subtracting one day until you
find the correct day.
A calendar table would also be useful here as it could be used to hold
holidays as well.
David Gugick
Imceda Software
www.imceda.com|||Are holidays considered a business day?
Jeff
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.|||http://www.aspfaq.com/show.asp?id=2519
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.

Another Date Question

There is no "Last business day of the month" option in SQL
Server job schedular. What is the best way to achive
this '. Is there any code out there to get this '
Thanks.Todd wrote:
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.
Calculate the first day of the next month by adding a month to the
current month, using Day 1, and using the year as it returned from the
add of the month. Then dateadd a -1 day and you are on the last day of
the current month. In a loop, check the day of the week using
datepart(dw,...) and if Sat or Sun keep subtracting one day until you
find the correct day.
A calendar table would also be useful here as it could be used to hold
holidays as well.
David Gugick
Imceda Software
www.imceda.com|||Are holidays considered a business day?
Jeff
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.|||http://www.aspfaq.com/show.asp?id=2519
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:0ed701c4bab8$33015290$a501280a@.phx.gbl...
> There is no "Last business day of the month" option in SQL
> Server job schedular. What is the best way to achive
> this '. Is there any code out there to get this '
> Thanks.

Annotations - No Copy, No Undo, No Delete confirmation?

In the Business Intellifgence studio, why can't I copy and paste an annotation, why is there no Delete confirmation, it's very easy to accidentally hit the delete option when you right click, worse still, if you do delete accidentally you can't Edit > Undo ? ..or have I missed something here?OK, i found out I can highlight the text, and use Ctrl+C on the keyboard to copy the text...no undo or delete confirmation is my main issue.

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
Loane
Hi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/pro.../anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>
|||Thanks John

> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> http://www.microsoft.com/technet/pro.../anservog.mspx
>
> John
>

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
LoaneHi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/pr...n/anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>|||Thanks John

> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx[/ur
l]
>
> John
>

Analysis Services in SQL Server 2000 for Small Business Server 2003

Hi there
Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
SQL Server 2000 Standard Edition does include Analysis Services, but I don't
get the option
to install AS under the "Select SQL Server components" on my SBS 2003
Premium Technologies CD.
Please help
Best regards
LoaneHi
You may be better off asking this in microsoft.public.windows.server.sbs
SQL Server is only available in the premium edition, therefore it sounds
like you must have that version?
Apparently there is a checkbox to tick that will install it, so it is a
matter of finding it!!!
http://tinyurl.com/8ntfy
Also read the section "Configuring Analysis Services" at
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
John
"Loane Sharp" <look_sharp_not@.hotmail.com> wrote in message
news:eHIq9e%23fFHA.3936@.tk2msftngp13.phx.gbl...
> Hi there
> Is Analysis Services included in SQL Server 2000 for SBS 2003? Apparently
> SQL Server 2000 Standard Edition does include Analysis Services, but I
> don't get the option
> to install AS under the "Select SQL Server components" on my SBS 2003
> Premium Technologies CD.
> Please help
> Best regards
> Loane
>|||Thanks John
> Hi
> You may be better off asking this in microsoft.public.windows.server.sbs
> SQL Server is only available in the premium edition, therefore it sounds
> like you must have that version?
> Apparently there is a checkbox to tick that will install it, so it is a
> matter of finding it!!!
> http://tinyurl.com/8ntfy
> Also read the section "Configuring Analysis Services" at
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
>
> John
>

Analysis Services and Proclarity

We have following environment setup: SQL Server 2005, SSAS 2005 and Proclarity working together to provide some business intelligence.

I have login problems with Proclarity Dashboar server.

What happens is after user logs in into the dashboard server and leaves the browser (IE6) idle for some period of time, the user gets logged out (due to session time out). Once logged out, the user can't log back in as themselves. Now if the user logins with some other userid and logs out properly, then he/she can log back in again as themselves.

Dashboard uses the windows userid/password for logins.

Anybodys help would be greatly appriciated.

Thanks

Giri

Looks like you are using basic authentication for the ProClarity Dashboard server? You have the option to use windows integrated security!

My advice is to contact http://www.proclarity.com/services/support.asp about this issue. You will need a valid account for this. As a customer you will also have access to information on two ProClarity communities. I have seen a lot of discussions and recommendations of how to set up windows integrated security(Active Directory) with ProClarity Dashboard Server 6.2

It is impossible to write all the details you will have to know here.

HTH

Thomas Ivarsson

Analysis Services 2005 OLE DB Provider Error

I try to open a SSAS Cube but I get a OLE DB error message below.

The same cube I can browse with the SQL Server Business Intelligence Development Studio.

Error message:

Microsoft OLE DB Provider for Analysis Services 2005 Microsoft OLE DB Provider for Analysis Services 2005 reported:

Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<MY Server Name>' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '<MY Server Name>' server.

The SQL Browser is used when you are attempting to communicate with a named instance. What you are seeing is a known problem, fixed in SP1, where the SQL Browser needs communication with a domain controller to validate your access rights. This happens to me if I disconnect my laptop from the network and try an connect to a named instance on it. I've also seen it if the SQL Browser is running under a service account that isn't a machine administrator -- and third I've seen this if you are running under XP SP2 and the firewall is stopping your connectivity to the SQL Browser.

You have a few options: 1) make it the default instance -- that works without any problems, 2) always make sure a DC is available, 3) make sure the XP firewall is disabled on the SQL Browser port# (and the various instance port#s), 4) attempt to connect specifically to the port # for the instance (which bypasses the redirector) -- try using <server>:<port#> syntax for the server name.

Hope that helps.

_-_-_ Dave

|||

Thanks Dave,

I have check the options:

1. I have installed sql2005 with the default instance <MSSQLSERVER> that is not the problem

2. I'm connected to the DC

3. I have disabled the firewall, and that has changed the error message!!

The new message is:

Error reported by OLAP server.

Additional information:

Microsoft? OLE DB Provider for Analysis Services reported:

Cannot connect to the server '<MYSERVER>. The server is either not started or too busy.

But I can work with the SQL Server Business Intelligence Development Studio without any problem!!

|||

I have found the solution for the reported error message.

After reinstalling the "Workstation components" I can connect to the cubes in SSAS for a client Olap tool.

Thanks Dave for your support.

Regards,

Peter

|||I got the same error with the same symptoms but resolved the OLAP connection problem simply by reinstalling the OLAP provider for SQL Server 2005. The file name is SQLServer2005_ASOLEDB9.msi and it can be found on the microsoft downloads site.|||

Hi Dave,

Some questions for you about your options:

1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.
SQL Server 2000 can be removed if this is an option.
2. How can you confirm that the DC is available besides when you log into the server which is on the domain?
3. The sql server is on a windows 2003 server. The AD server is in another state and is accessed via a VPN. Could this be a problem?
4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
If I use the instance name syntax -> 10.1.1.1\InstanceName - it works but then it uses the redirector which causes the main error.

So a couple of your solutions have some problems for me... is there any other way around them?

Thanks,
Andrew.

|||

>>1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.

There could be only a single default instance on the machine. And Analysis Services 2000 does not support named instances, so for AS 2005 be default instance you need to remove AS2000.

>>2. How can you confirm that the DC is available besides when you log into the server which is on the domain?

Not sure about this. You can try posting on windows networing newsgroup.

>>4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
Make sure you've got port numeber correctly. By default named instance picks up a port number dynamically on every restart. You can force it to use fixed port by specifying Port server configuration property.

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

Analysis Services 2005 OLE DB Provider Error

I try to open a SSAS Cube but I get a OLE DB error message below.

The same cube I can browse with the SQL Server Business Intelligence Development Studio.

Error message:

Microsoft OLE DB Provider for Analysis Services 2005 Microsoft OLE DB Provider for Analysis Services 2005 reported:

Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<MY Server Name>' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '<MY Server Name>' server.

The SQL Browser is used when you are attempting to communicate with a named instance. What you are seeing is a known problem, fixed in SP1, where the SQL Browser needs communication with a domain controller to validate your access rights. This happens to me if I disconnect my laptop from the network and try an connect to a named instance on it. I've also seen it if the SQL Browser is running under a service account that isn't a machine administrator -- and third I've seen this if you are running under XP SP2 and the firewall is stopping your connectivity to the SQL Browser.

You have a few options: 1) make it the default instance -- that works without any problems, 2) always make sure a DC is available, 3) make sure the XP firewall is disabled on the SQL Browser port# (and the various instance port#s), 4) attempt to connect specifically to the port # for the instance (which bypasses the redirector) -- try using <server>:<port#> syntax for the server name.

Hope that helps.

_-_-_ Dave

|||

Thanks Dave,

I have check the options:

1. I have installed sql2005 with the default instance <MSSQLSERVER> that is not the problem

2. I'm connected to the DC

3. I have disabled the firewall, and that has changed the error message!!

The new message is:

Error reported by OLAP server.

Additional information:

Microsoft? OLE DB Provider for Analysis Services reported:

Cannot connect to the server '<MYSERVER>. The server is either not started or too busy.

But I can work with the SQL Server Business Intelligence Development Studio without any problem!!

|||

I have found the solution for the reported error message.

After reinstalling the "Workstation components" I can connect to the cubes in SSAS for a client Olap tool.

Thanks Dave for your support.

Regards,

Peter

|||I got the same error with the same symptoms but resolved the OLAP connection problem simply by reinstalling the OLAP provider for SQL Server 2005. The file name is SQLServer2005_ASOLEDB9.msi and it can be found on the microsoft downloads site.|||

Hi Dave,

Some questions for you about your options:

1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.
SQL Server 2000 can be removed if this is an option.
2. How can you confirm that the DC is available besides when you log into the server which is on the domain?
3. The sql server is on a windows 2003 server. The AD server is in another state and is accessed via a VPN. Could this be a problem?
4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
If I use the instance name syntax -> 10.1.1.1\InstanceName - it works but then it uses the redirector which causes the main error.

So a couple of your solutions have some problems for me... is there any other way around them?

Thanks,
Andrew.

|||

>>1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.

There could be only a single default instance on the machine. And Analysis Services 2000 does not support named instances, so for AS 2005 be default instance you need to remove AS2000.

>>2. How can you confirm that the DC is available besides when you log into the server which is on the domain?

Not sure about this. You can try posting on windows networing newsgroup.

>>4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
Make sure you've got port numeber correctly. By default named instance picks up a port number dynamically on every restart. You can force it to use fixed port by specifying Port server configuration property.

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

Analysis Services 2005 OLE DB Provider Error

I try to open a SSAS Cube but I get a OLE DB error message below.

The same cube I can browse with the SQL Server Business Intelligence Development Studio.

Error message:

Microsoft OLE DB Provider for Analysis Services 2005 Microsoft OLE DB Provider for Analysis Services 2005 reported:

Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<MY Server Name>' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '<MY Server Name>' server.

The SQL Browser is used when you are attempting to communicate with a named instance. What you are seeing is a known problem, fixed in SP1, where the SQL Browser needs communication with a domain controller to validate your access rights. This happens to me if I disconnect my laptop from the network and try an connect to a named instance on it. I've also seen it if the SQL Browser is running under a service account that isn't a machine administrator -- and third I've seen this if you are running under XP SP2 and the firewall is stopping your connectivity to the SQL Browser.

You have a few options: 1) make it the default instance -- that works without any problems, 2) always make sure a DC is available, 3) make sure the XP firewall is disabled on the SQL Browser port# (and the various instance port#s), 4) attempt to connect specifically to the port # for the instance (which bypasses the redirector) -- try using <server>:<port#> syntax for the server name.

Hope that helps.

_-_-_ Dave

|||

Thanks Dave,

I have check the options:

1. I have installed sql2005 with the default instance <MSSQLSERVER> that is not the problem

2. I'm connected to the DC

3. I have disabled the firewall, and that has changed the error message!!

The new message is:

Error reported by OLAP server.

Additional information:

Microsoft? OLE DB Provider for Analysis Services reported:

Cannot connect to the server '<MYSERVER>. The server is either not started or too busy.

But I can work with the SQL Server Business Intelligence Development Studio without any problem!!

|||

I have found the solution for the reported error message.

After reinstalling the "Workstation components" I can connect to the cubes in SSAS for a client Olap tool.

Thanks Dave for your support.

Regards,

Peter

|||I got the same error with the same symptoms but resolved the OLAP connection problem simply by reinstalling the OLAP provider for SQL Server 2005. The file name is SQLServer2005_ASOLEDB9.msi and it can be found on the microsoft downloads site.|||

Hi Dave,

Some questions for you about your options:

1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.
SQL Server 2000 can be removed if this is an option.
2. How can you confirm that the DC is available besides when you log into the server which is on the domain?
3. The sql server is on a windows 2003 server. The AD server is in another state and is accessed via a VPN. Could this be a problem?
4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
If I use the instance name syntax -> 10.1.1.1\InstanceName - it works but then it uses the redirector which causes the main error.

So a couple of your solutions have some problems for me... is there any other way around them?

Thanks,
Andrew.

|||

>>1. How do you make SQL Server 2005 the default instance if SQL Server 2000 is also installed on the same machine.

There could be only a single default instance on the machine. And Analysis Services 2000 does not support named instances, so for AS 2005 be default instance you need to remove AS2000.

>>2. How can you confirm that the DC is available besides when you log into the server which is on the domain?

Not sure about this. You can try posting on windows networing newsgroup.

>>4. How do you connect to the port # since when I use the Data Connection Wizard and use 10.1.1.1:1384 it comes back with the error:
"Transport Layer error."
Make sure you've got port numeber correctly. By default named instance picks up a port number dynamically on every restart. You can force it to use fixed port by specifying Port server configuration property.

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