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 !!!!

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 !!!!

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

How to set up security to SQL 2005 Reporting Service?

I have Sql 2005 server (SSAS, SSRS, Database)installed on my workstation running on Windows XP Pro. SP2 for development only. However I need to migrate the reports to a "Production" enviroment next month which is set up with two servers running on Windows 2003 Server, one will serve as Data Server with Sql 2005 server and SSAS installed on it and the other will serve as Report Server with Sql 2005 Reporting Service. My question is how to set up the IIS on the Report Server to allow users from the domain to access the Report Manager (the reporting Service is intend to set up as an "Intranet" tool for the users ie No Internet access to the reports). A "dumpy" user will be set up at the Report Server for the data connection to the remote Sql 2005 Server. Also how to implement the security on the individual folder in the Report Manager. Currently I have folders set up for the department and I want to set up security only allow people from those depts to access their folder/subfolders. How to set up security on folder and subfolders in Report Manager? Can I set the security on my Windows XP machine to test it before I roll it out to the Production servers? Thanks.

here is a microsoft link that talks about role based security in reporting services...

http://msdn2.microsoft.com/en-us/library/ms156014.aspx

hope this helps...good luck!