Hi,

SQL 2005 Enterprise edition is not supported in Win XP machines. You can refer the below link for supported operating systems.

Hardware and Software Requirements for Installing SQL Server 2005

Hi SQLServerCentral,

Have you enabled Remote connections under surface area configuration??? If not use the below link

How to enable remote connections in SQL2005

You can also check this blog SQL Server Express...

Refer the below link

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290058

I think this may help you.

As you...

Try the below connection string

aspnet_regsql -S \SQLEXPRESS -E -A all -d

the -S option should be as . So pls use your servername before the instance name

Hi,

You can add the package yourself after connecting to integration services.

Connect to integration services.

Expand Stored packages

Right click on MSDB folder and click on "Import package"

Follow the onscreen option to import...

By connecting above, you can see the list of packages available and execute them.

If you need to Edit or view the package content, then you should use BIDS (click run-->...

Through which authentication mode you are connecting to the server.

If you are using windows authentication mode

1.) osql -E -Sservername

If you are using sql authentication mode

2.) 1.) osql -Sservername -Uusername -...

Hi,

While connecting to the server through SSMS, In the "server type" drop down list select Integration services and provide the necessary authentication.

Then connect to the service and you can see...

Im not sure, but storing audio files in sql server 2000 is not supported.

You can do the following

Store the audio files into a folder (eg: D:\songs)

Then store the filename and...

Hi,

Im not sure how it allocate CPU, but i can see in most of the cases like this it is utilizing from CPU 0 to CPU 3.

Yes you can assign...

Try restore using restore command.

Restore

Refer the below link, this may help you.

Moving system databases

You can try out the suggestion given by Steve.

After attaching in mirror take a tlog backup of the database from principal server and restore with standby option in the...

Yes the dbid remains same for all version