Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

windows user is created and unable to connect to sqlserver Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 2:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:23 AM
Points: 585, Visits: 1,295
HI to all ,
windows user is created and unable to connect to sqlserver management studio



Thanks
Naga.Rohitkumar
Post #1384484
Posted Wednesday, November 14, 2012 3:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 13,275, Visits: 11,062
How did you create the user?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384520
Posted Wednesday, November 14, 2012 3:59 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:54 AM
Points: 708, Visits: 3,290
You say the windows user is created but have you created a SQL Server login as well?

---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1384526
Posted Wednesday, November 14, 2012 5:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:23 AM
Points: 585, Visits: 1,295
windows id is created by windows team and by using sql administrator login i created sql login but some times it says unable to connect in this case what should i do

Thanks
Naga.Rohitkumar
Post #1384556
Posted Wednesday, November 14, 2012 5:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 13,275, Visits: 11,062
What kind of SQL login did you create?
Windows Authentication? SQL Server Authentication?

Did you enable it?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384570
Posted Wednesday, November 14, 2012 6:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:11 PM
Points: 12,905, Visits: 32,161
--deleted duplicate post.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1384583
Posted Wednesday, November 14, 2012 6:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:11 PM
Points: 12,905, Visits: 32,161
new users are at least a three step process:
create the user in Active directory (you said that was done)
create a login for the user in SQL Server(you said that was done)
Create a user in the database to match the login(missing?)
Assign the appropriate permissions/role so the user can access data(missing)

--creat the login for the Active Directory User
CREATE LOGIN [mydomain\NewUse] FROM WINDOWS;

--switch to the right database: if more than one database, repeat for each one
USE SandBox;
GO
--Create the user to match the login
CREATE USER [mydomain\NewUser] FROM LOGIN [mydomain\NewUser]

--assign permissions
--put the user in the correct permissions role
exec sp_addrolemember 'RoleAlreadyCreated', 'mydomain\NewUser'

--an example in case you don't have the role with the right permissions yet:
CREATE ROLE [AlmostOwners]
EXEC sp_addrolemember N'db_ddladmin', N'AlmostOwners'
EXEC sp_addrolemember N'db_datareader', N'AlmostOwners'
EXEC sp_addrolemember N'db_datawriter', N'AlmostOwners'
--can the users EXECUTE procedures? comment out if false
GRANT EXECUTE TO [AlmostOwners]
exec sp_addrolemember 'AlmostOwners', ' mydomain\NewUser'



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1384585
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse