How do I install AdventureWorks in my local PC

Question

How do I install AdventureWorks in my local PC

mw_sql_developer

SSCoach

Points: 19445
More actions
March 21, 2016 at 7:15 am

#325996

I have SSMS installed on my PC. However, I am not able to install the AW database on my local PC. In other works I want to be able to create a database in my local PC ( and not in a server ).
Can anyone guide me step by step on this process please ? ( See attached PIC )

Viewing 15 posts - 1 through 15 (of 29 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

SQL Server Management Studio (SSMS) is just a tool for manipulating SQL Server server instances. In order for you to have a copy of Adventureworks locally, you'll need to install a copy of SQL Server itself locally. SSMS is not SQL Server and SQL Server is not SSMS.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

mw_sql_developer SSCoach Points: 19445 More actions · Answer 2

Good Answer, Can you help me check whether I have SQL Server installed or not ?

Where do I start this ?Suggestions Please

Lowell SSC Guru Points: 323518 More actions · Answer 3

mw112009 (3/21/2016)
Good Answer, Can you help me check whether I have SQL Server installed or not ?
Where do I start this ?Suggestions Please

because you got "login failed" you definitely have SQL installed, but you are not added as a user yet.

if you did not have SQL installed, you would get an error like this:

TITLE: Connect to Server
------------------------------
Cannot connect to bananas.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

grab this script, and run it, and type MSSQLSERVER in the command prompt to identify which local SQL instance to take over

https://gist.github.com/wadewegner/1677788

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mw_sql_developer SSCoach Points: 19445 More actions · Answer 4

mw_sql_developer

SSCoach

Points: 19445

March 21, 2016 at 7:57 am

#1866455

Lowell

Please see attached

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 5

That suggests it's not running. The easiest way I know to check is to look at your Services. You should see one for SQL Server. It'll even provide the instance name.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lowell SSC Guru Points: 323518 More actions · Answer 6

mw112009 (3/21/2016)
Lowell
Please see attached

when the script prompted you for the instance name, you did not type "MSSQLSERVER"

it defaults to SQLExpress if you don't type anything.

you don't have an extra isntance named MidWest\SQLExpress, only the default instance you shows in your first screenshot.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mw_sql_developer SSCoach Points: 19445 More actions · Answer 7

Lowell

It did not prompt me.

Just to make sure we are in the same page, I have attached the script. I gave it a txt extension purposely so that I can upload it to the this forum. I hope this is the correct one. Let me try one more time and see whether it prompts me.

So I went into the command line and typed ADD ( I had the file named as ADD.cmd sitting in the USERS\xxxx\ directory.

Let me run this one more time and post a reply.

mw_sql_developer SSCoach Points: 19445 More actions · Answer 8

Lowell

Before I run the script for a second time..

I also noticed a new icon appearing in windows, Attached in the icon and the program it launches. May be you might have the answer you need.

I had issues uploading the 2 attachments. Anyhow one is there. In my next reply I will attach the next picture.

Hope this makes sense

mw_sql_developer SSCoach Points: 19445 More actions · Answer 9

Lowell

Here is the new Program Icon I mentioned in my previous reply.

See attached.

I know it is something related to SQLServer. I have never seen that before

mw_sql_developer SSCoach Points: 19445 More actions · Answer 10

Lowell: The script did not prompt me.

Looking at the attached ( in one of the previous posts ) image it is clear that SQLSERVER is running as a service. Do you agree ? Does that mean that SQLSERVER is installed on my local PC ( I mean besides SSMS ) ?

Please help ?

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

Oops. Sorry - bit by the bug.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

mw112009 (3/22/2016)
Lowell: The script did not prompt me.
Looking at the attached ( in one of the previous posts ) image it is clear that SQLSERVER is running as a service. Do you agree ? Does that mean that SQLSERVER is installed on my local PC ( I mean besides SSMS ) ?
Please help ?

You can see the SQL Server service running, so SQL Server is installed on your machine.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

mw_sql_developer SSCoach Points: 19445 More actions · Answer 13

Ed:

I agree, But I do not know how to connect. I mean I know how to open SSMS and then connect to other servers, run sql statements.

In this case what would I use as the server name ? ( See attached pic )

I am not sure what the instance name would be ?

SQL Smurf Valued Member Points: 71 More actions · Answer 14

Your instance name for a default install will be the same as the computer name.