Viewing 15 posts - 631 through 645 (of 6,105 total)
If the Alias is the same as the server/server+instance name, try removing that alias and see if it resolves.
February 26, 2009 at 2:49 pm
Unless you have a bonafide functionality reason why you couldn't use trusted connections (such as a web server sitting in the DMZ, which wouldn't be on the domain), the recommendation...
February 26, 2009 at 2:31 pm
Is Shared Memory enabled as a protocol for the SQL Server instance? Is it enabled as a Client Protocol and listed first in the protocol order?
February 26, 2009 at 2:26 pm
The short answer is no, you can't put in anything to prevent them from querying the data if you want them to do those other things. However, you can monitor...
February 26, 2009 at 2:18 pm
Then it sounds like something is running to change it back. If it's a SQL Server 2008 server, check to see if there is a Policy that is checked at...
February 26, 2009 at 2:15 pm
Mike Levan (2/26/2009)
February 26, 2009 at 2:13 pm
Miz Zahan (2/26/2009)
In one server, I got SSPI error, etc. I solved this by setspn and now connections are using Kerberos
However, in the...
February 26, 2009 at 2:10 pm
Video (works in SQL Server 2008 as well):
How to recover from being locked out of a SQL Server 2005 database
Basically you stop SQL Server. You restart it in single user...
February 26, 2009 at 2:06 pm
It's not impossible. You just can't perform the operation in reverse. It's like if you put a piece of paper through a high speed shredder. You aren't going to be...
February 25, 2009 at 2:00 pm
There have been reports of it changing when SP3 was applied and I saw another post here on SSC about the latest security update. Is it a consistent thing? Can...
February 25, 2009 at 1:56 pm
Posted it as a blog post so it would be easier to find in the future. This works for SQL Server 2005 and above.
February 24, 2009 at 2:56 pm
SQL Server MVP Aaron Bertrand has posted about seeing this behavior when installing SQL Server 2005 SP3:
My latest SP3 experiences - two thumbs acting like divining rods
Not seeing a connect...
February 23, 2009 at 9:54 am
Is this true of every database? Also check to see if the user has CONTROL DATABASE rights by querying sys.database_permissions. If the permissions are implicit (coming from the server level),...
February 23, 2009 at 9:43 am
If the only Windows group was BUILTIN\Administrators, this is a Windows group that is local to the physical server. In that case, being in a different domain shouldn't matter at...
February 22, 2009 at 5:39 pm
That should work. But if you're using a local account, what is generating the SSPI errors? SQL Agent trying to start up and connect or the jobs themselves when they...
February 22, 2009 at 5:32 pm
Viewing 15 posts - 631 through 645 (of 6,105 total)