Firstly run upgrade advisor to make sure all of your applications are going to be compatible with SQL 2008r2.

There are many things to consider when deciding on instances for consolidation,...

The DNS option (create a cname record to the new server, make sure you rename your old server as well:-) ) is a good shout also providing you named...

You can setup a SQL Alias using a .reg file, here is a sample keep in mind that its from a windows XP client so may need to be modified...

SQL Server Audit would be an option, this may help http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx

Is the SQL Browser service running?

You can use SQL Aliases for this, we configure every SQL client using a standard .reg file that contains server\instance details, it doesn't cover every applications as there is stuff...

you can also export the trace definition to a .sql script and modify that in SSMS which may improve things also

see if this helps:

http://www.databasejournal.com/features/mssql/article.php/3887996/Determining-Object-Access-Using-SQL-Server-Profiler.htm

ok, you are using the D$ share, you need to be an admin account to use that, I guess there is a trust between the 2x domains if domain administrator...

Are both the share level and NTFS permissions set to everyone full control?

Great artical John, i'm probably not alone in thinking why haven't I done that already 🙂 (implementing it in DEV as I type), looking forward to your next post.

Mike

42 = Answer to the question

Don't see any issues here

ah, may have read that wrong sorry, are you looking for just the SQL Native Client, this can be installed just by running the sqlncli.msi from your installation media

you need client components - management tools