Tuesday, December 9, 2008

System.Runtime.InteropServices.COMException

I received a pop up error with the message System.Runtime.InteropServices.COMException. This happened when I was trying to reload a project that somehow got unloaded.

Resolution:
  1. Once the solution opens, right-click on the unavailable project and select Edit project_file_name.vbproj.
  2. Scroll to the bottom of the page, and delete the ProjectExtensions section.
  3. Save the page.
  4. Right-click again on the unavailable project, and select Reload Project.
  5. Your project should now be available and you should be able to see all your project files.

Tuesday, November 11, 2008

SQL Authentication login error

I was trying to connect to Sql Server Management Studio today using SQL Server Authentication and received a Microsoft SQL Server, Error: 18452. "The user is not associated with a trusted SQL Server connection."

PROBLEM: Cannot login with any account using SQL Server Authication because the Server Authentication mode does not allow it. (We need to change it so SQL Server Authentication is allowed).

SOLUTION:
Step 1.) Log into Management Studio using Windows Authentication
Step 2.) Right Click on the Server and select Properties
Step 3.) Select the Security page from the left side navigation.
Step 4.) Select SQL Server and Windows Authentication mode.
Step 5.) Press OK
Step 6.) Right click on the Server and select Restart

You should now be able to login with the account that requires SQL Server authentication.

Hope this helps.

Reference:
http://chkiran.wordpress.com/2008/06/20/sql-server-authentication-not-working/

Error trying to create a Database Diagram in Sql Server 2005

Today I tried to create a Database Diagram in SQL Server 2005 and received a pop up error message:

Sql 2005 Database diagram support objects cannot be installed because this database does not have a valid owner

SOLUTION:
EXEC sp_dbcmptlevel 'yourDB', '90';
go
ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go
use [yourDB]
go
EXECUTE AS USER = N'dbo' REVERT
go

Thank you Shahed for posting the solution on
http://geekswithblogs.net/shahed/archive/2007/11/19/116940.aspx

Saturday, August 2, 2008

Downtown Sacramento Italian at Sofia's

Tonight my wife Nikki and I had dinner at an Italian Restaurant in Downtown Sacramento called Sofia's. What made us choose this restaurant was coupon I picked up from 100.5 The Zones Half Price Hookups.

Sofia's has been around for about 5 years. We eat out quite frequently and have never heard of this place. It may have been because it was a little off of the high traffic path of midtown restaurants located at 815 11st. Or it could have had to do with no website or minimal marketing.

Located on the corner block, there is plenty of parking and patio seating looking out towards 11th st. Walking into the restaurant, you first see the bar/lounge. I would definitely like to come back for drinks.

It was around 7pm and we were seated immediately; pretty quiet for a Saturday night. There were two people at the bar and only 3 or 4 tables with customers. The host placed us in a large booth.

Our drink order included a Pino Grigio and Stella Artois. For appetizers we chose the calamari. The calamari came out quickly and was great. Nikki ordered Gnocci in a Pesto sauce with sun dried tomatoes and chicken. I ordered the Seafood Fettucini. Both items were on special that evens so our expectations were high.

The entree's came out and both were generous in their portions. The gnocci was damn good. Nikki always order better food than I do. My seafood fettucini was alright. The presentation was good. There were lobster claws and clams all over the plate. Most of the seafood was a little over cooked. The sauce was too bland for my taste. For desert we had Cappuccino Mouse cake. It was awesome. Very rich.

We would definitely go back for drinks, maybe dinner. I would order something else though.

Paul