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: Today @ 5:56 AM
Points: 525, Visits: 1,004
HI to all ,
windows user is created and unable to connect to sqlserver management studio



Thanks & Regards
NAGA.ROHITKUMAR
Post #1384484
Posted Wednesday, November 14, 2012 3:53 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,375, Visits: 6,472
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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 489, Visits: 2,142
You say the windows user is created but have you created a SQL Server login as well?

-----------------------------------
http://www.SQL4n00bs.com
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: Today @ 5:56 AM
Points: 525, Visits: 1,004
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 & Regards
NAGA.ROHITKUMAR
Post #1384556
Posted Wednesday, November 14, 2012 5:38 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,375, Visits: 6,472
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: Today @ 5:23 AM
Points: 11,638, Visits: 27,715
--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: Today @ 5:23 AM
Points: 11,638, Visits: 27,715
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