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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

"NT AUTHORITY\SYSTEM" access - to which databases/actions and why?

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
 
Subquestion from the question Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005 discussing removal of NT AUTHORITY\System from SysAdmin group in MS SQL Server 2005. Is my SQL Server 2008 R2 "NT AUTHORITY\SYSTEM" login is mapped (right click on --> Properties --> User Mapping) to: user dbo for db AdvenureWorks user "NT AUTHORITY\SYSTEM" for databases - maser - msdb - ReportServer - ReportServerTempDB But no mapping exists for databases tempdb model any manually new created database AdvenureWorks2008 AdvenureWorks2008R2 AdvenureWorksDW AdvenureWorksDW2008 AdvenureWorks2008R2 AdvenureWorksLT AdvenureWorksLT2008 AdvenureWorksLT2008R2 Why such mapping was created for AdvenureWorks but not all other sample databases and newly created databases? Why does ReportServerTempDB requires mapping but not tempdb?


View Complete Post


More Related Resource Links

Creating Web Databases with Access 2010 and Access Services (Visual How To)

  
Watch the video and explore code as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Sample: Creating Web Databases with Access 2010 and Access Services

  
Explore the code in this visual how-to article as you learn how to create an Access 2010 Web database and publish it to Access Services on SharePoint Server 2010.

Video: Creating Web Databases with Access 2010 and Access Services

  
Create an Access 2010 Web database and publish it to SharePoint Server 2010 by using Access Services. (Length: 7:45)

Video: The Access Show: Managing Access Databases with SharePoint

  
Steve Greenberg recently gave a great talk at the SharePoint Developers Conference about how Access 2010 and Access Services enable organizations to provide better oversight of Access development. Steve and Clint walk you through the key points of this hit session. (Length: 42:57)

Video: The Access Show: Demo of Microsoft Access 2010 Services and Web Databases

  
Ryan McMinn and Clint Covington have a big announcement for us - Access Services is new functionality as part of SharePoint 2010 that allows users to create databases with forms and reports that run in the browser. (Length: 24:00)

Reading AND Writing Access 2 databases with SSIS

  

I went for a job interview this morning, and one of the scenarios that the IT manager (a former programmer) told me about was the following .... If anyone could give me any pointers that I can email him pointers to tomorrow (Wednesday 22nd) it may just help tip his decision in my direction. So there's beer in it if you answer a relevent answer, and I get the job.

Old systems using Access 2 databases. These systems are not due to be updated any time soon.

New systems need access to that data, so each night he exports information using SSIS. However, he needs to also write data back, and more often than just overnight.

However, when he connects to the database, using ODBC connections I think, he says that the app (SSIS) opens the tables / database exclusively, even if he selects the option NOT to open it exclusively.

Any ideas, suggestions or comments ?


Reading AND Writing Access 2 databases with SSIS

  

I went for a job interview this morning, and one of the scenarios that the IT manager (a former programmer) told me about was the following .... If anyone could give me any pointers that I can email him pointers to tomorrow (Wednesday 22nd) it may just help tip his decision in my direction. So there's beer in it if you answer a relevent answer, and I get the job.

Old systems using Access 2 databases. These systems are not due to be updated any time soon.

New systems need access to that data, so each night he exports information using SSIS. However, he needs to also write data back, and more often than just overnight.

However, when he connects to the database, using ODBC connections I think, he says that the app (SSIS) opens the tables / database exclusively, even if he selects the option NOT to open it exclusively.

Any ideas, suggestions or comments ?


Synchronizing two tables on two databases with a dataset - MS Access

  

Hey,

I have a C# problem I need to synchronize two MS Access tables from two different databases(two databases over a network) which is quite similar, I thought of using two different OleDbConnections and two DataAdapters to fill a Single DataSet and then manipulate the data in the DataSet, I think the source table (database with the primary data) should be loaded first (into the DataSet) then the secondary table from the remote database should subtract the existing records in the DataSet to get the difference then the difference should be Appended to the remote table, but I don't know how to remove the same records from the DataSet and to send the remaining records to the secondary database.

Here is some code I already have, but I don't know how to get this to work:

        private void btn_update_Click(object sender, EventArgs e)
        {
            UpdateExperiment();
        }

        private void UpdateExperiment()
        {
            OleDbConnection connSource = new OleDbConnection();
            OleDbConnection connDest = new OleDbConnection();
            OleDbDataAdapter daSource = new OleDbDataAdapter();
            OleDbDataAdapter daDest = new OleDbDataAdapter();
            OleDbCommand commSource = new OleDbCommand();
            OleDbCommand commDest = new OleDbCommand();
            DataSet ds

Why does Windows Sharepoint Services Search want access to non-sharepoint databases.

  

I have installed a new instance of Sharepoint 2007 and am in the process of configuring all the farm services.  At the moment the farm consists of a sharepoint box and a separate sql server.  Here is the catch.  There are already some non-sharepoint databases on the sharepoint server.  The account under which Central Administration runs has dbcreator and securityadmin privileges in the database.  The Sharepoint_Config and SharePoint_AdminContent databases were created without any issues.

When I try to start the Windows Services Search, I get an "Unknown Error."  Looking in the event viewer gives the following error "The server principal "MyServerPrincipal" is not able to access the database "MyDatabase" under the current security context."  This is true, MyServerPrincipal does not have privileges to access MyDatabase, but why should it.  MyDatabase has nothing to do with sharepoint.  

In an attempt to get past this issue, I gave MyServerPrincipal public access to MyDatabase, but that resulted in an additional error saying that it lacked INSERT privileges.  This is really worriesome.  Does anyone know why Sharepoint Search configuration would try to access the non-Sharepoint database?

 

Thanks a lot.


Restricting access to System Databases for Windows User

  

Hi All,

     I was asked to provide access to windows user for only User databases in server. I added this user to db_reader role in all databases after creating login in Server. But here is the problem, this user can able to access System databases even I have n't assign any role for this login in system databases. Your response will be helpful  to fix this . Please let me know if I am missing here to understand it.

 

Thanks

Pradeep


Pradeep

Access web database - what is the best way to add workflows to the data in these databases?

  

Hi,

I'm experimenting with Access Web Databases with SharePoint 2010.

Can anyone tell me how you typically use workflows with these databases?

Do you just stick to data macros or do you export the information to a static list and then add the workflow to the list, or are any of you working with it in other ways?

I'm looking for recommendations.

Any advice is appreciated.

Thanks.

 

Steve


Mixing Databases - SQLServer and MS Access ?

  

In a current project I am considering using SQLServer 2005 Express database and also Access database and this will be deployed, probably to a Database only server.

 

But are there any drawbacks to doing this (using both SQL Server and Access databases)?

 


"Actions / Open With Access" Always Fails with Access 2007.

  

Hello,

I am trying to open a List with the Actions / Link with Access functionality.  Every time I try, it simply opens up the MS Access interface as though I had gone through the Start button and selected MS Access.  However, it shows the name of the database, in the right side panel, that was in the "Open with Microsoft Access" dialog box that opens after you select Link with Access.  If you click on the database name, I get an error box saying that the database doesn't exist.

The caveat here is that it used to work.  I have a database that I have been using to run reports and custom queries on a List.  Now, if I click on the Linked Table, I get the error message "You do not have the necessary permissions to use the '[object]' object.  Have your sys admin or the person who created the object establish teh appropriate permissions for you." 

I am the one who created the list and I have admin rights to this area of Sharepoint.

I have also tried to perform the same tasks to another Sharepoint site where I have full Admin rights over the entire site.  Same problem.

The version of Sharepoint is 12.0.0.6539.

I also have MS Office 2003, Project and Visio, installed on my PC.

Any ideas or thoughts on what the problem may be?  Our Sharepoint techs and our

Access User Profile and Databases with WebParts?

  

Hello, my name is Mauricio Dominguez and I'm new to MOSS developement and I'm having some trouble adapting and finding my ground in its paradigme.

 

I need to have a Sharepoint Site with a Form that creates an event in a Database and then it gets indexed with Lucene.net. Then I also need a page from witch a user can query these events and it filters them acording to the "Ask me about" section of their profile.

My questions are:

1. How do I get my Form to create the event on the DB?

2. How can I get the profile information from the current user?

For the last part I tried following this blog post but it throws an error in the line 

 

TermStore store = session.TermStores["Managed Metadata Service"];

 

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

  
The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Store and Display Images from MS Access Database Using C#

  
There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

ASP.Net Upload Image to MS Access Database

  
As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table "tblImg" with the following fields:
Categories: 
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