Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
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
No comments yet.
You must be logged in to post a comment.
No trackbacks yet.
Microsoft SQL Server, Error: 15401
January 15, 2010 - 12:12 pm
Tags: 1501, error, microsoft sql server, sql server 2008
Posted in Software, computers, microsoft, sql server, windows, windows server 2008 | No comments
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 [...]
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 [...]
Classic Physics Lectures on Microsoft Research Website
July 14, 2009 - 11:19 pm
Tags: microsoft, physics, richard feynman
Posted in World, school, science, websites | No comments
Microsoft Research at this link, provides for free the lecture series of iconic physicist Richard Feynman.
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 [...]
Microsoft Hyper-V…
May 7, 2009 - 12:18 am
Tags: 64bit, hyper-v, microsoft, virtualization
Posted in computers, hpc | No comments
Using Windows 2008 Server Operating system, this allows you to create a server based virtualized computing platform.
An x64-based processor. Hyper-V is available in x64-based versions of Windows Server 2008—specifically, the x64-based versions of Windows Server 2008 Standard, Windows Server 2008 Enterprise, and Windows Server 2008 Datacenter.
Hardware-assisted virtualization. This is available in processors that include a virtualization [...]
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 [...]