No Local instance with SQLServer2005 Dev. Ed.

RLN

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

Oct 19 '06 #1

Subscribe Reply

5451

Dan Guzman

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" <rl************ ***@yahoo.comwr ote in message
news:11******** **************@ b28g2000cwb.goo glegroups.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.

Oct 20 '06 #2

RLN

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" <rl************ ***@yahoo.comwr ote in message
news:11******** **************@ b28g2000cwb.goo glegroups.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.

Nov 10 '06 #3

Erland Sommarskog

RLN (rl************ ***@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, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 10 '06 #4

Similar topics

4226

qualified and unqualified local elements (was: My schema validation is not working?)

by: C. M. Sperberg-McQueen | last post by:

wooks (wookiz@hotmail.com) wrote: > <?xml version='1.0'?> > <userlogin xmlns="urn:faster:userlogin" > xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'> > <login>mick</login> > <password>brown</password> > </userlogin> > Above is my schema instance.

.NET Framework

2973

Can't register local instance of SQL Server on local server PLUS

by: war_wheelan | last post by:

I have two servers running SQL Server on the same network and I am receiving errors registering the various instances as follows: SERVER1 tried to register the local instance (by netname, ip address and local) ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen | Connect() SERVER1 trying to register Server2's default instance (by netname, ip address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER

Microsoft SQL Server

2210

Local variables - quick question

by: Stefan Turalski \(stic\) | last post by:

Hi, I done sth like this: for(int i=0; i<10; i++) {...} and after this local declaration of i variable I try to inicialize int i=0;

C# / C Sharp

7559

Can't use 'local' to find sql server instances on local machine

by: karim | last post by:

My computer (connected to a domain) is having trouble connecting to the local MSDE when using 'local' or '(local)' as server name. The only way I can connect to server through Visual Studio or DTS in Enterprise manager is when using domainname\localcomputername format. Also when I try to install the starter kits from asp.net, the installer in each kit fails to find sql server instances. I am pretty sure it's related to fact the installer is...

ASP.NET

1266

Ridiculously Slow SqlServer2005 Sorting?

by: Mark Olbert | last post by:

Why does the following simple query against an SqlServer2005 table in an ASPNET2 website returning less than 10 rows: SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1 take no time at all (less than 1 second) yet the following sorted query against the same table (same number of returned rows): SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1 ORDER BY seq_num

ASP.NET

7241

Send Sms From SQLServer2005 to MobilePhone

by: Vinayagamurthy | last post by:

If it is possiable to send an SMS from SQLServer2005 to MobilePhone using any extended stored Procedures. Otherwise we can able to create any Stored Procedures for sending sms.

Microsoft SQL Server

3232

SqlServer2005: Transfer Sql Server Objects

by: Mark Olbert | last post by:

I'm looking for help in getting the Transfer Sql Server Objects task to work. The goal is to transfer the tables, views, sprocs, udfs from a SqlServer 2000 database to a Sql Server 2005 database. When I set the task up and run it, it fails complaining about an invalid foreign key relation. The relation in question is valid, and used in the current production environment under SS2000, so I think the real problem is something else. I've seen...

Microsoft SQL Server

7331

How to copy data from a table in one database to another database using sqlserver2005

by: yasinirshad | last post by:

HI, Can anyone tel me How to copy data from a table in one database to a table in another database using sqlserver2005. Thanks in advance.

Microsoft SQL Server

1908

migrated from sqlserver2005 to mysql

by: kkshansid | last post by:

kindly help me to provide important link as i migrated from sqlserver2005 to mysql sqlserver offers many facilities such as easy importexport from sqlserver to any formate access excel etc copy paste data to database query designer to design query easily but i can not to any of the works in mysql

MySQL Database

9568

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9398

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10007

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9832

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8831

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7375

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5419

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3924

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General