.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

Adding a second NIC to SQL Server

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

SQL 2005 Standard.

I would like to add a second NIC to my sql server to connect via cross cable to another server.

Can SQL Server listen on 2 IP on different NICs on the same instance ?
What are the best practice in doing that activity ?


View Complete Post

More Related Resource Links

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


Problem adding .NET 3.5.1 feature on Server 2008 R2

Having an issue with a 2008 R2 64-bit Server becoming unresponsive/locking up when trying to activate the .NET 3.5.1 feature.  Did not have any previous version of .NET installed but ran the .NET Cleanup utility and completed successfully but still have same issue.  It installed .NET 4 via the Microsoft Updates OK but still hangs part way through the 3.5.1 install via the Server Manager/Add Features.  Any ideas?  Thanks!

Adding second node to SQL Server cluster fails.

I have successfully created a MSCS cluster and I have the SQL cluster up and running on the first node.   When I put the install cd in the second node and go through the install it fails with the error SQL Server Setup has encountered the following error:  Object reference not set to an instance of an object. I'm assuming I get this error because on the cluster node configuration screen the "cluster network name" box is blank.   It won't let me select a name or type a name. The SQL cluster is up and running on the first node.   I can ping the sql cluster network name from both boxes.   The setup shows the installed node and the node I"m trying to add, so I don't see any problem. I have Windows 2008 R2 on both nodes and I'm installing SQL Server 2008 R2.   Any idea how I can get past this error?    Thank you.

Error adding connection in Server Explorer: "Unable to add data connection. ExecuteScalar requires a

I'm using Visual Studio 2008, and my database is SQL Server 2000. I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful. But when I click OK, I get the error: Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.What's going on here?

Scaling Single Server Farm by adding a seperate Database server

Hi, Right now, I am having a sinle server farm SharePoint 2010 installation. Now I need to seperate out the SQL server from the same box and want to move it to the new SQL server. In short , I need to have a seperate SQL server in my current farm (which is single server farm installtion). Can some one point me to the steps for the same ? Thanks.

Error 15401 when adding AD logins in upper case to a sql 2008 server

We are repeatedly getting Error 15401 when adding couple AD logins in upper case(DOMAIN_NM\USR_NM) to a sql 2008 server with the latin1_general, binary sort collation.  Lower case (DOMAIN_NM\usr_nm) works fine.  All the other servers, even the ones with the same collation, it is the opposite, upper case works and not the lower case.  Looked for duplicate SIDs in the domain, on the sql server, did not find any.  Any idea what's going on?. 

Adding a linked server with alias

I have to add a linked server now with an alias and with NT authentication. I got below code from a blog - I have few questions here, In general tab, Is that sql_server mandatory or can we give any other name? How about Provider string and Catalog information? How about NT authentication, where can we mention it. Please help..There are no problems to add SQL linked server to the specific host running it. But what if you need to give it an alias, rather than use hostname as linked server name?Here is how to do it:1) Step 1:. In SQL Server Management Studio open Linked Servers and then 'New Linked Server'.. Inside of appeared wizard - Select the General tab.. Specify alias name in "Linked server" field.. Select SQL Native Client as provider.. Add sql_server in "Product Name" field (that's the magic).. In "Data Source" - specify name of the host to be used as linked server.2) Step 2:. In Security tab - specify proper security options (e.g. security context)3) Step 3:. In Server Options tab - put "Data Access", RPC, "Rpc Out" and "Use Remote Collaboration" to be true.4) Step 4:. Enjoy.

Problem when adding Linked Server...

Hi @all,I try to add a new Linked Server to my DB in Microsoft SQL Server Management Studio Express...The following error is returned (SERVER2 is the Linked Server to add): There is no remote user 'sa' mapped to local user '(null)' from the remote server 'SERVER2'. (.Net SqlClient Data Provider)I entered the user sa and the correct password for SERVER2 but it doesen't work...When I connect to SERVER2 in Management Studio with the same infos it works fine...So please help...

adding ClientID to server control


hey all,

need help withthis one...

I need to add ClientID of one control to another server control attribute

this line works

<div content="<%= challengesTab_content.ClientID%>"  id="challengesTab">Challenges</div>

but when I add runat=server it doesn't get the clientid and just renders whatever is in content attribute

<div runat="server"  content="<%= challengesTab_content.ClientID%>"  id="challengesTab">Challenges</div>


so is there any way I can do it since I want to access this control on server side :s


Adding a SQL Server Table to Windows Form Application (c#)



I have created forms in the past that have connected to a SQL Server database and done a variety of manipulations.

This time I have a static table in SQL server that I want to add to the project and load into an array without having to connect to SQL Server i.e. the windows form application will have this datatable embedded within it so any user can use it. How do I add the table to the project in this way?

I know how to load the data into the array.




Adding triggers to a Merge Replicated published article in SQL Server 2008


Currently running merge replication on SQL Server 2008 10.0.1600 and I have a few questions around the correct procedures for adding and modifying triggers on published articles.  I've searched through the MSDN site and googled this but have not found any definitive information on correct procecdures.

1) When a new trigger is added to a published table do we just have to rerun the snapshot and then re-syncy the subscribers?  Just adding them does not seem to replicate them to subscribers.

2) When an existing trigger is modified should ALTER TRIGGER be used or should the trigger be dropped and then re-added?


Adding a server control on aspx page does not add events in aspx.designer.vb file



I work in VS 2008. Whenver I add a server control(Label) and set it properties in aspx.vb and build the solution, I get the error "Label1 not declared". While analyzing this issue I noticed that the event handler statements for the Label1 where not added in the designer.asp.vb file. These statement would actually be added automatically when I drag and drop a control to my webpage.

I would also like to inform the scenario after which this problem came to me. I was working in VS 2008 , VS 2005 and VS 2003 in the same machine.Could this have caused the issue ? Please advise.

Now each and everytime when I add a control, I am adding the "With Events" code in the designer page to make my build succesfull which makes me to spend more efforts.

Please advise if any settings have to be changed.



Adding server to a farm


Good day,

I want to add a new server to my existing MOSS 2007 farm. I've followed some of the articles on how to do it. Installed it as complete. When the wizard started I gave the remote server (Sql2005). Now curiously, it came back with 3 databases that seemed random. This is test environment so the db I chose was WSS_Content_Test, wich is what the current wss runs on. After picking that db the domain account was filed in the account field. The account is a domain account called xxxxSharePoint. I used this account to installed the whole thing, it is an administrator account that has also db admin rights including db create, db read, etc.

So when the wizard started I gave it the database, this domain account and password, selected the option not to install the central admin page. Then the wizard continued to perform 10 steps only to fail on the 2nd with a message of denied access. The logs on both  servers revealed that another domain account is trying to access the database and its credentials weren't adequate. I don't where this other acc

Adding named instance of SQL Server 2005 failed - "Error Locating Server/Instance Specified"


We are trying to add a named instance to our Windows 2003 R2 x64 SP1/SQL Server 2005 SP3 server.  It has been running for about 3 years now with a single (default) instance.  When trying to add a named instance, it fails when it gets to the point where it is Updating System Databases - "SQL Server Setup could not connect to the database service for server configuration.  The error was:[Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Refer to server error logs..."  We are using the local service account for both the default and new named instance.  Allow Remote Connections to This Server is enabled on the default instance. 

In Services, the new SQL Server service has started, but I cannot start the SQL Server Agent - it says it started and then stopped.  I cannot access the instance with SMS.  I rebooted the server and tried the process again with identical results.  I have successfully added a new instance to my test SQL Server using the same install files. Can anyone shed some light in this issue?  Thanks.

Adding user to SSAS server role not working


I have SQL Server 2005 SP3 installed on  Windows 7


 I’m trying to deploy a SSAS project and get the message


“Either the user, Ron-laptop\ron, does not have access to the analysis services Project2 database, or the database does not exist”


Following recommendations in the forum I’ve used SSMS to view the properties > security of the SSAS connection and am trying to add myself to “The server role is used to grant server-wide security privileges to a user” role


Adding Instance(SQL Server 2008 R2) and Moving Quorum Drive


Hi all,

I am Planning to Add new SQl Server 2008R2 Instance to SQL Server 2000 SP4 in Windows 2003 SP2 OS and As of now all the storage in SAN drive

Here problem is my company is going to move SAN drive to iSCSI and they given me iSCSI drives to Install SQL Server 2008R2 and they ask me Create Quorum drive on iSCSI.

1. Is it possible to create one more  Quorum  Drive or I need to move excisting Quorum to new Drive

I have below Groups in SAN Drive and I want Move those groups to iSCSI Drives what is best way ..to do this  with minimum Down time.

Cluster Group
Cluster Ip Adress
Cluster Name
MSDTC NetworkName

Disk G:
Disk L
SQL Server Name
SQL Server Agent
SQL Server Fulltext



Thanks in Advance



Adding an SP 2010 server to an existing farm. "Failed to connect to the configuration database." dur


I have an existing sp 2010 enterprise server hosting websites and central administration.  I have a seperate sql 2008 r2 server holding the databases.  My goal is to setup another sp 2010 enterprise server to provide redundancy for the websites and central admin.  I believe I am able to accomplish this by adding another web front end to the farm.  On the second server, I install sp 2010, run the config wizard and connect to the config database located on the sql server, however, I am interrupted at step 3 when I am notified of the following:

Failed to connect to the configuration database.
An exception of type System.InvalidOperationException was thrown.  Additional exception information: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
System.InvalidOperationException: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
   at Microsoft.SharePoint.Administration.SPEncryptedString.CheckCredentialLock()
   at Microsoft.SharePoint.Administration.SPManagedAccount.Deploy(SPApplicat

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