.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

Licence issue, user CAL

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


I have some licencing issues.

I have this scenario. I have a server-client design. Clients only communicate with the server aplication. The server application communicates with sqlserver. So that is the only connection.

Is this considered to be one user enviroment, with no need for additionl CALs or does every client application represent an individual user, thus requering additional user cals.

Kind regards

View Complete Post

More Related Resource Links

User validation Issue in xlsx file



I am validating user from Login.xlsx file. It was working fine by validating email and password from that file. For testing i got new file same contents of file but added some more user names.

So after that when i validating the user i am getting the following error "Data type mismatch in criteria expression".

But when i replaced the new to old one it is working fine. The contens of both files are the same. So why this kind of error happened.


Issue with Remember Me on User Login control


Hi everyone,

     I hope you can help me, I tried Google, but none of the solutions worked. Using VB.net and Membership, I have a login control in my master page with a remember me check box. When I check this box and login, some pages indicate that I am not logged in. If I go to another page, it will then indicate that I am still logged in. I have isolated one page that always indicates I am not logged in the first time I visit it, but if log in a second time and then go to it, it will finally recognize me as a user that is properly logged in. 

Some pages that this occurs on is in the top level, some pages are in a sub folder.

My MasterPage has the following Form Code:

<body bgcolor="#E0ECF9" topmargin="0" leftmargin="0">

    <form id="form1" runat="server">

My Aspx file has a troubleshooting label, several Gridviews and several DetailViews:

    <asp:Label ID="lblErRep" runat="server" Text=""></asp:Label>

My aspx.vb file has 1 line of code (Protec

Anounmouse user Theme Issue

Hi All, I am using sharepoint foundation 2010,my problem is when anounmous user visit my site it's shows diffrent css file , but when registerd user enter in to my site it's show diffrent CSS for home page. I have already created custom theme through powerpoint and uploaded it on sharepoint 2010 and it's working fine for all  registered user. But some how anonymous user view is not picking up CSS from the Custom Theme. Please help  

LDAP - directory entry issue with out user and password using impersonate and windows authentication

Hi All I am using the below code to fetch the user information from LDAP             DirectoryEntry entry = new DirectoryEntry("LDAP://DEV");             DirectorySearcher searcher =  new DirectorySearcher(entry);             SearchResult result;             searcher.Filter = "samaccountname=testuser";             result = searcher.FindOne(); here i am using windows authentication always and along with that when i enable the impersonate = true ,  the code fails at "result = searcher.FindOne();" with message "object reference not set to instance of an object "  also with the same code if i give the username and password along with the impersonate tag >> it works  or if i am using the user and password along with the DirectoryEntry  object then also it will work  but it fails with same user that i gave in impersonate tag / directory entry object with windows authentication enabled  and the  user logged to the application and no username and password tag in directory entry / impersonate tag  Interesting thing is that  in our development server ,  i am able to execute the same code with out user name p

Very Wierd User Authentication Issue

We recently had a new starter for whom HR assigned the wrong Windows user name (his initials are P.S. and he got the username pc12, which should have been given to another guy who was starting at the same time...) It took a little while before this came to light and by this time the user had logged on, accessed a bunch of applications etc... Eventually, everything gets straightened out in AD and both users now have exactly the right records. The only problem is SharePoint. Profile information is fine, but (and this is the weird part) when P.S. accesses the site, he gets 'Welcome Pxxxx Cxxxx' (the other guy's name). We have been trying to resolve this for days now, so there has been plenty of time for any required replication and there have been about 100 iis resets. Now get this, when P.S. accesses other internal Web sites, he's authenticated fine - it's just SharePoint! I sense a support call coming on, but if anyone else has seen anything like this it would be great to hear any ideas.

Multi Tenant - User Profile Sync Issue




I ahve the user profile setup in partition mode. Every thin appears to be installed fine and running. On the main central admin page it list mulitple tenants. I have to seperate subscriptions setup with the following commands

Add-SPSiteSubscriptionProfileConfig -Identity $sub1 -ProfileServiceApplicationProxy $pUPSP -SynchronizationOU $ou -mysitehostlocation $mysiteurl

The subscription also has a featurepack and userauthenticationpath set


I recive the foloing erro when the MOS FIM connector tryes to export any user profiles

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.
   at Microsoft.Office.Server.UserProfiles.ProfileChangeData.GetPartitionId(UserProfileApplicationProxy upaProxy)
   at Microsoft.Office.Server.UserProfiles.ProfileImportExportService.UpdateWithProfileChangeData(Int64 importExportId, ProfileChangeData[] profileChangeData)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj,

Issue using Managed Metadata with custom fields in the User Profiles application


Hi there,

I've created several custom properties in my User Profile Application.

I've also created several Term Sets in the Managed Metadata service application Term Store for use with these custom properties. Some of the Term Sets contain terms and have a closed submission policy whilst others have an open submission policy.

If the user hasn't already populated any of these custom fields in their profile, when they click on the Edit My Profile link from their My Site Profile page everything seems okay (for the first time).

The user is then able to successfully select values for these custom fields - the metadata is available. They can click on the "tag" icon to select values, or start typing and the suggestions appear. They are also able to enter new values into custom property fields where the term set is open to submission.

If they then Save and Close then go back into Edit My Profile, often not all of the existing data is populated in the metadata custom fields. On different occasions different fields may be blank. Sometimes this is accompanied by the error "Message from webpage / The server method 'ValidateTerms' failed", but not always.

Has anyone else tried this or have any suggestions are to what the issue might be?

Thanks in advance.

Sharepoint 2010 popup page issue while sign in as diferrent user


We have a SharePoint 2010 portal in which one of the functionalities opens a list item add form as a popup. We customized this add form using SPD by adding the following java script functions.

<script type="text/javascript">



function PreSaveAction()

 var reqType= document.getElementById("ctl00_xxxxxxxxxxxxx_ctl00_Lookup").value;
 reqType= reqType.replace(/^\s+|\s+$/g, '');

 var reqDesc= document.getElementById("ctl00_xxxxxxxxxxxxx_ctl00_TextField").value;
 reqDesc= reqDesc.replace(/^\s+|\s+$/g, '');
 var error="";
   error=error+" &";
  error=error+" Description";

 error=error+ " can not be empty";

Custom task user interface issue?



I have designed a custom task with a general view that holds a properties grid in a general view node. I have developed a custom editor to help user set the value of that property, Of Corse, I point my property to use that editor in design time using System.ComponentModel.EditorAttibuteClass . The editor appears as a modal dialog box. 

The issue is that when I put the Dock property of the properties grid to Fill then the ellipsis button doesn't appear but if I set the dock property to None then it appears (I mean the ellipsis button) and then I can click it to configure the property though that Modal dialog box.

So the question should I do additional steps to avoid this anomally

Thank you


The complexity resides in the simplicity

User profile synchronization issue in SharePoint 2010 Enterprise


User profile is not getting sync.

We see warning events with following details each day before the schedule task starts.

"The credentials used for the account DC\soft.ac expired on 3/15/2008 1:20:42 AM, and need to be updated. If they are not updated, the system may stop working. The account is used by the following:

Farm Account

Microsoft SharePoint Foundation Sandboxed Code Service User Profile Synchronization Service etc..."

But the account is not expired.

Can anyone help?

Sharepoint Designer 2010 - Collect Data from User Issue


I am currently running Sharepoint 2010 Foundation and Sharepoint Designer 2010

I am creating a custom workflow where I am asking 1 user for input using collect data from user.  Following this I am asking a different user the same question using another collect data from user.

Since these creates 2 tasks (1 for each user) I wanted to store the information in the same column, but I seem unable to do so.  Each collect data from user seems to create it's own column even if you name both the same (you end up with 2 columns with the same name but different column id's).

Is there a way to point them both to the same column?  Is there a better way to do this?


More the less I am asking the both persons a yes/no question.  in my workflow if they both say yes I send an e-mail but wanted to have only 1 column in the vew to see the results on the tasks.




Issue trying to remove user from role that is no longer available.


Using tutorials and some examples of handling membership permission on our site, i have a page that was built using examples found in those pages.. Anyway, now that it is all setup and working ran into first issue.. If a role is setup with a space in the name like this ("Read Only") then you get an error when you try to add someone to that role. But if i change it to be ("ReadOnly") it works fine and no issues..


                        <asp:GridView ID="GridViewRole" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSourceRoleObject"
                            DataKeyNames="RoleName" CellPadding="3" CellSpacing="3" AllowPaging="True">
                                <asp:CommandField ShowDeleteButton="True" DeleteText="Delete Role" />
                                        <asp:Button ID="Button1" runat="server" CausesValidation="false" Width="500px" OnClick="ToggleInRole_Click"
                                            Text='<%# ShowInRoleStatus( (string

Site Users Webpart - Add New User link Issue


Hi All,

We are using SharePoint OOTB Site Users webpart to display all the users in the respectives SharePoint groups. Its working fine. But, when we logged in as a user who has a member of visitors or members SharePoint groups, the user can able to see the "Add New User" link. Eventually, the link should not be displayed for members and visitors group.

Could any one face this issue? Is this bug in the SharePoint itself?

Kindly suggest.


Chandrasekaran C N


local/domain user issue


So I migrated an SQL Server Express 2005 database running on venerable Windows 2000 to a brand new server running Windows Web Server 2008 R2 (64-bit) with SQL Server Express 2008 SP2. I did the initial installation and setup as local administrator. I restored an SQL .bak file without incident and the database seems to be running normally. (After some minor IIS tinkering the ASP.Net website that relies on it works fine.)

I joined the new server to the domain and logged in as domain administrator. Of course the database's owner is the local administrator, and the domain admin doesn't have the full access that the local admin does.

If I get properties on my database in SSMS the owner is the local admin. If I try to change it, it lets me browse for other users, but won't recognize my domain admin at all - the only object types I can pick is Logins. If I try to add a new Login under Security, it sees my domain in Locations, but when I enter MyDomain\Administrator, it says it can't find it.

How can I fix it so that domain accounts are present and usable in SSMS?

With the old database I had a system DSN in ODBC set up to connect to the old database. (I would use linked tables in Access to connect to the database directly sometimes to make edits and things that I never built ASP pages to do.) The servername & database are the same

Issue when nesting User Controls


Hi everybody,

I have an issue  with  nested  User Control, I hope someone  may  help  to  work it out.

I have a  class library  solution  with  one  user control   and  some  nested  controls  inside it.  this is  the code:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Data;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.ComponentModel.Design;

using System.Windows.Forms.Design;

namespace myBaseAssembly



 public partial class BaseControl : UserControl


 public BaseControl()





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.

Choosing Between a User Control or Web Part for SharePoint

SharePoint will only display Web Parts on a page. However, there are publicly available shims that allow you to write user controls and have them be displayed as a Web Part. From SharePoint's point of view, the shim is a Web Part. From the point of view of the user control, the shim is simply a control in .NET that is including the user control
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