Google

Links
 
 
Category
 
Recent Entries
 
 
Archives


 
Posted By InfoTechGuyz

SQL 2005 Error: login failed for user sa the user is not associated with a trusted sql server connection

 

Solution: Make sure mix authentication is on (SQL / Windows), make sure SA account is enabled and restart SQL Server service.


 
Posted By InfoTechGuyz

When i try to access SQL 2005 Reporting Services Configuration Manager, I got this

 

error:
reporting services configuration manager
an unknown error has occurred in the WMI provider. Error code 80040219

Solution: The only solution i found was to reinstall sql 2005.


 
Posted By InfoTechGuyz

Today  SQL Server 2005 Installation on Windows 2003 ends with this

error: SQL Server Setup was unable add user DOMAIN\administrator to local group SQLServer2005MSFTEUser${server}${instance}

A few things i confirmed while i was troubleshotting, i am not sure what fixed the issue

Solution:
- make sure that you are logged on with a local admin account.
- make sure domain admins is part of local admin group
- remove and re-add domain admins and local admin from local admin group
- install SQL 2005 in different location