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


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

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

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
 

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
MSDTC IP Adress
MSDTC NetworkName
Q:Quoram


SQL
----
Disk G:
Disk L
SQL IP IpAdress(SQLCLUSTER)
SQL Network Name(SQLCLUSTER)
SQL Server Name
SQL Server Agent
SQL Server Fulltext

 

 

Thanks in Advance

 


SNIVAS


View Complete Post


More Related Resource Links

Moving the Quorum drive to new SAN (SQL Server 2005)

  

Hi,

  I have an active/passive cluster installed on Windows 2003 Ent ed with SQL Server 2005 installed. Currently we are planning to move to the new SAN. Can you give me detailed steps (with screenshots if possible) or links on how to move quorum and msdtc resources to the new SAN.

Thanks

Chandra


Chandoo

How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------


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!

installed ms sql server 2008 and there is no db instance

  
I had the 2005 version on installed on my pc...I installed visual studio 2010 professional but the sql 2005 did not work. I tried to install sql 2008 but I was unable to. Searched on the web and found out that I had to uninstall sql 2005 for some reason. I did. I successfully installed sql 2008 now but there is no database instance. I tried sqlcmd -L and there where no servers available.   Can I install I new instance now? How can I do that?

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

  
Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

named instance sql server 2008 install on cluster

  
I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

sql server 2008 cluster multi instance

  
we have a cluster with 2 nodes and we are thinking to add another instance so that node 1 takes care of instance 1 and node 2 takes care of instance 2, and at anytime they are watching each other's back. How is this done???? what is the procedure? thanks.  

Rebooting one Instance on a SQL 2008 Server with multiple instances installed

  
Hello, Hoping someone can answer the following questions ... If I have SQL Server 2008 with multiple Named Instances configured on it, can I reboot one Named Instance without rebooting any of the other Named Instances, or without having to reboot the entire server ? For example, if I have an application that needs to be re-booted and it requires the Database to be re-booted. Regards, JD

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?. 

PERFMON: Cannot see SQL Server 2008 R2 64 bit instance counters from remote machine

  
Hi, I have 2 machines X and Y. I am using X machine to run perfmon which will remote connect to Y machine and collect the counters for Y machine. I am surprised to see that I am not able to see the counters for SQL Server 2008 R2 64 bit when I remote connect the perfmon on X machine to Y machine. However, when I directly log in to Y machine and open perfmon, I can see the counters for SQL Server 2008 R2 64 bit !! What is not allowing me to see those counters while connecting remotely? I have same adminstrator rights on both machine for my login and use same login details to log into both machines. Both machiens X and Y are in same network and same domain. Any help will be appreciated.

Create new instance of sql 2008 R2 server

  
Is there a way to create a instace of sql server just using my pc name? Currently sql uses 'machine name\instance name'

SQl server 2008 installation is a different drive

  

1. Can I isntall sql server 2008 is different drive other than C. What is the best practice.

2. Due to a corrupted DB my SQl server generated huge log files and dump files that my C drive ran out of space. So is there an option in the maintenance plan to clean up SQL error log file which is located in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log .

 

 

 


problem with connecting to local SQL Server 2008 default instance using windows authentication

  

Hello, 

 

I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.

 

2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 127.0.0.1]

 

 

This us

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?

Thanks.


SQL Server Express 2008 instance fails to start

  

I've installed SQL Server Express with a named instance 'SQLSERVER2'. I was able to connect to it and reference it in the management studio. There was a problem though with Visual Studio 9 when running an ASP.NET web application that required connecting to the same instance. So, I went into the configuration manager to change the security level of the instance from network to local service. The change went through but could not restart the instance. That is what has created my next round of problems. I can't go in and change it back to network because the instance is permanently stopped. I cannot start it with the services manager. How can I fix this?

Here is the connection log:

2009-12-21 11:36:32.20 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
 Jul  9 2008 14:43:34
 Copyright (c) 1988-2008 Microsoft Corporation
 Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2009-12-21 11:36:32.50 Server      (c) 2005 Microsoft Corporation.
2009-12-21 11:36:32.51 Server      All rights reserved.
2009-12-21 11:36:32.51 Server      Server process ID is 21856.
2009-12-21 11:36:32.51 Server      Authentication mode

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