Cannot open database

By -
I was just working on a SQL rollback script verification tool when I got the following error:

System.Data.SqlClient.SqlException: Cannot open database <database> requested by the login. The login failed.Login failed for user <user>

the usual reason for this is a bad connection string, or a user that doesn't have permissions, but in my case it was that I was trying to create a new db file (to run the scripts against), and the directory did not exist in which I was trying to make my file.

Creating the directory was enough to get it to work.

Comments

Post a Comment

Popular posts from this blog

The marshmallow cream trainwreck

By -
Image
This week we have been busily trying to get ready for christmas. We have all of the presents that we need and Alison did all of the shopping, so really we're pretty close now. On Wednesday Mike was able to use some volunteer time off to go to The cannery at welfare square and help them can applesauce. He ended up canning about 15,000 pounds of applesauce. It was good, and he appreciates that guys work pays him for it. On Wednesday we all went to the church because the activity dudes and young women (and men) were having a caroling activity. We had a fun time going around and singing and then ate cookies and drink hot taco after. Gideon and Elsa ended up going home early with Alison. Thursday after dropping the kids off at Grandma Julie's house Alison went all over the entire valley to every store that exists in order to buy things in preparation for Christmas. (Alison wants me to add that it was only actually four stores.) Despite having gone everywhere she was still unable to
Read more

In which we blacken someone's name

By -
Last Sunday after we wrote our blog post Rea received her patriarchal blessing. The patriarch was not far away from our home, and she received a nice blessing. The patriarch's wife acted as a stenographer, and they delivered a text version of it to our house a few days ago, so she now can read it when she wants to. The Dalyias came over on Monday and the kids all played. They had a lot of fun and apparently ate a lot of mints as well. Wednesday was a very busy day. In the morning Alison and the kids went to the Poulson's house and then Mike took Sara to her acting class. Next, Rea went to the temple open house, and Alison took the kids to her presidency meeting with her, and then Mike took Sara back to her activity and grabbed the kids. Here's hoping that we can avoid that busy a day for at least a few weeks. Gideon had a lot of fun at Sullivan's birthday party on Thursday. They jumped on a trampoline, ate pie, played a lot of games, and ran around, so it sounds like it
Read more

Not Penguins

By -
Image
Look, we're posting on time! Only one week's worth of stuff, so it'll go fast. Last Sunday, Rea got her patriarchal blessing! She decided she wanted it and set up interviews and things, and it was so exciting to have it happen at last. It was a lovely experience. Wednesday Rea did a Secret Santa gift exchange in Young Women's. She had planned to make a snow globe with a sea turtle in it, but Mom procrastinated shopping until it was too late to find the turtle. After a lot of thought and effort, she ended up putting a Christmas candle in the glass globe with blue glass gems and a package of peppermint bark. It was pretty well received. One of her good friends got her name, and gave her a gorgeous locking journal cover that you can put new books into when you fill one up. It was perfect for her! Thursday this week was Rea's end-of-semester blue book exams. She had to draw the Western Hemisphere + Europe and label all countries, US states. and Canadian provinces and th
Read more