Posts Tagged ‘SQL Server

Some TSQL command to identify the version of SQL you are running:
SQL Server 6.5 SELECT @@VERSION

Version Number

Service Pack

6.50.479

[...]

a colleague of mine made a super blog post about an operational, near real time, BI platform for monitoring packages in a package sorter for the Dutch TNT Post Pakketservice.
Go check it out here

We had a problem with executing a SQL Job which runs a SSIS Package. Whenever the job started we would get the following error:
Executed as user: <domain>\<user>. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  09:13:01  Error: 2009-08-05 09:13:02.85     Code: 0xC002F304     Source: <source> [...]

I created a SQL User named UserA which was DB_Owner of 1 database. When I connected to this database with SQL Authentication I received the following error:
The server principal “User A” is not able to access the database “DatabaseA” under the current security context. (Microsoft SQL Server, error:916)

To resolve this error [...]

I’ve been struggling for quite a long time with Excel Web Access in combination with a SQL Analysis Server and SharePoint. The problem is that I am able to display an excel file (which is in a SharePoint web part), but whenever I choose to refresh the connection I get the following [...]