.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

Computer account as a logon in sql 2008 R2 !

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Im using SQL 2008 R2 and i opened SQL management studio , and go to security >Login , and i want to create a new logon for a computer account . so i put (Logon name : contoso\computer$ ) and then i pressed Search . But it didnt find the computer stating that i only can search for users or groups !!


So how can i allow computer account to access my sql ?


View Complete Post

More Related Resource Links

Not able to install SqlServer 2008 says Restart computer failed

While trying to install SqlServer2008 it show Restart computer as failed. I have restarted my computer and still it shows the same error. Cant proceed further. Please advice on how to proceed to install SqlServer 2008.   Thanks Ashok

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.........:(

Enabling SA account on SQL Server 2008 R2

Hi I'm setting up a SharePoint 2010 development machine and hit a snag. I installed SQL Server 2008 R2 with the default instance (devserv1\mssqlserver). That's configured for mixed mode authent and I can login using either Windows Auth or SA no worries. Note that it's just a local machine account and NOT a domain account (this is an isolated VM with no domain) I installed SharePoint 2010 on the machine. I don't recall changing any settings and during the install, it has created a new instance called devserv1\sharepoint. I can login to it using Windows Authentication, but I don't appear to have any permissions. Also, the SA user is disabled, but I can't enable it, because I get a permissions error when using my windows account to do it... One thing I noticed that is a bit weird is the version numbers of the 2 instances - the first/default instance is 10.5.0.* whereas the one created by SharePoint install is or thereabouts - i.e., it's SQL 2008 but not R2 which I don't reallty understand. Anyway, how can I enable the sa account on the sharepoint instance? Thanks.weirdbeardmt, PhD, BSc. Silly name, but lots of letters.

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/

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.

SQL SERVER 2005/2008 Proxy Account Set up

Hi All,I need to clear the logic behind Proxy account in SQL server 2005/2008.1.If i want to create a proxy account to run the xp_cmd shell system stored procidures ?2.And if i want to run the job steps what i understand here is:For:1 .above we can create a SQL/Windos Login and we can map this login to master database. it will create a user in master database, and we can aisign this user in master database xp_cmd shell extended strored procidure access from the securibles node or by running the scripts, however if this login/user dont have sysadmin access he can not run the xp_cmdshell extended stored prcidure in sql server query analyzer to achieve this task we need to create a credential using the EXEC sp_xp_cmdshell_proxy_account 'Windows LOGIN NAME','Password'.Here 'Windows LOGIN NAME' can be any windows account having least privilage(can not have syadmin privilage).For 2:To Run job steps using proxy account is where we have to use gui(off course ready scripts also)  but for that we need to create a cridential first if you are using gui:a) give name of cridentaial b) choose any windows account(haveing no sys admin access) and give the password for this windows account, make sure you are giving the correct password here.so now credentail part is done now go to proxy under sql server agentright click on proxy> new proxy> give a name to proxy, in credenti

VB.NET 2008 - How can i get system/shell icons position (Recycle Bin, My Computer etc) on Windows XP


Please, read this carefully. It is very important.

I already have the working code for all desktop icons position in VB.NET 2008, but it DOES NOT retrieve the systems icons position (like Recycle Bin, My Computer, My Documents etc), ONLY for the operating system Windows XP 32bit. This vb.net code works perfectly well and get the systems icons position, on Windows XP 64bit, Windows Vista and Windows 7.

So, the only problem that I have with this VB.NET 2008 code, is that it's NOT retrieving the system icons position, only on XP 32bit.

Can anyone help me ? I really need help, as I can't figure this out by myself.


Here is the VB.NET 2008 code:


Imports System.Runtime.InteropServices

Module mdlDesktopIcons

    Private Const STANDARD_RIGHTS_REQUIRED As Integer = &HF0000
    Private Const SECTION_QUERY As Integer = &H1S
    Private Const SECTION_MAP_WRITE As Integer = &H2S
    Private Const SECTION_MAP_READ As Integer = &H4S
    Private Const SECTION_MAP_EXECUTE As Integer = &H8S
    Private Const SECTION_EXTEND_SIZE As Integer = &H10S
    Private Const SECTI

SQL Server broken - cannot reset 'logon as ' built-in account - urgent



SQL Server Express 2008, on a standalone XP Pro fully updated, with a named instance of COMPUTERNAME\SQLEXPRESS.

As installed, the 'log on as' was set to NT\NETWORK SERVICE. Basically things worked, though I had some issues, now irrelevant. Foolishly I went into SQL Server Configuration Manager, clicked on SQL Server Services, in the right pane right-clicked on Sql Server (SQLEXPRESS) - Properties, on the logon tab - Built-in account, which showed Network Service.


From the dropdown, I selected Local Service and probably Apply, then Start, though maybe vice versa.


This stopped pretty much everything working, e.g. no access via Managment Studio etc (cannot login). Now if I attempt to select Network Service from the dropdown to put it back to what it was:

- If I click Apply I get a message box : Cannot find object or property [0x80092004]

- If I click Start there is a long wait while the progress bar ticks over, then a message box with 'The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details'


In the logs folder the log starts with informational stuff that looks to me to be pretty

SQL Express 2008 install error 84B40000 "The Windows account somain/user does not exist and cannot b


Full reported error

StdOut -2068578304: The following error occurred:
The Windows account doman\user does not exist and cannot be provisioned as a SQL system administrator
Error result: -2068578304
Result facility code: 1204
Result error code: 0

domain/user is a domain administrator and also a local administrator and is the currently logged in user.  This failure is happening as part of A Citrix XenApp 6.0 configuration which was started as an Administrator

A Google search for
"The Windows account" "does not exist and cannot be provisioned as a SQL system administrator"
Came up with absolutely nothing.

A Google search for -2068578304 failed to find anything, which did not surprise me.

-2068578304 translates into hex as 84B40000.

A Google search for 84B40000

Comes up with a fair few different textual descriptions with the same error code, which I am wading through.

Any help would be welcome.  I am also asking my friends at Citrix.


With thanks in advance.


How to add Computer account in SQL 2008R2



After installing sql 2008R2 i can't find computer account in login

give me please suggetion how to add computer account in login in SQL 2008R2.


my 64 bit computer, windows 7 OS, won't load and run microsoft visual studio 2008



i'm in school and am trying to load and run my downloaded microsoft visual studio 2008 program, and my computer won't let me sighting, incompatability with 64 bit versions of windows. please contact the vedor to see if a 64 bit compatible version is available.

please help!!!



Sharepoint Search Server Express 2008 can not index external domain fileshare with valid account


Since i have understood that sharepoint 2008 search express doesn't do any security trimming i am trying to index an external fileshare (on a non trusted domain) with it. After authenticating with the external domain account I can manually access all the files in that share i need to. Sharepoint 2008 search express somehow is unable to use the crawl rule in which i specified a different content access account (which is the external domain account).It continuously gives the error "Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content."

Exactly the same configuration works fine with sharepoint search server 2010, but that does do security trimming and because of the share being completely external my users could't see any search results.

Any suggestions?

What type of account is needed for deploying/maintaining SSAS cubes in SSAS 2008 R2


Hi All,

Can someone help in understanding what type of account is needed for deploying/maintaining SSAS cubes in SSAS 2008 R2?

Does one have to be in the local administrators group on the SSAS server? Can a domain group/user (non administrator) be assigned to any role that enables them to deploy cubes etc. If so, what Impersonation Mode will be used from within the dev studio while trying to depoly the project?

Can someone point to any documentation as well. I must not be searching right as I am not able to find an exact information.



SQL 2008 User DB logon slow - 20 second delay?


We are in the process of migrating a customer from SBS2003 + SQL to Server 2008R2 and SQL Server 2008 and having set up a test move of their main DB application (Raiser's Edge) to SQL 2008 we found the following:

If we are logged onto the client XP PC as domain admin, the logon to the DB as a User is almost instantaneous but if we are logged onto the PC as a user (who is a member of the group that has full access to the DB) then there is a delay of approx. 20 seconds while the logon is being validated. We have set up SQL and attached the DB in accordance with the instruction from Blackbaud (The developer of Raiser's Edge) and cannot understand what is causing the delay. In fact the 20 second delay occurs twice - once when the application connects to the DB in order to validate the user and then again when the user logs on.

I tried reducing the Remote Logon Delay but this had no effect on the problem.

Any help/advice would be appreciated.


Trying to create a Computer Account for a specific user?



We are coding an intranet site using .net DirectoryServices and AccountManagement to create a computer account in Active Directory with access rules allowing a specific user to add the computer to the domain. Has anyone had any success using the AccessRuleFactory method to set access rules? I'm stumped with a few aspects. So far, this is what we have...

Using AccountManagement, we can easily add the computer:

                Dim dsamComputer As New ComputerPrincipal(dsamDomainContext)
                dsamComputer.Name = UCase(txtComputerName.Text)
                dsamComputer.SamAccountName = UCase(txtComputerName.Text) + "$"
                txtDesc.Text = Trim(txtDesc.Text)
                If txtDesc.Text.Length > 0 Then dsamComputer.Description = txtDesc.Text
                dsamComputer.Enabled = True

Next we get the DirectoryEntry and ObjectSecurity for the computer. Also dim the ACE object:

                Dim deComputerDirectoryEntry As DirectoryEntry = dsamComputer.GetUnderlyingObject
                Dim adsComputerObjectSecurity As ActiveDirectorySecurity = deComputerDirectoryEntry.ObjectSecurity
                Dim adarAccessControlEntry As ActiveDirectoryAccessRule

SSRS 2008 R2 remote logon

I have just upgraded My instance from sql server 2005 to sql server 2008 r2. Upgrade completed successfully but I am now unable to connect to Reporting Services with anything except http://localhost/Reportserver, http://localhost/Reports. I cannot connect via http://<servername>/Reports from a remote workstation, or by clicking the links for web service URL and Report manager URL in the reporting services configuration manager.

SQL Server 2008 R2 Reporting Services - Can't Authenticate with local windows account


No matter What I do, I can't seem to authenticate to SSRS using a local windows account unless that account is a member of administrators. Is there some sort of special role that local users need to be a member of to authenticate properly?

When I attempt to access reporting services, am prompted with a login window asking for login as password. If is use a local admin account it works fine, if I use a local user account, it prompts me again two times and then just shows a blank page. 


  • I've tried adding the local non-admin user account to all of the SQLServer groups but no luck.
  • I've tried deleting and creating a new local user account with the same group membership as above, but no luck.
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