Viewing 15 posts - 721 through 735 (of 6,105 total)
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...
January 23, 2009 at 12:10 pm
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...
January 23, 2009 at 11:53 am
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...
January 23, 2009 at 11:49 am
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...
January 23, 2009 at 9:35 am
Jack Corbett (1/23/2009)
K. Brian Kelley (1/23/2009)
Jack Corbett (1/23/2009)
K. Brian Kelley (1/23/2009)
January 23, 2009 at 9:19 am
Steve Hindle (1/23/2009)
Thanks.Where do I run the SETSPN -L command? At the command prompt?
Yes. However, if you haven't already, you may need to install the Support or Resource Kit tools....
January 23, 2009 at 9:17 am
So you moved the application and database (both) from one server to another? Is that correct?
January 23, 2009 at 9:09 am
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...
January 23, 2009 at 9:04 am
Jack Corbett (1/23/2009)
K. Brian Kelley (1/23/2009)
January 23, 2009 at 9:02 am
Trusted Connection = Windows login
Is the SQL Server on the same server as the IIS server where your ASP.NET application is running?
January 23, 2009 at 8:57 am
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...
January 23, 2009 at 8:55 am
MarkusB (1/23/2009)
In SQL 2005 SP2 or higher you can also create a Login trigger to log the logon event into a table.
You can, but if something were to happen to...
January 23, 2009 at 6:12 am
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...
January 22, 2009 at 7:06 pm
GilaMonster (1/22/2009)
Network admins at my previous company didn't allow any of those to be used anywhere.
This is one positive towards auditors. In some cases, even on the trusted network, we've...
January 22, 2009 at 2:05 pm
GilaMonster (1/22/2009)
K. Brian Kelley (1/22/2009)
Sorry, folks, but we have had solutions to prevent unencrypted data flowing across the data into SQL Server. 🙂
We have em. The question of who uses...
January 22, 2009 at 1:05 pm
Viewing 15 posts - 721 through 735 (of 6,105 total)