SQL Server Agent proxy accounts were created for this very reason. You can read more about them in Books Online: http://msdn2.microsoft.com/en-us/library/ms189064.aspx

Cheers,

Dan

This is the best source for comparing features between editions: http://msdn2.microsoft.com/en-us/library/ms143761.aspx

Hi Eric,

It's true that Database Snapshots are only available in Enterprise edition. I'll have someone look at the feature comparison sheet and make sure it's clear. I can say the...

I'm not familiar with configuring Cisco firewalls. However, I can conceptually tell you what to do. The default SQL Server instance listens on port 1433, the named instanace (SQLExpress) in your...

Sorry for the incomplete answer. Take a look at the following blog entry: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Cheers,

Dan

You'll ned to start the SQLBrowser service on the server. You can do this from "SQL Server Configuration Manager". Then you'll be able to connect using 'serverIP'\SQLExpress

You can submit feedback directly to the SQL Server team @: https://connect.microsoft.com/SQLServer/Feedback

Cheers,

Dan

SQL Server Express doesn't include Analysis Services (OLAP). This is what you'll want to install:

1) SQL Server 2005 Developer/Workgroup/Standard/Enterprise Edition

a) Database Services

b) Analysis Services

c) Reporting Services

d) Management Studio (includes profiler...

Hi Mike, what are you trying to connect from? Enterprise Manager, SQL Server Management Studio, an ASP.net application, etc.?

SQL2005 was probably installed as a default instance (instance name = MSSQLSERVER). SQL2000 was then had to be installed as a named instance (instance name = foo). When you connect...

That functionality was removed in SQL Server 2005. In SQL Server 2000 it was FYI only, the server didn't use the information for anything.

Cheers,

Dan

Here is a KB for configuring remote connections: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Cheers,

Dan

Here's another thing to look at that can impact start-up time: http://blogs.msdn.com/dtjones/archive/2006/08/23/714738.aspx

Cheers,

Dan

In Management Studio when you select a folder in the Object Explorer (e.g. Tables) you should see a "Summary" window. If not select the View menu and select Summary or...

I suggest you post to one of the following forums: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=5&SiteID=1

to get an answer more quickly post what error msg you're getting.