Business Intelligence

Business intelligence is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes. BI can handle large amounts of information to help identify and develop new opportunities

---

Sql Server Authentication – Error 18456

November 6, 2013  in Business Intelligence / Sql Server  tagged Errors / Tips & Tricks by Linda Lawton

As you know there are two ways to connect to sql server. Windows Authentication SQL Server Authentication Windows Authentication uses the logon on your pc to access the database server.   While SQL Server Authentication required that you enter a login and a password. The picture above shows what happened when I tried to […]

---

SSAS – Login failed for user

October 29, 2013  in Business Intelligence  tagged Errors / Tips & Tricks by Linda Lawton

So I am the proud owner of a new PC here at work.  YEAH!   But when I tried to process my cube in Analysis Services I got this error. OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT SERVICE\MSOLAP$SQL2012’.; 42000. I know I have seen […]

---

---