Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

Can't login to specific database with user sa, all others okay

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Aerik - 14 Mar 2008 20:07 GMT
Hi,

I'm hoping someone can shed some light on this.  We're using sql
server express edition, and our server has a couple of databases (in
addition to the built in ones).  We've been using user sa, with a
password set (non-blank) to access the databases.  Suddenly, we can't
access the one of them.  Unfortunately, we have no other users
configured with access to it either.  Logging in with windows
authentication (as administrator) does not grant us access to the
database either.  What can cause this?  How can we fix it?

Thanks,
Aerik
Linchi Shea - 15 Mar 2008 05:30 GMT
What error message are you getting when you try to query the database?

Linchi

> Hi,
>
[quoted text clipped - 9 lines]
> Thanks,
> Aerik
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.