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