As indicated by the KB article, this sort of solution isn't generally recommended. What our DBAs do to get around this issue is they have large USB hard drives, which...

DrewTheEngineer (10/25/2007)

---

To all: Is it possible to install only SSMS from the SQL Server 2005 installation disk? We need to provide SSMS to about 30 users via Citrix, and...

Two places to check:

The first is the LOG directory under where SQL Server is installed. See if there is a recent log that was started at about the same time...

The issue here is the logs can't be restored as long as there are active connections into the database. Replication may be a better option.

You can configure SSRS in a NLB cluster or you can put it into a web farm with a hardware load balancer. We've done the latter. This assumes the database...

Matt Miller (10/25/2007)

---

SSMS given to an unqualified user (even with only read capability to the appropriate tables) is like a Denial of Service attack in a box. I don't...

The information is found in Books Online, which is Microsoft SQL Server's documentation. It usually installs with the client tools and/or a server install.

You said SQL Server 2003. If...

sp_unsetapprole assumes you already captured the original security context in a cookie. In the example you gave, where the connection already had an app role set, that's not what you...

I don't think there is anything natively within PHP which will accomplish this. You may have to write a custom routine or use a third party product. However, if the...

Did SQL Server start? If not, what errors are present in the application and system event logs related to SQL Server?

If SQL Server 2005, use SQL Server Configuration Manager to make the change. You'll need to change the password on the domain first.

Also, if you have anywhere else where that...

If SSRS and the database engine are on the same server, it's likely a timing issue. The SSRS service is starting up before the database engine is ready and the...

In the LOG directory, there should be SQL Profiler traces which are created by default with SQL Server 2005 to track this sort of thing. You might be able to...

This is a networking issue, not a SQL Server issue. What it means, basically, is that your RAS/VPN server isn't providing an IP address. If you were connecting on a...

Do you have any systems which handle password change? Or do all of your users use CTRL+ALT+DEL? If the former, perhaps it can be extended.