public class ben:harrell

January 15, 2007

Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)

Filed under: database, dba, errors, SQL Server 2005 — Tags: , , , , , , — benjamin harrell @ 8:28 pm

Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)

This error bugged the crap out of me tonight and I saw all kinds of crazy answers usually involving some sort of SQLCMD -blah -blah…i think this maybe the problem with command line happy developers/dbas but to make a long story short the fix is EASY and you will kick yourself for not trying this.

1.  click the options button if the options are not showing.

2.  click the connection properties tab if it is not active

3.  click on the Connect to database: dropdown

4.  type in the name of a database that still exists (ex. ‘master’)

5. connect!

I heard all kinds of rants and raves about how atrocious it was that microsoft did this to us and I agree it does suck that SQL Server doesn’t do something about this automagically but what would you suggest it do?

 

 

[UPDATE]  I wanted to move some of the great ideas in the comments to the top so that people could find other solutions more quickly:

From Commenter Fritz Laurel:

ALTER LOGIN loginid
WITH DEFAULT_DATABASE = master
GO

From commenter Das:

For those of you who use their Domain accounts, here is the Alter statement to run once you assign the MASTER DB from the above step.

ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master

Replace [BUILTIN\Administrators] with your [domain\usr]

NOTE:[Brackets] required on Domain\User accounts

From commenter Breb02 (SQL 2000?)

RUN–>cmd
sqlcmd -E -d master (osql -E -d master for SQL 2000)
1>sp_defaultdb ‘Computer\username’, ‘master’
2>go

Later SQL Server versions:
sqlcmd -E -d master

From commenter Fuad Ahmed

And the solution for me was just switching the registration property of the server from sql authentication to windows authentication.

I think I was lucky that the login sa had different default database and the windows authentication had different.

From commenter Tony G

I’m using VS2008 Server Explorer. I opened Modify Connection, Advanced Properties, and just set User Instance to true. That allowed my local SQL Server to open the local mdf. HTH

From commenter BobG

I had to.. Under my “registered servers” list, pick the offending server/instance and then right click, choosing “properties”, then choosing “connection properties”, and then type in a database name in the offending server/instance in the “Connect to database:” drop down box.

Then I was able to get in but no offered choices from this post worked for me beyond getting back in, and I had very little rights/access.
I wound up deleting my login from the Server/instance under “Security”. Then I was able to close MS SQL Studio and went back in without further issue.
Note: I also have that same account, a domain account, that I had deleted listed under other SQL Domain Groups for the offending server/instance.

From commenter PeterG

I am running Win7x64 and once of a sudden could not open my DB anymore. I ended up having to “take ownership” of the folder with the DB inside and viola – it worked

From commenter Adrian

To repair an an SQL Server 2000 with default db detached I made the following :

1. I used SQL Server 2005 management console from a client PC and get connected to the server to another existing database;

2. Created another user :
EXEC sp_addlogin ‘Adrian’, ‘p1234′

3. Re-attached the default database with :
EXEC sp_attach_db @dbname = ‘ATOTAL’,
@filename1 = ‘C:\ATOTAL DB\atotal_Data.MDF’,
@filename2 = ‘C:\ATOTAL DB\atotal_LOG.LDF’

From commenter spiritos

I couldn’t connect either (default db not found) so tried this fix but I couldn’t even browse the server to select a new db to use. As a result I started looking at the Security for the db… turns out there was a db that was restored (just happened to be my normal login’s default db!) but in the process some Users had been dropped from the Security folder – including the group that my “normal” login belonged to! Added these groups back in then could connect again!

From commenter One IT Services

You don’t have to use any commands at all, if you still have a login that works then use that to first login to the object explorer.
If you don’t then when logging in make sure you do as stated in the blog which was to click the options button on the Connect to Server Screen.
Then on Connect to Database just click Browse Server, say yes to connect and select any database from the list.
Then once you’re in the Object Explorer, expand Security, Logins and select the username you need to fix.
At the bottom of the Login Properties box you just need to select a Default Database, most likely Master.

From commenter vishalsharma

Note : you have to type master in default database drop down. You won’t see it there in the list.

 

I hope some of these most appreciated comments will help others!

Advertisements

119 Comments »

  1. Big thanks for this post. Fortunately it came up at the top of Google and I can tell by looking around that you’ve saved me a bunch of time.

    Comment by Chris — January 30, 2007 @ 1:04 pm

  2. Thanks a bunch. You just saved me a big headache!

    Comment by Victor — February 7, 2007 @ 2:32 pm

  3. I got this error when I did a command execute insert statement, I was not sure what you were referring too above with the options butto instructutions. So clicking around (I’m in VS 2005) I right clicked on the filename.mdf file name in the server explorer tab and picked “Close Connection”. Then it worked. Not sure why, but I hoped I contributed a possible solution for someone. Thanks.

    Comment by Greg — February 9, 2007 @ 8:50 am

  4. What version of SQL are you running? I do not see this magical “options” button.

    Comment by scott — March 2, 2007 @ 5:23 pm

  5. I was running SQL 2005 when I had this issue. The options button was in SQL Management Studio in the connection dialog. Hope this helps!

    Comment by Ben Harrell — March 2, 2007 @ 6:02 pm

  6. Nah, im on 2000… Go to know for the future. Thanks man

    Comment by scott — March 2, 2007 @ 8:48 pm

  7. Thanks, I spend 4 hrs. on using command prompt to overcome on this issue and your post is greate issue solved in a minute

    Comment by rama7700 — March 12, 2007 @ 9:53 am

  8. dbas need to learn to make it simple

    Comment by lalala — March 13, 2007 @ 10:26 am

  9. Just had this problem. Google results round a few nasty looking fixes and this. Thankfully I used this first. Saved me a lot of time.

    Comment by Chris Jones — March 15, 2007 @ 5:00 am

  10. sorry. its not working. still i get the error 4064.

    Comment by Kannan.P — March 20, 2007 @ 9:31 am

  11. I was having this problem after inadvertently taking a db offline which happened to be the default db for the only user I could remember the pw for (stupid, I know).

    Anyway, my problem was that once I logged in via mgmt studio, set to master, I couldn’t do anything. I couldn’t bring the db back online, or reset the default db of my user or change passwords of other users or anything else. Nothing.

    The, I found this other great post on this:
    http://blogs.sqlservercentral.com/blogs/brian_kelley/archive/2006/12/11/1230.aspx

    Basically, once you gain access, you can run a query to reset the default database for any user and then you’re home free.

    ALTER LOGIN loginid
    WITH DEFAULT_DATABASE = master
    GO

    Comment by Fritz Laurel — March 24, 2007 @ 5:06 pm

    • With a domain name, use this:

      ALTER LOGIN “MYDOMAIN\mylogin”
      WITH DEFAULT_DATABASE = mydb
      GO

      Comment by Gibbs — March 3, 2010 @ 12:31 pm

    • Wow! This really helped me! I was entering the alter command also in command line and it kept blowing up. Finally this post made it clear that I had to type it in a query and it worked. This can be frustrating! Thanks a bunch!

      Comment by Regin — June 28, 2010 @ 9:44 am

      • Me too! Thank you all very much.

        Comment by Пчиња — October 12, 2011 @ 6:19 am

  12. Hi,

    a very useful info but please be more detailed next time 😉

    thanks,
    Svet
    http://devcha.blogspot.com/

    Comment by Svetoslav — March 30, 2007 @ 5:36 am

  13. Thank You

    Comment by Mark — April 18, 2007 @ 2:54 am

  14. Thank You

    Comment by Alex — April 25, 2007 @ 8:09 am

  15. Thank You. You saved my day

    Comment by sanpran — April 28, 2007 @ 2:23 pm

  16. Thanks a lot.
    It’s working again.

    Comment by Gunther — May 31, 2007 @ 6:51 am

  17. WOW… all the bull about ALTER LOGIN crap in all other forums… …. you made my day … great … it works now… after struggling for 4 hrs… thanks a lot.

    Comment by Capton Siluvairajan — July 26, 2007 @ 8:28 pm

  18. For those of you who use their Domain accounts, here is the Alter statement to run once you assign the MASTER DB from the above step.

    ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master

    Replace [BUILTIN\Administrators] with your [domain\usr]

    Adios

    Comment by Das — August 7, 2007 @ 9:45 am

  19. Thank you!

    I knew what the problem was, but not how to fix it!

    Comment by Mark — August 23, 2007 @ 10:32 am

  20. Thank you! I experienced this problem by simply detaching the database that was set as the default database for my login.

    SQL Server should display a list of other databases the user has access to if the default database is no longer available.

    I still had to run the ALTER command after gaining access:

    ALTER LOGIN [DOMAIN\LoginID] WITH DEFAULT_DATABASE = master

    Note: [Brackets] required on Domain\User accounts.

    Comment by Gordon Bell — September 19, 2007 @ 4:24 am

  21. I nearly gave up and re-installed sql. You saved me!!!

    Comment by kwagzz — October 25, 2007 @ 12:50 pm

  22. you save my precious life!

    Comment by imperialx — November 13, 2007 @ 9:05 am

  23. Hi there
    I ‘m not sure about where the options button is, but closing and reopening connection (just click on the dbname, under data connection) did the trick.
    I’m not a db expert, I tried to solve with Msft forums, got just a lot of sqlcmd incredifantastic crap.
    It actually was a two clicks story.
    Thanks to all the people who posted here and gave the right hint

    Comment by magius — November 29, 2007 @ 9:53 pm

  24. I am domain admin on the server. I tried setting master under the options. Lets me in but still cannot access any object properties.
    I did the alter login for [BUILTIN\Administrators] and did not work. Tried running the alter command on my domain account but my account is not physically created on the server since I am a member of the Administrators group.

    Any other ideas?
    I have also tried executing the “sp_defaultdb [builtin\Administrators] master” and that did not work either.

    I have a SQL account as sysadmin that is the only way I can get in.

    Comment by Shawn — December 18, 2007 @ 4:56 am

  25. Ha..ha…
    Thanks man, it’s works.. before i have stupid solution to reinstall

    Comment by herman — January 20, 2008 @ 3:56 am

  26. Thank you. Fast and easy.

    Comment by trool — March 3, 2008 @ 2:12 am

  27. Great post!!!
    This saved me a lot of time..Thanks

    Comment by Don — March 5, 2008 @ 5:14 pm

  28. For those who are unable to access any objects after login in with the “master” default user database, just rename the database with the old name it has before.

    Then change the user default database to what you want in the user property.

    Fixed!

    Comment by Teh — March 6, 2008 @ 11:46 am

  29. Thanks. Straight forward and simple. You saved me a bunch of time also !

    Comment by Tim — March 11, 2008 @ 7:47 am

  30. Thanks! I found lots of examples but none worked. Until I tried yours – simple. Again, Thanks!

    Comment by Jonathan — April 4, 2008 @ 8:25 pm

  31. Thanks. Info saved lots of time.
    Selecting Option and typing master, and then, useng alter login statement given by several people worked great! Outstanding Site for future reference.

    Comment by ANDRE — April 8, 2008 @ 10:00 am

  32. AMAZING
    MANY MANY THAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAks

    Comment by Jawad — April 10, 2008 @ 2:53 pm

  33. u are the KINGGGGGGGGGGGG
    i hate microsoftttttttttttttttttt what a silly database server

    Comment by Jawad — April 10, 2008 @ 2:54 pm

  34. Great and fantastic job.
    I got fix in seconds.
    Thanks a lot buddy I was having whole day same problem and sqlcmd and blah blah.

    Wonderfull Benjamin .

    Comment by Aun — April 15, 2008 @ 2:57 pm

  35. it really worked for me.. thanks a lot…

    Comment by baru — May 13, 2008 @ 10:45 am

  36. Legend mate,
    Worked a treat

    Comment by Tom — May 14, 2008 @ 4:47 am

  37. Excellent!!!!!!!!!!!!!

    Comment by Aaron — May 14, 2008 @ 7:25 am

  38. It didn’t work for me your solution…anyway, I suppose u have another SQL Server version

    The problem for this error seems to be the deletion of a db, witch u previously set some credentials on it.
    My solution:
    RUN–>cmd
    sqlcmd -E -d master (osql -E -d master for SQL 2000)
    1>sp_defaultdb ‘Computer\username’, ‘master’
    2>go

    chears,

    Comment by breb02 — May 15, 2008 @ 4:02 pm

    • Thanks breb02… SQL Server 2000 fix…

      RUN–>cmd
      osql -E -d master
      1>sp_defaultdb ‘MYDOMAINNAME\myloginname’, ‘master’
      2>go

      Later SQL Server versions:
      sqlcmd -E -d master

      Comment by shell_l_d — October 26, 2009 @ 12:42 am

  39. Wow! I’m really lucky that your expert solution was found! I’ve been spendng whole morning for this… crab! Why Microsoft never prompt any message to alert user that it requires a default database?? Thank you!!!!! 😀

    Comment by Vit — May 21, 2008 @ 4:54 am

  40. Well yuo saved me alot of drama, allowed me in easily and then just ran the ALTER SER command to get everything back in working order. Fooken mint

    Comment by Seano — June 12, 2008 @ 3:00 am

  41. Thanks a lot!!!

    Comment by MrSiezen — June 12, 2008 @ 5:09 am

  42. Hi, do you have a Solution for MSSQL2000? In MSSQL2000 I didn’t fidn the ‘connection property’ tab. It will be good if you included some print screen

    Comment by Alvin — July 8, 2008 @ 2:46 am

  43. breb02, U are God to me!!

    Comment by sowmya — July 18, 2008 @ 12:41 pm

  44. Thanks so much, it saved me a lot of time.

    Comment by candy — August 6, 2008 @ 9:55 pm

  45. Thanks for the hint

    Comment by wayne — August 7, 2008 @ 12:16 pm

  46. Thanks, Gordon for the “Note: [Brackets] required on Domain\User accounts.”

    Comment by wayne — August 7, 2008 @ 12:19 pm

  47. I kicked myself like havinf wasted time in that blah blah of sqlcmd thing for half an hour .

    And the solution for me was just switching the registration property of the server from sql authentication to windows authentication.

    I think I was lucky that the login sa had different default database and the windows authentication had different.

    Anyways, you definitely made a clue.

    Comment by Fuad Ahmed — August 29, 2008 @ 5:33 am

  48. God bless you!

    Comment by Keegan Wade — October 21, 2008 @ 5:53 am

  49. This is just plain pitiful. Thanks a bunch for this advice.

    Comment by JacKCrustoe — November 26, 2008 @ 11:52 am

  50. Thanks for the useful posting…
    You saved my day…

    Comment by Prashanth — December 18, 2008 @ 6:09 am

  51. […] to post of benharell and comment of Fritz […]

    Pingback by Cannot open user default database, login fails « Álvaro Brange’s Blog. — December 19, 2008 @ 9:54 am

  52. Thank you for the post. I made a post with your suggest and comments of Fritz linked to you post.:)

    Comment by abrange — December 19, 2008 @ 10:10 am

  53. Glad to help, thanks for the link!

    Comment by Ben — December 19, 2008 @ 10:31 am

  54. Just wanted to say a big thankyou for this post, i’be been going around the houses with this one, and to be honest thought your resoloution would be another dead end, but no!!! it works, thank you thank you thanks you 🙂

    Comment by Neil Brennan — February 12, 2009 @ 4:00 am

  55. Thanks buddy. It really saved my time.

    Comment by Abdul Qadir — April 5, 2009 @ 11:12 am

  56. Thanks a ton. Saved me a bunch of hours….

    Comment by Rajender — April 8, 2009 @ 9:14 am

  57. This works fine for single user If I specified the login. However, I have bunch of users, I need to change default database one go. How shall I do it.

    Comment by sql — May 28, 2009 @ 4:37 pm

  58. I still don’t get it — I’m using 2000 and I don’t have an options button (that I can see). help.

    Comment by Kathy — July 27, 2009 @ 7:36 pm

  59. I’m not sure how to fix this on 2000, maybe someone will be nice enough to answer? My post was only regarding 2005/2008. Good Luck!

    Comment by Ben — July 27, 2009 @ 8:30 pm

  60. it’s in portuguese, but if you need, use Google Translator:

    Visual Web Developer 2008 + SQL Server 2008 Express: “Cannot open user default database. Login failed.” [resolvido!]
    http://b4it.blogspot.com/2009/09/visual-web-developer-2008-sql-server.html

    Comment by Marcos Henke — September 10, 2009 @ 8:58 am

  61. Thank you. It helped me and saved my time

    Comment by Madhu — September 21, 2009 @ 1:19 am

  62. love you!

    Comment by ponchin — December 2, 2009 @ 8:51 am

  63. Thanks a lot!!! Great!!
    You saved me a lot of time!!

    Comment by Antonio — February 4, 2010 @ 3:58 pm

  64. Fantastic

    Comment by Gibbs — March 3, 2010 @ 12:22 pm

  65. Thanks buddy. I rarely comment on any website. but you saved my time as well.

    Comment by Arbab — March 11, 2010 @ 4:40 am

  66. Thanks so much. You win!

    Comment by Brandi — June 18, 2010 @ 4:14 pm

  67. […] MSSQL Queries Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQ… […]

    Pingback by MSSQL Queries « Psgprakash's Blog — June 30, 2010 @ 4:56 pm

  68. Nice. However, as one poster already said, the missing part is to use ALTER LOGIN to set the default database.

    Comment by prideaux — August 3, 2010 @ 2:37 am

    • Thanks a lot!…it was very useful

      Comment by c — September 3, 2010 @ 10:36 am

  69. Thank you! Spent 3 hours on this and this post helped me immediately!

    Comment by g — August 12, 2010 @ 2:12 am

  70. I’m just reinstalling AdventureWorks and I got the error documented here. The solution described didn’t help but it did make me think to try something else that did.

    I’m using VS2008 Server Explorer. I opened Modify Connection, Advanced Properties, and just set User Instance to true. That allowed my local SQL Server to open the local mdf. HTH

    Comment by TonyG — September 24, 2010 @ 3:44 pm

  71. Thanks a lot! It is a very useful information. Thanks for sharing.

    Comment by Jayapriya Narasimhan — November 26, 2010 @ 12:10 am

  72. A++++++++

    Wasted 10 minutes on microsoft website without any luck:

    http://support.microsoft.com/kb/307864

    but resolved the issue straight away after reding your post.

    Thanks

    Jay

    Comment by Jay — November 26, 2010 @ 8:59 am

  73. thnx buddy . ur solution helped me a lot.

    Comment by rohan — January 22, 2011 @ 3:32 am

  74. Thanks mate. Wasted 10 mins trying to resolve this by using sql cmds. This helped immediately.

    Comment by Srihari — January 25, 2011 @ 6:08 am

  75. This post helped me out a lot but it took me a while to put it altogether.

    I too had the issue where I took a DB offline; which I’ve done many times in the past without issue, and then got the 4064 error.

    I had to.. Under my “registered servers” list, pick the offending server/instance and then right click, choosing “properties”, then choosing “connection properties”, and then type in a database name in the offending server/instance in the “Connect to database:” drop down box.

    Then I was able to get in but no offered choices from this post worked for me beyond getting back in, and I had very little rights/access.
    I wound up deleting my login from the Server/instance under “Security”. Then I was able to close MS SQL Studio and went back in without further issue.
    Note: I also have that same account, a domain account, that I had deleted listed under other SQL Domain Groups for the offending server/instance.

    Comment by BobG — January 25, 2011 @ 1:11 pm

  76. Hi, Thanks a million for saving my time…god bless you …take care

    Comment by kishoresagar — January 26, 2011 @ 1:28 pm

  77. I am running Win7x64 and once of a sudden could not open my DB anymore. I ended up having to “take ownership” of the folder with the DB inside and viola – it worked. Very screwy…

    Comment by PeterG — January 28, 2011 @ 7:03 am

  78. It’s really a short and sweet answer and also effective very fast

    I would like to tell this all in one sentence..

    You rocks

    Thanks again

    Comment by Asow — January 31, 2011 @ 1:01 am

  79. To repair an an SQL Server 2000 with default db detached I made the following :

    1. I used SQL Server 2005 management console from a client PC and get connected to the server to another existing database;

    2. Created another user :
    EXEC sp_addlogin ‘Adrian’, ‘p1234’

    3. Re-attached the default database with :
    EXEC sp_attach_db @dbname = ‘ATOTAL’,
    @filename1 = ‘C:\ATOTAL DB\atotal_Data.MDF’,
    @filename2 = ‘C:\ATOTAL DB\atotal_LOG.LDF’

    It worked.

    Comment by Adrian — March 4, 2011 @ 4:25 am

  80. Thanks a lot. This really works.
    Execute in the database that is accesssible
    Alter login loginId(Eg:sapient\bmatha]
    with DEFAULT_DATABASE=Master

    Comment by Basavarajayya — April 7, 2011 @ 1:42 am

  81. GREAT – this solved it after spending hours on other post’s.

    Many thanks

    Comment by MartyDK — April 25, 2011 @ 1:39 pm

  82. It’ reallly really helpful…thanks to post this soluation

    Comment by sanjay — May 25, 2011 @ 4:03 am

  83. This was VERY simple and helpful.

    Comment by JGustafson — June 3, 2011 @ 7:03 am

  84. I just tried what you wrote here, and am still having problems. I’m wondering if it is because I’m trying to connect to a SQL Server 2008 Express database?

    Comment by rodsmusings — June 13, 2011 @ 11:23 am

  85. Nice one! Not my exact problem but certainly pointed me in the right direction…

    I couldn’t connect either (default db not found) so tried this fix but I couldn’t even browse the server to select a new db to use. As a result I started looking at the Security for the db… turns out there was a db that was restored (just happened to be my normal login’s default db!) but in the process some Users had been dropped from the Security folder – including the group that my “normal” login belonged to! Added these groups back in then could connect again!

    So, thanks for pointing me in the right direction – just thought I’d leave this note here in case anyone else finds this slightly different resolution useful…

    Comment by spiritos — August 1, 2011 @ 5:33 am

  86. You don’t have to use any commands at all, if you still have a login that works then use that to first login to the object explorer.
    If you don’t then when logging in make sure you do as stated in the blog which was to click the options button on the Connect to Server Screen.
    Then on Connect to Database just click Browse Server, say yes to connect and select any database from the list.
    Then once you’re in the Object Explorer, expand Security, Logins and select the username you need to fix.
    At the bottom of the Login Properties box you just need to select a Default Database, most likely Master.
    Click ok and your done.
    No mucking with the SQL Commands at all.

    Comment by One IT Services — August 4, 2011 @ 7:36 pm

  87. thanx so much!!!!! and yes I do wanna kick my ass for not even thinking of trying this……

    Comment by fred alm — September 19, 2011 @ 9:56 am

  88. Thanks so much

    Comment by Isaac — September 28, 2011 @ 5:05 am

  89. This solved my problem. I was trying to connect sql express on my machine and was getting error Cannot open user default database. Login failed.
    Login failed for user ‘\’.

    But reading your post has solved my problem. I Logged in by selecting the master as default database option.

    Note : you have to type master in default database drop down. You won’t see it there in the list.

    Comment by vishalsharma — November 9, 2011 @ 9:25 am

  90. We’re a bunch of volunteers and starting a brand new scheme in our community. Your web site provided us with valuable information to paintings on. You’ve performed an impressive process and our entire community will probably be grateful to you.

    Comment by интернет портал для женщин — November 13, 2011 @ 8:46 am

  91. great blah–blah

    Comment by mcts — January 11, 2012 @ 12:15 am

  92. Thanks Mate. You saved my day.

    Comment by Shafrina — January 12, 2012 @ 4:54 pm

  93. Хакерский софт

    Comment by zimkasoft — February 20, 2012 @ 3:58 am

  94. Thanks a lot for your clear and easy solution steps

    Comment by mier — March 7, 2012 @ 7:16 pm

  95. Thank you for the article. saved me from trawling up and down the net! Founds yours in about 2 mins.

    Comment by Nigel — March 9, 2012 @ 10:52 am

  96. You saved me time and money on this one. Thanks a bunch.

    Comment by Carlos B Vasquez — March 13, 2012 @ 5:56 pm

  97. Hey I am so excited I found your weblog, I really found you
    by accident, while I was looking on Aol for something else, Anyways
    I am here now and would just like to say thanks for a remarkable post and a
    all round enjoyable blog (I also love the theme/design), I don’t have time to read through it all at the moment but I have
    book-marked it and also added in your RSS feeds, so when I have time I will be
    back to read more, Please do keep up the great work.

    Comment by repairs laptop — October 11, 2012 @ 8:24 pm

  98. Thanks a ton, helped me connect to my server

    Comment by aniket — October 12, 2012 @ 4:39 pm

  99. […] Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQ… […]

    Pingback by New updates for Cannot open user default database post « public class ben:harrell — January 4, 2013 @ 1:25 pm

  100. Thank you so much…so more easy

    Comment by ma Eugenia — March 18, 2013 @ 8:35 am

  101. Flash web designers will like the cost and the creativity of the Trendy Flash
    Site Builder. Wouldn’t it be easier if we could be able to save changes ourselves whenever we want. The specific combination of reps, sets, exercises, and weight depends upon the desires of the body builder.

    Comment by Online form Generator — July 19, 2013 @ 6:23 am

  102. Save All Paperwork: Whatever paperwork arrives with your parts or which is
    provided from the seller should be maintained. For professional
    web site builders extra complex laptop software
    program for net design is needed. If a picture is worth
    a thousand words then you can just image how much
    you will absorb by browsing this site.

    Comment by online form builder — July 31, 2013 @ 4:24 am

  103. Flash web designers will like the cost and the creativity of
    the Trendy Flash Site Builder. There are many web designers who charge huge amount of money to do this job for you.
    You can make corrections directly instead of having to search mistake through the code,
    if something does not seem OK for you.

    Comment by online form generator — August 2, 2013 @ 2:49 pm

  104. Consider consulting if you are between jobs and have a valuable skill set.

    With a downsized economy, companies may
    be more willing to hire you on an as-needed basis. If you
    find enough businesses you can consult with, it may
    end up being equivalent to a full-time position or at least hold you over until you can find one.

    Comment by warehouse jobs in california — August 17, 2013 @ 1:09 pm

  105. These aree actually great ideas in concerning blogging.
    You have touched somee nice poijnts here. Any way keep up wrinting.

    Comment by kancelaria adwokacka kraków — September 10, 2013 @ 8:44 am

  106. Very useful info and very thanks my dear…

    Comment by Sameer Poonthottathil — February 5, 2014 @ 7:48 am

  107. I just like the helpful information you supply for your articles.
    I will bookmark your blog and take a look at again here regularly.

    I’m reasonably sure I will be informed plenty of new stuff right here!
    Good luck for the next!

    Comment by trulylovable.com — July 23, 2014 @ 6:09 am

  108. Hello to every body, it’s my first go to see of this webpage; this blog consists of remarkable and truly good information in favor of readers.

    Comment by Beats Headphones — September 21, 2014 @ 4:58 am

  109. Thanks for sharing this informative article with us I have found another article that shows some more alternative methods to fix SQL Server Error 4014: http://dinesql.blogspot.in/2016/05/guest-post-methods-to-fix-sql-server.html

    Comment by John Walker — May 16, 2016 @ 2:32 am

  110. While having a paper map only costs $15 versus $250, it is not always as accurate as having a GPS system. “Be sure to make the expense worthwhile by anticipating delays and planning for them. The software outsourcing firm adopts various methodologies to perform a particular task.

    Comment by napoleonsumpter — July 14, 2016 @ 12:13 am

  111. create links

    Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064) | public class ben:harrell

    Trackback by create links — April 1, 2017 @ 9:16 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: