SQL: Access Denied even for Admins
Posted by (JavaScript must be enabled to view this email address) on Mon 09 Mar 2009
Occasionally you will find that your user account doesn’t have a default database associated with it, this will stop you logging into SQL using Windows Authentication regardless of being a local administrator.
To be able to log in do the following:
1. Create a local user (as you have administrative access this is fine)
2. Add the user to local administrators and to the SQL Server Users group something like this (SQLServer2005MSSQLUser$MACHINENAME$INSTANCENAME)
3. Restart the SQL Server
4. Log into the laptop as the new local user
5. Run SQL Server
6. Go to security and right click on the user account which does not have access to SQL Server and select properties
7. Set the default database as master
8. Set the user role as required
9. Ensure that the user has access to the correct databases
10. Click ok
11. Log out of the pc
12. Log in as the original user.
You will now have access to log into the SQL Server.
Your Comments
-
-
-
-
-
-
-
Commenting is not available in this section entry.Abercrombie & Fitch
Abercrombie
Abercrombie & Fitch clothes
Abercrombie Fitch
Abercrombie Fitch UK
Louis Vuitton
Louis Vuitton handbags
Louis Vuitton bags
Louis Vuitton outlet
Louis Vuitton uk
LV Handbags
LV bags
06451623
Posted by Mauro Masucci on 10/21 at 02:20 PM
will find that your user account doesn’t have a default database as of men’s Diesel clothes, view our extensive full range of Diesel clothing. Here at The Menswear Site,
Diesel Jeans and Diesel shirts
diesel jeans
uk diesel
diesel
diesel
Herve Leger
Herve sale
Herve Leger dresses
Herve Leger skirt
HerveLegersociated with it, this will stop you logging into SQL using Windows Authentication regardless of being a local
Posted by Mauro Masucci on 11/04 at 02:45 PM
unable to provision the project access website as it was failing with the error message:
Need evening dresses,or gowns? Formal evening dresses from dresses shop, evening gowns from dress4sale,Laundry and dress4sale
Wedding dresses
evening dresses
evening dresses sale
Dresses sale
Wide collection of prom dresses, evening dresses and gowns, cocktail dresses, summer dress, 2010 summer dresses,
little black dresses, beaded dresses
Abercrombie & Fitch
Abercrombie
Abercrombie & Fitch clothes
replica watches
Abercrombie Fitch
Abercrombie Fitch UK
¡°The Project Application exist
Posted by Mauro Masucci on 11/06 at 12:14 PM
we were unabletiffany co jewelry
tiffany & co
tiffany jewelry
Tiffany Necklaces
Tiffany Bracelets
Tiffany Earrings
Tiffany Rings
herve sale
Herve Leger
Herve Leger Dress
leger dress to provision the project
Posted by Mauro Masucci on 12/03 at 02:39 PM
I can’t believe how much of this I just wasn’t aware of. Thank you for bringing moreinformation to this topic for me. I’m truly grateful and really impressed.
celebrity lace wigs
cheap lace wigs
front lace wigs
full lace wigs
Posted by Mauro Masucci on 12/16 at 04:58 AM
Replica Watches
Omega Replica
Replica Rolex Watches
Best Replica Watches
Swiss Replica Watches
Fake Watches
Watch Replica
Rolex Replica
Tiffany Store
Tiffany Jewellery
Tiffany
Tiffany sale
Posted by Mauro Masucci on 12/20 at 08:52 AM
Party Dresses Beach Wedding Dresses White Wedding Dresses mother of the bride formal gowns, apparel, outfits in Austin, Texas. Discount modest mother of the groom dress in petite Informal Wedding Dresses Classic Wedding Dresses Fashion Wedding Dresses Elegant Wedding Dresses Sexy Wedding Dresses ordered 4 dresses to be used as bridesmaid dresses in a wedding. I have just received them and they are more beautiful than I imagined. The dresses were made with great skill and craftma Sweet Wedding Dresses Colored Wedding Dresses Red Wedding Dresses Wedding Dresses With Embellishment What fabric is this dress made Silk Wedding Dresses Corset Back Wedding Dresses
Posted by Mauro Masucci on 12/25 at 02:28 AM