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.
| Author |
Topic |
|
JeffInTexas
Starting Member
7 Posts |
 Posted - 2011-12-13 : 12:04:23
|
| Hi, all. I am a little lost here. I downloaded Adventureworks LT 2008R2 and it is installed in my server, Jeff-PC\SQLEXPRESS.I use C# to go and add the AW LT database, and it days I don't have permission. I thought C# was just using my current Windows user-id, which is Jeff-PC\Jeff. I am using Windows Login Authentication. In Server Studio, when I login as Jeff-PC\SQLEXPRESS using Windows Authentication, I can access the database just fine. |
|
|
JeffInTexas
Starting Member
7 Posts |
Posted - 2011-12-13 : 12:10:01
|
| Also, I checked my Log-Ins for the Server, and Jeff-PC is mapped to AdventureWorks with user=dbo and schema =dbo.In the AdventureWorks security, user dbo is set up having default schema dbo. |
 |
|
|
JeffInTexas
Starting Member
7 Posts |
Posted - 2011-12-13 : 17:27:04
|
| This is still vexing me. Maybe instead of trying to solve my particular issue with this particular install, someone can tell me how to set up users, schemas and roles. The reason I ask it this way is because I created another db, called Test, and it is not accessible from Visual Studio, either. "Permission denied."I'm the only guy on a stand-alone computer, named Jeff-PC. My user name on my computer is Jeff. How would I set this up on a newly-created database that I create in Server Solution Explorer? |
|
|
|
|
|
|
|
|
Lost trying access to AdventureWorks from app