We had 68 SQL Servers I just restore as needed based on the email and you should know 2000 did not have a separate security section with the database. ...

I am glad we had this conversation because I have been wondering why creating Backup Devices in the Master is needed in 2005 now I know why. I can...

You are talking about SQL Server Login and Database permissions and I am telling you in 2000 SP3a and below you could. However 2005 comes with many extra layers....

I have restored 2000 databases many times and it restore all the users, sometimes I get orphaned users I could edit the Master but it was a bank so I...

I think a restore of your backup will restore all your users login included because 2000 when I restore a database and see orphaned users I just delete the restore...

Your Vista must be Vista Ultimate or Business so IIS 7 can be configured for IIS 6 like in the first link below so you can install Reporting Services.

If you...

Your error tells me you are in x64 operating system so you have to tell me what version of SQL Server you are running x64 which 64bits or x86 which...

The OPENDATASOURCE and other features are disabled by default in SQL Server 2005 you need to go into SAC(surface area configuration) to enable it before your developer can use it....

Each service has it's own domain user account, which is part of the local windows group mentioned above.

The account cannot be used to run Replication or data automation because...

You getting back Not Null is really not important because only aggregate functions ignore nulls because the aggregates are created for scalar value but a SELECT returns table. But...

In SQL Server 2005 we use the Agent for data automation so you really cannot use a none admin account because if you use the Agent to run DTS/SSIS package...

In SQL Server 2005 the options are configurable in the create Full Text Index wizard automatic, manual or none because Full Text is not like the version in 2000 which...

The SQL Server Agent is off by default so you need to go into Configuration Manager and change that, you can also change the account because if you skip the...

I am glad I could help but I cannot understand how bugs are converted to depreciated features. I find it troubling that Microsoft is converting known issues to depreciated.

Goodluck with posting bugs because you may find your answer in the link below and most of what Microsoft says are depreciated are bugs I gave to the Reporting Services...