Post reply

Help! Need basic installation with worry-free log-in

  • December 13, 2011 at 5:19 pm

    #251963

    I am trying to use the AdventureWorks sample db in Server Express 2008 R2 to do some C# coding in Visual Studio to write some database CRUD routines and learn.

    I can access the AW database just fine when I log in to Server Studio, but when I try, from Visual C# Studio, to access the database to model from it, it denies permission.

    Yet..... I am the only computer and the only user: Jeff-PC\Jeff

    The folks at SQL Team haven't been able to offer any advice yet.

    All I want is this what the title says: An installation that is worry free without all these hassles. Somehow, I must have Log-ins, users and schemas messed up, but I don't see how. Log-In is Jeff-PC\Jeff. User of AW database, dbo with schema dbo, is mapped to log-in. dbo has owner privileges.

    Any help would be VERY much appreciated. Thanks.

  • December 13, 2011 at 9:31 pm

    #1420987

    Have you tried creating a sql login (instead of using the Jef-PC\Jeff windows login). Give the newly created sql login sysadmin permissions on your instance and use that in your connection string of your C# code..

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 14, 2011 at 2:14 am

    #1421104

    I think you should search for video tutorials on google which will load lots of information required.

    I have seen some of the videos and they really work well. you will get an exact idea of how to do things.

    You may also prefer for youtube website.

    resume writing[/url] | examples of resumes[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply