Marc Valk dot Net
blogging about…… Microsoft, Cloud Computing
Posts Tagged ‘SQL Server’
Identify SQL Server version
In: SQL Server
30 Oct 2009Some TSQL command to identify the version of SQL you are running:
SQL Server 6.5 SELECT @@VERSION
Version Number
Service Pack
6.50.479
[...]
- No Comments
- Tags: SQL Server
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
- No Comments
- Tags: Cloud Computing, SQL Server
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> [...]
- No Comments
- Tags: SQL Server
SQL: Microsoft SQL Server, error:916
In: SQL Server
6 Jul 2009I 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 [...]
- No Comments
- Tags: SQL Server
EWA: Error Data Refresh Failed
In: Security| SharePoint
30 Jun 2009I’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 [...]
- No Comments
- Tags: Kerberos, SharePoint, SQL Server, SSAS