Database mail expands the surface area of your SQL Server. If you aren't using it, it should be turned off. Then again, if you're relying on it in order to...

You are on SQL Server 2005, right? If so, first:

- Create a role. You can do this through SQL Server Management Studio's GUI.

- Make the ASPNET user account a member...

If the non-domain servers are on a different network segment or have to cross a firewall, etc., those would be where I'd start. If one group is working and another...

Then it's probably an out of synch login-user mapping. Each Windows account, to include ASPNET, has a SID (Security IDentifier) to identify it uniquely. When you go from one server...

Jack Corbett (1/23/2009)

---

K. Brian Kelley (1/23/2009)

---

Jack Corbett (1/23/2009)

---

K. Brian Kelley (1/23/2009)

---

And when you are coming through Named Pipes, it's dropping back to NTLM. Kerberos support for Named Pipes was introduced...

Yes. However, if you haven't already, you may need to install the Support or Resource Kit tools....

So you moved the application and database (both) from one server to another? Is that correct?

Do you have jobs within the domain which run at > 5 minutes? If so, are they experiencing the same problem? If not, can you set one up as a...

Jack Corbett (1/23/2009)

---

K. Brian Kelley (1/23/2009)

---

And when you are coming through Named Pipes, it's dropping back to NTLM. Kerberos support for Named Pipes was introduced in SQL Server 2008. It's...

Trusted Connection = Windows login

Is the SQL Server on the same server as the IIS server where your ASP.NET application is running?

There could be an SPN problem which is why Kerberos is failing. If you use SETSPN -L for the service account under which SQL Server is running, do you see...

You can, but if something were to happen to...

There is not a way to create new server roles, no. You can, in SQL Server 2005 and 2008, assign server level permissions to logins. So if your logins were...

This is one positive towards auditors. In some cases, even on the trusted network, we've...

GilaMonster (1/22/2009)

---

We have em. The question of who uses...