Viewing 15 posts - 541 through 555 (of 620 total)
I'm being told that the 'Local Security Policies' has to be set so the account is in the 'Login as service' group, though not sure if this does or can...
November 4, 2008 at 10:07 am
I work in a very heavily security concious environment and at one point found that although services.msc had said the account had been given logon-as-service rights did not actually make...
November 4, 2008 at 10:03 am
Is this your only SQL server or a new server to your environment. If so why arent you using domain account to run the services? I always use one account...
November 4, 2008 at 9:53 am
You would need to ensure the server collation is set to what you would expect and rebuild your master database (and any others).
http://support.microsoft.com/kb/325335
Read the section on rebuilding master. It...
November 3, 2008 at 7:15 am
liteswitch (10/30/2008)
quote]
Also, good practive is to run the SQL services as a domain account.
Makes it easier...
October 31, 2008 at 3:08 am
Like I have siad in recent posts, you need to have two instances of RS.
October 31, 2008 at 3:05 am
Is it direct attached or NAS/Shared Disk?
Unless you can set disk shares up you cannot run a clustered solution. It is possible with vmware.
There must be shared disk for quorum,...
October 30, 2008 at 6:56 am
madhu.arda (10/29/2008)
Could you plz explain me why this approach is better?any performance gain?
1. All data processing kept on an already active SQL server (no need to install, configure and maintaine...
October 29, 2008 at 11:25 am
madhu.arda (10/29/2008)
and other report server n tempdb on Production server 2(Native mode...
October 29, 2008 at 11:03 am
ThomasLL (10/29/2008)
You questions...
October 29, 2008 at 8:48 am
Ok, so think I understand a bit more now what your trying to achieve. Below is a link to a web cast which will explain basic SQL clustering setup and...
October 29, 2008 at 7:05 am
Schadenfreude-Mei (10/29/2008)
I will try and track down a best practice doc for you.
Ok so if you have a read of: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx it explains some key considerations. Figure 4...
October 29, 2008 at 4:43 am
binu.ma (10/28/2008)
I lgged into the server with admin id then the query is working .But when i tried with a user id in ssms it is not working
So...
October 29, 2008 at 3:17 am
TRACEY (10/28/2008)
The 4th box you configure the IIS and where to run the reports from but the database configuration is on the MAIN SQL box.Well that my understanding.
Thats correct. Though...
October 29, 2008 at 3:08 am
I may have misunderstood at some point so apologise if this is wayyyyyy off track.
If you want to have the 4th server as the RS server, that is actually...
October 28, 2008 at 10:32 am
Viewing 15 posts - 541 through 555 (of 620 total)