.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

Remove SQL2005 from domain and then add a new SQL2008 back using the same name?

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

We have an email complaince application using a SQL 2005 server which is part of the domain.  I want to build a new Windows 2008 / SQL 2008 server to replace the priginal SQL 2005.

Now to change the SQL connection within the application itself is a nightmare.  With this I am curious if I could first, shut down the compliance application so no data is going to the current DBs.  Next, backup these DBs and then shut down the current SQL 2005 server.

Now, build on new hardware a Windows / SQL 2008 server.  Go into AD and remove the original SQL2005 server and then simplay re add it using the same server name.  Once this is done, join the new 2008 server to the domain using the old server name.  Reload SQL and create the original security accounts.  Once this is done, create the databses and then restore using the backups.

Now the hope is that once this is all done, that I bring up the complaince application and it just connects to the new server and is happy as a clam.

Does this sound solid or am I looking to create other severe headaches by doing this and should just fight through the rebuilding SQL and then messing with the application to point it to the new server?



View Complete Post

More Related Resource Links

In a SQL2005 Reporting Subscription I need to revert the parameter back to the default value "overri

Hi, In a SQL2005 Reporting Subscription I need to revert the parameter back to the default value "override-default." This value was updated to a specific value and now I am unable to have the report updated daily with the new data.  Within Report Manager, drill into the specific report, click on the properites tab, and chose the second link on the left "Parameters."  For the value in question (DataID) someone unchecked the "Has Defalult" button.  This results in the "Use Default" check box being removed from the UI in the Subscription tab.  I can get the Use Defalut box back by entering a specific value in the 'defalut value' but the report runs against that one value (instead of updating daily.) Before the "Has Defalult" was unchecked, the Defalut Value is a buttton, which says "Override Defalut."  It is this 'button' that I am trying to get back. I've googled this and looked thru MS kb without luck.  (I think it maybe a matter of using the right language...) Thank you for your reply.   Victoria  

Does "Microsoft OLE DB Provider for SQL Server" get different versions for SQL2005 and SQL2008?

We know SQLServer OLE DB have two driver types: SQL Native Client and Microsoft OLE DB Provider. I know The former one have different versions for SQLServer2005 and SQLServer 2008 (SQLNCLI.DLL, SQLNCLI10.DLL), right? And for latter one, does it have different versions? I only got SQLOLEDB.dll under system32 folder, but have no idea whether it have different versions. Can some one help me?   Thanks Spring  

SQL2005 and SQL2008 installed on the same environment - Application problems connecting to SQL2005 d


We have an environment with SQL 2005 and SQL2008 instances - failover 2 node cluster 64 bit.

We installed a new web application and we cannot connect to the databases on the SQL2005 instance.

We are able to connect to the database using the same credentials used by the web site using a udl file and using SQL Management Studio. However, the web site tells that we do not have authorisation to access the web site.

I wonder whether there is something to do with the fact that we have the two SQL versions on the same environment.

We had a similar problem on another mixed environment. On that particular case the connection failed on a SSIS package. We tried the same package on a SQL2005 and the package ran.

If the mixture of the two versions is affecting new applications to connect to the databases, is there a way around to resolve this problem? Unfortunately, the environments contain live databases.

Thank you in advance for your help.

Infopath Question: XPath code to remove domain name from AccountID field in Person/Group Picker


I have an infopath email based submission form where I am using the Person/Group picker as a way for people to find people in the active directory to CC the form to. I was using the field "DisplayName" in the control and discovered that when you try to CC several employees, that it would disrupt the rules and you can't send the form.

I want to use the field "AccountID" but it includes the domain before the email alias (for ex. REDMOND\johndoe). Is there a formula code I could use to remove the domain from every email alias. Right now my CC formula is concat(SubmitterAlias, "; ", DisplayName)

Unable to connect Traditional VB6 Application to SQL2008 - After Upgrade from SQL2005



We have  VB6 application working and it uses ADO to connect to SQL2005.   We have upgraded server to SQL2008
Now VB6 application is unable to connect,  the Code Line object_ADOConnection.Open  Fails,  meaning it gets hung-up.

Any Directions what could be wrong or anything that needs to change in code.?


Slowness writing to database after upgrade from SQL2005 to SQL2008/R2



We have recently upgraded our SQL server and moved from SQL2005 to SQL2008/R2.

A program we use continuously inserts rows of data into a table in the database.

The process used to write approximately 200 lines of data per second, but since upgrading it will only write one line per second.

We have tried to mirror the configuration of the server as accurately as possible, but does anyone know of a setting that could be causing the data to be written so slowly?

Kind Regards,


SQL Server Domain membership remove/add


OS = Windows 2008 R2 64 bit

SQL Server 2008 R2 64 bit

SQL server is installed with added feature of Reporting and Analysis services. The Services are running under a domain account.

We need to remove and re-add the server from the domain due to it continually failing authentication.

Are there any problems or known issues in doing this? Will SQL services still function OK?



Drop down remove selected item on post back


Hi ,i have a place order form and i have a drop down list that contains list of items

whenever i add item (for example item1)  to place order and click add another item button,

i need to remove  (item1 ) from drop down list to avoid dupplicate insert in sql table

or mayb need to fill the drop down but without (item1) cause i already selected it

it s kind of validation

i am using sql datasource to fill the drop down list of items

Post back puzzle


Hi, I have a website where the user makes a selection from a combo box and it then fills a couple text boxes with text based upon the selection. I'm sure as you know it could take a second for the text to appear in the text box due to the post back. I know there is no way to make it instantanious, so what I would like to do it fill the text box with somthing like "Loading Info..." so the user does not type in it while the information is loading.

If you would like to see what I mean please go to this page: www.epiclinks.com/create.aspx and mess around with the combo boxes and You'll see what I mean.

What I would like to do is have it do a post back to write "Loading Info..." and then do another post back to fill it in based upon their selection. How would I do this?

I'm up for anything, so if you have a better solution than that please let me know.


Remove #Region from whole web site


Hi All,

I need to deliver source code to client and my boss need to remove all the comments and #region sections from the whole web site source code.

So is there any functionality available in visual studio 2010 or may be in an other 3rd party tool available to do so, which can remove all the #region from all over the source code ?

Otherwise my developers has to do donkey work.... :(( and I don't wish it. 

Any help or tips/tricks would be appreciated.


AutoGenerateSelectButton="False" ignored when using Domain Service


Crosspost from RIA Services forum: http://forums.silverlight.net/forums/t/196466.aspx

I'm creating a Dynamic Data application in VS2010 and have recently switched to using a Domain Service to give greater control over the data presented to the client. I've noticed that the AutoGenerate<Action>Button attributes on my GridView are being ignored. The presence of the Edit and Delete buttons appear to be contingent on the existence of Update and Delete methods on the partial classes autogenerated in the Domain Service, but i'm not seeing how to control the generation of the Select button. Is there a way to control this from within the Domain Service class?

Dynamic Data, Domain datasource, Poco and lookups


Mr. Edward,

Excuse my question but: it is necessary to involve in our projects something more than just Dynamic Data or should we make use of all other features available in VS2010 (which will make assume taht they had been left out of the Dynamic Data framework) like: wef, poco, azure, wcf, cloud, mvc, silverllight, ajax, odata, agile, workflow, etc.?

Sorry my ignorance, I'm just transcribing names as they come to my mind and of which I don't know anything about


Carlos Porras (El Salvador)

Pass ASP.NET membership identity object across domain?


I am trying to figure a way to SSO with ASP.NET membership and role model.

I can implement custom membership provider which consume web services hosting on a server.

With encryption of data. No problem.

But my question is, If I sign on a website with my provider, got my identity object on that application,

could I pass it to another website on another domain which use the same provider and by doing so, do not need to login again?

If this is possible, I am going to implement this solution. Please tell me what's your take on this.

How do I preserve __viewstate between cross domain posts or how do I get a __viewstate of a Remote S


Here is what I want to do:
I have a local site in which I want to display data from a remote site
Lets say: I want to display data of http://www.abc.com/Default.aspx on my localhost

Now Default.aspx requires some post-data which it sends to itself. Thus the __viewstate and __eventvalidation are posted back to it by itself. I want to directly post the data to Default.aspx from localhost without opening Default.aspx and display the Default.aspx's response on my localhost.

The WebApp on http://www.abc.com is configured for __eventvalidation i.e. I cannot post-data to it from my localhost without getting a __viewstate from it. I also have to post the current __viewstate of http://www.abc.com/Default.aspx to itself

How can I accomplish it?

How to authenticate local user usin ldap or non domain authentication



I created one application, and I need to authenticate local user. This user is the user who is login to his/her Personal Computer.. Main thing his that he/she does not in any DOMAIN... I want NON-DOMAIN authentication.. any how.... please help...

Security negotiation failed because the remote party did not send back a reply in a timely manner. T



Dear All i have created one simple service

like this

namespace WcfService2
        public class Service1 : IService1
        public string ShowEmpName(string strFirstName, string strLastName)
            return strFirstName + strLastName;

after executing in .net command promt i got 2 files

service.cs & output.config

after that i create one class file like this

namespace WcfService2
    public class clientcs

        static void Main(string[] args)
            Service1Client client = new Service1Client();
            string strResult = client.ShowEmpName("Pradeep", "Deokar");

Web deployment project - web.config section replacement does not add remove tag


I have a web application that is actually installed as a component of a third party site.  In some configurations, I need to remove certain connection strings and re-add them.  I'm replacing this web.config section with a xml file that includes the following:

      <remove name="MyOverridenConnection"/>
      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

For some reason the remove tag is left out during the substitution and I end up with the following in the installed config:

      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

Is there any way to issue removes in replaced sec

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