August 18, 2010 at 9:25 am
Hi have a Stored procedure
which is having the option to create user like below
DECLARE @SQL NVARCHAR(1000);
SET @SQL = 'CREATE LOGIN ' + @UserName + ' WITH PASSWORD= ''TestUser123'',CHECK_POLICY = OFF'
EXECUTE(@SQL)
when Run the above statement in Query Analyzer it is not giving any error.
When i am calling through ASP.Net application it is giving error.
Even i tried Hardcode the user name like below in the procedure
CREATE LOGIN TESTUSER With PASSWORD = 'TestUser123' -- This is working in Query Analyzer but not working from the application.
The Error Message is
Password validation failed. The password does not meet Windows policy requirements because it is too short. User does not have permission to perform this action.
One Additional Information The Database is migrated from SQL server 2000 to 2005
Any Idea Please ?
August 18, 2010 at 11:11 am
Answered in here.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply