.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

SQL instances

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
I have a requirement to move 6 databases into 6 instances of SQL. These will be on two seperate clusters. My problem is each of these databases are currently in different time zones. Is there anyway to set an instance to use a certain time zone?

View Complete Post

More Related Resource Links

Multiple Instances of User Control


I have a user control that I place on a page severl times.  When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl.  So I get duplication of an insert that I do.  Is there a way to make sure these events are isolated so this doesn't happen.


How to run multiple instances of workflow



I've created simple sequential workflow. It's only creates one task and is waiting in while loop until task is Approved. It works fine when I run only one instance of this workflow, but if I start another instance before first one is finished it gets stack and doesn't complete task an workflow stays in In Progress state forever.

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

governing service instances?

We have a WCF service that uses a third party component.  The third party component has strict concurrent licensing security built in and will throw errors if you attempt to concurrently process more than your license will allow.  My question is how to configure our WCF Service to only allow up to a maximum number of service instances at any given time and thus stay under our third party control licensed limit?   (Note, running net.tcp under IIS7/WAS with 16 CPU cores)    thanks    

Clearing WF instances?

Hi, I have been creating lot of WF instances, and now im running of memory after running the program for 15 min or so. Is there any way to clean up the resources in Workflow Application Completed method?

Different SQL Server instances on one server

Good afternoon. I have a Windows Server 2003 with SP2 loaded. On it I have SQL Server 2000 - 8.00.760 SP3 Developer Edition along with SQL Server 2005 - 9.00.1399.06 RTM Developer Edition. Can I also install an instance of SQL Server 2008 on this server without cauing a problem with the otherSQL instances? Thank you.

Identical instances listed by installer after upgrade

I ran the edition upgrade on a SS2005 installation to bring it up to 2008 R2. Now I am seeing two identically named instances (MSSQLSERVER) when I run setup again. Not only the instance name, but also the details (version, edition, installed features) are identical.  I tried running a repair on the first "instance" and got a file locking error that crashed the setup. Rebooted, then tried again, this time on the second "instance". Same error: The process cannot access the file 'C:\Windows\SysWOW64\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process. Background: Reporting Services had been misconfigured, so I was going to uninstall and reinstall SSRS; that is why I had gone back to the setup program. This is Std x64 Edition, running on Server 2008 Std.  

SSRS2005: Is it safe to manually remove instances from the Keys table in the report server database?

I have a problem with redundant reporting services instances still hanging around in the initialization pane of the RS configuration wizard and I can't get rid of them. The problem arose when we had new webfarms and before I had removed all references to the old ones from the initialization screen, the old webfarms had been switched off, removed from the network and dismantled. Therefore when I try to 'de-initialize' them, I get an error stating that reporting services cannot connect to them and when I run reports, a fair few are trying to run on the old webfarms which no longer exist and are disappearing into the void. There's a table in the report server database called Keys whch contains details of these intances and i'm wondering if its safe to remove these via SQL commands without breaking reporting services on other machines.   As a side note: All this stems from the fact that when you uninstall Reporting Services, not all of the files / references are removed. So as a general word of warning, if you do an uninstall of RS2005, you'll need to make sure everything's gone before re-installing, throwing away old machines etc. These include folders in IIS and these old instances as mentioned above.  

multiple instances of report manager VS multiple users

Hello, I want multiple users to access same report or different reports through report manager for a report server. Will the scenario of opening multiple windows of report manager on same machine and execute reports from all windows simultaneously mean same as multiple users accessing the reports at the same time? If not, then how should I generate the scenario of multiple users? Regards.

Can I have two instances (SQL 2005 - 2008) at the same server?

Hello, I have a Windows 2008 R2 with sql server 2005 x64. I would like to have both instances (SQL server 2005 x64 and 2008 x64) at the same server, each one having its own databases. Is the possible? What should I pay attention to? Thank youChristos

SQL Express instances

Please is there a way of locating where the instance names are stored. I have a problem in that I only want to use the default instance name but I cannot do that as a failed installation has left that value as in use. If I try to use a specified name I get errors that do not allow me to install the full packge. I have  tried ridding the registry of any reference to SQLEXPRESS, but the installation program still finds it as being in use. I've looked in hiiden files but I cannot find where it is. Any help would be appreciated.   Regards Keith Moss

Can not connect to SQL 2005 Instances from Client

Dear Experts I have a problem. I am not able to connect to Remote SQL Server instances from my PC. Though some of my team members are able to connect to the Instances without any problem. We have tried with all the below options and no joy. 1. We tried connecting, with the IP Address, like IP\<ServerInstance>, Port# 2. Added the IP address to Host file with the network address and tried, like <WINServerName>.<networkaddress>\<ServerInstance>, Port#, even without the Port#. 3. Tried to create an ODBC DSN, why this because, this had resolved the issue some times. Thought will help, but didn't work out. After all these, whenever we tried to connect to the server, we received the below error message. Error Message : Can not connect to <WINSERVER>.NetworkAddress\<DBInstance> A network-related or instance-specific error occured 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 :TCP Provider, error:0 - No such Host is known) (Microsoft SQL Server, Error - 11001). Kindly help to resolve this issue. I have been strugling since quite some time. Regard Deepak

How to use single windows service to host multiple WCF Services instances (Each instance of WCF is i

How to use single windows service to host multiple WCF Services. I have a mutiple instance of same WCF service in different folder, each instance has unique service name and port. WCFService has reference to Reg-Free COM Reference, i have Native.WCFService.manifest in each folder. Ex: WCFService1 is in "C:\WCFService01\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config WCFService2 is in "C:\WCFService02\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config Now i need host above services from single Windows Service. I am trying to create AppDomain for each above WCFService Instance from Windows Service and then host. Its working if i register COM dll in the server using regsvr32, but when i un register COM dll, i am getting unable to load COM component .... This looks like AppDomain is not loading COM DLL and Manifest files. Its looks strange but we need it in this way because we have production and test environment in the same server. Everything works fine if create a seperate Windows Service for each WCFService Instance, but my manager wants single Windows Service :). Any help whould be really appreciated.  ravi kumar reddy

How do I set PrimitiveDataProperties Value in the Workflow DurableInstancing.Instances Table

Hi, I'm simply trying to persist my Variables (or designated Variables) from my Workflow and I came across this article (http://msdn.microsoft.com/en-us/library/ee960223.aspx) on how to read the Values from the PrimitiveDataProperties Column in the DurableInstancing.InstancesTable, but I can't seem to find any documenation on how to save the Variables to this Column.  I thought my Variables would automatically save into the PrimitiveDataProperties Column after persisting, but it does not. I only find articles about using Promotable Properties or Tracking Participants in order to get Data out of a Workflow Instance, but both require configuration and/or custom Views in the Persistence Database, etc.  I simply just want to have my Variables persisteced when I use the PersistActivity and  then be able to read them at a later time. Thanks Devaron Ruggiero

How to install TDP Agent and its configuration on the SQL instances?

Hi,   How to install TDP Agent and its configuration on the SQL instances? any helpful link? Great thanksHelen

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