.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

what permissions required fro Lnked Server

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Hi All,

Need some help regarding Linked Server.

Environment:SQL Server 2005 , sp2



Goal: I want to check the properties of my Linked server.




I have db machine and two instance are running SQL01 and SQL02.

From SQL01, i have a created a Linked server to SQL02 using sysadmin accnt

 /* script */

/****** Object: LinkedServer [machine\SQL02] ******/

EXEC master.dbo.sp_addlinkedserver

@server = N'machine\SQL02',

@srvproduct=N'SQL Server'

/* For security reasons the linked server remote logins password is changed with */

EXEC master.dbo.sp_addlinkedsrvlogin







EXEC master.dbo.sp_serveroption


@optname=N'collation compatible',



EXEC master.dbo.sp_serveroption


@optname=N'data access',



EXEC master.dbo.sp_serveroption





EXEC master.dbo.sp_serveroption



View Complete Post

More Related Resource Links

Required Permissions for SQL Server 2005 DB and Impersonation

I have an Intranet ASP.NET WebForm application that uses Integrated Windows authenication and Impersonation (required becuase triggers are used to create audit logs) to connect to a SQL Server 2005 DB on the same box (no double hop issues). Normal users get their DB permissions via the <Domain\Domain Users AD group, which has a SQL Server login and a user created for the DB.  Everything works fine when I explictly grant the associated DB user CONTROL permissions on the DB.

However, after doing more research on the actual permissions granted via CONTROL, this seems to be way too much access.  The best decription of the CONTROL permission I found was at http://www.mssqltips.com/tip.asp?tip=1718, which states, "This grants the equivalent to ownership over the database. The db_owner fixed database role has this permission implicitly."  However, every other DB permission combination I've tried without granting CONTROL always fails to connect to the DB.  Impersonation is working, the correct accessing Domain/User is referenced in the error message.  The approriate User in the DB is in the db_datareader and db_datawriter roles and when I explictly grant them every single permission on the DB except CONTROl they fail with a "

Database permissions required for Smo.Server.NetName


Hi all,

who can explain why when i use this code:

  ServerConnection conn = ServerConnection(serverName);

  var server = new Server(conn);
  string testInstance = server.NetName

next exception is thrown:

"Caught exception in SQL Product Configuration wizard. Exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.'"

user can connect using SQL management studio.

It will only work if i give user "SysAdmin" permission. Obviously it is too high of a permission to read server and db properties

Any help is much appreciated,


sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


Required permissions cannot be acquired when host asp.net 3.5 application in godaddy


I got the following error when click print report button.

Application : asp.net 3.5

Crystal report : 10.5

Host: godaddy

Please help me.


Required permissions cannot be acquired.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

sql server agent roles and permissions

hi does any one have idea of what kind of roles are needed for creating a SQL server agent job and why those roles are needed?? Please Reply ASAP Because i don't have sysadmin rights.........so that other developers can use the same login for creating the jobs Thanks in advance

How to check effective permissions for a user or group for a SQL server object or whole server?

Guys, How do I see effective permissions for a user or group for a SQL server object or whole server? For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through membership in other groups) Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins… Anyway, what is the right way to see effective permissions for a user or group? Sorry for asking such a simple question, I’ve searched but found nothing relevant.

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

Server-side validation on an Entity Framework required field (property) does not work!

Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    

Server ERROR: An error occurred during the parsing of a resource required to service this request.

I have created one asp.net 2.0 application and created a setup project. I run this setup in my local machine, the application run fine, but i uploaded into online server I met the following parser error.How to solve this error? Kindly help me. Very urgent.. Kamal....

why runat="server" attribute is required for ajaxcontroltoolkit controls?

the doubts i have may looks silly,i started my carrier in dotnet recently,1)we are calling them as client side controls,then what is the need for runat server attribute?2)<asp:Button ID="Button1" runat="server" Text="Button" /> <asp:ConfirmButtonExtender ID="Button1_ConfirmButtonExtender" runat="server"              ConfirmText="Really?" Enabled="True" TargetControlID="Button1">  </asp:ConfirmButtonExtender>when i execute the above code,i observed that in status bar message as "connecting to localhost",if they are client side controls what  is the need of going to local server,why it is happening?Thanks in advance.

SQL Agent - service account permissions - SQL Server 2008

Hi @ all   I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine. I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE 42000 Error(7314)). The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions? Which settings are needed? Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'} Powershell Console: works                                     SQL Agent Job: access denied I tried some solutions with user rights, group policies and security permissions but nothing works. like: Configuration -Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/

Health Analyzer reports "Product / patch installation or server upgrade required." and I can't seem

The text of the error is: On server SHAREPOINTSERVER, once all required products and/or patches are installed, perform an upgrade by either running PSConfigUI.exe or by executing the command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures". If a former upgrade attempt has failed, you may need to resolve upgrade specific issues before attempting upgrade again. Refer to the upgrade status page (http://sharepointserver:XXXX/_admin/UpgradeStatus.aspx) for information about current and prior upgrade attempts, and to determine issues that may be preventing upgrade from succeeding. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=142700". So I went to the server in question and ran the command line quoted in the error message and then I get this error back: Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1 4\LOGS\PSCDiagnostics_....log and the application event log. So fine, I look into the event log and get this: Failed to initiate the upgrade sequence. An exception of type System.IO.IOException was thrown. Additional exception information: Access to the path 'C:\ProgramData\Microsoft\SharePoi

Product / Patch installation or server upgrade required in Health Reporting area

Via PSCDiag Log I get ERR Task upgrade has failed with an unknown exception ERR Exeception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of Microsoft.SharePoint.Upgrade.SPIiswebsSitewssSequence Failed--->System.DirectoryServices.DirectoryServicesCOMException (0x80070003): The system cannot find the path specified.

SQL Server 2005 Express Edition - GUI to set permissions on stored procedures

Hi there, I have SQL Serve 2005 Express Edition (Build 2600: Service Pack 3) installed; I also have the Management Console installed. My problem is that I cannot set execute permission, or any other type of permissions on my stored procedures through the GUI, as the Property menu item is missing from the right click menu. I read somewhere that this happens when you have SP1, but as I stated above I have got SP3 installed... Any help?   Regards, D.

Setup of SQL Server 2008: Restart required but I have restarted

Hello,I have tried to install SQL Server 2008. I cannot install, because I get the errormessage the prerequistite "Restart the computer is required".But every time I restart my computer and try to execute the setup of SQL Server 2008, I get the same message, I have to restart the computer.I cannot install the SQL Server 2008. What can I do?Thanks

Permissions using Server Management Studio

I'm using sql 2008 and I'm trying to set NT permissions to tables in Server Management Studio. I have a user group that needs read only and individual groups that need modify. Everyone is part of the user group and if your not part of an individual group they only have read only. The problem I'm having is if you're part of an individual group you have modify access to the entire database. Example, I have an tblArt. In the permissions for tblArt I have added the Art Group and given them permission to Insert, Select and Update. Not only does this give them modify access to tblArt but modify access to all the other tables even though the Art Group is only part of tblArt. What do I need to do to limit the group permissions to the individual tables? Thanks, Paul

MSDTC - TransactionOption "Required" works from my XP Workstation but not from our 2008 Server

I have a SSIS package (2008) that has a sequence container with TransactionOption Required.  This is needed to ensure that multiple tasks commit or fail together.  It also has a custom transformation that establishes (acquires) connection objects. This package works great when run from my local XP workstation.  I can see the distributed transaction starting and committing in the SSIS output. The problem is that when I roll this package out to the server, it fails to acquire the connection, throwing an error at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectinoMAnager100.AcquireConnection(Object pTransaction).  I've verified that the security settings of MSDTC on this server are consistent....they are definitely set to allow inbound and outbound. Are there any issues with MSDTC on Windows Server 2008?  Is it possible that I'm getting an issue because my workstation is 32 bit but the server is 64 bit? Thanks -Mark
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend