UsingSQLServer

UsingSQLServer - Using MS SQLSERVER in Visual Studio 1....

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Using MS SQLSERVER in Visual Studio 1. Instructions for accessing ASU SQLSERVER database: Your SQL Server login is your ASURITE ID. The password is the ASURITE password 1) Go to myapps.asu.edu, log in with your asurite username and password 2) Search for Visual Studio 3) Click Run app now on the right of “Microsoft Visual Studio 2008 ”( 2005 doesn’t work! ) 4) A file named MyAppsOnline.exe is downloaded. 5) After the installation is complete, launch Visual Studio 2008 2. Instructions for establishing connection to SQLSERVER database: To connect to your SQL Server database in Visual Studio, go to menu View -> Server Explorer , this will open a server explorer window(usually you have to click other windows then you can find the server explorer window). In server explorer, right click on Data Connections , choose add connection. You need to provide the following information to make a new database connection:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1. Server name: acadmssql 2. Use Windows Server authentication for the option log on to the server. user name: your asu riteID, password: your default password(your asu 10-digit-ID) 3. Choose select or enter a database name for the option connect to a database. In the combo box below, choose the database with a name the same as your asuriteID. You are the dbo for your own database so you have full permission.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/11/2009 for the course CSE 412 taught by Professor Davulcu,h during the Fall '08 term at ASU.

Page1 / 7

UsingSQLServer - Using MS SQLSERVER in Visual Studio 1....

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online