troubleshooting Question

User Login Name grayed out

Avatar of yanci1179
yanci1179 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
2 Comments1 Solution554 ViewsLast Modified:
Okay I set up the users for sql and I do the following

user:  generalUser
schemaName: genaralSchema

I create a user in the database
UserName: generalUser
LoginName: generalUser
DefaultSchema: generalSchema

It takes the changes but when I go back defaultSchema is set back to dbo.  Why can't it stay as generalSchema for the default schema?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros