|
|
Posted by RLN on 11/10/06 20:05
Dan,
Please accept my 2 apologies; first for a late reply, and second if I
am using SQL-Server terms incorrectly.
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.
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.
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.
I hope this clarifies my original request.
Dan Guzman wrote:
> > My problem is I cannot register a local database on the local drive for
> > testing/education purposes.
>
> I'm not sure what you mean by 'register' a local database. A database can
> be created with CREATE DATABASE (including attach) or RESTORE.
>
> > There are a couple of small databases that are in development in our
> > group and I need to work on when offline from the network.
>
> I suggest you create a backup of the desired databases and then restore.
> You can use SQL Server Management Studio for this.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "RLN" <rlntemp-newsgroup@yahoo.com> wrote in message
> news:1161270087.986650.261700@b28g2000cwb.googlegroups.com...
> > (New to SQL Server Installs)
> >
> > I installed SQL Server 2005 Developer Edition on a WinXP-SP2
> > workstation and can see some enterprise databases on the network just
> > fine.
> >
> > My problem is I cannot register a local database on the local drive for
> > testing/education purposes.
> > (I accepted all of the defaults on the install and thought all was
> > well.)
> >
> > There are a couple of small databases that are in development in our
> > group and I need to work on when offline from the network.
> >
> > Short of uninstalling the whole product and doing it over, what steps
> > can I take to remedy this so I will be able to work with DB's locally?
> >
> > Thanks.
> >
Navigation:
[Reply to this message]
|