Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot find SSMS on server to connect to SQLExpress2005 Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 4:55 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 2:56 PM
Points: 18, Visits: 154
Hi everyone,
I have a SQL Express 2005 instance on our Blackberry server. I can see the location of the database and log files on the E drive and the error logs etc but I can't connect to the instance as I cannot find any software on the server to let me to do so. I also don't have access to the server myself via windows authentication and we don't know the sa password so cannot connect from my own SSMS on my laptop. I've searched both C and E drive for ssms, all .exe's and found no SQL software
Any ideas?
thanks
G
Post #1511054
Posted Tuesday, November 5, 2013 6:30 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 7:40 AM
Points: 664, Visits: 6,701
Find someone who is an admin on the server.
That would be the quickest way to resolve it. They should be able to decide how they want to grant access for you.

Also double check that you are specifiying the instance correctly on your local SSMS.

If you are not using SA, you still need to connect with SSMS using an account (SQL or Windows) that has access to the database(s).

Post #1511462
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse