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

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

SQL Server Permissions, restoration after computer crash

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :


A week ago my system's hard drive suffered a rather tedious hard drive failure, which I was able to resolve but has created some other issues after the fact.  The Hard drive developed a fault, and in order to restore my system, I was forced to use BartPE as a live cd, and transfer the data from the "defective" drive to the new drive.  for some reason the defect caused a fault which prevented most Imaging software from being able to image the drive over so I was forced to use XCOPY.

Yes, this actually worked, and as I am writing this post, it is my exact same system that I used last week, with the minor problem of having to reactivate windows when I finally was finished.

However, there apparently is a minor issue with the NTFS security descriptors.  I am not surprised, since I was using the BartPE loaded windows system to transfer the files I expected a little "renaming" of security descriptors to occur in the process.  But when faced with the prospect of rebuilding the entire system from scratch, this was a reasonable cost.  However, this tragically confused Sql Server. 

As we know SQL Server Installs Several Groups into the User And Groups of the system:

  • SQLServer2005SQLBrowserUser$COMPUTERNAME
  • SQLServerMSSQLServerAD

    View Complete Post

More Related Resource Links

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.

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

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/

Connect SQL Server 2005 to Ms Access on another computer

I'm trying to create a "Linked Server" on my SQL Server 2005.  This linked server is a reference to an Access File on a remote computer.  I've set up all the permissions and shared resources.  I've created an ODBC DSN to connect to the database.  If i open the DSN in excel, i can retrieve data.  If I open a linked server connected to the DB I get the following error when i try to run a query against it.   ------------------ OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "LS_Specialty" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'.  It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LS_Specialty". ---------------------   Why does this DSN work in Excel and Access, but not in SQL

Linked Server to DB2 from SQL 2005 IA64BIT computer

Has anyone created a linked server to DB2 on AS/400 from SQL Server 2005 IA64 BIT? We were hoping to use the new Microsoft OLEDB Provider for DB2...The problem is the driver looks like it will only work on x64 computers."The single setup program will install the provider and tools on both x86 and x64 computers" We were able to install the driver on the IA64 computer and were able to successfully create a data source from the Data Access Tool. Oddly enough when we attempted to create a linked server in SSMS we received an error, we also noticed that the DB2OLEDB provider is not listed in SSMS. This is becoming a real problem so any ideas on how we can get this driver to work or suggestions on an alternative would be greatly appreciated.   thx.art.  

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.

Accessing the command prompt of the server computer in c#

Hi ,I'm developing a web application in asp.net using  C# and need to access the command prompt of the server computer.After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:\Test".The absolute path of the server is "\\MyServer"Any help to achieve this ( or any other alternative suggestions) would be greatly appreciated....ThanksPS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.

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

Getting Sql Server Management Studio 2008 installed on local computer

Hello, I have been trying to figure out this problem for a while now so hopefully someone can help me out - I would really appreciate it! Right now I have SQl Server Management Studio2005 installed on my computer for a SQL sever that we have. We recently got a 2008 sql server and if I remotely access the server, I can see that SQL Management Studio 2008 has been isntalled on the new server. I need to build new databases but need SQL Management Studio 2008 on my computer and I have no idea how to get it. I have a "Microsoft SQl Server 2008 R2" folder on my computer, and I have already tried clicking on "Configuration Tools" and then "SQL Server Installation center" and it isntalls a bunch of things, but none of them are "SQL Server Management Studio 2008."  I also found a link on a Microsoft website that says it's SQL Server Management studio 2008 R2 but it was just the same bunch of programs I already downloaded. How do I install Sql Server Managment Studio 2008 on my computer?! Thanks in advance for any help you can provide.

Failure to Install SQL Server 2005 on XP Computer with Service Pack 3

I have tried multiple times to Install Business Contact Manager (Office Small Business 2007). Each time the installation fails because it can not complete installation of SQL Servier 2005. Here's the log with the failed component in BOLD: Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time            : Sat Sep 11 16:11:50 2010   Machine         : REF1 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0009_REF1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : REF1 Product         : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bo

Sql Server login permissions

what permissions should we grant to the  sql login   for entity framework?

Installing multiple instances of SQL Server R2 creates permissions issues - first instance won't st

After installing two named instances of SQL Server 2008 R2 DataCenter edition (R2D2 and C3P0) I found the first instance would no longer start.  The errorlog showed the reason to be an invalid path. 2010-09-14 18:15:39.12 Server      Error: 17113, Severity: 16, State: 1. 2010-09-14 18:15:39.12 Server      Error 3(The system cannot find the path specified.) occurred while opening file 'C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary. Finding the files in the proper location I check the ACLs and found the Local Group created for the second instance on the ACL for the first instance.  That is to say for instance R2D2 I found MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0 instead of the MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$R2D2 that was originally there. C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA>icacls master.mdf master.mdf NT AUTHORITY\SYSTEM:(F)            BUILTIN\Administrators:(F)            MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0:(F) It seems that creating the second instance causes this problem.  I have been u

SQL Server 2K5 - INSERT INTO Script crash with no specific error

Hi, I need to run a sql statement that insert data into a table. I have about 14000 line to insert. In SQL Management studio, I did a script like that : INSERT INTO [TableName] (Field1,fireld2,field3,...) Select 'Values1','Values2','Value3',.... UNION ALL Select 'Values1','Values2','Value3',.... UNION ALL Select 'Values1','Values2','Value3',.... UNION ALL . . . When I try to insert around 1000 line and more, the script crash with no specific error code or message. I only see the message in the status bar saying, the script ended with error. Is there a way to avoid having that error ? ThanksRichard Martin Web Developer / BI Developer

Problems to connect to sharepoint server from another computer



recently i developed a webservice in Visual Studio 2008 that connects to Microsoft office sharepoint server 2007, i've already have both the WS and the SharePoint server deployed in the same IIS, and when i create a client to that webservice that its on the same machine that the iis, it works perfectly.


but the problem comes when i run this client from a different instance or machine, i'm not able to connect to the SharePoint server, i'm wondering if there is a configuration that i'm missing.


this is my web.config from my webservice:


<?xml version="1.0"?>


    Note: As an alternative to hand editing this file you can use the 

    web admin tool to configure settings for your application. Use

    the Website->Asp.Net Configuration option in Visual Studio.

    A full list of settings and comments can be found in 

    machine.config.comments usually located in 





        <sectionGroup name="system.we

SQL Server 2005 permissions error. The EXECUTE permission was denied on the object "xp_instance_reg


I have a SQL Server host running SQL 2005 9.00.4294 x86 Standard Edition running on Windows build 2195 SP4.  My client workstation is running only SQL Server 2005 workstaion components.   When a user of the host who has db_owner access attempts to view the properties of a table by right-clicking the table and then clicking Properties, the following error mesage is displayed:  

"The EXECUTE permission was denied on the object "xp_instance_regread", database 'mssqlsystemresource', schema 'sys'

For security purposes, I do not want to grant execute on xp_instance_regread to these users. Does anyone know of a workaround that will allow members of db_owner to access table properties using the abovementioned method and does not require execute access to be granted?




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