asked on

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

Evan Cutler

Wait, sorry.
You post-installed SMSS on the server, and still cannot see the database?

Atouray

ASKER

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.

Evan Cutler

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

Evan Cutler

Also, go into START -> SQL SERVER 2008 -> SS2008 configuration utility, and make sure all named pipes are started (TCP/IP, etc....)

ASKER CERTIFIED SOLUTION

Atouray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Atouray

ASKER

Because I figured out the solution.

Evan Cutler

any chance on getting the points to this?