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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Database Users showing disabled

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

In SSMS, a database user is showing up as disabled (a down reddish arrow). When I look at the server login - it shows that it is a valid login to the instance. I go to Login Properties and then click User Mapping on the GUI and check the particular database to add/enable this user to a Role. However, no luck. It still shows the user as disabled. The user cannot connect to the database. This is in SQL Server 2005, EE64.

Can someone please help? - Thanks.




View Complete Post


More Related Resource Links

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.

showing modalpopup and saving data to database simultaneously using ajaxtoolkit and javascript

  
hi,i have a button ,i want that when i click on that button the data should be saved in the database as well as at the same time a modal popup should display the customerid .i have written the code as <asp:button id="save1" runat="server" onclick="Button4_Click" style=""z-index:" mode="hold" xmlns:asp="#unknown" /> left: 740px; position: absolute; top: 304px" Text="save"/> <asp:panel id="panel" runat="server" xmlns:asp="#unknown">  /asp:Panel> <ajaxtoolkit:modalpopupextender id="MPE" runat="server" targetcontrolid="save1" xmlns:ajaxtoolkit="#unknown"> PopupControlID="panel" DropShadow="true" BackgroundCssClass="modalBackground/> protected void Button4_Click(object sender, EventArgs e) { string id = TextBox1.Text; string name = TextBox2.Text; string cn = "Data Source=hcl;Initial Catalog=mydata;Integrated Security=True"; SqlConnection con = new SqlConnection(cn); SqlCommand cmd = new SqlCommand("insert into customer values (@id,@name)", con); con.Open(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@id", id); cmd.Parameters.Add("@name",name); cmd.ExecuteNonQuery(); con.Close(); CUSTID.Text = id.ToString(); MPE.Show(); }

Recovery of Database Disabled SQL Agent, Cannot Detach Database, Etc... Please Help

  
I am a beginner SQL user, as the company laid off the IT guy and I am stuck with this.  So I really need some help on this one.  Any ideas would be appreciated. I was doing a merge join command to put data from one database to another.  These are 60GB databases with valuable data.  Halfway through I was told by client to just stop the query.  I did this but it left the good database with a large 80GB log file. When I rebooted the machine the recovery of this database took 5-10 minutes...  Thus the SQL Agent disabled itself waiting for recovery.  After recovery was 100% complete with no errors SQL Agent will not restart.  I can do a force turn on using a "1" statement, but the SQL Agent log file says it is still waiting for recovery. In any event, I cannot detach the database because it says 1 user connected.  I cannot backup, drop, etc...  I saw in one forum a guy said to turn service off, copy database to a new location, turn service back on, delete the database, attach copied database...  But I am a little worried about deleting. Once again - I am a SQL newbie and really need a pointer on this one.  I need to free this database and get a it back to a normal sized log file. Advice???

Excel Web Part - different Powerpivot Slicer disabled tue to sharepoint users

  
Hello, first of all i'm new to sharepoint. I found quite similar question to mine http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered. So what i have done so far: I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it. I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba. What i want to achieve: Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself) So i need to disable slicers in the pivot chart tue to the sharepoint accounts. My Qestion: Is it possible? If yes, how! Any help would be appreciated. Is it possible via VBA or do i have to use Excel web scervices?  Thanks for your help :)

I have to do it manually or is there any other way...?to transfer the users in database mirroring

  
One issue in database mirroring: In Primary server every week 2-3 users will additionally added.How will these users gone to Mirror Server database?I have to do it manually or is there any other way...? One more thing is that Primary server is llve  and 24 hours users connected, If I want to migrate users on other server then I have to make mirror server as primary server and then run SP_rev_login , it is automatic failover then  the newly created users will not be at the mirror server??then problem"SQLSERVER DBA" "INDIA"

How to ensure that all users are logged off the sql database and that they can't access when the SQ

  

We are trying to restore a SQL Server 2005 (all the databases). We have failed with the restore for a couple of times and the vendor says that we have to ensure that all database users are logged off the database. A restore will fail if other users try to use the database while the restore operation is in
progress.

How could this be acomplished. There is no way that we can control if any user or app access the server while we are restoring.

The problem is that when when we are restoring the databases if someone access any of them while the restore is taking place the process fails.

The question is how should the restore be performed? Is there any way to change the state of the database so that the databases can be restored?


Any thoughts?


Users, Sessions, Processes, Instances, Database Engine

  
Can you depict me the existing relation between Users, Sessions, Processes, Instances and Database Engine of SQL Server?
MJ_Developer.

Users can access every new library though Anonymous access id disabled

  

Hi guys,

I have a really strange stuff going on... I have Anonymous acces disabled on my MOSS portal in Central Administration:

Central Admin->Application Management->Authentication Providers->Default-> Anonymous Access is checked off

 

So I doesn't even have an option to enable it on any sites of this web application. But when I create a new Document Library all users have read permissions to it though I left only System Account at library permissions .

Am I missing something?


Forms based authentication allow only specific users from database table

  

I have the following implementation and I'm sure there is an easy way to do what I want to do but I can't figure it out. 

1. I use forms based authentication to authenticate to my site

2.  I use active directory to authenticate the users

3.  I use the Allow Users="xxx" tag to authorize the users limited to the list that can access my site. (e.g.. even though Mary is an AD user she can't access my site unless I put her credentials in the allow users tag in the web.config file)

All is working well but I want to move the users access list (e.g.. <allow users="john" />" from the web.config to a database table so that I can create a user maintenance page for my admins to add and delete user access.   For the life of me I can't figure out how to do this and I can't seem to find an article on it either.  I'm sure I'm just not looking for the right thing, so help is greatly appreciated. 

Here is my web.config file..


<configuration>
 
    <connectionStrings>
    
        <add name="DBConnectionString" connectionString="Data Source=PRIMSRV;Initial Catalog=MAINDB;Persist Security Info=True;User ID=svc.Test;Password=password

disconnect all the users from database

  

Hi gurus

Is there any command to disconnect all the users from the database. I don't want to set it in single user mode.

Cheers,

Sengwa


Change the default users for a new database?

  
Is there any way to customise the default users that have access to a newly created database? I have an Active Directory group that has been granted logon rights to the SQL server, but I need it to have read/write access to any new databases that are created on the server. I don't want to use the Mgmt Studio to grant the permissions. This is because we have an app that creates the databases, but it doesn't set the security. I want an easy way for the security to be granted.

Win7 64bit showing my database as ReadOnly when Application Installed

  

Hello ,

I have faced a very strange issues so far.. let me explain you all my situation..

I have an windows application.. it's developed in the .net framework 2.0 and back end with SQL Express 2005 , and I am attaching my database file while I install application on the machine.

My appliction works okay in all the operating system with 32 bit platform but when I tried to install it on the Win 7 , 64 bit it was giving me error with ReadOnly database and can't execute query.

I have checked all permission given to folder of my database in both 32bit and 64 bit win7, it looks same.. then what could be cause of such an error.. though when I tried to run it from vs in win7 64bit (Debug though visual studio), it was working correctly..

if you have any solution.. for this problem. let me know ..

thanks..

 

 

 

 

 

 


Thanks and Regards, Shailesh B. Davara sdavara.com

Win7 64bit showing my database as ReadOnly when Application Installed

  

Hello ,

I have faced a very strange issues so far.. let me explain you all my situation..

I have an windows application.. it's developed in the .net framework 2.0 and back end with SQL Express 2005 , and I am attaching my database file while I install application on the machine.

My appliction works okay in all the operating system with 32 bit platform but when I tried to install it on the Win 7 , 64 bit it was giving me error with ReadOnly database and can't execute query.

I have checked all permission given to folder of my database in both 32bit and 64 bit win7, it looks same.. then what could be cause of such an error.. though when I tried to run it from vs in win7 64bit (Debug though visual studio), it was working correctly..

if you have any solution.. for this problem. let me know ..

thanks..

 

 

 

 

 

 


Thanks and Regards, Shailesh B. Davara sdavara.com

People picker not showing disabled accounts, I need it to.

  

I know its a weird request but we have a group that uses accounts for email that are disabled in AD.  I have not set any filters for the people picker and I'm 100% sure that these accounts were showing up in the picker a few weeks ago.  From what I've been reading the picker should show all users and groups in AD whether they are disabled or not, is there something I can do to fix this?

thanks in advance.


Creating a web-part in sharepoint showing charts connected through a database

  
here's what I intend to do: 1) Import data from a database(through creating a connection to database) 2) create a graph or chart using the values from the database(in excel) 3) then import that chart to the sharepoint site as a web-part. My question is how to accomplish the task. (all the three steps) So, whenever the values are updated in the database, the sharepoint site will be automatically updated. Any help would be greatlly appreciated.

create database trigger to capture new session users

  

Hi 

I would like to capture the session user names of people connecting to our database and store them in a separate table.

I was hoping I could "create trigger foo on database for logon". But that is only valid for server based triggers. The problem is I know adding a server based trigger might upset some of our database guys so ideally I would like to avoid this option if possible.

Does anyone have any suggestions?

Thanks in advance

Blair

 


Sql Server Database services option in components install is disabled during installation of SQL Ser

  

OS: Windows Vista

SQL :2005

While selecting components to install during installation of SQL Server 2005 on Windows Vista

1)Sql server database services ,create a sql server failover cluster

2)Analysis services

3)reporting Services are disabled mode.

please tell me how to enabled this  options during installation.


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