Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
 Posted - 2007-10-21 : 14:01:48
|
| Hi all,i've searched forum and haven't found anything interesting for my problem.I have installed SQL server 2005 (enterprise) 32-bit and have run SQL server Management Studio. (using: Windows XP)What/how shall I install/connect to a server name (database engine)? I have AdventureWorks and would like to use it in Management Studio.thank you for your help. :) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-21 : 16:42:34
|
| If you installed sql client on your machine, you can register sql servers on your network you like to connect to and open object browser to see dbs on the server. |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2007-10-21 : 17:37:09
|
| i'm running on IIS (localhost) and apparently i'm having a problem regarding connection string when deploying/processing Adventure Works DW in Analysis Server.???? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-21 : 19:29:56
|
| AdventureWorksDW is relational db in sql engine, you have to create cube if like to asscee in AS. |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2007-10-22 : 12:50:51
|
| i'm getting error:The project could not be deployed to the 'localhost/AdventureWorks' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. and have no idea what's wrong with my localhost connection, when i'm trying to deploy adventureworks database in my SSAS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 21:20:44
|
| Is AS running on that machine? Try connect with host name instead of localhost. |
|
|
|
|
|
|
installing sql server 2005