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
No comments:
Post a Comment