define addl space and have EM 'see' it

I need space!!! net admin has given it to me, but em doesn't 'see' it.
Nothing is an actual physical device on the server, its off in network land.
I'm having to manually move my backup folders to the addl space so that my
bkups will run. Its production and I'm worried.
I thought it might be because the space was added while things were still
running, so I downed everything (pwr was going down anyway). But it still
doesn't have it as available for bkups.
And I'd really appreciate a couple of good ref books for enterprise mngt,
tools and all this stuff.
Kelly
What do you mean by it doesn't see it? Do you mean you can't see the mapped
drive letter? If so you should not use mapped drives for SQL Server. Use
the UNC notation instead.
\\Other server\SharedDrive
Also make sure that the account that SQL Server is running under is a domain
account with rights to that share otherwise it can not access it. If SQL
Server is running under the local system account it has no rights off on the
server it is running on.
Andrew J. Kelly SQL MVP
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:1881DC32-39A7-41A3-BDEE-0B0E9DAA50A5@.microsoft.com...
>I need space!!! net admin has given it to me, but em doesn't 'see' it.
> Nothing is an actual physical device on the server, its off in network
> land.
> I'm having to manually move my backup folders to the addl space so that my
> bkups will run. Its production and I'm worried.
> I thought it might be because the space was added while things were still
> running, so I downed everything (pwr was going down anyway). But it still
> doesn't have it as available for bkups.
> And I'd really appreciate a couple of good ref books for enterprise mngt,
> tools and all this stuff.
> --
> Kelly
|||I'm not sure what you mean. The server itself can 'see' the drive (my
computer...) as a drive. em can 'see' the other drives. I check w/network
and sql is using the administrator account. But the new drive is not a
choice when I try to do a backup or set up one w/the wizard.
Since all of our drives don't really live on the physical machine (and I'm
really out in a field here(and its raining :<) cause this is network stuff),
they are all logical devices not something that I can actually go and see,
how would I define this new logical drive to em? It must have happened at
one time, because it can 'see' the other logical drives.
"Andrew J. Kelly" wrote:

> What do you mean by it doesn't see it? Do you mean you can't see the mapped
> drive letter? If so you should not use mapped drives for SQL Server. Use
> the UNC notation instead.
> \\Other server\SharedDrive
>
> Also make sure that the account that SQL Server is running under is a domain
> account with rights to that share otherwise it can not access it. If SQL
> Server is running under the local system account it has no rights off on the
> server it is running on.
> --
> Andrew J. Kelly SQL MVP
>
> "Kelly" <Kelly@.discussions.microsoft.com> wrote in message
> news:1881DC32-39A7-41A3-BDEE-0B0E9DAA50A5@.microsoft.com...
>
>
|||If you are using the Maintenance plan to do your backups then simply type
the UNC path to the new share in the space provided in the wizard. If you
don't know what that is then ask your network people. If they don't know
they shouldn't be your network people<g>. The gui (EM) will not be able to
see the actual mapped drive which you call a Logical drive but if you use
the UNC path it will work.
Andrew J. Kelly SQL MVP
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:62523077-2B79-4F1E-B5FF-BC6C1F884C8A@.microsoft.com...[vbcol=seagreen]
> I'm not sure what you mean. The server itself can 'see' the drive (my
> computer...) as a drive. em can 'see' the other drives. I check
> w/network
> and sql is using the administrator account. But the new drive is not a
> choice when I try to do a backup or set up one w/the wizard.
> Since all of our drives don't really live on the physical machine (and I'm
> really out in a field here(and its raining :<) cause this is network
> stuff),
> they are all logical devices not something that I can actually go and see,
> how would I define this new logical drive to em? It must have happened at
> one time, because it can 'see' the other logical drives.
> "Andrew J. Kelly" wrote:
|||Thank you, thank you, thank you!!!!
It worked! of course the np wanted to know why I wanted to know such a
thing, but I said they could give it to me or they could set up copy jobs to
move things around themselfs. Such fun! I may cause some trouble now.
Any good book to recommend? I need to read up on the things I can do.
Much more fun than app stuff!
Kelly
"Andrew J. Kelly" wrote:

> If you are using the Maintenance plan to do your backups then simply type
> the UNC path to the new share in the space provided in the wizard. If you
> don't know what that is then ask your network people. If they don't know
> they shouldn't be your network people<g>. The gui (EM) will not be able to
> see the actual mapped drive which you call a Logical drive but if you use
> the UNC path it will work.
> --
> Andrew J. Kelly SQL MVP
>
> "Kelly" <Kelly@.discussions.microsoft.com> wrote in message
> news:62523077-2B79-4F1E-B5FF-BC6C1F884C8A@.microsoft.com...
>
>
|||Depends on what subject your really after. A good overall SQL Server book
is "Inside SQL Server 2000" by Kalen Delaney.
Andrew J. Kelly SQL MVP
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:40D1273C-3D35-4D4C-AA2B-1B198F84BFFC@.microsoft.com...[vbcol=seagreen]
> Thank you, thank you, thank you!!!!
> It worked! of course the np wanted to know why I wanted to know such a
> thing, but I said they could give it to me or they could set up copy jobs
> to
> move things around themselfs. Such fun! I may cause some trouble now.
> Any good book to recommend? I need to read up on the things I can do.
> Much more fun than app stuff!
> --
> Kelly
>
> "Andrew J. Kelly" wrote:

Default Value in DropDownlist Parametrs

im developing a report server Project in VB.net 2005 with reporting
service 2005 and i have a dropdownlist parameter, i just want to have
this parameter with a specific value, not with <select a value>. I
populate this dropdownlist with a ds (of course).
I dont know how use the Default Values in the Project. somebody know
has to use it?
thanks!!!Is your values coming from query then give the same to the default parameter.
why do you want a default when you give multiple option for the user to
select.
Amarnath
"Ref" wrote:
> im developing a report server Project in VB.net 2005 with reporting
> service 2005 and i have a dropdownlist parameter, i just want to have
> this parameter with a specific value, not with <select a value>. I
> populate this dropdownlist with a ds (of course).
> I dont know how use the Default Values in the Project. somebody know
> has to use it?
> thanks!!!
>

default setting in RS

Hi,
Is anyway to set default setting in Reporting Service develop environment
.Net 2003?
For example, I want default the Font Properties as "Time New Roman, 12pt,
Bolder" in .Net,
so that I don't need to modify all of the font property during report edit.
Anyway or any idea can do this?
Thanks for reply! :)
AngiAngi,
You can't edit the designer default, but:
Report designer has style templates that you can use with the report wizard.
You can alter existing templates (bold, casual, corporate, compact) or add
new ones by editing the styletemplates.xml file in the
\90\tools\binn\vsshell\common7\ide\business intelligence
wizards\reports\styles folder within the SQL Server progam folder.
This way you can make your own template for designing you own reports.
Please use your full name when posting to these newsgroups.
Jon Jahren
"angi" <angi@.microsoft.public.sqlserver.olap> wrote in message
news:euNzzZ7xEHA.4052@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Is anyway to set default setting in Reporting Service develop environment
> .Net 2003?
> For example, I want default the Font Properties as "Time New Roman, 12pt,
> Bolder" in .Net,
> so that I don't need to modify all of the font property during report
edit.
> Anyway or any idea can do this?
> Thanks for reply! :)
> Angi
>

Default Server Name

I have MSSQLServer version 8 installed. I'm using it to code with .NET. I
somehow ended up with MSSQLServer using an incorrevt server name when it
starts up. It gives me a dropdown box to select the correct servername, but
that's annoying.
My question is how can I get it to use the correct servername as the default
when it loads?
Any help is really appreciated!!
Bob
"Bob" <whoopiea@.whoopie.com> wrote in message
news:%230uT7NxjEHA.2948@.TK2MSFTNGP11.phx.gbl...
> I have MSSQLServer version 8 installed. I'm using it to code with .NET.
I
> somehow ended up with MSSQLServer using an incorrevt server name when it
> starts up. It gives me a dropdown box to select the correct servername,
but
> that's annoying.
Did you change the server name after SQL Server was installed?

> My question is how can I get it to use the correct servername as the
default
> when it loads?
If yes to the above question, use the following (from BOL):
-- substitute the previous name and new name of your servers as appropriate
sp_dropserver old_name
GO
sp_addserver new_name, local
GO
Steve
|||"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:uP4Nfd4jEHA.3844@.TK2MSFTNGP12.phx.gbl...
> "Bob" <whoopiea@.whoopie.com> wrote in message
> news:%230uT7NxjEHA.2948@.TK2MSFTNGP11.phx.gbl...
> I
> but
> Did you change the server name after SQL Server was installed?
> default
> If yes to the above question, use the following (from BOL):
> -- substitute the previous name and new name of your servers as
appropriate
> sp_dropserver old_name
> GO
> sp_addserver new_name, local
> GO
>
> Steve
>
Steve:
Thanks.
I inadvertantantly installed the sample databases to the wrong place, and
could not access them (ie: Northwind, PUBS, etc...) After alot of
troubleshooting, I got them installed from "\\computername" to
"\\computername\NetSDK". Then I deleted the databases from the data file in
"\\computername". The NetSDK folder is where they are and when I select
"\\computername\NetSDK" from SQL Server Service Manager's screen's dropdown
menu, all is fine. However, "\\computername" always comes up in the
dropdown as the default.
I'm kindof new with programming with SQL Server and not sure how to execute
the commands you suggested (sp_dropserver old_name ... GO
sp_addserver new_name, local ... GO)
All I know is how to code to the database.. creating databases, connection
strings within VS.NET and SQL queries, etc. from the programming environment
(I'm used to DB2, Access and some others).
Any additional insight is appreciated.
Thanks again,
Bob
|||Bob,
Sorry, I misunderstood your original question, it sounded as though you had
renamed your server after the SQL Server install. Since that is not the
case -- disregard my advice.
The dropdown default is something likely stored in your computers
registry...
Steve
"Bob" <whoopiea@.whoopie.com> wrote in message
news:eMn0Pa$jEHA.2680@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:uP4Nfd4jEHA.3844@.TK2MSFTNGP12.phx.gbl...
..NET.[vbcol=seagreen]
it[vbcol=seagreen]
servername,
> appropriate
> Steve:
> Thanks.
> I inadvertantantly installed the sample databases to the wrong place, and
> could not access them (ie: Northwind, PUBS, etc...) After alot of
> troubleshooting, I got them installed from "\\computername" to
> "\\computername\NetSDK". Then I deleted the databases from the data file
in
> "\\computername". The NetSDK folder is where they are and when I select
> "\\computername\NetSDK" from SQL Server Service Manager's screen's
dropdown
> menu, all is fine. However, "\\computername" always comes up in the
> dropdown as the default.
> I'm kindof new with programming with SQL Server and not sure how to
execute
> the commands you suggested (sp_dropserver old_name ... GO
> sp_addserver new_name, local ... GO)
> All I know is how to code to the database.. creating databases, connection
> strings within VS.NET and SQL queries, etc. from the programming
environment
> (I'm used to DB2, Access and some others).
> Any additional insight is appreciated.
> Thanks again,
> Bob
>

Default Printing Option for Crystal Report

I have developed a PDF web report which opens in a browser by using Crystal Report for VS.NET 2003. Is there any way to capture the printer settings of the users (who view this report) and change the Printer Paper Size to Legal? I understand that this is a security issue and this is not permitted under normal circumstances...but is there a round about way? My OS is Windows 2003.
Thanks for your helpIf I understand your question correctly, here's how I do it in VB 6 and CR 8.5 using RDC (maybe you can manipulate it to fit your needs?).

Report.PaperSize = crPaperLegal
Report.PrintOut

This way, you don't have to change the user's settings.