Quick newbie question about sql server

[callum8]

Hi, wondered if anyone could help me as I'm a bit dumbfounded right now...

I have Powerpivot installed successfully but unfortunately when I try to import data from an SQL database it cannot find any Server Name... Do I have to install SQL Server seperately?

Sorry, Im just starting out with this and following a book but have no experience with SQL...

Thanks

 

[ruve1k]

Try typing the server name in manually. Sometimes they don't show up in the drop-down list.

 

[callum8]

Sorry really new to this but how do I know the name of the SQL Server?

 

[ruve1k]

Call the database administrator and ask him/her what the name of the server is and whether you have access to it or not.

 

[callum8]

thanks for your help but this is a home computer

 

[ruve1k]

What SQL database are you trying to import data from?

 

[callum8]

its one i downloaded called adeventure works..

thanks for your time by the way... tbh think this might be a bit beyond me and will just use a access database.

 

[ruve1k]

It'll probably be easier for you to work with Access.
But if you want you can download and install SQL Server Express (free edition) on your local machine and then find instructions on how to install the sample database onto your local instance of SQL Server.