How to encrypt the URL

I want to pass some information in the URL to Reporting Service.
But the Url can be view clearly.
But there are some sensitive information
How can I encrypt the URL?

I don't know if this would be possible for you, but if you render thereport using ASP.Net, you can pass variables to the report by settingvariables in cookies. This way, you show the report the way that itneeds to be, and the client has no access to the information. I have anexample if you would be interested.
|||

Thanks for your answer.

I need your examples.

Please give me!

|||

Hi,
Can I also have the example. I am also currently looking into how not to show the url.
Thanks.

|||Ok, well, first, you need to add a parameter to your report. When youtest run the report, it will ask you for the value of your prompt.Then, in ASP.Net (using VB.Net), this is how I render to an .aspx page:
<code>
CurrentLocation = Request.Cookies("LocationCookie").Value
Dim rs As New newafp.RSService.ReportingService
rs.Credentials = New System.Net.NetworkCredential("UserName", "Password", "")
Dim parameters(0) As RSService.ParameterValue
parameters(0) = New RSService.ParameterValue
parameters(0).Name = "Location"
parameters(0).Value = CurrentLocation
Dim results As Byte(), image As Byte()
Dim streamids As String(), streamid As String
results =rs.Render("/Folder/ReportName", "HTML4.0", Nothing,"<DeviceInfo><HTMLFragment>True</HTMLFragment><StreamRoot>/Reports/</StreamRoot></DeviceInfo>",parameters, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,streamids)
For Each streamid In streamids
image = rs.RenderStream("/Folder/ReportName", "HTML4.0", streamid, _
Nothing, Nothing, parameters, Nothing, Nothing)
Dim stream As System.IO.FileStream = _
System.IO.File.OpenWrite(Server.MapPath("") & "\" & streamid)
stream.Write(image, 0, CInt(image.Length))
stream.Close()
Next
Response.BinaryWrite(results)
</code>
I don't know if you see it or not, but I have an image that isdisplayed with this report. You don't need it, but I kept it in becauseit will still work even if you don't have any images to write. Or, ifyou don't want to have it included, you can remove the For Loop (fromFor Each line to the Next line). Let me know if you have any questionson this.
|||Thanks,
But there are some statements which I can't understand.
I will study with these codes
Thank again.sql

how to encrypt db files

Came across the following on best practises as well
" Use the SQL Server service account to encrypt database files with EFS."
How do you set it up ?Just because it is on someone's best practices list, doesn't mean it should
just be grabbed and executed. When you encrypt the files on the OS, you
incur a performance hit everytime they need to be accessed to do the
decrypt/encrypt. Since a database server never quits reading or writing to
the files, this can be a rather heavy load on the machine and cause
significant degradation in performance.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:exfOsOKIGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Came across the following on best practises as well
> " Use the SQL Server service account to encrypt database files with EFS."
> How do you set it up ?
>|||>decrypt/encrypt. Since a database server never quits reading or writing to
Actually SQL2005 seems to close the file if no active query is running...
-- AntiSpam/harvest --
Remove X's to send email to me.|||The server is supposed to hold the individual database files open and in
a ready state regardless of user activity. Are you sure you don't have
the autoclose property turned on for the database you are looking at?
That is:
select databaseproperty('<dbname>', 'IsAutoClose')
*mike hodgson*
http://sqlnerd.blogspot.com
Josh Assing wrote:

>Actually SQL2005 seems to close the file if no active query is running...
>
>-- AntiSpam/harvest --
>Remove X's to send email to me.
>|||Hi Hassan,
Encrypting your data files can be a prudent measure (MSDE instance on a
field salesperson's laptop with customer data, for example). I
wouldn't necessarily recommend it on the server side.
Here is a nice how-to on encrypting your files using EFS...
http://www.sqlservercentral.com/col...menting_efs.asp

How to enable service broker for specified database?

Hi All,

I am newbie in SQL Service broker. As we know, the is_broker_enabled can help us check whether the specified database is enabled for service broker. I would like to know

<>How can I enable servce broker for specified database if I see the value(is_broker_enabled) is 0?

<>How can I disable the service broker for specified database is I see the vlaue (is_broker_enabled) is 1? Do I need to dropped all service broker configration in the specified database?

Thanks in advance.

Michael

ALTER DATABASE test SET ENABLE_BROKER

ALTER DATABASE test SET DISABLE_BROKER

This temporarily shuts down the Service Broker operations in the database - you can enable and disable it as often as you want whether there are service broker objects in the database or not.

How to enable a domain account to change service account?

Hi,
We're running two SQL server 2000, SP3 A and B. On A, the service account
for both the SQL server and agent is a domain account. On B, the service
account is local system account. On A in enterprise manager, my personal
domain account can change the service account to whatever I want. But on B,
in security of enterprise manager, the 'Startup service account' grays out
for my domain account. How should I allow my domain account to modify
startup service account? Is it something that needs to be done in the active
directory or on the database server? How?
Thanks much in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running two SQL server 2000, SP3 A and B. On A, the service account
> for both the SQL server and agent is a domain account. On B, the service
> account is local system account. On A in enterprise manager, my personal
> domain account can change the service account to whatever I want. But on B,
> in security of enterprise manager, the 'Startup service account' grays out
> for my domain account. How should I allow my domain account to modify
> startup service account? Is it something that needs to be done in the active
> directory or on the database server? How?
> Thanks much in advance for any help.
> Bing
Are you a local administrator on Server B?
John|||"John Bell" wrote:
> Hi
> "bing" wrote:
> > Hi,
> >
> > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > for both the SQL server and agent is a domain account. On B, the service
> > account is local system account. On A in enterprise manager, my personal
> > domain account can change the service account to whatever I want. But on B,
> > in security of enterprise manager, the 'Startup service account' grays out
> > for my domain account. How should I allow my domain account to modify
> > startup service account? Is it something that needs to be done in the active
> > directory or on the database server? How?
> >
> > Thanks much in advance for any help.
> >
> > Bing
> Are you a local administrator on Server B?
> John
How should I tell?
Bing|||"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > > Hi,
> > >
> > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > for both the SQL server and agent is a domain account. On B, the service
> > > account is local system account. On A in enterprise manager, my personal
> > > domain account can change the service account to whatever I want. But on B,
> > > in security of enterprise manager, the 'Startup service account' grays out
> > > for my domain account. How should I allow my domain account to modify
> > > startup service account? Is it something that needs to be done in the active
> > > directory or on the database server? How?
> > >
> > > Thanks much in advance for any help.
> > >
> > > Bing
> >
> > Are you a local administrator on Server B?
> >
> > John
> How should I tell?
> Bing
Never mind. I figured it out.|||"bing" wrote:
>
> "bing" wrote:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > "bing" wrote:
> > >
> > > > Hi,
> > > >
> > > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > > for both the SQL server and agent is a domain account. On B, the service
> > > > account is local system account. On A in enterprise manager, my personal
> > > > domain account can change the service account to whatever I want. But on B,
> > > > in security of enterprise manager, the 'Startup service account' grays out
> > > > for my domain account. How should I allow my domain account to modify
> > > > startup service account? Is it something that needs to be done in the active
> > > > directory or on the database server? How?
> > > >
> > > > Thanks much in advance for any help.
> > > >
> > > > Bing
> > >
> > > Are you a local administrator on Server B?
> > >
> > > John
> >
> > How should I tell?
> >
> > Bing
> Never mind. I figured it out.
Well, I figured out how to figure out if my personal domain account is in
the local Administrators group on the database server. Yes, it is. But my
original question still remains. Now that, my domain account is a local
administrator on both the SQL server 2000 A and B, why I can change the
service account on A but not on B (service account section in EM->Security
grays out). What else should I check?
Thanks,
Bing|||Hi
"bing" wrote:
>
> "bing" wrote:
> >
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > "bing" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > > > for both the SQL server and agent is a domain account. On B, the service
> > > > > account is local system account. On A in enterprise manager, my personal
> > > > > domain account can change the service account to whatever I want. But on B,
> > > > > in security of enterprise manager, the 'Startup service account' grays out
> > > > > for my domain account. How should I allow my domain account to modify
> > > > > startup service account? Is it something that needs to be done in the active
> > > > > directory or on the database server? How?
> > > > >
> > > > > Thanks much in advance for any help.
> > > > >
> > > > > Bing
> > > >
> > > > Are you a local administrator on Server B?
> > > >
> > > > John
> > >
> > > How should I tell?
> > >
> > > Bing
> >
> > Never mind. I figured it out.
> Well, I figured out how to figure out if my personal domain account is in
> the local Administrators group on the database server. Yes, it is. But my
> original question still remains. Now that, my domain account is a local
> administrator on both the SQL server 2000 A and B, why I can change the
> service account on A but not on B (service account section in EM->Security
> grays out). What else should I check?
> Thanks,
> Bing
As a local administrator you should have enough permissions. Were you
connected to the server itself?
John|||> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
I mean logged on locally to the server in question!
John|||"John Bell" wrote:
> Hi
> "bing" wrote:
> >
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > "bing" wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > > > > for both the SQL server and agent is a domain account. On B, the service
> > > > > > account is local system account. On A in enterprise manager, my personal
> > > > > > domain account can change the service account to whatever I want. But on B,
> > > > > > in security of enterprise manager, the 'Startup service account' grays out
> > > > > > for my domain account. How should I allow my domain account to modify
> > > > > > startup service account? Is it something that needs to be done in the active
> > > > > > directory or on the database server? How?
> > > > > >
> > > > > > Thanks much in advance for any help.
> > > > > >
> > > > > > Bing
> > > > >
> > > > > Are you a local administrator on Server B?
> > > > >
> > > > > John
> > > >
> > > > How should I tell?
> > > >
> > > > Bing
> > >
> > > Never mind. I figured it out.
> >
> > Well, I figured out how to figure out if my personal domain account is in
> > the local Administrators group on the database server. Yes, it is. But my
> > original question still remains. Now that, my domain account is a local
> > administrator on both the SQL server 2000 A and B, why I can change the
> > service account on A but not on B (service account section in EM->Security
> > grays out). What else should I check?
> >
> > Thanks,
> >
> > Bing
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
Thanks much for taking time helping.
Yes, I logged on both A and B using my domain account via remote desktop
connection. I can change the service account in control panel->services.
But seems like that method is discouraged. From the advices I've gathered so
far, changing service account in EM should be the right way to go.
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "bing" wrote:
> > > >
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > "bing" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > > > > > for both the SQL server and agent is a domain account. On B, the service
> > > > > > > account is local system account. On A in enterprise manager, my personal
> > > > > > > domain account can change the service account to whatever I want. But on B,
> > > > > > > in security of enterprise manager, the 'Startup service account' grays out
> > > > > > > for my domain account. How should I allow my domain account to modify
> > > > > > > startup service account? Is it something that needs to be done in the active
> > > > > > > directory or on the database server? How?
> > > > > > >
> > > > > > > Thanks much in advance for any help.
> > > > > > >
> > > > > > > Bing
> > > > > >
> > > > > > Are you a local administrator on Server B?
> > > > > >
> > > > > > John
> > > > >
> > > > > How should I tell?
> > > > >
> > > > > Bing
> > > >
> > > > Never mind. I figured it out.
> > >
> > > Well, I figured out how to figure out if my personal domain account is in
> > > the local Administrators group on the database server. Yes, it is. But my
> > > original question still remains. Now that, my domain account is a local
> > > administrator on both the SQL server 2000 A and B, why I can change the
> > > service account on A but not on B (service account section in EM->Security
> > > grays out). What else should I check?
> > >
> > > Thanks,
> > >
> > > Bing
> >
> > As a local administrator you should have enough permissions. Were you
> > connected to the server itself?
> >
> > John
> Thanks much for taking time helping.
> Yes, I logged on both A and B using my domain account via remote desktop
> connection. I can change the service account in control panel->services.
> But seems like that method is discouraged. From the advices I've gathered so
> far, changing service account in EM should be the right way to go.
> Bing
If the account you are logged into the server with is a local windows
administrator then it should be fine and you should be able to change the
service account. To access the property pages you need to be a SQL Server
sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
machine, you don't have any aliases set up and the server is registered as
(LOCAL) ?
John|||"John Bell" wrote:
> Hi
> "bing" wrote:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > "bing" wrote:
> > >
> > > >
> > > >
> > > > "bing" wrote:
> > > >
> > > > >
> > > > >
> > > > > "bing" wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > > > Hi
> > > > > > >
> > > > > > > "bing" wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > We're running two SQL server 2000, SP3 A and B. On A, the service account
> > > > > > > > for both the SQL server and agent is a domain account. On B, the service
> > > > > > > > account is local system account. On A in enterprise manager, my personal
> > > > > > > > domain account can change the service account to whatever I want. But on B,
> > > > > > > > in security of enterprise manager, the 'Startup service account' grays out
> > > > > > > > for my domain account. How should I allow my domain account to modify
> > > > > > > > startup service account? Is it something that needs to be done in the active
> > > > > > > > directory or on the database server? How?
> > > > > > > >
> > > > > > > > Thanks much in advance for any help.
> > > > > > > >
> > > > > > > > Bing
> > > > > > >
> > > > > > > Are you a local administrator on Server B?
> > > > > > >
> > > > > > > John
> > > > > >
> > > > > > How should I tell?
> > > > > >
> > > > > > Bing
> > > > >
> > > > > Never mind. I figured it out.
> > > >
> > > > Well, I figured out how to figure out if my personal domain account is in
> > > > the local Administrators group on the database server. Yes, it is. But my
> > > > original question still remains. Now that, my domain account is a local
> > > > administrator on both the SQL server 2000 A and B, why I can change the
> > > > service account on A but not on B (service account section in EM->Security
> > > > grays out). What else should I check?
> > > >
> > > > Thanks,
> > > >
> > > > Bing
> > >
> > > As a local administrator you should have enough permissions. Were you
> > > connected to the server itself?
> > >
> > > John
> >
> > Thanks much for taking time helping.
> > Yes, I logged on both A and B using my domain account via remote desktop
> > connection. I can change the service account in control panel->services.
> > But seems like that method is discouraged. From the advices I've gathered so
> > far, changing service account in EM should be the right way to go.
> >
> > Bing
> If the account you are logged into the server with is a local windows
> administrator then it should be fine and you should be able to change the
> service account. To access the property pages you need to be a SQL Server
> sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> machine, you don't have any aliases set up and the server is registered as
> (LOCAL) ?
> John
Hm. Sorry I don't quite understand the question. Here is what SELECT
@.@.SERVERNAME returns on A and B respectively.
A. TECUMSEH
B. HAMMERHEAD
And here are A's and B's host name in DNS:
A. pc200.dept.some.edu
B. hammerhead.dept.some.edu
Any problems with that?
Bing|||Hi
> > If the account you are logged into the server with is a local windows
> > administrator then it should be fine and you should be able to change the
> > service account. To access the property pages you need to be a SQL Server
> > sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> > machine, you don't have any aliases set up and the server is registered as
> > (LOCAL) ?
> >
> > John
> Hm. Sorry I don't quite understand the question. Here is what SELECT
> @.@.SERVERNAME returns on A and B respectively.
> A. TECUMSEH
> B. HAMMERHEAD
> And here are A's and B's host name in DNS:
> A. pc200.dept.some.edu
> B. hammerhead.dept.some.edu
> Any problems with that?
> Bing
It looks like Server a was renamed from TECUMSEH to PC200, but that is the
one that works? If you type SET COMPUTERNAME at a command prompt does it come
up with the same name as SELECT @.@.SERVERNAME?
If the server was renamed you would need to change the SQL Server's name
using the instructions in http://support.microsoft.com/default.aspx/kb/303774
John|||"John Bell" wrote:
> Hi
> >
> > > If the account you are logged into the server with is a local windows
> > > administrator then it should be fine and you should be able to change the
> > > service account. To access the property pages you need to be a SQL Server
> > > sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> > > machine, you don't have any aliases set up and the server is registered as
> > > (LOCAL) ?
> > >
> > > John
> >
> > Hm. Sorry I don't quite understand the question. Here is what SELECT
> > @.@.SERVERNAME returns on A and B respectively.
> >
> > A. TECUMSEH
> > B. HAMMERHEAD
> >
> > And here are A's and B's host name in DNS:
> >
> > A. pc200.dept.some.edu
> > B. hammerhead.dept.some.edu
> >
> > Any problems with that?
> >
> > Bing
> It looks like Server a was renamed from TECUMSEH to PC200, but that is the
> one that works? If you type SET COMPUTERNAME at a command prompt does it come
> up with the same name as SELECT @.@.SERVERNAME?
> If the server was renamed you would need to change the SQL Server's name
> using the instructions in http://support.microsoft.com/default.aspx/kb/303774
> John
Yeah, A works. B doesn't.
On A:
'set computername' returns pc200.
'SELECT @.@.SERVERNAME' returns TECUMSEH.
'select @.@.version" returns
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 1)
On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
'select @.@.version' returns
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Bing|||Hi
> Yeah, A works. B doesn't.
> On A:
> 'set computername' returns pc200.
> 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> 'select @.@.version" returns
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 1)
> On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> 'select @.@.version' returns
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> Bing
>
So that does not get you any further with the original issue! Have you tried
changing the service account in services to localsystem for server B and then
see if you can change it to a domain account in EM?
John|||"John Bell" wrote:
> Hi
> > Yeah, A works. B doesn't.
> >
> > On A:
> > 'set computername' returns pc200.
> > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > 'select @.@.version" returns
> > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > 5.2 (Build 3790: Service Pack 1)
> >
> > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > 'select @.@.version' returns
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > NT 5.2 (Build 3790: Service Pack 1)
> >
> > Bing
> >
> So that does not get you any further with the original issue! Have you tried
> changing the service account in services to localsystem for server B and then
> see if you can change it to a domain account in EM?
> John
I just tried, but it didn't make any difference.
Actually, that put the issue back to its original state. In the very
beginning, I noticed my personal domain account (in the local administrators
group) could not change the service account in EM on B. But I was able to
change the service account to a domain account in services in control panel.
This domain account is also in the local administrators group. I tried to
log on B using both my personal domain account and the desired service
account I wanted to change to, but neither works. In services, the 'Log on
As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > > Yeah, A works. B doesn't.
> > >
> > > On A:
> > > 'set computername' returns pc200.
> > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > 'select @.@.version" returns
> > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > 5.2 (Build 3790: Service Pack 1)
> > >
> > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > 'select @.@.version' returns
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > NT 5.2 (Build 3790: Service Pack 1)
> > >
> > > Bing
> > >
> > So that does not get you any further with the original issue! Have you tried
> > changing the service account in services to localsystem for server B and then
> > see if you can change it to a domain account in EM?
> >
> > John
> I just tried, but it didn't make any difference.
> Actually, that put the issue back to its original state. In the very
> beginning, I noticed my personal domain account (in the local administrators
> group) could not change the service account in EM on B. But I was able to
> change the service account to a domain account in services in control panel.
> This domain account is also in the local administrators group. I tried to
> log on B using both my personal domain account and the desired service
> account I wanted to change to, but neither works. In services, the 'Log on
> As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> Bing
If you are able to log on as the local administrator or domain administrator
do these work?
John|||"John Bell" wrote:
> Hi
> "bing" wrote:
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > > Yeah, A works. B doesn't.
> > > >
> > > > On A:
> > > > 'set computername' returns pc200.
> > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > 'select @.@.version" returns
> > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > 5.2 (Build 3790: Service Pack 1)
> > > >
> > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > 'select @.@.version' returns
> > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > NT 5.2 (Build 3790: Service Pack 1)
> > > >
> > > > Bing
> > > >
> > > So that does not get you any further with the original issue! Have you tried
> > > changing the service account in services to localsystem for server B and then
> > > see if you can change it to a domain account in EM?
> > >
> > > John
> >
> > I just tried, but it didn't make any difference.
> > Actually, that put the issue back to its original state. In the very
> > beginning, I noticed my personal domain account (in the local administrators
> > group) could not change the service account in EM on B. But I was able to
> > change the service account to a domain account in services in control panel.
> > This domain account is also in the local administrators group. I tried to
> > log on B using both my personal domain account and the desired service
> > account I wanted to change to, but neither works. In services, the 'Log on
> > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> >
> > Bing
> If you are able to log on as the local administrator or domain administrator
> do these work?
> John
OK, I tried to log on 'Administrator' on B, Startup service account in EM
still grays out. What the heck!
Bing|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > > Yeah, A works. B doesn't.
> > > > >
> > > > > On A:
> > > > > 'set computername' returns pc200.
> > > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > > 'select @.@.version" returns
> > > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > > 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > > 'select @.@.version' returns
> > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > > NT 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > Bing
> > > > >
> > > > So that does not get you any further with the original issue! Have you tried
> > > > changing the service account in services to localsystem for server B and then
> > > > see if you can change it to a domain account in EM?
> > > >
> > > > John
> > >
> > > I just tried, but it didn't make any difference.
> > > Actually, that put the issue back to its original state. In the very
> > > beginning, I noticed my personal domain account (in the local administrators
> > > group) could not change the service account in EM on B. But I was able to
> > > change the service account to a domain account in services in control panel.
> > > This domain account is also in the local administrators group. I tried to
> > > log on B using both my personal domain account and the desired service
> > > account I wanted to change to, but neither works. In services, the 'Log on
> > > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> > >
> > > Bing
> >
> > If you are able to log on as the local administrator or domain administrator
> > do these work?
> >
> > John
> OK, I tried to log on 'Administrator' on B, Startup service account in EM
> still grays out. What the heck!
> Bing
If the administrator is not allowed then there is something seriously wrong!
It isn't something daft like you are not checking the This Account radio
button.
John|||Hi
"bing" wrote:
>
> "John Bell" wrote:
> > Hi
> >
> > "bing" wrote:
> >
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > > Yeah, A works. B doesn't.
> > > > >
> > > > > On A:
> > > > > 'set computername' returns pc200.
> > > > > 'SELECT @.@.SERVERNAME' returns TECUMSEH.
> > > > > 'select @.@.version" returns
> > > > > Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> > > > > 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > On B, both 'set computername' and 'SELECT @.@.SERVERNAME' hammerhead.
> > > > > 'select @.@.version' returns
> > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > > > Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> > > > > NT 5.2 (Build 3790: Service Pack 1)
> > > > >
> > > > > Bing
> > > > >
> > > > So that does not get you any further with the original issue! Have you tried
> > > > changing the service account in services to localsystem for server B and then
> > > > see if you can change it to a domain account in EM?
> > > >
> > > > John
> > >
> > > I just tried, but it didn't make any difference.
> > > Actually, that put the issue back to its original state. In the very
> > > beginning, I noticed my personal domain account (in the local administrators
> > > group) could not change the service account in EM on B. But I was able to
> > > change the service account to a domain account in services in control panel.
> > > This domain account is also in the local administrators group. I tried to
> > > log on B using both my personal domain account and the desired service
> > > account I wanted to change to, but neither works. In services, the 'Log on
> > > As' is local system for both MSSQLSERVER and SQLSERVERAGENT now.
> > >
> > > Bing
> >
> > If you are able to log on as the local administrator or domain administrator
> > do these work?
> >
> > John
> OK, I tried to log on 'Administrator' on B, Startup service account in EM
> still grays out. What the heck!
> Bing
If the administrator is not allowed then there is something seriously wrong!
It isn't something daft like you are not checking the This Account radio
button?
John

How to enable a domain account to change service account?

Hi,
We're running two SQL server 2000, SP3 A and B. On A, the service account
for both the SQL server and agent is a domain account. On B, the service
account is local system account. On A in enterprise manager, my personal
domain account can change the service account to whatever I want. But on B,
in security of enterprise manager, the 'Startup service account' grays out
for my domain account. How should I allow my domain account to modify
startup service account? Is it something that needs to be done in the active
directory or on the database server? How?
Thanks much in advance for any help.
Bing
Hi
"bing" wrote:

> Hi,
> We're running two SQL server 2000, SP3 A and B. On A, the service account
> for both the SQL server and agent is a domain account. On B, the service
> account is local system account. On A in enterprise manager, my personal
> domain account can change the service account to whatever I want. But on B,
> in security of enterprise manager, the 'Startup service account' grays out
> for my domain account. How should I allow my domain account to modify
> startup service account? Is it something that needs to be done in the active
> directory or on the database server? How?
> Thanks much in advance for any help.
> Bing
Are you a local administrator on Server B?
John
|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> Are you a local administrator on Server B?
> John
How should I tell?
Bing
|||"bing" wrote:

>
> "John Bell" wrote:
>
> How should I tell?
> Bing
Never mind. I figured it out.
|||"bing" wrote:

>
> "bing" wrote:
>
> Never mind. I figured it out.
Well, I figured out how to figure out if my personal domain account is in
the local Administrators group on the database server. Yes, it is. But my
original question still remains. Now that, my domain account is a local
administrator on both the SQL server 2000 A and B, why I can change the
service account on A but not on B (service account section in EM->Security
grays out). What else should I check?
Thanks,
Bing
|||Hi
"bing" wrote:

>
> "bing" wrote:
>
> Well, I figured out how to figure out if my personal domain account is in
> the local Administrators group on the database server. Yes, it is. But my
> original question still remains. Now that, my domain account is a local
> administrator on both the SQL server 2000 A and B, why I can change the
> service account on A but not on B (service account section in EM->Security
> grays out). What else should I check?
> Thanks,
> Bing
As a local administrator you should have enough permissions. Were you
connected to the server itself?
John
|||
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
I mean logged on locally to the server in question!
John
|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
Thanks much for taking time helping.
Yes, I logged on both A and B using my domain account via remote desktop
connection. I can change the service account in control panel->services.
But seems like that method is discouraged. From the advices I've gathered so
far, changing service account in EM should be the right way to go.
Bing
|||Hi
"bing" wrote:

>
> "John Bell" wrote:
>
> Thanks much for taking time helping.
> Yes, I logged on both A and B using my domain account via remote desktop
> connection. I can change the service account in control panel->services.
> But seems like that method is discouraged. From the advices I've gathered so
> far, changing service account in EM should be the right way to go.
> Bing
If the account you are logged into the server with is a local windows
administrator then it should be fine and you should be able to change the
service account. To access the property pages you need to be a SQL Server
sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
machine, you don't have any aliases set up and the server is registered as
(LOCAL) ?
John
|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> If the account you are logged into the server with is a local windows
> administrator then it should be fine and you should be able to change the
> service account. To access the property pages you need to be a SQL Server
> sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> machine, you don't have any aliases set up and the server is registered as
> (LOCAL) ?
> John
Hm. Sorry I don't quite understand the question. Here is what SELECT
@.@.SERVERNAME returns on A and B respectively.
A. TECUMSEH
B. HAMMERHEAD
And here are A's and B's host name in DNS:
A. pc200.dept.some.edu
B. hammerhead.dept.some.edu
Any problems with that?
Bing

How to enable a domain account to change service account?

Hi,
We're running two SQL server 2000, SP3 A and B. On A, the service account
for both the SQL server and agent is a domain account. On B, the service
account is local system account. On A in enterprise manager, my personal
domain account can change the service account to whatever I want. But on B,
in security of enterprise manager, the 'Startup service account' grays out
for my domain account. How should I allow my domain account to modify
startup service account? Is it something that needs to be done in the activ
e
directory or on the database server? How?
Thanks much in advance for any help.
BingHi
"bing" wrote:

> Hi,
> We're running two SQL server 2000, SP3 A and B. On A, the service account
> for both the SQL server and agent is a domain account. On B, the service
> account is local system account. On A in enterprise manager, my personal
> domain account can change the service account to whatever I want. But on
B,
> in security of enterprise manager, the 'Startup service account' grays out
> for my domain account. How should I allow my domain account to modify
> startup service account? Is it something that needs to be done in the act
ive
> directory or on the database server? How?
> Thanks much in advance for any help.
> Bing
Are you a local administrator on Server B?
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> Are you a local administrator on Server B?
> John
How should I tell?
Bing|||"bing" wrote:

>
> "John Bell" wrote:
>
> How should I tell?
> Bing
Never mind. I figured it out.|||"bing" wrote:

>
> "bing" wrote:
>
> Never mind. I figured it out.
Well, I figured out how to figure out if my personal domain account is in
the local Administrators group on the database server. Yes, it is. But my
original question still remains. Now that, my domain account is a local
administrator on both the SQL server 2000 A and B, why I can change the
service account on A but not on B (service account section in EM->Security
grays out). What else should I check?
Thanks,
Bing|||Hi
"bing" wrote:

>
> "bing" wrote:
>
> Well, I figured out how to figure out if my personal domain account is in
> the local Administrators group on the database server. Yes, it is. But m
y
> original question still remains. Now that, my domain account is a local
> administrator on both the SQL server 2000 A and B, why I can change the
> service account on A but not on B (service account section in EM->Security
> grays out). What else should I check?
> Thanks,
> Bing
As a local administrator you should have enough permissions. Were you
connected to the server itself?
John|||
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
I mean logged on locally to the server in question!
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> As a local administrator you should have enough permissions. Were you
> connected to the server itself?
> John
Thanks much for taking time helping.
Yes, I logged on both A and B using my domain account via remote desktop
connection. I can change the service account in control panel->services.
But seems like that method is discouraged. From the advices I've gathered s
o
far, changing service account in EM should be the right way to go.
Bing|||Hi
"bing" wrote:

>
> "John Bell" wrote:
>
> Thanks much for taking time helping.
> Yes, I logged on both A and B using my domain account via remote desktop
> connection. I can change the service account in control panel->services.
> But seems like that method is discouraged. From the advices I've gathered
so
> far, changing service account in EM should be the right way to go.
> Bing
If the account you are logged into the server with is a local windows
administrator then it should be fine and you should be able to change the
service account. To access the property pages you need to be a SQL Server
sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
machine, you don't have any aliases set up and the server is registered as
(LOCAL) ?
John|||"John Bell" wrote:

> Hi
> "bing" wrote:
>
> If the account you are logged into the server with is a local windows
> administrator then it should be fine and you should be able to change the
> service account. To access the property pages you need to be a SQL Server
> sysadmin. I assume that SELECT @.@.SERVERNAME will return the same name the
> machine, you don't have any aliases set up and the server is registered as
> (LOCAL) ?
> John
Hm. Sorry I don't quite understand the question. Here is what SELECT
@.@.SERVERNAME returns on A and B respectively.
A. TECUMSEH
B. HAMMERHEAD
And here are A's and B's host name in DNS:
A. pc200.dept.some.edu
B. hammerhead.dept.some.edu
Any problems with that?
Bing

How to editing XML file through script tack in SSIS (Integration Service) 2005

Please help me with editing a XML file through script tack in SSIS (Integration Service) 2005

Thank you

Here are some articles to start with:

http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
http://sqljunkies.com/WebLog/knight_reign/default.aspx

How to editing XML file through script tack in SSIS (Integration Service) 2005

Please help me with editing a XML file through script tack in SSIS (Integration Service) 2005

Thank you

Here are some articles to start with:

http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
http://sqljunkies.com/WebLog/knight_reign/default.aspx

how to dynamically create report in web app?

Hello,
I am rather new to report service. What I want to achieve is prvide a web
page and let users to choose what fields they want to see, what table they
want to query and what formats they want to apply.
Is it something achievable? Would someone give me some tutorial or hints?
Many Thanks
--
hello, please helpAlthough possible it is not trivial. You need to know the RDL specification
(go to MSDN.microsoft.com and search on RDL specification, there are several
articles). Then there is the issue that this is a server based product, you
cannot change the RDL on the fly. You have to publish the RDL. With RS 2005
you can use the new controls and give the control the RDL and the dataset
(in local mode you do not even need the server). These controls come with VS
2005 (Not with SQL Server). So, check out the spec and see if this is really
something you want to tackle. Depending on the complexity you might be
better off to use XML and XSL instead.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jerry.xuddd" <jerryxuddd@.discussions.microsoft.com> wrote in message
news:78300BE1-38D8-4491-997D-2C4C0EC98AFE@.microsoft.com...
> Hello,
> I am rather new to report service. What I want to achieve is prvide a web
> page and let users to choose what fields they want to see, what table they
> want to query and what formats they want to apply.
> Is it something achievable? Would someone give me some tutorial or hints?
> Many Thanks
> --
> hello, please help

How to Download trial version

Hi Everybody,

Anybody know is there any place to download trial version of the Microsoft SQL

server 2000 Report service ?

Because i have already installed the sql server 2000 but in that CD i could find out

the Report service ! so how do i install the Report Service ?

do i have to buy the SQL Server report service 2000 separately ?

any idea ? its realy help me if i can download the trial software for practice my own

withing a small period !

regards

sujithf

Did you mean the 2005 version, if so, it comes with SQL Server 2005 and all you need to do is go to Control Panel, add/remove programs and select Add components from the setup wizard. Don't remember how it worked with 2000, but it may have been a separate download.

BTW, you want to get 2005, it has lots of improvements.

How to do this ?

I want to do a win app or web app that has many reports, I do not want to use CR Service, I want to try SQL Server 2005 Reports, please is anyone who can tell me how to do this, or can send me any link telling me anything in this directon ?

I really appreciate your help !

Sincerely

The first place to start is the Microsoft site.

http://www.microsoft.com/sql/technologies/reporting/default.mspx

|||Hi,
Thnx Brad
Can u suggest me any book speaks about creating reports in VS.NET (2003 or 2005) using SQL Report Services (SQL 2000 or 2005) .
I value your help!

Best regards|||For RS 2000 the book "Microsoft Reporting Services in Action" by Teo Lachev is very good.

How to do backup in Cluster

Hi,

I have a cluster set up and working fine. I am in a stage where I need to do the backups. I have added 4 disks as dependecies to the sql service for the instance. The backups should not be on these disks. When I do a simple backup I can see only these 4 disks so my question is how do I do the backup to fileshare or other disks that are not partof the cluster. I have 3 virtual servers so what wil be the best thing to do for backup

Thanks

Adminanup,

What is preventing you from backing up to a fileshare?

-Matt

|||

Is there a reason for not sending your backups to disks which are part of your cluster group?

Certainly you wouldn't send backups to the same disk as the database is stored on, but another disk in the same group should work just fine.

|||

Thanks

It was a firewall issue and could not backup to a fileshare.

Like you have mentioned what is the best practices in backing up DB in cluster

1. fileshare

2. add a disk resouce(which I assume will fail evertime SQL will failover) to the SQL group in cluster and add as dependency

Thanks

|||I would choose #2 for performance reasons.|||

Thanks Kevin,

I would think backing to fileshare would be efficient as in case of failover it has to failover the backup disk as a resouce so can you please give me some insight as why this is recommended as compnared to #1

|||

Hello,

The failover of a disk resource is usually very quick (and given it is used for backup which can be reissued, thus not impacting service, is not time critical), so the duration of failover should not be an issue. I would think #2 was chosen for performance as it does not involve moving data across the network as per option 1.

Cheers,
Rob

How to do backup in Cluster

Hi,

I have a cluster set up and working fine. I am in a stage where I need to do the backups. I have added 4 disks as dependecies to the sql service for the instance. The backups should not be on these disks. When I do a simple backup I can see only these 4 disks so my question is how do I do the backup to fileshare or other disks that are not partof the cluster. I have 3 virtual servers so what wil be the best thing to do for backup

Thanks

Adminanup,

What is preventing you from backing up to a fileshare?

-Matt

|||

Is there a reason for not sending your backups to disks which are part of your cluster group?

Certainly you wouldn't send backups to the same disk as the database is stored on, but another disk in the same group should work just fine.

|||

Thanks

It was a firewall issue and could not backup to a fileshare.

Like you have mentioned what is the best practices in backing up DB in cluster

1. fileshare

2. add a disk resouce(which I assume will fail evertime SQL will failover) to the SQL group in cluster and add as dependency

Thanks

|||I would choose #2 for performance reasons.|||

Thanks Kevin,

I would think backing to fileshare would be efficient as in case of failover it has to failover the backup disk as a resouce so can you please give me some insight as why this is recommended as compnared to #1

|||

Hello,

The failover of a disk resource is usually very quick (and given it is used for backup which can be reissued, thus not impacting service, is not time critical), so the duration of failover should not be an issue. I would think #2 was chosen for performance as it does not involve moving data across the network as per option 1.

Cheers,
Rob