Posts tagged microsoft
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
Jan 15th
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….
Dec 29th
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 actual external facing ip address to the firewall settings
- wait for 5-10 mins for your ip address to be accepted by the azure online firewall system
- run the script commands below
See commands/reference pictures below:
Server Name: serverx serverx.database.windows.net
Administrator Username: userx
Server Location: South Central US
db name: ankh
cd dw
buildawdwaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
cd lt
buildawltaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
Azure SQL….
Dec 24th
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
Classic Physics Lectures on Microsoft Research Website
Jul 14th
Microsoft Research at this link, provides for free the lecture series of iconic physicist Richard Feynman.
Microsoft Hyper-V…
May 7th
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 option; specifically, Intel VT or AMD Virtualization (AMD-V).
- Hardware Data Execution Protection (DEP) must be available and be enabled. Specifically, you must enable Intel XD bit (execute disable bit) or AMD NX bit (no execute bit).
- An applicable example is the Intel XEON E5430 Quad core CPU
Good microsoft setup link here.
Silverlight….
Jan 11th
Microsoft Silverlight allows developers to create rich, cross-platform, interactive Web applications. I went through some sample code from Microsoft’s silverlight.net website and created a base page from which to demo/test the functionality of silverlight capabilities and use these as a base for learning as well as for future projects. Click here to see these awesome demos.
Unable to connect to remote server – error
Dec 31st
If you get this message say from Visual Studio when trying to deploy SSRS reports to a SQL Server 2008 database instance, heres how this can be resolved. This is usually caused by kerberos security authentication. Navigate to: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer Edit the file rsreportserver.config
Make the change below:
<!–<Add Key=”SecureConnectionLevel” Value=”2″/>–>
<Add Key=“SecureConnectionLevel“ Value=“0“/>
Restart Reportserver. You should be able to deploy your reports now to SQL Server Reporting Services 2008.