Backing up a database to a remote shared folder

We are using SQL 2K with sp4 on W2K servers but they are in windows workgroup
not domain. The SQL service is started by the local system account. I am
having a hard time trying to back up a database to a remote shared folder
located in another W2K server in the same windows workgroup. I believe it is
an authentication/permission issue. I am aware that SQL server looks at
network shared folder differently than the way Windows see but don't know
how to get around it under the workgroup setup. If it is under domain setup,
I have no problem.
Any help on this is very much appreciated.
Wingman
The account that SQL Server runs under must have permissions to that share.
Make sure you use UNC for the path and not a mapped drive.
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
> We are using SQL 2K with sp4 on W2K servers but they are in windows
> workgroup
> not domain. The SQL service is started by the local system account. I am
> having a hard time trying to back up a database to a remote shared folder
> located in another W2K server in the same windows workgroup. I believe it
> is
> an authentication/permission issue. I am aware that SQL server looks at
> network shared folder differently than the way Windows see but don't know
> how to get around it under the workgroup setup. If it is under domain
> setup,
> I have no problem.
> Any help on this is very much appreciated.
> Wingman
|||Yep, I know about the UNC part but how do I assign the local account that run
SQL server to that share under the WorkGroup envirnoment. I am not very
familar with the Windows Workgroup setup. From the computer that I have the
shared folder, I can't see any user account from other computers. I believe
it is because of the Workgroup setup but then again it may be just my
inexperience in this area. Please advise.
Wingman
"Andrew J. Kelly" wrote:

> The account that SQL Server runs under must have permissions to that share.
> Make sure you use UNC for the path and not a mapped drive.
> --
> Andrew J. Kelly SQL MVP
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
>
>
|||You'd have to create an account with same name and password as the service account on that other
machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...[vbcol=seagreen]
> Yep, I know about the UNC part but how do I assign the local account that run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have the
> shared folder, I can't see any user account from other computers. I believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
|||I am not sure if you can use the local service account or not in a workgroup
for this. You could set the permissions on the share to allow everyone to
read and write to it but that would obviously allow anyone with access to
that workgroup to access that share. Maybe someone with more experience in
WorkGroups can pipe in.
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...[vbcol=seagreen]
> Yep, I know about the UNC part but how do I assign the local account that
> run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have
> the
> shared folder, I can't see any user account from other computers. I
> believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
|||Yep, this does it. Thanks!!!
"Tibor Karaszi" wrote:

> You'd have to create an account with same name and password as the service account on that other
> machine.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...
>
sql

Backing up a database to a remote shared folder

We are using SQL 2K with sp4 on W2K servers but they are in windows workgrou
p
not domain. The SQL service is started by the local system account. I am
having a hard time trying to back up a database to a remote shared folder
located in another W2K server in the same windows workgroup. I believe it i
s
an authentication/permission issue. I am aware that SQL server looks at
network shared folder differently than the way Windows see but don't know
how to get around it under the workgroup setup. If it is under domain setup
,
I have no problem.
Any help on this is very much appreciated.
WingmanThe account that SQL Server runs under must have permissions to that share.
Make sure you use UNC for the path and not a mapped drive.
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
> We are using SQL 2K with sp4 on W2K servers but they are in windows
> workgroup
> not domain. The SQL service is started by the local system account. I am
> having a hard time trying to back up a database to a remote shared folder
> located in another W2K server in the same windows workgroup. I believe it
> is
> an authentication/permission issue. I am aware that SQL server looks at
> network shared folder differently than the way Windows see but don't know
> how to get around it under the workgroup setup. If it is under domain
> setup,
> I have no problem.
> Any help on this is very much appreciated.
> Wingman|||Yep, I know about the UNC part but how do I assign the local account that ru
n
SQL server to that share under the WorkGroup envirnoment. I am not very
familar with the Windows Workgroup setup. From the computer that I have the
shared folder, I can't see any user account from other computers. I believe
it is because of the Workgroup setup but then again it may be just my
inexperience in this area. Please advise.
Wingman
"Andrew J. Kelly" wrote:

> The account that SQL Server runs under must have permissions to that share
.
> Make sure you use UNC for the path and not a mapped drive.
> --
> Andrew J. Kelly SQL MVP
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
>
>|||You'd have to create an account with same name and password as the service a
ccount on that other
machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...[vbcol=seagreen]
> Yep, I know about the UNC part but how do I assign the local account that
run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have t
he
> shared folder, I can't see any user account from other computers. I belie
ve
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
>|||I am not sure if you can use the local service account or not in a workgroup
for this. You could set the permissions on the share to allow everyone to
read and write to it but that would obviously allow anyone with access to
that workgroup to access that share. Maybe someone with more experience in
WorkGroups can pipe in.
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...[vbcol=seagreen]
> Yep, I know about the UNC part but how do I assign the local account that
> run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have
> the
> shared folder, I can't see any user account from other computers. I
> believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
>|||Yep, this does it. Thanks!!!
"Tibor Karaszi" wrote:

> You'd have to create an account with same name and password as the service
account on that other
> machine.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...
>

Backing up a database to a remote shared folder

We are using SQL 2K with sp4 on W2K servers but they are in windows workgroup
not domain. The SQL service is started by the local system account. I am
having a hard time trying to back up a database to a remote shared folder
located in another W2K server in the same windows workgroup. I believe it is
an authentication/permission issue. I am aware that SQL server looks at
network shared folder differently than the way Windows see but don't know
how to get around it under the workgroup setup. If it is under domain setup,
I have no problem.
Any help on this is very much appreciated.
WingmanThe account that SQL Server runs under must have permissions to that share.
Make sure you use UNC for the path and not a mapped drive.
--
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
> We are using SQL 2K with sp4 on W2K servers but they are in windows
> workgroup
> not domain. The SQL service is started by the local system account. I am
> having a hard time trying to back up a database to a remote shared folder
> located in another W2K server in the same windows workgroup. I believe it
> is
> an authentication/permission issue. I am aware that SQL server looks at
> network shared folder differently than the way Windows see but don't know
> how to get around it under the workgroup setup. If it is under domain
> setup,
> I have no problem.
> Any help on this is very much appreciated.
> Wingman|||Yep, I know about the UNC part but how do I assign the local account that run
SQL server to that share under the WorkGroup envirnoment. I am not very
familar with the Windows Workgroup setup. From the computer that I have the
shared folder, I can't see any user account from other computers. I believe
it is because of the Workgroup setup but then again it may be just my
inexperience in this area. Please advise.
Wingman
"Andrew J. Kelly" wrote:
> The account that SQL Server runs under must have permissions to that share.
> Make sure you use UNC for the path and not a mapped drive.
> --
> Andrew J. Kelly SQL MVP
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
> > We are using SQL 2K with sp4 on W2K servers but they are in windows
> > workgroup
> > not domain. The SQL service is started by the local system account. I am
> > having a hard time trying to back up a database to a remote shared folder
> > located in another W2K server in the same windows workgroup. I believe it
> > is
> > an authentication/permission issue. I am aware that SQL server looks at
> > network shared folder differently than the way Windows see but don't know
> > how to get around it under the workgroup setup. If it is under domain
> > setup,
> > I have no problem.
> >
> > Any help on this is very much appreciated.
> >
> > Wingman
>
>|||You'd have to create an account with same name and password as the service account on that other
machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...
> Yep, I know about the UNC part but how do I assign the local account that run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have the
> shared folder, I can't see any user account from other computers. I believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
>> The account that SQL Server runs under must have permissions to that share.
>> Make sure you use UNC for the path and not a mapped drive.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
>> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
>> > We are using SQL 2K with sp4 on W2K servers but they are in windows
>> > workgroup
>> > not domain. The SQL service is started by the local system account. I am
>> > having a hard time trying to back up a database to a remote shared folder
>> > located in another W2K server in the same windows workgroup. I believe it
>> > is
>> > an authentication/permission issue. I am aware that SQL server looks at
>> > network shared folder differently than the way Windows see but don't know
>> > how to get around it under the workgroup setup. If it is under domain
>> > setup,
>> > I have no problem.
>> >
>> > Any help on this is very much appreciated.
>> >
>> > Wingman
>>|||I am not sure if you can use the local service account or not in a workgroup
for this. You could set the permissions on the share to allow everyone to
read and write to it but that would obviously allow anyone with access to
that workgroup to access that share. Maybe someone with more experience in
WorkGroups can pipe in.
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...
> Yep, I know about the UNC part but how do I assign the local account that
> run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have
> the
> shared folder, I can't see any user account from other computers. I
> believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
> Wingman
> "Andrew J. Kelly" wrote:
>> The account that SQL Server runs under must have permissions to that
>> share.
>> Make sure you use UNC for the path and not a mapped drive.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
>> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
>> > We are using SQL 2K with sp4 on W2K servers but they are in windows
>> > workgroup
>> > not domain. The SQL service is started by the local system account. I
>> > am
>> > having a hard time trying to back up a database to a remote shared
>> > folder
>> > located in another W2K server in the same windows workgroup. I believe
>> > it
>> > is
>> > an authentication/permission issue. I am aware that SQL server looks
>> > at
>> > network shared folder differently than the way Windows see but don't
>> > know
>> > how to get around it under the workgroup setup. If it is under domain
>> > setup,
>> > I have no problem.
>> >
>> > Any help on this is very much appreciated.
>> >
>> > Wingman
>>|||Yep, this does it. Thanks!!!
"Tibor Karaszi" wrote:
> You'd have to create an account with same name and password as the service account on that other
> machine.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:6075EA91-4D10-4E03-A3D1-3BB693F750D6@.microsoft.com...
> > Yep, I know about the UNC part but how do I assign the local account that run
> > SQL server to that share under the WorkGroup envirnoment. I am not very
> > familar with the Windows Workgroup setup. From the computer that I have the
> > shared folder, I can't see any user account from other computers. I believe
> > it is because of the Workgroup setup but then again it may be just my
> > inexperience in this area. Please advise.
> >
> > Wingman
> >
> > "Andrew J. Kelly" wrote:
> >
> >> The account that SQL Server runs under must have permissions to that share.
> >> Make sure you use UNC for the path and not a mapped drive.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> >> news:45312278-0845-433D-8F7D-2139BD2B0523@.microsoft.com...
> >> > We are using SQL 2K with sp4 on W2K servers but they are in windows
> >> > workgroup
> >> > not domain. The SQL service is started by the local system account. I am
> >> > having a hard time trying to back up a database to a remote shared folder
> >> > located in another W2K server in the same windows workgroup. I believe it
> >> > is
> >> > an authentication/permission issue. I am aware that SQL server looks at
> >> > network shared folder differently than the way Windows see but don't know
> >> > how to get around it under the workgroup setup. If it is under domain
> >> > setup,
> >> > I have no problem.
> >> >
> >> > Any help on this is very much appreciated.
> >> >
> >> > Wingman
> >>
> >>
> >>
>

AVG Function

I've imported several reports from Access that I am now trying to convert use
a shared SQL data source. Several of these report show an average value for a
datetime field in SQL, ex. a textbox with a value of =AVG(Fields.T1.Value)
Does anyone have a workaround for RS to be able to average a time value on a
report. Thank youTry this:
=DateTime.FromBinary( Avg( CDate(Fields!T1.Value).Ticks ) )
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:0A8D8368-EEC2-46E7-A24A-EB517AA4D8C4@.microsoft.com...
> I've imported several reports from Access that I am now trying to convert
use
> a shared SQL data source. Several of these report show an average value
for a
> datetime field in SQL, ex. a textbox with a value of =AVG(Fields.T1.Value)
> Does anyone have a workaround for RS to be able to average a time value on
a
> report. Thank you|||Thank you Robert,
This command returned an error "FromBinary is not a memvber of Date"
Any help is appreciated, thank you very much.
"Robert Bruckner [MSFT]" wrote:
> Try this:
> =DateTime.FromBinary( Avg( CDate(Fields!T1.Value).Ticks ) )
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "halej51" <halej51@.discussions.microsoft.com> wrote in message
> news:0A8D8368-EEC2-46E7-A24A-EB517AA4D8C4@.microsoft.com...
> > I've imported several reports from Access that I am now trying to convert
> use
> > a shared SQL data source. Several of these report show an average value
> for a
> > datetime field in SQL, ex. a textbox with a value of =AVG(Fields.T1.Value)
> >
> > Does anyone have a workaround for RS to be able to average a time value on
> a
> > report. Thank you
>
>|||Oh, the FromBinary method is only available on .NET 2.0 (and RS 2005).
Try this for RS 2000:
=new DateTime( Avg( CDate(Fields!T1.Value).Ticks ) )
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:7629239C-2FDD-4049-84EA-8326EF7299CA@.microsoft.com...
> Thank you Robert,
> This command returned an error "FromBinary is not a memvber of Date"
> Any help is appreciated, thank you very much.
>
>
> "Robert Bruckner [MSFT]" wrote:
> > Try this:
> > =DateTime.FromBinary( Avg( CDate(Fields!T1.Value).Ticks ) )
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "halej51" <halej51@.discussions.microsoft.com> wrote in message
> > news:0A8D8368-EEC2-46E7-A24A-EB517AA4D8C4@.microsoft.com...
> > > I've imported several reports from Access that I am now trying to
convert
> > use
> > > a shared SQL data source. Several of these report show an average
value
> > for a
> > > datetime field in SQL, ex. a textbox with a value of
=AVG(Fields.T1.Value)
> > >
> > > Does anyone have a workaround for RS to be able to average a time
value on
> > a
> > > report. Thank you
> >
> >
> >|||Robert,
That was a huge help! Thank you very much. I am getting a #Error in some of
the footer fields using this calculation but I think this might be a data
issue.
Thank you!
"Robert Bruckner [MSFT]" wrote:
> Oh, the FromBinary method is only available on .NET 2.0 (and RS 2005).
> Try this for RS 2000:
> =new DateTime( Avg( CDate(Fields!T1.Value).Ticks ) )
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "halej51" <halej51@.discussions.microsoft.com> wrote in message
> news:7629239C-2FDD-4049-84EA-8326EF7299CA@.microsoft.com...
> > Thank you Robert,
> >
> > This command returned an error "FromBinary is not a memvber of Date"
> >
> > Any help is appreciated, thank you very much.
> >
> >
> >
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Try this:
> > > =DateTime.FromBinary( Avg( CDate(Fields!T1.Value).Ticks ) )
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "halej51" <halej51@.discussions.microsoft.com> wrote in message
> > > news:0A8D8368-EEC2-46E7-A24A-EB517AA4D8C4@.microsoft.com...
> > > > I've imported several reports from Access that I am now trying to
> convert
> > > use
> > > > a shared SQL data source. Several of these report show an average
> value
> > > for a
> > > > datetime field in SQL, ex. a textbox with a value of
> =AVG(Fields.T1.Value)
> > > >
> > > > Does anyone have a workaround for RS to be able to average a time
> value on
> > > a
> > > > report. Thank you
> > >
> > >
> > >
>
>|||Another similar situation which help would be appreciated for.
I have a table with 4 datetime fields, storing only the time. In the report
I need to produce an average of these 4 fields like, (T1.Value + T2.Value +
T3.Value + T4.Value)/4. This obviously throws a similar error.
Any help is appreciated.
"halej51" wrote:
> Robert,
> That was a huge help! Thank you very much. I am getting a #Error in some of
> the footer fields using this calculation but I think this might be a data
> issue.
> Thank you!
>
> "Robert Bruckner [MSFT]" wrote:
> > Oh, the FromBinary method is only available on .NET 2.0 (and RS 2005).
> > Try this for RS 2000:
> > =new DateTime( Avg( CDate(Fields!T1.Value).Ticks ) )
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "halej51" <halej51@.discussions.microsoft.com> wrote in message
> > news:7629239C-2FDD-4049-84EA-8326EF7299CA@.microsoft.com...
> > > Thank you Robert,
> > >
> > > This command returned an error "FromBinary is not a memvber of Date"
> > >
> > > Any help is appreciated, thank you very much.
> > >
> > >
> > >
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > > > Try this:
> > > > =DateTime.FromBinary( Avg( CDate(Fields!T1.Value).Ticks ) )
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "halej51" <halej51@.discussions.microsoft.com> wrote in message
> > > > news:0A8D8368-EEC2-46E7-A24A-EB517AA4D8C4@.microsoft.com...
> > > > > I've imported several reports from Access that I am now trying to
> > convert
> > > > use
> > > > > a shared SQL data source. Several of these report show an average
> > value
> > > > for a
> > > > > datetime field in SQL, ex. a textbox with a value of
> > =AVG(Fields.T1.Value)
> > > > >
> > > > > Does anyone have a workaround for RS to be able to average a time
> > value on
> > > > a
> > > > > report. Thank you
> > > >
> > > >
> > > >
> >
> >
> >