.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

Fried My Server! Sa Acct Locked Out

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 

Ok, I was testing something on one of my servers and made the mistake of setting the default database for sa to a user database rather than master.  I changed it back in SSMS under Security/Logins/sa, by choosing master from the default db pulldown.   I thought this fixed it, but apparently not.

A little bit later I delete the user database that I had previously set as the sa default.  Now, everything I try to do I get "Cannot open user default database...login failed for user sa".  If I shut down SSMS, I can only reconnect by choosing "master" as the default db.   But even once in, I can't perform any actions without getting the error msg above.

I tried running the following query to fix it:

ALTER LOGIN sa WITH DEFAULT_DATABASE = master

And a:

exec sp_defaultdb 'sa', 'master'

And even a:

EXEC sp_change_users_login @Action='Auto_Fix', @UserNamePattern='sa', @Password='fof!master0'

In case this was some user/login orphan issue.  No go.

This is SQL 2005.   I'm sure there is some easy fix, but its beyond me.  Can anyone help?

 

 

 




View Complete Post


More Related Resource Links

Client image files uploaded to Server are staying locked when accessed again.

  

I have a web form that, upon user request, uploads an image file from the client to a server folder, makes a thumbnail and saves to another folder than sets an imageurl of an image control to that thumbnail. All fine up to here, problem is that at times (not always but could not find the exact pattern) when uploading an existing file, it throws a ' ... file used by another process ... ' error, both on the original image file and the created thumbnail. Is there a way to prevent the locking of these files or alternately, which object need I destroy to release the image file and avoid these contentions? I do destroy the image object immediately after thumbnail is created. Ideas anyone?


Locked out of SQL 2008 Server

  
The situation is as follows:

- Client is running SQL Server 2008 on a Windows 2008 Standard server 
(Hpserver1)
- HPServer1 is a member server in the domain
- Developers use HPServer1\Administrator account to manage server via SQL 
Management Studio Express
- I do not know if the server was configured to authenticate in mixed-mode 
or Windows-only mode
- I do not know the SA password (if there was one)

- HPServer1 is promoted to be a domain controller in the Windows domain

- Developers have lost the ability to manage the server via SQL Management 
Studio Express because the HPServer1\Administrator user ID no longer exists 
and they do not know the SA password

- No domain accounts with administrative rights are able to access the SQL 
server for management purposes either.

- I demote the HPServer1 back to member server and set up the new local 
Administrator account with the same password as before.

- The new HPServer1\Administrator is also unable to access the SQL server 
via SQL Server Management Studio

- I downloaded and tried the MS SQL Password Unlocker tool from Digitial 
River and was able to change the SA password in the Master database but the 
database was still in accessible.

My question is what do we need to do next to regain management access to 
this database?


Server error: is checked out or locked for editing by ... but page does not exist

  

I tried to rename a page in the source variation of a Publishing Site using Site Content and Structure tool, let's call it "newpage". This threw an HTTP 500 error. I then tried to rename it in SharePoint Designer. I got two message prompts, the first said:

"A file with the name Pages/newpage.aspx already exists. Do you want to replace this file?"

There is no file of that name in the Pages list in either the source or target variation. I said "Yes" and got the following error:

"Server error: The file <path>/newpage.aspx is checked out or locked for editing by ."

No user name was given in the message. I can successfully rename the page in the target variation to have the new name.

I also cannot create a new page in the source variation called newpage.aspx, I get an error saying that there is already a page of that name ... but there isn't. I have cleared the site and site collection recycle bins.


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

  

Hi,

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 ?


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SQL Server Backup and Restore (video)

  
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.

SQL Server 2005 Try and Catch Exception Handling

  
I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:
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