.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

Unable to enable SA account

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
SQL 2008 installed on a @008 Server w/SP2 I Can login with Windows Builtin\Administrator. The server is in mixed mode. I try to enable the SA account and it states that I don't have permission. I have used the runas cmd, tried alter login. no success I do not have permission to add a DB or another user account. Is there a grant script that needs to be run on the master DB?

View Complete Post

More Related Resource Links

WCF Service Unable to Access Personal Certificate Store Unless Service Account is Logged In

I created a WCF service that has a method which makes a call to a SOAP web service over the internet. In order to make a call to the SOAP web service, it requires that an X.509 certificate be sent with the HttpWebRequest. The X.509 certificates are loaded in the Personal and Trusted Certificate store of the account which the service is running under. When the service account is logged into the server, everything works just fine. However, when the service account is not physically logged onto the server, it has problems loading up the X.509 certificate and fails authentication when trying to make the HttpWebRequest. I am new to WCF services so I don't even know where to start looking. Can anyone please help? Thanks in advance.

Unable to change the Service account??

Followed this guide: http://support.microsoft.com/kb/832770 I have setup my account SPadmin to have access to my SQL DB i went into IIS and attempted to change it there for my Default sharepoint site in the applications pool page > Properties>Identity Nada, i changed it his apply reset IIS and back to my old account(very frustrating) so further reading showed attempting to change it via Central administration.   Went there and chose Operations>Service accounts chose my webservice,Application pool and configurable and setup my SPadmin, reset IIS and still no change.   Thoughts? i feel like there is  some stupid step i'm missing because it will not change regardless.   Thanks Steve K

Unable to create company account in ax 09

Hi All, I am using ax 09 sp1 with IND Localization standard(Base) package. when i tried to create an company from administrator/Company account it create the company.but when  again i reopen the same form company account  doesnt exist their.after that i checked in SQL server record is their but its not showing in AX(front End). i tired with different SQL server also but same issue persist. kindly suggest me the solution  or cause behind this. I am looking forward for response asap.

Unable to enable a database for CDC


Issue - When attampting to execute sys.sp_cdc_enable_db in our test environment, I am receiving the error listed below. The databaseis owned by 'sa'; I have executed sp_changedbowner 'sa', 'dbo' to force its setting, and also detached and re-attached the database, to no avail. It works in our development and staging environments, but in this environment it fails.

Environment   == SQL Version Label                                            == Result

Development  == 10.0.2760.0 SQL Server SP1 CU6 plus hotfixes? == Works

Testing           ==  10.0.2734.0 SQL Server SP1 CU4                    == FAILS

Staging          == 10.0.2531.0 SQL Server SP1 (base)                  ==  Works

Command that is failing - exec sys.sp_cdc_enable_db

Errors that i get.

Msg 3930, Level 16, State 1, Procedure sp_cdc_enable_db_internal, L

Accordion : Unable to enable accordion panes.


In the content page, I have an ajax accordion pane with couple of panes.
Within each of those panes there is 1 user control.

Initially all the panes except the first one (AccordionPaneMain) is enabled.

The first pane user control  contains a  form view . In formview itemcommand
I am doing some processing and then was trying to enable rest of the panes by calling
the function showPanes in the main page by using invoker method.

My problem is, the method (showPanes) is getting executed but the panes are not enabled.

I would appreciate any help in getting the panes enabled somehow.

Sections of code below

protected void Page_Load(object sender, EventArgs e)
public void hidePanes()

public void showPanes(string dummy)
    AccordionPaneAddress.Enabled = true;

<asp:Accordion ID="AccordionOnlineApplication" runat="server" 
        HeaderCssClass="accordionHeader" ContentCssClass="accordionContent" 
        Font-Names="Verdana" Font-Size="10"  
        FramesPerSecond="100" FadeTransitions="true" 

Unable to Register Managed Account

Error occuring while registering a new Managed Account

The given key was not present in the dictionary.

unable to connect to sqlserver while creating my account using VS2010 proffessional in WIN 7 home pr



I am getting  an error while  debug my application that unable to connect SQL server......The message is...


 at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
   at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
   at System.Web.Security.Roles.RoleExists(String roleName)
   at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line 51
   at CreateUser(DomainService , Object[] )
   at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
   at System.

Unable to Enable Enterprise Features


I have a new SharePoint 2010 server that I am setting up. I installed it using the Standard Edition license key and I now need to enable some enterprise features. I have a valid Enterprise key and when I initially did the upgrade, it errored out. Now when I try to restart it, it tells me:

"An existing request to enable the Enterprise feature is in progress. To check the status of this request, go to the Timer Job Status page in Central Administration Operations and check the status of the SharePoint Server Enterprise Features Upgrade Job."

I have checked the Timer Job and it isn't listed as running or completed for that matter. I have stopped and restarted the timer service and tried again with no luck, and also rebooted the server and tried again, also with no lucik.

Can anyone help me figure out how to clear this message so that I can try this process again? I am getting desperate here.

Thanks for any help.

Enable Server Proxy Account


In some of our Machines we are not installing the Management Studio. In a machine where Management Studio is not there how to do Enable Server Proxy Account.

Or is there any way to Invoke Server properties window through a Exe / command prompt.


Best Regards,


Unable to add users into sharepoint if i am Using emails as account name in Active Directory.

I am using moss 2007 version and Active directory version 6.0.. . my AD domain is siamint so if i add a user as vikas. it gets added in AD with logon name as vikas@siamint.com now if i add a user sahil@yahoo.com into ad. it gets added as sahil@yahoo.com@siamint. now when i try to add user from peoples and groups,site settings in a sharepoint site; i gets user siamint\sahil in people picker. rather it should be siamint\sahil@yahoo.com. it means the name is truncated from @. Is this a sharepoint error or what. Ultimately i think it means we cannot add users with @ in their usernames.

How Do I Enable Inline GridView Editing?

Now that you have created a site with Edit and Details views, how do you enable inline editing in a GridView control? This video shows you how, and also touches on routing.

Gridview Enable Selection Problem



I have a gridview with Enable selection and Enable Paging equals to TRUE.

I also set the PageSize of my gridview to 4 so that I only displays 4 rows per page.

The problem is when I click the pager in the bottom of my gridview, my gridview is disappearing and no records appear.

Here is code behind of my gridview:

If e.Row.RowType = DataControlRowType.DataRow Then
                e.Row.Attributes("style") = "cursor:pointer"

                e.Row.Cells(2).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(3).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(4).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(5).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(6).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))

Textbox in ItemTemplate inside Gridview, unable to get the value


Hi. I have a itemtemplate inside a gridview.

<asp:TemplateField HeaderText="Enter OTP">
                            <asp:Label ID="Label2" runat="server"
                                style="font-family: Arial, Helvetica, sans-serif; font-size: x-small"
                                Text="PIN Num:"></asp:Label>
                            &nbsp;<asp:TextBox ID="txtPIN" runat="server" Height="21px" Width="100px"></asp:TextBox>

SqlServer - Windows Account to install Application from Gallery


Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application

I selected umbraco cms and got this wizard:

I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.

I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.

My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?

Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.

Wrong Account being used to access files - Help - No Impersonation


I run a simple .aspx website on a Windows Server 2008 machine.

There is NO impersonation, and System.Security.Principal.WindowsIdentity.GetCurrent().Name returns NT AUTHORITY\NETWORK SERVICE, which it the account which the application pool runs. In my web.config, I have <authentication mode="Forms">.


I tried to test the security of the application and server by removing file permissions to the .aspx files. I was greatly worried when the website continued to run without problem (it should not have been able to read the .aspx files).

By turning on file level auditing, I discovered that the .aspx files were being read by the machine$ account (if the machine is called Serv1, then the files would be read by the Serv1$ account, which seems to have access to all files on the local machine).


Is this a security breach or is this behaviour by design ?

Please can somebody assist, as I am worried.

ASP.Net account deleted. How to create it again?


 Hi I have created an intranet application using ASP.Net/IIS.

I normally need to web share the folder and allow full permission to ASP.Net user account.

However, I carelessly deleted this account. How to create it again ?

Pls help.... thanks.


Unable to make connection to database?


Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents. 

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
              SelectCommand = "SELECT * FROM Resident "
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