Friday, March 23, 2012

how to setup local SQL Server 2005 DB

I installed 2005 Developer edition on a local workstation in our lab. I can connect to a network SQL Server with it just fine. But I do not have a local instance of SQL Server on this workstation.

How do I create a local instance of SQL Server? (box is WinXPPro-SP3)

After accepting the defaults for this installation, I noticed that there were no "local" instances of SQL server available, whereby I could go out and create my own test databases locally or copy a few tables from a production server over to my local box for testing. I'm looking through the books online and do not see (maybe I missed it) the steps to creating a local instance for setting up a workstaiton as a 'test' environment.

Assistance is appreciated.

RLN

Bummer to find that no one responded to this problem because its the same exact problem I'm having except that I have Standard edition installed on XPPro SP2

Anyone have any ideas on how I can set this up?

Thanks

|||

Hi,

i do not understand what you are try to achieve here!!!

Local Instance of SQL Server !? you may try installing SQL 2005 Developer Edition / SQL 2005 Express Edition on your Workstation and then you may restore backup of your production database or you may detach db on prod server copy .mdf and .ldf files to your workstation and attach it on your work station to work as local/test environment and attach your prod db again so that prod server is also up for use.

is this you are looking for!?

Hemantgiri S. Goswami

|||

I'm in the same situation.

In S2K you could only do this with personal edition so I guess it could be the same here....Express edition maybe?

But if there's any help out there I too would welcome any advice.

Thanks,
Eamon
Ireland

|||Have you refer my reply !!!!sql

No comments:

Post a Comment