Upgrading From SQL 2000 A few questions.

Hi All,

Not sure if this is the most appropriate group to ask this, so appologies if
its in the wrong place, anyhow!

Currently, we are running VS2003, SQL Server 2003 and have implemented a
number of reports using the embedded Crystal Reports Version 9. Although
this works, we want to get our systems up to date and convert the
application to use ASP.NET 2.0 and Sql Server 2005 to make use of the
reporting services.

My Questions.

1.) I use a custom solution to prevent people accessing my reports
currently, by coding the form not to allow users who dont appear in my
access control table for reports. I was wondering what kind of security
facilities are available in SQL 2005 to allow me to do this ? I dont want it
based on Windows NT Group membership.

2.) Can you run SQL 2000 and 2005 side by side ( from a migration point of
view )

3.) If 2 is "YES", is it possible to mirror a SQL 2000 server database onto
the 2005 servier so I can do development on the 2005 server configuration
before I switch users over ?


4.) When I look at the licencing costs, they refer to number of users. In
the ASP.NET evnvironment, does the ASPNET account act as one of those user

5.) Finally, can you still access SQL 2005 with the SQL server username and
password like you can in SQL 2000?

Thanks for your help







--
Goofy

> 1.) I use a custom solution to prevent people accessing my reports
> currently, by coding the form not to allow users who dont appear in my
> access control table for reports. I was wondering what kind of security
> facilities are available in SQL 2005 to allow me to do this ? I dont want
> it based on Windows NT Group membership.

For server-based reports, the RS security model allows you to create roles
and add users to roles. With local reports, your application needs to take
care of report security and providing data to the report.

> 2.) Can you run SQL 2000 and 2005 side by side ( from a migration point of
> view )

Yes, but one needs to be a named instance. Note that you cannot easily
change a named instance to default or visa versa after the migration.

> 3.) If 2 is "YES", is it possible to mirror a SQL 2000 server database
> onto the 2005 servier so I can do development on the 2005 server
> configuration before I switch users over ?

I'm not sure I fully understand your requirements but you can restore a SQL
2000 database to SQL 2005 and perform development under SQL 2005 until you
are ready to switch. Personally, I would treat this like a normal
development project. When you are ready to go live, restore the database to
SQL 2005 and then run the same upgrade scripts you applied during
development.

> 4.) When I look at the licencing costs, they refer to number of users. In
> the ASP.NET evnvironment, does the ASPNET account act as one of those user

It's best to ask Microsoft directly regarding licensing questions.
Generally speaking, you need to use per-processor licensing if your ASP.NET
application servers anonymous internet users. Also, licensing varies by SQL
Server edition. See http://www.microsoft.com/sql/howtobuy/faq.mspx.

> 5.) Finally, can you still access SQL 2005 with the SQL server username
> and password like you can in SQL 2000?

Yes. Depending on the OS, you can also enforce password policies for
standard SQL Server login.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Goofy" wrote in message

> Hi All,
>
> Not sure if this is the most appropriate group to ask this, so appologies
> if its in the wrong place, anyhow!
>
> Currently, we are running VS2003, SQL Server 2003 and have implemented a
> number of reports using the embedded Crystal Reports Version 9. Although
> this works, we want to get our systems up to date and convert the
> application to use ASP.NET 2.0 and Sql Server 2005 to make use of the
> reporting services.
>
> My Questions.
>
> 1.) I use a custom solution to prevent people accessing my reports
> currently, by coding the form not to allow users who dont appear in my
> access control table for reports. I was wondering what kind of security
> facilities are available in SQL 2005 to allow me to do this ? I dont want
> it based on Windows NT Group membership.
>
> 2.) Can you run SQL 2000 and 2005 side by side ( from a migration point of
> view )
>
> 3.) If 2 is "YES", is it possible to mirror a SQL 2000 server database
> onto the 2005 servier so I can do development on the 2005 server
> configuration before I switch users over ?
>
>
> 4.) When I look at the licencing costs, they refer to number of users. In
> the ASP.NET evnvironment, does the ASPNET account act as one of those user
>
> 5.) Finally, can you still access SQL 2005 with the SQL server username
> and password like you can in SQL 2000?
>
> Thanks for your help
>
>
>
>
>
>
>
> --
> Goofy
>