.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

MIgrate Registered Servers

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
My current machine is Win XP with SQL 2005 SP3 (32 bit) on it and I got a new maching with Windows 7 (64 bit) and installed SQL 2008 R2.  I read an article on how tr transfer my registered servers by copying the RegSrvr.ml file into AppData --> Roaming --> Microsoft --> Microsoft SQL Server --> 100 --> Tools --> Shell on my new computer and it still is not picking them up.  Does anyone know how I can get my registered servers from my old machine to my new machine

View Complete Post

More Related Resource Links

Unhandled Exception with registered servers in SQL 2008 64-Bit


I've just installed Windows 7 Ultimate, 64-bit.
I installed SQL 2008 and imported my registered servers (I exported them prior to install of Win-7).
The import failed.

Now I get the following error everytime I display registered servers.
I have uninstalled ALL version of SQL (2005, 2008) and deleted all directores from my computer (Program Files and Program Files (64) for Microsoft SQL Server).
However, the error continutes and renders the Resisterd Servers window totally usless (i.e. there are no entires in the tree list of server types so I cannot add any).

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Security.Cryptography.CryptographicException: Key not valid for use in specified state.

   at System.Security.Cryptography.ProtectedData.Unprotect(Byte[] encryptedData, Byte[] optionalEntropy, DataProtectionScope scope)
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.ProtectData(String input, Boolean encrypt)
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.get_SecureConnectionString()
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer.get_ConnectionString()
   at Microsoft.SqlServer.Management.RegisteredServers.Registered

SQL Management Studio - Quick Create Local Server Groups (Registered Servers)


We have a lot of SQL Servers, and sometimes we need to run ad hoc queries against multiple servers at once.


Usually I add each server that I want to query under Registered Servers > Local Server Groups in SQL Management Studio. However this can become time consuming.


What I want to achieve is to be able to import a large list of Servers at once, either via a script or xml builder that can achieve this for me.

Has anyone already done this, or can they point me in the right direction?


Migrate VBA To C# Word 2007


few Days Back I was Invloved In a project Which was Migration VBA in Office Word 2007 to C#..

I faced Loads Of Problem (I am was Very new to Word VBA)..

So I Decided To Migrate


the above VBA Book


I have Migrated Concept and collection Section...

Hope It help SomeBody Like Who was Struggeling to Migrate VBA to VSTO

Migrate an asp.net application from .NET 1.1 to .NET 2.0


Hi All,

does anybody know a way to convert a .NET 1.1 application to .NET 2.0 version? Basically I want the current application that opens and compiles in visual studio 2003 to open and compile in visual studio 2008.

Any help would be great!!


thanks in anticipation,


Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Taming the Stateless Beast: Managing Session State Across Servers on a Web Farm


Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.

John Papa

MSDN Magazine October 2000

Windows 2000: Asynchronous Method Calls Eliminate the Wait for COM Clients and Servers


Windows 2000 is the first version of COM to support asynchronous method calls, which permit clients to make nonblocking calls to COM objects and objects to process incoming calls without blocking the calling threads. COM clients benefit from asynchronous method calls because they can continue working while waiting for outbound calls to return. Objects benefit because they can queue incoming calls and service them from a thread pool. Our SieveClient and SieveServer sample apps demonstrate how to create and use asynchronous clients and servers in COM-based distributed applications.

Jeff Prosise

MSDN Magazine April 2000

"This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported"



I am getting the following error when i want to add a remote connection in the Server explorer:

'This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported'

what can be the problem. On Microsoft site i saw, you need to install following update: 'Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'

But i have a Microsft SQL Express Server 2005 SP3...

'Meter number is not registered ' error FedEx ship web service move to production



I want to integrate FedEx ship web service in my website. It works fine for local but for production it gives error. I changed test credentials by production credentials. also changed test url "https://gatewaybeta.fedex.com:443/webservices" by production url "https://gateway.fedex.com:443/webservices" But I am getting error that meter number is not registered. Please advice.

SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

Migrate DB + files outside DB into SharePoint using SSIS and scripts


Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....

So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.  

Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...

Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!



Custom Field Control 'not registered as safe'


Hi all,


my goal is to create a custom field control based on a custom field, to be part of a custom content type which derives from a publishing page. Also I want the custom field control to be part of a custom page layout which is associated with my custom content type.


I followed the steps from Patrick Tisseghems book 'Inside MOSS2007', which includes the following instructions:


  • Create and implement the following classes: CustomField, CustomFieldValue, CustomFieldControl. Sign them and deploy the assembly to the GAC.
  • Create a User Control Custom.ascx. Copy it to Controltemplates directory.
  • Create fldtypes_custom.xml and copy to 12\TEMPLATE\XML
  • Add <SafeControl /> entry to web.config

I did of all the above plus I created a page layout in SharePoint Designer which contains an instance of my CustomFieldControl.


When I create an instance of CustomPage (derived content type from Publishing Page, with extra field of type CustomField) with my custom page layout and add it to the Pages library of my Publishing site, everything seems to go fine. When i edit properties of the page with /Pages/Forms/EditForm.aspx I can even edit the custom field value trough the interface using mu custom field control! Everything seems to work perfectly!


But... this

how to consume the dll file which is registered in GAC, into my asp.net web application



i have created a strong name key to my dll file...and then i have added it to GAC.

In general, to add a .dll file in the solution explorer, right click -> add reference...

How should I refer the dll file registered in  GAC



How can i restrict the user to login only from the system which he registered from the Computer.

Hi,I am Kartheek. ASP.Net Web developer. I got one requirement regarding security.In my website, if one user registered from a computer, we have to allow  that user to be able to access the site from that computer only. If he try to login from another system even in LAN, we have to deny the access.Please help me with this. Thanks in advance,Kartheek Challagundla.kartheekchk86@gmail.com

how to move SSAS applications between windows servers

Hi All, We have separate windows servers hosting production and development environments.  Each environment consists of MS SQL Server and SSAS, studios, etc.  What would be the best way to move MS SQL Server databases and SSAS objects from one server to another?  I have been looking for some import/export applications but have not been able to find anything. Thanks for any help, Thanks, Roscoe

msmdpump.dll not getting registered

I am using SSAS 2008 and I am getting error on registering msmdpump.dll using regsvr32 Error is "msmdpump.dll was loaded, but the DllRegisterServer entry point was not found". The file can not be rgistered" My machine is Win XP with IIS 5.1. I want to use SSAS from Java. I am going through steps mentioned on this link - http://www.matthewgodding.com/articles/2010/2/27/getting-data-from-sql-analysis-services-using-java-and-olap4.html I can not launch page http://localhost/olap/msmdpump.dll I get this error in firefox - <soap:Envelope> − <soap:Body> − <soap:Fault> <faultcode>XMLAnalysisError.0xc10e0002</faultcode> <faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring> − <detail> <Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/> </detail> </soap:Fault> </soap:Body> </soap:Envelope>  
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