|
|
Posted by Erland Sommarskog on 11/10/06 23:10
RLN (rlntemp-newsgroup@yahoo.com) writes:
> On a 2nd test box (WinXP-SP2) I have Sql Server 2005 Developer Edition
> installed.
>
> What works:
> -When I launch Mgmt Studio, I am able to connect to an enterprise SQL
> Server box successfully on our network.
> -In Mgmt Studio, when I click on "View/Registered Servers", I can see
> "W4082107/test". This is my test box. I am under the impression that
> "W4082107/test" is a "local" SQL Server where I can copy sample
> databases off of the network and compose and work with copies of
> Northwind, etc.
Yes and no. You can backup a database on the big SQL Server, and
restore the database on your machine. But this presumes that there
is a network share somewhere, but both you and SQL Server can access.
You can also use the Copy Database Wizard to copy a database with the
SMO method, which copies the database object by object. But CDW is
very buggy, and may not copy everything.
> What does not work:
> -I am not able to have a local instance of SQL server working on my
> local drive to do some practice work with SQL Server.
In what way does it not work? Since you provide no information, I
will ask a couple of basic questions:
* You are certain that you installed the Database Engine and not just
only the tools?
* If so, have you ensured that SQL Server is running? Check this in the
SQL Configuration Manager.
* If it is running, do you connect to it properly. I assume that W4082107
is your workstation. The /test should probably be \test, if you have
installed SQL 2005 as a named instance. You can view the instance
names in the Configuration Manager.
> I'll take a look on MSDN, TechNet and the MSKB for a page (maybe a
> 'step-by-step') that references setting up a local instance of SQL
> Server when it is working with the Enterprise servers just fine. I
> thought I could install SQLServer Express to get my local databases to
> work, but MS says the Developer Edition and Express cannot exist on the
> same box.
That is not correct. It's perfectly possible to have instance of both
Developer and Expres Edition on the same box. What is not possible is
to install SQL Server Management Studio Express if you have the big
Mgmt Studio installed and vice versa.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|