adding windows user via sp_cmdshell

assuming SQL server nt service is started under domain user with right to cr
eate windows user in domain, is there a way to execute sp_ in QA that allow
mw to create domain user, set password and add user to group in domain? if s
o can anyone provide this s
tatment.
Tom,Hi,
Yes. See the OS commands NET USER and NET GROUP in OS Help. You can use this
command from Query Anayzer using XP_CMDSHELL.
Sample
Master..XP_cmdshell 'net user Fin_user password /DOMAIN /ADD'
go
Master..XP_cmdshell 'net group Finance /DOMAIN /ADD'
go
For more details of command execute the below from command prompt
net user ?
net group ?
Thanks
Hari
MCDBA
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:E8D38151-CF4C-4EF9-A713-617E25BA2AEE@.microsoft.com...
> assuming SQL server nt service is started under domain user with right to
create windows user in domain, is there a way to execute sp_ in QA that
allow mw to create domain user, set password and add user to group in
domain? if so can anyone provide this statment.
> Tom,|||Hello Hari,
I have tried it, but it did not work for me, I got:
The request will be processedat DC ...
System error 5 has occurred
Access denied.
I got this regardless if I'm using SA account to open Query Analizer or wind
ows auth... where am member of domain admin. any idea...
"Hari Prasad" wrote:

> Hi,
> Yes. See the OS commands NET USER and NET GROUP in OS Help. You can use th
is
> command from Query Anayzer using XP_CMDSHELL.
> Sample
>
> Master..XP_cmdshell 'net user Fin_user password /DOMAIN /ADD'
> go
> Master..XP_cmdshell 'net group Finance /DOMAIN /ADD'
> go
>
> For more details of command execute the below from command prompt
> net user ?
> net group ?
> Thanks
> Hari
> MCDBA
>
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:E8D38151-CF4C-4EF9-A713-617E25BA2AEE@.microsoft.com...
> create windows user in domain, is there a way to execute sp_ in QA that
> allow mw to create domain user, set password and add user to group in
> domain? if so can anyone provide this statment.
>
>|||Hi Tom
As Hari said it is possible, but difficult. The problem
here is its taking the userid of SQL Server instance that
the runs the xp_cmdshell and attempting to create users.
If that userid doesn't have the Server (not SQL)
permission to do its going to crash and burn.

>--Original Message--
>Hello Hari,
>I have tried it, but it did not work for me, I got:
>The request will be processedat DC ...
>System error 5 has occurred
>Access denied.
>I got this regardless if I'm using SA account to open
Query Analizer or windows auth... where am member of
domain admin. any idea...
>"Hari Prasad" wrote:
>
Help. You can use this[vbcol=seagreen]
password /DOMAIN /ADD'[vbcol=seagreen]
command prompt[vbcol=seagreen]
message[vbcol=seagreen]
617E25BA2AEE@.microsoft.com...[vbcol=seagreen]
domain user with right to[vbcol=seagreen]
execute sp_ in QA that[vbcol=seagreen]
user to group in[vbcol=seagreen]
>.
>|||Hi,
I agree with you peter. To do this you might need to start the MSSQL server
service using
a Domain Administrator account. I will not suggest you this.
I will not recommend you to create users / Groups from Query Analyzer.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2dc001c470c1$74fea120$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Tom
> As Hari said it is possible, but difficult. The problem
> here is its taking the userid of SQL Server instance that
> the runs the xp_cmdshell and attempting to create users.
> If that userid doesn't have the Server (not SQL)
> permission to do its going to crash and burn.
>
> Query Analizer or windows auth... where am member of
> domain admin. any idea...
> Help. You can use this
> password /DOMAIN /ADD'
> command prompt
> message
> 617E25BA2AEE@.microsoft.com...
> domain user with right to
> execute sp_ in QA that
> user to group in|||Agreed.

>--Original Message--
>Hi,
>I agree with you peter. To do this you might need to
start the MSSQL server
>service using
>a Domain Administrator account. I will not suggest you
this.
>I will not recommend you to create users / Groups from
Query Analyzer.
>Thanks
>Hari
>MCDBA
>
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2dc001c470c1$74fea120$a301280a@.phx.gbl...
that[vbcol=seagreen]
>
>.
>sql

Adding Win 2000 account to SQL Server database role

According to SQL Server 2000 Books online:
"When you add a Windows NT 4.0 or Windows 2000 login without a user account
in the database to a SQL Server database role, SQL Server creates a user
account in the database automatically, even if that Windows NT 4.0 or Window
s
2000 login cannot otherwise access the database".
My Questions: How can you add a login to a role without a user account (with
that login) in the database? So, I don't understand the above comments. I wa
s
unable to create the above example since I had to create a win 2000 login as
a user in the database first before adding that login to a role. Can someone
please explain the above comments?
Thanks,
KevMaybe you were trying it just through Enterprise Manager?
You need to use the system stored procedure to do this. Try
the following:
Create a new user on the machine.
In Query Analyzer, execute the following:
use northwind
go
sp_addrolemember 'db_datareader', 'YourMachine\YourUser'
The windows account will show up a user in the database with
access via group membership. You don't have to first add the
login or add the user to the database.
-Sue
On Wed, 21 Sep 2005 08:06:04 -0700, Nam
<Nam@.discussions.microsoft.com> wrote:

>According to SQL Server 2000 Books online:
>"When you add a Windows NT 4.0 or Windows 2000 login without a user account
>in the database to a SQL Server database role, SQL Server creates a user
>account in the database automatically, even if that Windows NT 4.0 or Windo
ws
>2000 login cannot otherwise access the database".
>My Questions: How can you add a login to a role without a user account (wit
h
>that login) in the database? So, I don't understand the above comments. I w
as
>unable to create the above example since I had to create a win 2000 login a
s
>a user in the database first before adding that login to a role. Can someon
e
>please explain the above comments?
>Thanks,
>Kev

Adding User groups Wont work

Hello,
We are using reporting services for about 6 months now and granting
access to windows users works great. I cant seem to get user groups to
work however. I am not a expert on windows users/groups so I dont
really know what to check.
Say for example we have a user group called "Activations" I type the
name and it enters correctly, and shows the group has access to a
report. Then if I look at the group in MS Outlook and see what users a
Group has it shows me the users. But if they try and access the report
they get a error saying they dont have access. Only way I can get it to
work is by adding the usernames one-by-one.
Ona a side note the group "Everyone" seems to work fine. Has anyone
else had any problems or know what I could check.
Thanks,
EddieI should also say that the user groups I want to add are domain user
groups - not local. But wouldnt RS be able to user domain user groups?
eddieb wrote:
> Hello,
> We are using reporting services for about 6 months now and granting
> access to windows users works great. I cant seem to get user groups to
> work however. I am not a expert on windows users/groups so I dont
> really know what to check.
> Say for example we have a user group called "Activations" I type the
> name and it enters correctly, and shows the group has access to a
> report. Then if I look at the group in MS Outlook and see what users a
> Group has it shows me the users. But if they try and access the report
> they get a error saying they dont have access. Only way I can get it to
> work is by adding the usernames one-by-one.
> Ona a side note the group "Everyone" seems to work fine. Has anyone
> else had any problems or know what I could check.
> Thanks,
> Eddie|||When you map the user group to a role are you putting in the domain?
I have several domain groups plus some individual users and what I have done
is added a local group (like Reports) to this local group I add the
individual users and the domain groups. Then I assign this local group to
the Browser role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"eddieb" <eballinger@.nl.rogers.com> wrote in message
news:1156422956.940596.164720@.74g2000cwt.googlegroups.com...
>I should also say that the user groups I want to add are domain user
> groups - not local. But wouldnt RS be able to user domain user groups?
>
> eddieb wrote:
>> Hello,
>> We are using reporting services for about 6 months now and granting
>> access to windows users works great. I cant seem to get user groups to
>> work however. I am not a expert on windows users/groups so I dont
>> really know what to check.
>> Say for example we have a user group called "Activations" I type the
>> name and it enters correctly, and shows the group has access to a
>> report. Then if I look at the group in MS Outlook and see what users a
>> Group has it shows me the users. But if they try and access the report
>> they get a error saying they dont have access. Only way I can get it to
>> work is by adding the usernames one-by-one.
>> Ona a side note the group "Everyone" seems to work fine. Has anyone
>> else had any problems or know what I could check.
>> Thanks,
>> Eddie
>

Adding Table to Dataset for SQL Server Mobile causes VS 2005 to lock up.

I am running VS 2005 Professional Edition

Windows XP profession with Service Pack 2

SQL Server 2005 Developer Edition.

WHAT I HAVE DONE:

I have a database running in an instance of SQL Server.

I set this up for merge publication and then set up a SQL Server Mobile Edition Subscription to that publication. After a few oversights I got everything working. The Mobile database replicated just fine. I went back verified all data was there. Can make queries to it.

PROBLEM:

I set up a new dataset to use tables from the SQL Server Mobile database. If I drag one of the tables to the dataset, VS 2005 simply stops responding. It is not using any processor. I click any place on the application and I get the Microsoft Visual Studio Delay Notification saying:

Microsoft Visual Studio is Busy.

Microsoft Visual Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft.

Well... It is more than just a delay. The environment is not using any processor its just sitting here. And I left it running for 2.5 hours... so now this is becoming a big source of pain for me because I need to get that dataset working to finish my business logic. The only option I have is to Kill the process.

Hopefully someone out there can help.

Additional Services running:

IIS (Whatever version comes with Windows XP Pro. I think 5.1)

SQL Server Agent, SQL Server Integration Services, SQL Server Broswer and SQL Server FullTextSearch

UPDATE: I am editing this post with an update.

I noticed that my other tables get added to the dataset just fine. It is when I add one particular table that the entire visual studio simply stops and starts giving the delay notification. I have no idea why this happens... nor do I see any noticeable difference between this table and the rest of them. I went back and made sure that all columns types where directly supported by SQL Mobile Edition and they are.

Kevin,

I've seen this in a couple of circumstances:

1. you had a pre-release version of VS2005 (Whidbey) on your dev machine at some point , then installed the RTM, and something is disconnected in the feature that does the automatic BindingSource generation when you add a new database datasource to your project. this, unfortunately, requires a cleanup and reinstall ofVS2005

2. you are accidentally trying to use a SQL CE 2.0 database as the data source

Darren

|||

Darren,

This is a clean install of Visual Studio 2005. No pre release or beta versions have been on this machine.

I created the database a new SQL Server Mobile Edition database and then filled that database via replication of a SQL Server 2005 database.

I am connecting to it via as SQL Server Mobile Edition Data Source.

I did update the first post to add that it is in fact only 1 table that locks up the solution. The other 48 tables load just fine. I don't see any differences in this table from the others except that it has the most columns. It has 52 columns of types int, nvarchar, rowguid, bigint.

Is there anything else you can think of for me to try or check out?

|||

Kevin,

Would you be willing to email me a copy of your sdf file and I can try it in my VS2005 install and maybe see what it is about that one table that can't be modeled into a BindingSource? You can contact me through my blog (just Google me).

-Darren Shaffer

|||

Darren,

I took the database over to another developers PC who is working on another project. He does not have SQL Server installed but does have Visual Studio 2005 Professional running.

We got the exact same results. All tables could be added to the dataset designer by dragging and dropping but the one table caused the Microsot Delay Notification.

We then decided to try to add the table to the designer by right clicking and saying add table. Then added the table via the query statements. It added just fine that way.

So the problem seems to rear its head only during the Drag -N-Drop method of the Data Set Designer. I am still scratching my head as to why this could be.

I'll will send you a copy of this database to checkout for yourself.

|||

Kevin,

Just to give you an update, I did send a copy of your database to Laxmi - we're hoping to get a fix into SP1 of VS2005.

thanks,

Darren

|||

Darren,

Thank you for the update.

Can you please eloborate a little as to what the problem was?

|||

Kevin,

I got the same behavior you did - you try to add the Vehicles table to a DataSet in VS2005 and it sits forever. I tried repairing the database first, and even tried removing the merge subscription from the SQL Mobile database first. Same behavior. The only thing I think might be involved here is that you have several BIGINT columns in that table and these translate to an INT64 in .NET. I'm wondering if the VSD (Visual Studio for Devices) team anticipated the need to support INT64 in the dataset designer for SQL Mobile data sources.

I'll let you know when I hear back from Laxmi on his investigation of the issue.

Darren

|||

Hi Kevin & Darren,

My team mate Mr. Mohit Khullar who was working on this issue has reproduced the problem and found the root cause too. This bug is in the communication of data between desktop designer and device.

Thanks for pointing out the bug. We would try to make this fix into Whidbey SP1.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||I wonder if it's possible to be a little more specific...? I found this thread just doing a Google search for "Microsoft Visual Studio .NET 2005 'Delay Notification'" - Since I seem to get this message every now and then and haven't pinned it down to anything specific that causes it. My co-worker just walked up and I showed it to him and asked if he's ever seen it, and he said Yup, lots... Also, it happens on different machines... My home PC, my 2 work PCs, and my VMs.

Sometimes it comes back after a bit.. Sometimes (like now) it doesn't! (well, I've waited about 20 minutes.. I figure that's long enough!) ;) Nothing else is open and the CPU is more or less totally idle according to the Task Manager.
It would be nice to know what's causing it, so I can try to avoid certain behaviours.
I have to say that it's Excessively Lame that it says "If you regularly encounter this delay during normal usage please report this prolem to Microsoft." -- But it doesn't say to who, or what email, or what phone number I should report this to! Making me search for something that should have been known to whoever wrote that "Delay Notification" dialog is, as I say.. Lame. :(

Visual Studio 2005 in General ROCKS. This is just one particular very annoying (to me) thing.
Also, the PC is not directly connected to the Internet, so even though when I force-kill it with Task Manager and it asks me to "Please tell Microsoft about this problem." - I can't send it, and it doesn't give me any other way to do so! - That also is another thing about MS products that I find Particularly annoying!

Thanks
- Andrew

PS - Am I EVER glad I selected all and copied before I hit Post! - It just refreshed the screen or something and I lost my entire message! :( Try again... (edit: at least it worked the 2nd time!)
|||

Hi Laxmi,

I thought I would let you know that this problem is NOT reserved just for mobile server connections. This problem is very common for straight Windows Applications. I receive this message VERY often. I thought it was due to my converting a VS2003 solution across to VS2005, but that is not the case either. Although, to clarify, converting a VS2003 solution to VS2005 does seem to cause this message to be raised more often than from a brand new creation of a solution.

I hope this helps identify the bug more specifically.

cheers,

Mark Chimes

|||

I think there has been lot of confusion about the context of this thread. There is a particular table schema and when this table is added to DataSet, VS is locked up. There can be other cases of VS locking up which are in no way related to this thread. So, please just dont take this thread as just "VS Locking up" case rather take it as "VS Locking up for a particular SQL Mobile Table Schema".

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere Edition, Microsoft Corporation

|||no confusion occuring except when you say the error is restricted to '...a particular table schema'. i am experiencing the exact same problem in a web app i am busy with. i drag a dataset from the toolbox which then creates a default datatable...WITH an adapter ...et voila! i cant say for sure where the designer is trying to link the table adapter to but the result is a dead-end for vs.|||

Are you still facing the same problem with Whidbey SP1 or Whidbey SP1 Beta?

Thanks,

Laxmi

Adding Table to Dataset for SQL Server Mobile causes VS 2005 to lock up.

I am running VS 2005 Professional Edition

Windows XP profession with Service Pack 2

SQL Server 2005 Developer Edition.

WHAT I HAVE DONE:

I have a database running in an instance of SQL Server.

I set this up for merge publication and then set up a SQL Server Mobile Edition Subscription to that publication. After a few oversights I got everything working. The Mobile database replicated just fine. I went back verified all data was there. Can make queries to it.

PROBLEM:

I set up a new dataset to use tables from the SQL Server Mobile database. If I drag one of the tables to the dataset, VS 2005 simply stops responding. It is not using any processor. I click any place on the application and I get the Microsoft Visual Studio Delay Notification saying:

Microsoft Visual Studio is Busy.

Microsoft Visual Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft.

Well... It is more than just a delay. The environment is not using any processor its just sitting here. And I left it running for 2.5 hours... so now this is becoming a big source of pain for me because I need to get that dataset working to finish my business logic. The only option I have is to Kill the process.

Hopefully someone out there can help.

Additional Services running:

IIS (Whatever version comes with Windows XP Pro. I think 5.1)

SQL Server Agent, SQL Server Integration Services, SQL Server Broswer and SQL Server FullTextSearch

UPDATE: I am editing this post with an update.

I noticed that my other tables get added to the dataset just fine. It is when I add one particular table that the entire visual studio simply stops and starts giving the delay notification. I have no idea why this happens... nor do I see any noticeable difference between this table and the rest of them. I went back and made sure that all columns types where directly supported by SQL Mobile Edition and they are.

Kevin,

I've seen this in a couple of circumstances:

1. you had a pre-release version of VS2005 (Whidbey) on your dev machine at some point , then installed the RTM, and something is disconnected in the feature that does the automatic BindingSource generation when you add a new database datasource to your project. this, unfortunately, requires a cleanup and reinstall ofVS2005

2. you are accidentally trying to use a SQL CE 2.0 database as the data source

Darren

|||

Darren,

This is a clean install of Visual Studio 2005. No pre release or beta versions have been on this machine.

I created the database a new SQL Server Mobile Edition database and then filled that database via replication of a SQL Server 2005 database.

I am connecting to it via as SQL Server Mobile Edition Data Source.

I did update the first post to add that it is in fact only 1 table that locks up the solution. The other 48 tables load just fine. I don't see any differences in this table from the others except that it has the most columns. It has 52 columns of types int, nvarchar, rowguid, bigint.

Is there anything else you can think of for me to try or check out?

|||

Kevin,

Would you be willing to email me a copy of your sdf file and I can try it in my VS2005 install and maybe see what it is about that one table that can't be modeled into a BindingSource? You can contact me through my blog (just Google me).

-Darren Shaffer

|||

Darren,

I took the database over to another developers PC who is working on another project. He does not have SQL Server installed but does have Visual Studio 2005 Professional running.

We got the exact same results. All tables could be added to the dataset designer by dragging and dropping but the one table caused the Microsot Delay Notification.

We then decided to try to add the table to the designer by right clicking and saying add table. Then added the table via the query statements. It added just fine that way.

So the problem seems to rear its head only during the Drag -N-Drop method of the Data Set Designer. I am still scratching my head as to why this could be.

I'll will send you a copy of this database to checkout for yourself.

|||

Kevin,

Just to give you an update, I did send a copy of your database to Laxmi - we're hoping to get a fix into SP1 of VS2005.

thanks,

Darren

|||

Darren,

Thank you for the update.

Can you please eloborate a little as to what the problem was?

|||

Kevin,

I got the same behavior you did - you try to add the Vehicles table to a DataSet in VS2005 and it sits forever. I tried repairing the database first, and even tried removing the merge subscription from the SQL Mobile database first. Same behavior. The only thing I think might be involved here is that you have several BIGINT columns in that table and these translate to an INT64 in .NET. I'm wondering if the VSD (Visual Studio for Devices) team anticipated the need to support INT64 in the dataset designer for SQL Mobile data sources.

I'll let you know when I hear back from Laxmi on his investigation of the issue.

Darren

|||

Hi Kevin & Darren,

My team mate Mr. Mohit Khullar who was working on this issue has reproduced the problem and found the root cause too. This bug is in the communication of data between desktop designer and device.

Thanks for pointing out the bug. We would try to make this fix into Whidbey SP1.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||I wonder if it's possible to be a little more specific...? I found this thread just doing a Google search for "Microsoft Visual Studio .NET 2005 'Delay Notification'" - Since I seem to get this message every now and then and haven't pinned it down to anything specific that causes it. My co-worker just walked up and I showed it to him and asked if he's ever seen it, and he said Yup, lots... Also, it happens on different machines... My home PC, my 2 work PCs, and my VMs.

Sometimes it comes back after a bit.. Sometimes (like now) it doesn't! (well, I've waited about 20 minutes.. I figure that's long enough!) ;) Nothing else is open and the CPU is more or less totally idle according to the Task Manager.
It would be nice to know what's causing it, so I can try to avoid certain behaviours.
I have to say that it's Excessively Lame that it says "If you regularly encounter this delay during normal usage please report this prolem to Microsoft." -- But it doesn't say to who, or what email, or what phone number I should report this to! Making me search for something that should have been known to whoever wrote that "Delay Notification" dialog is, as I say.. Lame. :(

Visual Studio 2005 in General ROCKS. This is just one particular very annoying (to me) thing.
Also, the PC is not directly connected to the Internet, so even though when I force-kill it with Task Manager and it asks me to "Please tell Microsoft about this problem." - I can't send it, and it doesn't give me any other way to do so! - That also is another thing about MS products that I find Particularly annoying!

Thanks
- Andrew

PS - Am I EVER glad I selected all and copied before I hit Post! - It just refreshed the screen or something and I lost my entire message! :( Try again... (edit: at least it worked the 2nd time!)
|||

Hi Laxmi,

I thought I would let you know that this problem is NOT reserved just for mobile server connections. This problem is very common for straight Windows Applications. I receive this message VERY often. I thought it was due to my converting a VS2003 solution across to VS2005, but that is not the case either. Although, to clarify, converting a VS2003 solution to VS2005 does seem to cause this message to be raised more often than from a brand new creation of a solution.

I hope this helps identify the bug more specifically.

cheers,

Mark Chimes

|||

I think there has been lot of confusion about the context of this thread. There is a particular table schema and when this table is added to DataSet, VS is locked up. There can be other cases of VS locking up which are in no way related to this thread. So, please just dont take this thread as just "VS Locking up" case rather take it as "VS Locking up for a particular SQL Mobile Table Schema".

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere Edition, Microsoft Corporation

|||no confusion occuring except when you say the error is restricted to '...a particular table schema'. i am experiencing the exact same problem in a web app i am busy with. i drag a dataset from the toolbox which then creates a default datatable...WITH an adapter ...et voila! i cant say for sure where the designer is trying to link the table adapter to but the result is a dead-end for vs.|||

Are you still facing the same problem with Whidbey SP1 or Whidbey SP1 Beta?

Thanks,

Laxmi

adding sql server CAL on cluster

Hi Guys,
i am using sql server 2000 on Windows 2000 cluster with
150 concurrent license . now i want to add 50 more licence.
do i have to add this for both nodes?
what is the procedure to do this ? is it using licensing
manager in control panel?
PLS advice meReplied in the other thread.
David Portas
SQL Server MVP
--

adding sql server CAL on cluster

Hi Guys,
i am using sql server 2000 on windows 2000 cluster with
150 concurrent license . now i want to add 50 more licence.
do i have to add this for both nodes?
what is the procedure to do this ? is it using licensing
manager in control panel?
PLS advice me
Replied in the other thread.
David Portas
SQL Server MVP

adding second node to sql cluster

I created a one node Cluster in Windows 2003 enterprise server. I then loaded
a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees
the new node. However when I attempt to load the SLQ executables on the
second node the only option I have once I choose the virtual server is to
upgrade the existing installation. That does not install the executable on
the second node. What am I doing wrong. Thanks in advance.
you must choose upgrade the existing installation on virual server and add
second node for existing virtual sql server
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Joe McHae" wrote:

> I created a one node Cluster in Windows 2003 enterprise server. I then loaded
> a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees
> the new node. However when I attempt to load the SLQ executables on the
> second node the only option I have once I choose the virtual server is to
> upgrade the existing installation. That does not install the executable on
> the second node. What am I doing wrong. Thanks in advance.
|||I did choose upgrade. I did not see an option to add a second node for the
existing sql server. The second server is in the cluster.
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> you must choose upgrade the existing installation on virual server and add
> second node for existing virtual sql server
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Joe McHae" wrote:
|||In the setup routine, there will be an Advanced option. After selecting,
there will be a Maintain and Existing Installation option.
This will take you down an installation path were you can add new cluster
member nodes as a potential SQL Server failover partner.
In the maintenance section of the SQL Server 2000 failover clustering
document is an Add/Remove Cluster Nodes sub-section.
Adding or Removing a Cluster Node from the Virtual Server Definition
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EPUAG
Best of luck.
Sincerely,
Anthony Thomas

"Joe McHae" <JoeMcHae@.discussions.microsoft.com> wrote in message
news:332E6DA7-9F20-455C-97BE-ABD7BE8EFAE8@.microsoft.com...[vbcol=seagreen]
> I did choose upgrade. I did not see an option to add a second node for the
> existing sql server. The second server is in the cluster.
> "Aleksandar Grbic" wrote:
add[vbcol=seagreen]
loaded[vbcol=seagreen]
cluster sees[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
executable on[vbcol=seagreen]
|||Anthony;
thanks, the problem I wa having was the executables for SQL were not loading
on the second node. I followed your link then removed the node and added it
again. for some reasons the executables are there. I guess that is why they
call it magic.
Joe
"Anthony Thomas" wrote:

> In the setup routine, there will be an Advanced option. After selecting,
> there will be a Maintain and Existing Installation option.
> This will take you down an installation path were you can add new cluster
> member nodes as a potential SQL Server failover partner.
> In the maintenance section of the SQL Server 2000 failover clustering
> document is an Add/Remove Cluster Nodes sub-section.
> Adding or Removing a Cluster Node from the Virtual Server Definition
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EPUAG
> Best of luck.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Joe McHae" <JoeMcHae@.discussions.microsoft.com> wrote in message
> news:332E6DA7-9F20-455C-97BE-ABD7BE8EFAE8@.microsoft.com...
> add
> loaded
> cluster sees
> the
> to
> executable on
>
>

adding other users

Created a report in SSRS 2005 on a test windows server 2003.

I have admin rights on this server.

I can access it by http://localhost/reports

and then click on the report itself to view the data.

Now I would like my colleague to access this report on this server.

He does NOT have admin rights.

I would like him to view the report from his browser by typing:

http://servername/reports or something simiilar.

How/where do I add him to have access to the report?

Thanks

Found the link to add the user.

Thanks anyway

Adding NT login using T-SQL

Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin
doesn't seem to have this capability.
Thank you in advance for your help!
Use sp_grantlogin for that.
As of 2005, you use CREATE LOGIN for both types of logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in message
news:1C6B2795-8C35-45B2-B584-3B615CE505D9@.microsoft.com...
> Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin
> doesn't seem to have this capability.
> Thank you in advance for your help!

Adding NT login using T-SQL

Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin
doesn't seem to have this capability.
Thank you in advance for your help!Use sp_grantlogin for that.
As of 2005, you use CREATE LOGIN for both types of logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in me
ssage
news:1C6B2795-8C35-45B2-B584-3B615CE505D9@.microsoft.com...
> Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogi
n
> doesn't seem to have this capability.
> Thank you in advance for your help!

Adding NT login using T-SQL

Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin
doesn't seem to have this capability.
Thank you in advance for your help!Use sp_grantlogin for that.
As of 2005, you use CREATE LOGIN for both types of logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in message
news:1C6B2795-8C35-45B2-B584-3B615CE505D9@.microsoft.com...
> Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin
> doesn't seem to have this capability.
> Thank you in advance for your help!

adding NT AUTHORITY\NETWORK SERVICE problem

Hi,
I trying to add a login AUTHORITY\NETWORK SERVICE'. to sql 2005.
I got the error says the windows NT AUTHORITY\NETWORK SERVICE not found, pls
check the name again.
ANy ideas.Try to execute this statement
USE [master]
GO
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS WITH
DEFAULT_DATABASE=[master]
GO
Regards,
Manoj Raheja
MCDBA, MCITP
"mecn" wrote:

> Hi,
> I trying to add a login AUTHORITY\NETWORK SERVICE'. to sql 2005.
> I got the error says the windows NT AUTHORITY\NETWORK SERVICE not found, p
ls
> check the name again.
> ANy ideas.
>
>

Adding new node to SQL SP4 cluster

Hi all,
I'm trying to add a new node to our SQL Server 2000 SP4 cluster. Cluster
node is Windows 2003 SP1. I can add the node to the SQL cluster, but when I
try to add SP4 to the new node, I get an error message when I enter in the
service password for the instance.
Error message : Setup cannot verify/grant logon as service right to the SQL
Server service logon account: 5000 (0x1388)
However, this error didn't come up when I was adding the node to the SQL
cluster and it prompted me for the same password. We're running an
active/active configuration and I can't do anything with the other instance
(the default one) as it says that this instance is still waiting for the
service pack!
Any ideas anyone? Thanks in advance
Dave
Dave Wall
Dave,
It looks like a permission issue. Does the Windows domain a/c that you are using the setup have local admin privileges on both the cluster nodes? Try running the setup using the virtual SQL Server service a/c or the
cluster service a/c ?
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Dave,
Are you using the NEED_SP_KEY in the registry. If yes, then remove this key and re-run SP4 from the original node (i.e the node that is already on SP4 and owns the SQL resources) and see if this helps?
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Thanks Uttam,
removed the reg key and it all went through without any problems
Dave
Dave Wall
"Uttam Parui[MS]" wrote:

> Dave,
> Are you using the NEED_SP_KEY in the registry. If yes, then remove this key and re-run SP4 from the original node (i.e the node that is already on SP4 and owns the SQL resources) and see if this helps?
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
|||Dave,
Glad to hear that the issue is resolved. I appreciate your update.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hello, I'm having the same problem, but I don't know what you mean by this
NEED_SP_KEY I can't find any information on it. If you could shed some light
on this I would greatly appreciate it!
--Gene
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:KA3IUo6kFHA.944@.TK2MSFTNGXA01.phx.gbl...
> Dave,
> Are you using the NEED_SP_KEY in the registry. If yes, then remove this
key and re-run SP4 from the original node (i.e the node that is already on
SP4 and owns the SQL resources) and see if this helps?
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Depending on certain parameters, the Need_SP_Key is added to the new node by the setup process when the node is
added to the SQL failover cluster.
Check (on all nodes) if you have the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Need_SP_Key
If yes, then delete it. Then try to install the service pack 4 from the active node where SQL Server is currently running.
If no, then you might be having a different issue. Give more details for us to help you.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Uttam Parui[MS] wrote:
> Dave,
> Are you using the NEED_SP_KEY in the registry. If yes, then remove this key and re-run SP4 from the original node (i.e the node that is already on SP4 and owns the SQL resources) and see if this helps?
For me this does not realy help. The node needs to be a possible owner of
the sql resources or else, the node is not updated. When you have just added
the node by the advanced sql setup option, this is not the case yet.
The second problem is, that this way sp4 updates all the nodes and takes the
SQL resources OFFLINE.
I tried installing SP3 first, which is not a goed idea. The sqlsetup runs
fine, the node becomes a possible owner but can't be used (sql wil not come
online), the NEED_SP_KEY dissapears, with means SP4 wants to reapply totaly.
Restoring the NEED_SP_KEY solves this but then the "Setup cannot
verify/grant logon as service right..." is back.
So adding a SP4 node without takeing SQL temporarily offline is not possible.
Hans
p.s.
SP4 was installed with a enterprise admin account.
|||There is a hotfix available from Microsoft support which fixed this for me.
See http://support.microsoft.com/?kbid=905286
BB.
"Hans de Bruin" wrote:

> Uttam Parui[MS] wrote:
> For me this does not realy help. The node needs to be a possible owner of
> the sql resources or else, the node is not updated. When you have just added
> the node by the advanced sql setup option, this is not the case yet.
> The second problem is, that this way sp4 updates all the nodes and takes the
> SQL resources OFFLINE.
> I tried installing SP3 first, which is not a goed idea. The sqlsetup runs
> fine, the node becomes a possible owner but can't be used (sql wil not come
> online), the NEED_SP_KEY dissapears, with means SP4 wants to reapply totaly.
> Restoring the NEED_SP_KEY solves this but then the "Setup cannot
> verify/grant logon as service right..." is back.
> So adding a SP4 node without takeing SQL temporarily offline is not possible.
> --
> Hans
> p.s.
> SP4 was installed with a enterprise admin account.
>

Adding more RAM for MS SQL Server 2000

Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:

>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If you wanted to address > 4GB of RAM then you would have to start playing with AWE but <= 4GB is addressable with normal windows memory addressing & therefore normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar

Adding more RAM for MS SQL Server 2000

Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
OskarThis is a multi-part message in MIME format.
--060508000204080606090209
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
No. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:
>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machine
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
>more gigabytes of RAM into the machine and I want to allow the SQL Server to
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it to
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>
--060508000204080606090209
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>No. All you have to do is add the /3GB switch to boot.ini and
reboot. If you wanted to address > 4GB of RAM then you would have
to start playing with AWE but <= 4GB is addressable with normal
windows memory addressing & therefore normal MSSQL dynamic memory
management.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Oskar wrote:
<blockquote cite="midDA9DCAEE-A7F3-4E04-986C-97D1E43CDE91@.microsoft.com"
type="cite">
<pre wrap="">Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machine
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
--
Many thanks,
Oskar
</pre>
</blockquote>
</body>
</html>
--060508000204080606090209--|||This is a multi-part message in MIME format.
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Hi,
This will work out if your SQL server 2000 edition is Enterprise or =Developer. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:OvpsIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. = If you wanted to address > 4GB of RAM then you would have to start =playing with AWE but <=3D 4GB is addressable with normal windows memory =addressing & therefore normal MSSQL dynamic memory management.
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar
--=_NextPart_000_004D_01C565EC.8E52DE90
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Hi,
This will work out if your SQL server =2000 edition is Enterprise or Developer. Standard edition can support a maximum of 2 =GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" wrote in message news:OvpsIwbZFHA.4088=@.TK2MSFTNGP15.phx.gbl...No. All you have to do is add the /3GB switch to boot.ini and =reboot. If you wanted to address > 4GB of RAM then you would have to start playing =with AWE but <=3D 4GB is addressable with normal windows memory =addressing & therefore normal MSSQL dynamic memory management.
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com Oskar wrote: Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at =my hand. The SQL Server is configured for dynamic memory allocation. The =machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed =two more gigabytes of RAM into the machine and I want to allow the SQL =Server to use a total of 3GB of RAM (by means of turning on the /3GB switch in =Windows boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling =it to use the additional gigabyte of RAM?
--
Many thanks,
Oskar

---

--=_NextPart_000_004D_01C565EC.8E52DE90--

Adding more RAM for MS SQL Server 2000

Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
OskarNo. All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Oskar wrote:

>Hi
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machi
ne
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed tw
o
>more gigabytes of RAM into the machine and I want to allow the SQL Server t
o
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Window
s
>boot.ini).
>Do I also have to reconfigure any SQL Server parameters after enabling it t
o
>use the additional gigabyte of RAM?
>--
>Many thanks,
>Oskar
>
>|||Hi,
This will work out if your SQL server 2000 edition is Enterprise or Develope
r. Standard edition can support a maximum of 2 GB only.
Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:Ovp
sIwbZFHA.4088@.TK2MSFTNGP15.phx.gbl...
No. All you have to do is add the /3GB switch to boot.ini and reboot. If yo
u wanted to address > 4GB of RAM then you would have to start playing with A
WE but <= 4GB is addressable with normal windows memory addressing & therefo
re normal MSSQL dynamic memory management.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Oskar wrote:
Hi
I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).
Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?
Many thanks,
Oskar

Adding FoxPro to SQL Cluster?

Hi all,
I am the SQL DBA for an organization. We have an active/passive 2-node SQL 2000 cluster running on Windows 2003 Server. So far, it has been very stable (knock wood).
Somebody here wants to add FoxPro as a clustered application onto our (failover) clustered database server. My gut tells me no, partially because I'm not sure if you can cluster FoxPro, and what the implications of running a FoxPro cluster are. Also, I
have not been able to find any information on the Web about implementing, administrating or coding for a FoxPro cluster, while the same information on SQL Server clustering is abundent.
My questions are:
1. Has anyone out there implemented a clustered FoxPro server?
2. If so, have you implemented this on the same cluster as your production SQL Server cluster?
3. Does anyone have any recommendations for or against this type of setup?
4. Can anyone point me in the direction of information that would make the case one way or the other about this proposed implementation?
Thanks in advance!
Cheers,
-m
My first question would be:
Why do they want to do this?
Why would they want to use a FoxPro application in an environment that is
designed for high availablitly?
Theoritically any application can be clustered but logically it does not
make sense to cluster an application that by design is a desktop
application. It seems to be a waste of resources.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Someone within your organisation seems to be getting confused between server products and desktop products. Foxpro is a desktop product. Another way of looking at it is by replacing the word "FoxPro" with "Access", "Word", "Excel" etc and ask yourself t
he same questions again. Desktop applications are not cluster-aware. Some server products are. eg SQL Server 2000, Exchange 2000/2003. Attempting to make a desktop application cluster-aware seems to be a major step in the wrong direction. Your initia
l instincts were correct. Now you just need to point out the differences between cluster-aware applications and non-cluster-aware applications to your management.
If management want high availability with their database platform switch from FoxPro to SQL Server 2000 EE (on a MCS cluster). There is no such thing as a cheap highly available solution in the database space (well I've not seen one yet).

Adding DataSet as DataSource to Report Published on Report Server from ClientSide

Hi

I am Creating Click Once Windows Application with Reporting Services 2005.I have created Report and Published on Report Server.In my windows application I am successfully able to view my published report through report viewer control.

Now in my application I am getting a dataset from my custom webservice. I want this dataset data to be added to my report as datasource at runtime on Client Side ,as my report is on Report Server.

waiting for help!!

Thanks in Advance

Pankaj

The report server does not support passing in data sets for reports to run with. You could use the Viewer control in local mode and have the viewer show the report with that data set. Of course by doing this you would loose all of the server add ons (client print for the web control, subscriptions, security, etc).

-Daniel

|||

Hi

Thanks for suggession. But will you please tell me which functions/class I have to use to set my new dataset as datasource to my report at client side.as you have mentioned to use reportviewer as localmode.will you please clearly specify.

Thanks

Pankaj

|||

Hi Daniel

Or is it possible to get report from reportserver at client side and make it as local report and use it as local report and add datasources to it.?

-Pankaj

|||

You can dynamically set the data set using .LocalReport.DataSources.Add. If you look on http://www.gotreportviewer.com/ you will find examples to go by.

You may also want to look into writing a custom Data Processing Extension. By doing this, any report on the server could use your data extension to populate it's data. You can find more information here http://msdn2.microsoft.com/en-us/library/ms154655.aspx.

I'm not sure exactly what you are trying to accomplish so it's hard to say which is the best approach for your problem.

-Daniel

|||The following article may help you to find the most appropriate solution.

Adding database access to existing account prompts password change confirmation dialog

Running SQL Server 2000, Service Pack 3a, Hotfix MS03-031 (8.00.818)
on Windows 2000 Server, Service Pack 3:
Whenever I try to add or change the attributes of an existing SQL
Server-authenticated login, I'm prompted to "Confirm new password"
even though I'm not changing the password. Windows-authenticated
logins don't seem to do this.
Any ideas?
Thanks!
Michael Brule
Database Administrator
The Phoenix CompaniesFrom my understanding the hotfix you mentioned should of
fixed that issue.
Here's more info
http://support.microsoft.com/?id=826161
Quoting from that knowledge base article:
==============SYMPTOMS
After you install MS03-031: Cumulative Security Patch for
SQL Server, when you make changes to a standard SQL Server
login by using Enterprise Manager, you are prompted for a
password, even if you did not change the password. If you
did not change the password, you cannot successfully close
the dialog box, regardless of the entry that you use.
>--Original Message--
>Running SQL Server 2000, Service Pack 3a, Hotfix MS03-031
(8.00.818)
>on Windows 2000 Server, Service Pack 3:
>Whenever I try to add or change the attributes of an
existing SQL
>Server-authenticated login, I'm prompted to "Confirm new
password"
>even though I'm not changing the password. Windows-
authenticated
>logins don't seem to do this.
>Any ideas?
>Thanks!
>Michael Brule
>Database Administrator
>The Phoenix Companies
>.
>|||Thanks, Bob! That took care of it!
Michael Brule
Database Administrator
The Phoenix Companies