Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server 2005 Interview Questions > Can not have a registration server

:: Categories ::

Interview Question in SQL Server 2005


 

Interview Question :: Can not have a registration server


Hi, I am studying how to use MS SQL2005 from SQL server tutorial 2005. When I try to do a registration server, I receive a erro 26. I have 3 questions to ask.

When I installed the MS SQL2005 for the first time, I had 2  SQL servers:
    1. the MS SQLExpress and MS SQL2005. I did not want to install SQLExpress but it is in my computer. Please explain why it is there... 
    2. When I try to do registration server, from Database engine -> New -> Registration Server, the new server registration display, from server Name drop down list box, there is only one server display is (local)\SQLEXPRESS. I can register to this one the database that I have, but I need is (local)\MSSQL2005. But where is it.
    3. The database AdventurWorks.mdf is located in: C:\Program Files\Microsoft SQL Server\90\Tools\Samples and I believe the database is for MS SQL2005. I have to copy this database to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data for MS SQLEXPRESS.
 Would you let me know why and how to connect to MS SQL2005 instead of SQEXPRESS server.
Thanks
Answers to "Can not have a registration server"
RE: Can not have a registration server

I want to sqlserver 2005(387) questions and answers send my gmail id: ganeshanmsc@gmail.com


 
Vote for this answer ::  
RE: Can not have a registration server

Ans 1 - If you would have installed Microsoft Visual Studio 2005 earlier Ms SQL Server 2005 Express edition is installed by default with it.


Ans 2 - Please analyze if the installation of Microsoft SQL Server 2005 is correcly done. At most there can be only one default instance of SQL Server installed on the PC, there can be many named instances though. Try installing Microsoft SQL Server Named instance. You will be able to find out the orther server too.


Ans 3- Once you get logged in to SQL Server you can attach the database files to the database. Click on the Database Engine -> Right Click on Database -> Click on Attach database. Go to the files where the Adventure Works database is located. Select it. Adventure Works database will be ready to be used.


 


Please let me know incase of any queries.


 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License