Saturday, September 20, 2014

Change sa password using SQL Server Management Studio



Change sa password using SQL Server Management Studio


If you want to change your 'sa' password with SQL Server Management Studio, here are the steps:
  1. Login using Windows Authentication and ".\SQLExpress" as Server Name
  2. Change server authentication mode - Right click on root, choose Properties, from Security tab select "SQL Server and Windows Authentication mode", click OK Change server authentication mode
  3. Set sa password - Navigate to Security > Logins > sa, right click on it, choose Properties, from General tab set the Password (don't close the window) Set sa password
  4. Grant permission - Go to Status tab, make sure the Grant and Enabled radiobuttons are chosen, click OK Grant permission
  5. Restart SQLEXPRESS service from your local services (Window+R > services.msc)

Installing SQL Server Management Studio 2008

---

Installing SQL Server Management Studio 2008

UPDATE 7/31/2012 - Since this post new versions of SQL Server & Visual Studio have been released. To install the latest version of SQL Server see SQL Server Install. For more information on working with SQL Server Local DB in Visual Studio 2012 see Working with SQL Server LocalDB in Visual Studio 2012 and the MSDN Library SQL Server 2012 Express LocalDB.
One of the first things I always do after installing Visual Studio is to install SQL Server Management Studio (SSMS). Visual Studio 2010 installs SQL Server 2008 Express on your machine but doesn’t include SSMS. Although you can use Visual Studio to create/connect/design databases, I like having SSMS around for advanced management. I recall SSMS for SQL Server 2005 was a simple install, unfortunately they threw the kitchen sink into the SSMS 2008 installer and I’m always confused at which buttons I need to push to get it to do what I want. So I’m writing up this blog post for two reasons 1) So I remember the steps and 2) So you can be less frustrated :-) (BTW, a birdie tells me that the SQL team is looking at making this installer much simpler in the future. Hooray!)
Okay the first thing you need is to make sure you get the right version of SSMS. If you installed Visual Studio 2010 then you will need the 2008 version (not R2).
STEP 1: Download Microsoft® SQL Server® 2008 Management Studio Express and select either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe depending on your machine’s OS bit-ness. I’m running Windows 7-64bit so I’ll be detailing the steps as it pertains to that OS.
STEP 2: Make sure you’re logged in as an administrator of the machine then right-click on the exe you downloaded and select “Run as Administrator”. If you’re on Windows 7 then you’ll get a compatibility warning. Click past it for now to continue with the install. Later you’ll need to apply SQL 2008 Service Pack 2.
STEP 3: You should now see the “SQL Server Installation Center” window. Yes it looks scary. Select the “Installation” tab.
image
STEP 4: Select “New SQL Server stand-alone installation or add features to an existing installation”. It will then run a rule check. Make sure there are no failures and then click OK.
image
STEP 5: The next step is misleading. The Setup Support Files window looks like it’s doing something and stuck on “Gathering user settings.” It’s actually waiting for you to click the Install button! Doh!
image
STEP 6: Another rule check. You’ll probably end up with a Windows Firewall warning this time. If you want to enable remote access to SQL Server you’ll need to configure the firewall later. Since I’m using SQL Server Express for development purposes on this machine only, I won’t need to worry about that. Click Next.
image
STEP 7: Okay here is the step I always mess up because it’s just not intuitive at all. On the Installation Type window you have a choice between “Perform a new installation of SQL Server 2008” OR “Add features to an existing instance of SQL Server 2008”. You need to select new installation, NOT add features. I know I know, totally weird. You would think that since you just want to add SSMS that it would be Add features to existing instance – I mean I don’t want a new instance, just the dang tools. Sigh. Click Next.
STEP 8: Next you get the Product Key window. You obviously don’t need a product key for SQL Server Express since it’s free so just click Next.
image
STEP 9: Accept the License Terms and click Next.
image
STEP 10: Okay now for the window we’ve all been waiting for - Feature Selection. Check off “Management Tools – Basic” and then click Next.
image
STEP 11: Verify your disk space requirements and click Next.
image
STEP 12: Help Microsoft improve SQL Server features and services by selecting to send usage and error reports to them (or not). Click Next.
STEP 13: Another quick rule check runs. Click Next.
image
STEP 14: Now it looks like we’re ready to install. Click the Install button.
image
The install will kick off and will take about 5 minutes to complete.
STEP 15: Once the installation completes, click the Next button again.
image
STEP 16: Complete! Click the Close button and you should be all set.
image
STEP 17: Fire up SQL Server Management Studio! You should now see it in your Programs under Microsoft SQL Server 2008. Make sure you run it as an administrator for access to all the features.
image
And don’t forget at some point to install the latest SQL Server 2008 Service Pack. I hope this helps people who have just installed Visual Studio 2010 but also want to install SQL Server Management Studio. I know I’ll be referring to my own post on this when I need to do it again :-)
Enjoy!

Wednesday, September 17, 2014

Crystal Report 2013 Does Not Provide Creation Of Distributable

Crystal Report 2013 does not install any Software Development Kit. However you have two options:

1) SAP Crystal Reports, developer version for Microsoft Visual Studio 2010 / 2012, which you can download from here: http://scn.sap.com/docs/DOC-7824

2) Keep using the CR 2008 SDK. This SDK fully supports reports created in CR 2013.

Tuesday, September 16, 2014

3D Studio MAX Install VRay

---
3D Studio MAX Install VRay
STEPS
1) Run installer
2) Accept terms
3) Choose Installation Type
4) Select Target Installation Path
5) VRay Server Option
6) Hardware Lock License Option
7) Confirm Installation
8) Installation in progress
9) Run 3D Studio Max and check in Plugin Manager

STEPS

1) Run installer

2) Accept terms

3) Choose Installation Type

4) Select Target Installation Path

5) VRay Server Option

6) Hardware Lock License Option

7) Confirm Installation

8) Installation in progress

Successful.

9) Run 3D Studio Max and check in Plugin Manager

---

---

3ds Max Install Error "Unhandled Exception"

---


If you run into “Unhandled Exception” error, it could be something related to the display driver.
Solution:
Run “Change Graphics Mode”.
Select “Revert From Direct3D”.
Select “Software”.
---

3ds Max Install Error "Insert CD 1"

---

Info:
If you get error message such as “Insert CD 1” during installation, then you should extract the iso into normal folder and run installer from there.

---

3D Studio Max 2010 Installation On Windows 7

---
3D Studio Max 2010 Installation
STEPS
1) Run Installer.
2) Click Install Products
3) Select Products to install.
4) Wait for initialization.
5) Start Installation.
6) Enter 3ds Max 2010 Serial Number and Product Key
7) Review and Confirm Installation.
8) Installation In Progress.
10) Done.

STEPS

1) Run Installer.


Info:
This tutorial is using the iso file 3DS_Max_2010_32Bits.iso  (if you get error message such as “Insert CD 1” during installation, then you should extract the iso into normal folder and run installer from there).
Notice the menu on left hand side of the Autodesk 3D Max 2010 Setup Window.

2) Click Install Products

3) Select Products to install.

4) Wait for initialization.

5) Start Installation.

Select Country.
Select I Accept.

6) Enter 3ds Max 2010 Serial Number and Product Key

7) Review and Confirm Installation.

8) Installation In Progress.

10) Done.


---


---

3D Studio Max 2010 Installation On Windows XP

---
3D Studio Max 2010 Installation On Windows XP

STEPS

1) Run Installer.


Info:
This tutorial is using the iso file 3DS_Max_2010_32Bits.iso  
If you get error message such as “Insert CD 1” during installation, then you should extract the iso into normal folder and run installer from there.
Notice the menu on left hand side of the Autodesk 3D Max 2010 Setup Window.

2) Click Install Products

3) Select Products to install.

4) Wait for initialization.

5) Start Installation.

Select Country.
Select I Accept.

6) Enter 3ds Max 2010 Serial Number and Product Key

7) Review and Confirm Installation.

8) Installation In Progress.

Installation Done.

9) Test Run.


Info:
If you run into “Unhandled Exception” error, it could be something related to the display driver.
Solution:
Run “Change Graphics Mode”.
Select “Revert From Direct3D”.
Select “Software”.

---

---