• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Accessing sql server 2008 analysis service database on cmd

I have currently installed SQL server without the management studio but now I want to delete a database on the analysis service but I cannot after installing the management studio because I cannot see the analysis service on the connect to tab. Is there anyway I can access the services from command prompt and delete the database?

Thank you
0
Atouray
Asked:
Atouray
  • 4
  • 3
1 Solution
 
Evan CutlerVolunteer Chief Information OfficerCommented:
Wait, sorry.
You post-installed SMSS on the server, and still cannot see the database?
0
 
AtourayAuthor Commented:
Yes, I downloaded the free version of ssms R2 edition. I cannot use the one from the SQL R2 dvd because i get the error that the instance installed does not have an ID.
0
 
Evan CutlerVolunteer Chief Information OfficerCommented:
ok...

Lets attack this in two points:

One.
Sounds like you have a service that's not running.
You should be able to connect SMSS to any database with the services running.
Go to Start->Control Panel->Administrative Services->Services
look for everything that starts with SQL Server and see if somethings' turned off...turn it on.
go back to SMSS and try to connect to the database.

Two.
What your asking for is SQLCMD
http://www.youtube.com/watch?v=eKuVKn4jtqA  <--intro video
http://blog.mclaughlinsoftware.com/2009/05/16/fix-sql-server-2008-client/   <-- to get it to work if SQLCMD refuses to fire.
http://databases.about.com/od/sqlserver/ss/sqlcmd.htm  <-- good start point
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Evan CutlerVolunteer Chief Information OfficerCommented:
Also, go into START -> SQL SERVER 2008 -> SS2008 configuration utility, and make sure all named pipes are started (TCP/IP, etc....)
0
 
AtourayAuthor Commented:
I got it. I stopped the services, went to the OLAP dirctory and deleted the references to that databases. Restarted the service and everything went back to normal. Thank you all
0
 
AtourayAuthor Commented:
Because I figured out the solution.
0
 
Evan CutlerVolunteer Chief Information OfficerCommented:
any chance on getting the points to this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now