<div>
Hi ...<br />
<br />
what are you using Windows Authentication or SQL Server authentication?<br />
<br />
<br />
Regards,<br />
<br />
Marc<br />
<br />

</div>


Hi ...

what are you using Windows Authentication or SQL Server authentication?


Regards,

Marc



<div>
As Julianva said ... either give them sa access or add the appropiate AD Group to the SQL Server with System Admin rights.<br />
<br />
Regards,<br />
<br />
Marc<br />

</div>


As Julianva said ... either give them sa access or add the appropiate AD Group to the SQL Server with System Admin rights.

Regards,

Marc


<div>
Well, the problem is that we are trying to use analysis manager from other desktops and the message &quot;can not login&quot; appear. Looking through Experts exchange on this problem, basically noone had posted a solution that was accepted by the asker, which is why I'm asking how to disable the whole login mechanism. The computer is not in the Internet.
</div>


Well, the problem is that we are trying to use analysis manager from other desktops and the message "can not login" appear. Looking through Experts exchange on this problem, basically noone had posted a solution that was accepted by the asker, which is why I'm asking how to disable the whole login mechanism. The computer is not in the Internet.

<div>
Just give them the System Administrator role and get them to sign an agreement or something. &nbsp;Either that or promise them your first-born ...
</div>


Just give them the System Administrator role and get them to sign an agreement or something.  Either that or promise them your first-born ...

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I would like to turn off all security and granting all users everything in my SQL Server 2000. How can this be done? <br />
<br />
best regards,<br />
<br />
henrik
</div>
</div>


Hi,

I would like to turn off all security and granting all users everything in my SQL Server 2000. How can this be done? 

best regards,

henrik

Turn off security completely

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.