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