.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

How to enable Administrator login in SQL Server 2008?

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

Hi All,

In accident, I set the sharepoint/administrator login to disable, so now I having problem in connection to my database, 

how can I enable the login for administrator?

is SQL Server 2008 got other default login (administrator) so that I can login and change administrator login?

thank you in advanced.

View Complete Post

More Related Resource Links

How to setup windows server 2008 to enable socket communication?

I wrote a simple socket program, which listens to the 82 port, then receives and sends data through it. I tested the program on my local machine and it works fine, but after I published the program onto my windows server 2008, it does not work anymore. I guess it should be the firewall causing the problem, so I added rules to allow 82 port for both in and out bound, and I also add my application to the allowed program list for passing firewall, but still doesn't work, how could I solve it?   The windows server 2008 machine has a public network IP address, while my workstation is in a local network without public IP address, I connect to server 2008 through a router which has a public IP address. Is that the problem?   thanks! Regards! directfriends.net

Login failed for WINDOWS Administrator login. (Microsoft SQL Server, Error: 18456)

Hi All, I am using SQL server 2008. While adding SQL user i unknowingly deleted the SQL authentication user from SQL server. Now the problem is i can not login with Windows Authentication neither i can login as "sa" user as this user is disabled. Please suggest me how to get in to SQL server management studio. Database is up and running but i can not access the database any more after doing this blunder. Please suggest me how to recover SQL instance, Thank you.

Can not login to SQL Server 2008 R2 Express

I installed Visual Studio Web Developer 2010 express edition in a 64 bit windows 7 version. While installing applications, it showed error like cannot login using username sa which I ignored and continued installation. After installation is over, I tried to login SQL Server Management Studio and both SQL server authentication and Windows authentication failed. Can you please let me know 1. What is the default user name of SQL server express? 2. I also tried to select the configue option and there it is displaying Install SQL server 2008 R2. But I am quite sure I installed it.   Please help since I am very new to windows and dot net. I was basically a LAMP guy and thought to start learning dot net and windows technologies. Regards Anirban

Installing SharePoint 2010 with SQL Server 2008 - SQL Exception - Login Failed

Hello I've been trying to install SharePoint 2010 with SQL Server 2008 in my Windows Server 2008 R2 box. I've got the same error all the times. System Specifications Windows Server 2008 R2 SQL Server 2008 with SP1 SharePoint 2010 Enterprise 6GB RAM, 320GB HDD Installation Steps I followed Installed Windows Server 2008 R2 and joined it to our domain Logged in as domain administrator Installed SQL Server 2008 Selected the Local Service account for all the SQL Server 2008 services during installation Selected Mixed mode authentication Selected 'Add Current User' in all the other installation screens Installed SQL Server 2008 SP1 Installed SharePoint 2010 Selected Farm option Selected Complete Installation Tried to run the configuration wizard and got sqlexception error - login failed But i checked that the current user (domain admin) is having all the permissions. Also added the domain admin as Security Admin and DB Creator in SQL Server instance. Any ideas?  Regards NLV Visit SharePoint User group - India

Can't enable filestream on SQL Server 2008 Express 64bit under Win 7(64 bit WOW)

I have a newbie question.  I am running Win7(64 bit WOW). I installed SQL Server 2008 Express R2 (64 bit), but when I go to enable filestream, it reports that my edition of SQL Server does not support filestream.  I thought that the 64 bit edition would.  It says to install SQL Server 2008 64 bit.  Am I correct that that is not a free download?  Do I have any other options?

what the configuartion to Enable Remote Connection on SQL Server 2008


I have  server and I install windows server2003 With sqlserver 2008

and I have Application with vb.net2008  and i want to make connection between the application and sql server 2008

wht Is steps to make them>>>>??

Enable Full Text Index in VWD 2008 / SQL Server Express 2008


 Hi, I am using VWD 2008 Express and SQL Server 2008 Express. I want to enable full text index in some of my table. How do I do that? I only have  SQL Server Management Studio Express 2008. As far as I know, I cannot use SQL Server Management Studio Express 2008 to update the full text catalog according to : http://msdn.microsoft.com/en-us/library/ms365247.aspx

My tables are also not enable Full Text Search by default. 


 Any help would be very much appreciated!

 Edit 1: Someone had a similar problem to mine on this link: http://forums.asp.net/t/1169961.aspx
I installed the Sql Server 2008 Express with Advance Services and made sure that Full Text functionality is installed. However I don't get a full text menu in SQL Server Management Studio. 

 Edit 2: I uninstall and reinstall SQL Server 2008 Express with Advance Services but still couldn't be able to enable full text index.

 Edit 3: After see this, I guess I have to do it manually then:  http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3912985

how to enable remote Connection sql server 2008



I've just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable I but "Surface Area Configuration" of sql 2005 seems to be vanished in this new version. Despite  I searched like 2 hours, I couldn't find any useful solution,  interestingly all the results are either nonsense or related to 2005 version.

Please me what the hell should I do and I believe many people will use your answer!

Thank you in advance

Error Installing SQL Server 2008 Express: '' is not a valid login or you do not have permission


I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission.

I have tried installing both SQL Server 2008 Express with Tools and SQL Server 2008 with Advanced Services, and they both fail the same way. I am trying to do a new stand-alone installation.

I'm running Windows XP Home Edition SP3.

Looking into the error, some forums say I have to install it from THE Administrator account, and not an account with administrator permissions; it also cannot be in Safe Mode, because then the Windows Installer won't work. Unfortunately, I haven't been able to login to the Administrator account. I can go to the home login screen, do ctrl+alt+del twice, and attempt to login to the Administrator account, but I receive this error: Unable to Log You on because of an Account Restriction.

Other forums say that in the Server Configuration section, all you have to do is provide the username and a strong password from an administrative account on the computer, and it doesn't have to be THE Administrator. Well, I did that, but for some reason it doesn't recognize my username and passw

Sql Server 2008 logs Authentication mode incorrectly avoids remote login


Im trying to connect SQL server 2008 Express R2 installed on XP sp3 pc through ODBC SQL Server driver with a Windows 7 PC. I managed to define static IP ports and setup firewall. Now the ODBC connection successfully gets created by accepting uid : sa and my password given.

Now Im getting "login failed for user ". " msg from my application. When I run the same application with same ODBC connection created in the SQL server PC it works fine. The two pcs operate in a workgroup.

Following  is the error log. Im surprised to note that the server logs its in Mixed mode initially and later makes a cry that its in Windows Authentication mode. !!!!

010-07-25 15:19:53.76 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
    Apr  2 2010 15:53:02
    Copyright (c) Microsoft Corporation
    Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3, v.3311)

2010-07-25 15:19:53.76 Server      (c) Microsoft Corporation.
2010-07-25 15:19:53.76 Server      All rights reserved.
2010-07-25 15:19:53.76 Server      Server process ID is 3552.
2010-07-25 15:19:53.76 Server      Auth

SQL 2008 login server duplication


New Laptop running SQL server express 2008 R2.  Did a reinstall of SQL after some had uninstalled the first install. 

When logging in now I see the server name twice as well as local twice. How can I remove the duplicate names?


Microsoft Sql Server 2008 r2 Login Problem


Hi guys....

              I am facing the problem to acess the Data Base.

              some time ago i am easily acess the data base by typing the server name(like and type the user id and password   from  web.config file but now i am find the error.like .

Login failed for user 'NSAdmin' (Microsoft Sql Server, Error:18456).

please anybody help me out to finding the solution of the problem asap.


sql Server 2008 login


I just re-installed SQL Server 2008 on my desktop (after a hardware failure).  When I try to log in with Windows Authentication I get an error message - "Cannot connect"  with the Additional Message - A network-related or instance-specific error occurred while establishing a connection to SQL Server.  The Server was not found or not accessible.

Soome would be greatly appreciated.



Re-login to SQL Server 2008 in Windows authentication mode after resetting my Windows login password



I recently reset my Windows login password but from then onwards SQL Server 2008 is not allowing me to login in Windows authentication mode.

Can someone please help on where I can go and set my new Windows Login password in SQL Server 2008 and continue to login in Windows authentication mode?

Thank you,

Anish Ravindran

how to enable remote Connection sql server 2008



I've just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable I but "Surface Area Configuration" of sql 2005 seems to be vanished in this new version. Despite  I searched like 2 hours, I couldn't find any useful solution,  interestingly all the results are either nonsense or related to 2005 version.

Please me what the hell should I do and I believe many people will use your answer!

Thank you in advance

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out



The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains my current windows logon and the password field is blank. I am logged in with a windows administrator account though I hadnt explicitly added this account to the SQL server sysadmin role.

I have also tried "Run as Administrator" with the SQL server management studio but the problem persists

Please note that SQL server was installed with another windows administrator account. Could this be the reason ? Will it work if I login with the account with which SQL server was installed ?

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials
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