Microsoft SQL Server, Error: 15401
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment.
You’ll keep getting “Windows NT User or group ‘MyDomain\MyUser’ not found. Check the name again. Microsoft SQL Server, Error: 15401″
No comments yet.
You must be logged in to post a comment.
No trackbacks yet.
Installing Sharepoint 2010 Beta..
February 19, 2010 - 2:56 pm
Tags: chart controls, geneva framework runtime, installation, sharepoint, sharepoint 2010 beta, sql server 2008
Posted in Software, microsoft, sql server, windows, windows server 2008 | No comments
Microsoft Sharepoint 2010 beta software requires the following:
Application server role, web server IIS Role
SQL Server 2008 native client
Microsoft “Geneva” framework runtime
Microsoft Chart Controls for Microsoft Framework 3.5
Microsoft Filter Pack 2.0
SQL Server 2008 Analysis Services ADOCMD.NET
I attempted to install this on a development Windows 2008 R2 server, which already had SQL Server 2008 R2 installed. Out [...]
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
January 15, 2010 - 12:17 pm
Tags: 246133, knowledge base, logins, microsoft, passwords, sql server 2005, sql server 2008
Posted in Software, computers, microsoft, sql server, windows, windows server 2008 | No comments
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Azure sample database setup….
December 29, 2009 - 11:57 am
Tags: adventureworks, azure, microsoft, sql server 2008
Posted in Software, computers, microsoft, programming, sql server, visual Studio .Net, websites, windows, windows server 2008 | No comments
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure:
you need an account – get one from sql.azure.com – it takes some time for your access information to arrive by email.
download the sample database using link above
extract/unzip to a known location
make sure you add your home/work/workstation [...]
Business Intelligence w/SQL 2008
December 27, 2009 - 2:43 pm
Tags: business intelligence, OLAP, OLTP, sql server 2008, SSIS. SSAS
Posted in Software, computers, programming, sql server, windows, windows server 2008 | No comments
Currently reading “Delivering Business Intelligence with Microsoft SQL Server 2008 by Brian Larson”
Interesting quotes/definitions:
“Would you tell me please, which way I ought to go from here?” asked Alice.
“That depends a good deal on where you want to get to,” said the Cat.
“I don’t much care where,” said Alice.
“Then, it doesn’t matter which way you go,” said [...]
Azure SQL….
December 24, 2009 - 6:21 pm
Tags: adventureworks, azure, cloud computing, database, microsoft, sample, sql server 2008
Posted in Software, computers, microsoft, sql server, windows | No comments
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
collection_set_3_upload job keeps failing on uploading Query Statistics – SQL Server 2008
October 13, 2009 - 8:54 am
Tags: data collection, query statistics, sql server 2008
Posted in General, Software, computers, sql server | No comments
Keep getting the error messages below from the logs:
To view the detailed logs in SSMS 2008:
Drill down on
Management -> data collection -> query statistics -> view logs
====== Error Messages Below=====
Event
Data Code
Message
SSIS error. Component name: DFT – Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “ODS [...]
Autodesk 3ds Max 2009 error…
July 23, 2009 - 6:37 am
Tags: 3ds max 2009, driver, error, forcing null driver mode, Loading of custom driver failed, null, opengl
Posted in computers, graphics | No comments
If you get the error below, “Loading of custom driver failed, forcing null driver mode.”
Simply go to customize menu/preferences/viewport/choose driver and select OpenGL – if your graphics card supportsw this, then restart 3ds max. You have to do this for the 32bit and 64bit if you have both installed.
Microsoft Sql Server Administration…
May 24, 2009 - 10:28 am
Tags: sql, sql server 2005, sql server 2008, t-sql
Posted in General, Security, Software, computers, internet, sql server, windows server 2008 | No comments
Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include:
EXEC sp_configure
GO
–Instance level principals.
SELECT * FROM sys.asymmetric_keys
SELECT * FROM sys.certificates
SELECT * FROM sys.credentials
SELECT * FROM sys.linked_logins
SELECT * FROM sys.remote_logins
SELECT * FROM sys.server_principals
SELECT * FROM sys.server_role_members
SELECT * FROM sys.sql_logins
SELECT * FROM sys.endpoints
GO
–Database level principals.
SELECT * FROM sys.database_principals
SELECT * FROM sys.database_role_members
GO
ALTER LOGIN sa WITH NAME [...]
Error: Connect to SSIS Service on machine "" failed:
March 11, 2009 - 9:18 am
Tags: service, sql server 2008, ssis, windows server 2008
Posted in Software, computers, sql server, windows server 2008 | No comments
On a new instalaltion of SQL Server 2008, running on Windows Server 2008, l cannot connect to SSIS from SSMS (Sql server management console) 2008 running on a client workstation. I can connect from the local server end.
I tried adding the users Group to the permissions option on Component Services/MsdtsServer100 as suggested by many sites [...]
Render SSRS 2008 Report from Website to Adobe PDF
January 15, 2009 - 10:44 pm
Tags: adobe, pdf, render, report, sql server 2008, ssrs 2008, visual studio
Posted in Software, computers, internet, websites | No comments
This is a test project to see if l can successfully render to PDF from an asp.net website, using Report Control from a Visual Studio 2008 project.
First l created a simple sample table called MyContact from some files from the AdventureWorks database. Heres the code:
SELECT
[ContactID] ,[Title] ,[FirstName] ,[LastName]
,[EmailAddress] ,[Phone] ,[ModifiedDate]
into MyContacts
FROM [...]