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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

creating server groups in sql 2005or2008

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :ASP.Net

Hello everyone,

I was trying to  create a Server Group in sql 2008 from ssms.But did not get any option for creating groups and registring different servers under a particular group.I am using Enterprise edition with sp2 on windows 2003 servr os.

Let me know what could be a problem.

View Complete Post

More Related Resource Links

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Creating List Definitions with Custom List Columns for SharePoint Server 2007

Learn to use Visual Studio 2008 Extensions for Windows SharePoint Services to create a SharePoint list definition that implements custom list columns.

Creating a table-valued function on a user defined type in SQL Server CLR

We would like to be able to create a table-valued function on a user defined type.  We would like the syntax in SQL to look like it works for the XML nodes function:   DECLARE @myXml XML = '<a><b>1</b><b>2</b><b>3</b></a>' ; SELECT  node.query('text()') FROM    @myXml.nodes('a/b') nodes (node) ;   In other words, in the FROM clause, we can access the "nodes" method of the xml variable and it returns a rowset. Thanks!

Creating a recordset using VBA in Excel with SQL Server Compact

I have create a SQL Server Compact database from VBA in Excel.  So far so good.  Now I want to access the database via a recordset.  here is my code.        Set recSet = New ADODB.Recordset        recSet.LockType = adLockBatchOptimistic     recSet.CursorType = adOpenKeyset     Call recSet.Open("SELECT * FROM SPAR", dbConn)   When I run this I get and error in Call recSet.Open("SELECT * FROM SPAR", dbConn):Errors Occurred, [,,,,]  I have search many forums about his problem, but I still can't see where the error is from.  I am using Excel 2003, and SQL Server Compact 3.5   Regards, Peter

Checking SQL Server User Roles and Creating SQL Server Users using VB.NET

Hello gurus!Firstly I want to apologies if this question is out of place here.. if someone can direct me to the correct forumn great and Thanks!I have a VB.NET application which uses its own Backend Database (MSSQL Server). I need to distribute this application to sites where there will be an existing SQL Server.So I will need to Create the Database on this server. The Application includes methods for building the database on startup if not already connected to one.However the users windows logon may not have the correct permission to connect and create a Database on the Server. I have a DB Setup form in my application which asks for the Servname, Username, Password and Database name. I have catered for Windows Authentication and SQL Server Authentication within the form - the user makes the choice.Assuming they enter a Username and Password for SQL Server Athentication then I will be trying to connect using this user and create the database on the given server. The following is my outline logic:-                                                                  Create db Process                                                                             |                                                                             |                                                               Check Credentials                                                                   / 

Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010

Learn how to create a Business Connectivity Services (BCS) custom connector to integrate data sources into SharePoint Server 2010.

Creating Lists On Share-point 2010 Server from .stp list template files using Features

Plz, let me know, how to create list on share-point 2010 server from .stp list template files using features in C#

SP2010- Creating an Index server which will host all the Service applications

Guys, Current Environment : 1 Sql server 2008 R2 and 1 SharePoint 2010 Server OS : windows server 2008 all 64 bit (goes without saynig) For better performance i want to seperate out Service application ( expecially Search Service application) to another windows server while keeping the existing one as a WFE hosting CA as well. From the little documentation i found i am creating an Index server(with out CA on it) 2 questions here : 1. Is this the best way to optimize my farm? 2. Is there any online documentation or any knd of link that woudl describe how to set up the index server. thanks in advance. Sameer  

Creating assembly throwing an error as system.directoryservices assembly is not in the SQL Server

Hi, I am trying to create an assembly (DLL file that created by C# ) which uses System.DirectoryServices assembly. When I try with following script Create ASSEMBLY Addresstype From 'C:\ActiDirectoryFunctions\ActiveDirectoryFunctions.dll' I am getting following Error Assembly 'ActiveDirectoryFunctions' references assembly 'system.directoryservices, version=, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. From above error message, I learnt that System.DirectoryServices assembly is not in the SQL Server. I am using SQL SERVER 2005 SP2 and .Net Framework 3 is there in the machine How to manually add this assembly into this SQL Server Machine? Please let me know if you know Thank you, Raj Dreaming a world without any war in anywhere

Feature with wsp for creating specific groups on any site creation

hi, i need to create a sharepoint feature for wss 3.0 with .wsp (wsp for easy deployment) which do folowing funtionality: Ability to run some custom code for creating specific custom groups on every site creation. Feature needs to be activated when deployed so when user create new site it creates groups based on our custom code( i have custom code for creating gorups just need to know how to attached it to feature which works on every site creation event) Any workable example is very helpful for me because i am very confuse and already did reasearch on that. i guess feature stapling is not the solution in my case. Thanks in advanced shaheen

SQL Server 2008: When creating database with filestream group pc hangs


I am facing this STRANGE problem with sql server 2008. When I try to create a new database with filestream group my system hangs. When I restart pc by direct power off and then on, I cannot see the new database but at the given location I could see that database files and filestream group has been created. 

Solutions Tried.
Uninstall, download new version then reinstall but to no use.
Set maximum permissions to current user (according to my knowledge).
Using Mix mode authentication.

PC configuraion:
XP Home Edition SP2,
Intel Dual Core 2.0 GHZ Processor
4GB Ram,
SQL Server express SP1 installed on NTFS Partition
Plenty of Disk Space
Comodo Firewall pro, Avast Antivirus ( Already tried to stop firewall and antivirus still no use)

Any help would be appreciated.

Creating default SharePoint groups for upgraded sites



I am doing some testing in preparation for a DB attach upgrade from MOSS 2007 to SharePoint Server 2010, and I've run across a bunch of old sites that do not have the default Owners, Members, and Visitors groups. Without those groups (specifically, without Members) we won't be able to take full advantage of the My Sites Memberships page. 

I noticed, though, that when I "Enable Enterprise Features" for all current sites from within Central Administration, sometimes those groups get created on a site that didn't have them before. I've done this on a few different environments and it doesn't seem to always create those groups. Now, I didn't think I had to run Enable Enterprise Features because our 2007 environment was Enterprise, but then I realized some of the sites were created back in SharePoint 2003 and enterprise features might never have been run on the sites when it was upgraded to MOSS 2007. 

So the question: is running Enable Enterprise Features for current sites supposed to create the default groups if they don't exist (along with everything else it does)? Is that the recommended way to get groups made for all sites so site admins/owners can add people to that new Members group which allows the users to visit their My Site page to view all the sites they are members of?


Are nested Windows groups supported as SQL Server 2008 logins?


I am attempting to configure a new SQL Server 2008 instance to use Windows authentication, and am encountering a problem when adding Windows domain groups as logins. Specifically, Windows users who are direct members of a Windows group that has been added as a login behave normally. Users who are members of groups that are, in turn, members of other groups which have been added as logins are unable to connect.

In a simplified example, consider the following:

Group: MYDOMAIN\DataViewers
  Member: MYDOMAIN\Hazel
  Member: MYDOMAIN\Seamus

Group: MYDOMAIN\DataEditors
  Member: MYDOMAIN\Vaughan
  Member: MYDOMAIN\Liesel

Group: MYDOMAIN\AllUsers
  Member: MYDOMAIN\DataViewers <-- This is a group
  Member: MYDOMAIN\DataEditors <-- This is a group

If I add the MYDOMAIN\AllUsers group as a SQL Server login (and map it to some databases), none of the end users (i.e. Hazel, Seamus, Vaughan, Liesel) can connect. If I add the MYDOMAIN\DataViewers or MYDOMAIN\DataEditors groups as logins, though, their members can connect. Similarly, if I add an end user directly to the AllUsers group, they can connect normally.

It appears as if the nested group model I had envisioned is not supported in SQL Server 2008, but I have been unable to find any documents that state this conclusively. Therefore, my q

Problem Creating Server Side Javascript


I have a custom control which creates client side Javascript in order for it to function. When the property .OnSelectScript is wrapped in an if...then that tests its length, the value of .OnSelectScript appears to be ignored when the Javascript is being generated. However, when I set the .text value of a test label to Javascript, it appears there. I have confirmed that the statement *does not* appear client side when I view the source for the page.

Property declaration for the control

    Public Property OnSelectScript() As String
            Return _OnSelectScript
        End Get
        Set(ByVal value As String)
            _OnSelectScript = value
        End Set
    End Property
    Private _OnSelectScript As String

Full SUB as designed

    Protected Sub Page_Load() Handles Me.Load

        Dim ClientSideJavaScript As New StringBuilder

        LabelSelectorTitle.Text = Me.Title
        Call LoadData()

        ClientSideJavaScript.Append("/*File: Test Selector.aspx.vb Sub: Page_Load()*/" & Chr(10))
        ClientSideJavaScript.Append("function setValue(ParentPopup, TargetDisplayControl, NewDisplayValue, TargetTextboxControl, NewKeyValue) {" & Chr(10))

Search server 2010 setup - error creating search service application

I am running in a very similar siutation as this post:

I am configuring a new Search Server 2010 production environment.

I used the search setup account to run the setup and run the SharePoint Products Configuration Wizard.

During the first run of the SharePoint configuration wizard (where the farm account and service applications are setup), the process failed because the search service application could not be created.  

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException: User does not have permissiont to perform this action.

I was under the assumption that the setup account had securityadmin and dbcreator SQL Server roles.  However, this was not the case and I had them added.  My original thought was the setup failed because of this.  After those roles were added, I tried to recreate the search service application and I still get a failure.

I am pretty sure I have followed the prerequisites as prescribed by Microsoft in terms of account setup (

SQL Server Login - Windows Groups

We are trying to standardise access to SQL Server in our oraganisation.

We are installing SQL Server Management Studio locally for all our developers and DBA's.

The DBA login in sql server has been given the 'sysadmin' role. The DBA domain account has been made a member of the following Windows Groups,

- Remote Desktop Users
- Users

Our developers have been given the appropriate database role. Their domain admin account has been made a member of the following Windows Groups,

- Users

Can you advise whether this is a correct setup, if not can you suggest an alternative ?
Do we need to put Developers in the 'Users' group ?


Creating DSN for local machine in SQL Server Express 2005


Good evening,

This is my first time with SQL Server, so please forgive me if this is a ridiculous question:

I'm trying to create a DSN so I can connect up to SQL Server Express 2005 on my laptop/local machine. I'm attempting to connect via Windows NT authentication. I've tried 'Named Pipes' and TCP/IP settings but am not able to connect. I keep getting an error that states:

SQLState: '01000'

SQL Server Error: 2

Connection failed

SQLState: '08001'

SQL Server Error: 17

SQL Server does not exist or access denied

Is the server created by just installing SQL Server 2005, or is there something additional I need to do? Any help would be much appreciated.




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