eHow launches Android app: Get the best of eHow on the go.
How to Create Your First Web Site
How to Follow the NFL on the Internet
How to Use Smileys in E-mail
How to Turn Off Sounds, Pictures or Video on Web Pages
How to Password-Protect a Web Page
How to Upload Files to Another Computer With an FTP Program
How to Use the Paste Special Command in Excel
How to Use the Pivot Table Wizard in Excel
How to Use the Wizard to Create a Find Duplicates Query in Microsoft Access
How to Redirect Users From One URL to Another
How to Merge Workbooks in Excel 2003
How to Check Comcast E-mail
How to Search Craigslist
How to Design a Web Site
How to Increase Download Speed
How to Start a Web Site
How to Use a Do-While Loop in Excel VBA
How to Use an If-Then Statement in Excel VBA
How to Use Excel's TTEST Function
How to Use Excel's TRIM Function
Using Excel to Build a Quoting System
How to Display a PDF File in an HTML Web Page
How to Send E-mail From an HTML Page
How to Use FTP
What Is a Database Used For?
How to Find a Job on the Internet
How to Use an HTML Editor
How to Make a Picture Into a Link
Using Microsoft SQL Credentials
Entering Data Using SQL Management Studio
Creating a Database in MySQL
Creating a User in MySQL
Creating a Table in MySQL
Summary: When logging in to a structured query language (SQL) database, a person can sign in with their SQL credentials or with their Windows credentials. Use SQL server authentication with tips from a software developer in this free video on using Microsoft SQL.
Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more
"Hi, My name is Dave Andrews. Today I'm going to tell you about using SQL credentials in Microsoft SQL server as opposed to Windows credentials. Let's go to the computer for an example. I'm going to open up the SQL management studio. Click on start, all programs. Let's find Microsoft SQL server. I'm going to run the SQL Server Management Studio. Now, you have two ways to login to a SQL database. Number one is by using SQL credentials and number two is by using Windows credentials. This will work on a server that has a mixed mode installation that allows you to use either one of those two. Now, way that you does this is by when you're connecting to your server, you have your server name there, and you can choose here to use Windows authentication which is going to use the user name that you're currently logged into, into the Windows computer. Or you could use SQL server authentication, which means you have to have a user that has been created for you by the database administrator. I'm loggin' in as sa which is a default user for SQL server. I'm just going to type in that password. Close out that little box. This is for the sa user on my database. Now, I've just logged into that database using SQL server credentials rather than using the user name that I was logged into the server as. It's that easy. My name is Dave Andrews and I've just told you about using SQL server credentials rather than Windows credentials to login to a SQL database."
eHow Article: Using Microsoft SQL Credentials
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
