Browse by Tags

Solution - Login failed for user x. Reason Token based server access validation failed and error - 18456

Had a very bizarre situation yesterday where a local machine account couldn’t access SQL Server and was getting Login failed for user <user>. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <client ip>] along with Error...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 1 2011
The server principal '<domain>\User' already exists. But it doesn’t

Interesting little situation occurred today, the person I was working with was trying to add a login to a server and was getting the following error. “The server principal '<domain>\User' already exists” They were using a command like this and couldn’t figure out why they were getting the...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 18 2010
Copying logins to another server

I'm busy setting up a new server to replace our main live server and part of that is to get the logins copied over. The database users will come over when I restore the databases but I wanted to get the logins they relate to, with the same SIDs, passwords and other properties as they have on the...

Posted to DavidWimbush (Weblog) by DavidWimbush on Fri, Apr 9 2010
Avoid SQL Injection with Parameters

The best way to avoid SQL Injection is with parameters. With parameters you can’t get SQL Injection. You only get SQL Injection where you are building a SQL statement by concatenating your parameter values in with your SQL statement. Annoyingly many TSQL statements don’t take parameters, CREATE DATABASE...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Apr 5 2010
Makesafe script - set up security for developers

I worked yesterday on a script that is supposed to run on DEV database after it has been restored from production. This script adjusts configuration data and security in the database so developers can work safely on production data without compromising security policies. The original script has a long...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on Sat, Oct 24 2009
How to access SQL Server when you've forget the password

There is a little known feature of SQL Server 2005 is that when you start SQL Server in single user mode local administrators of the server have sysadmin access to the sql server. You may feel this a security concern, but if a user can get local admin of your server, and restart your service then having...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 22 2007

Page 1 of 1 (6 items)

SQL Server Blogs

Browse by Tags

Solution - Login failed for user x. Reason Token based server access validation failed and error - 18456

The server principal '<domain>\User' already exists. But it doesn’t

Copying logins to another server

Avoid SQL Injection with Parameters

Makesafe script - set up security for developers

How to access SQL Server when you've forget the password