xp_cmdshell - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

xp_cmdshell

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-01-06 : 05:31:20

I am sysadmin in Dev sql server and I can run this sql in query analyser
EXEC master..xp_cmdshell @param

I have created a new login in Dev i.e. user 'TestUser' and pwd as 'password' and made it sysadmin
Now I want to test running the same above query but under a different login. But I can not login to query analyser with this user login
Do you know why please?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-06 : 14:29:46

why you cant login? did it throw any error?
Can tell how you tried to login? I hope you've enabled Mixed mode authentication

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-06 : 15:33:15

pebkap?

HOW did you create the new login?



USE [master]
GO
CREATE LOGIN [TestUser] WITH PASSWORD=N'password'
	, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'TestUser', @rolename = N'sysadmin'
GO

???

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-01-08 : 10:23:58

quote:
Originally posted by X002548

pebkap?

HOW did you create the new login?

USE [master]
GO
CREATE LOGIN [TestUser] WITH PASSWORD=N'password'
, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'TestUser', @rolename = N'sysadmin'
GO

Usin gthe wizard created the login and password and assigned it to the database with owner permission.
Thanks

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-08 : 11:30:15

Is mixed mode authentication enabled?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources