|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL cannot connect to database for OnePoint/MOM/ForeFront all of the sudden???
I just noticed today that my MOM/ForeFront server wasn't working anymore, so
I've worked backwards and I notice now that SQL cannot open the OnePoint database via the SQL Management studio. I've checked the logs and it says: 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open database "OnePoint" requested by the login. The login failed. [SQLSTATE 42000] 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'domain\sql'. [SQLSTATE 28000] The SQL server process is running as DOMAIN\SQL and it did start, so I am perplexed as to what I need to do to fix this. Any ideas? Did you try to login to teh SQL instance using some other login and check if
the database is online? Linchi Show quoteHide quote "Andrew Weaver" wrote: > I just noticed today that my MOM/ForeFront server wasn't working anymore, so > I've worked backwards and I notice now that SQL cannot open the OnePoint > database via the SQL Management studio. > > I've checked the logs and it says: > > 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open > database "OnePoint" requested by the login. The login failed. [SQLSTATE > 42000] > 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 18456<c/> Login failed for > user 'domain\sql'. [SQLSTATE 28000] > > The SQL server process is running as DOMAIN\SQL and it did start, so I am > perplexed as to what I need to do to fix this. > > Any ideas? > I'm logging in as administrator...
shouldn't I be able to see it? thanks, -Drew Show quoteHide quote "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message news:29E75AE0-7C2C-451A-A90D-0077BDA8F636@microsoft.com... > Did you try to login to teh SQL instance using some other login and check > if > the database is online? > > Linchi > > "Andrew Weaver" wrote: > >> I just noticed today that my MOM/ForeFront server wasn't working anymore, >> so >> I've worked backwards and I notice now that SQL cannot open the OnePoint >> database via the SQL Management studio. >> >> I've checked the logs and it says: >> >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open >> database "OnePoint" requested by the login. The login failed. [SQLSTATE >> 42000] >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 18456<c/> Login failed >> for >> user 'domain\sql'. [SQLSTATE 28000] >> >> The SQL server process is running as DOMAIN\SQL and it did start, so I am >> perplexed as to what I need to do to fix this. >> >> Any ideas? >> So you are logged in as admin via SSMS and expect to see a database on the
list, but you don't see it. Try select * from sys.databases to see if it is listed there. Linchi Show quoteHide quote "Andrew Weaver" wrote: > I'm logging in as administrator... > > shouldn't I be able to see it? > > thanks, > -Drew > > "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message > news:29E75AE0-7C2C-451A-A90D-0077BDA8F636@microsoft.com... > > Did you try to login to teh SQL instance using some other login and check > > if > > the database is online? > > > > Linchi > > > > "Andrew Weaver" wrote: > > > >> I just noticed today that my MOM/ForeFront server wasn't working anymore, > >> so > >> I've worked backwards and I notice now that SQL cannot open the OnePoint > >> database via the SQL Management studio. > >> > >> I've checked the logs and it says: > >> > >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open > >> database "OnePoint" requested by the login. The login failed. [SQLSTATE > >> 42000] > >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 18456<c/> Login failed > >> for > >> user 'domain\sql'. [SQLSTATE 28000] > >> > >> The SQL server process is running as DOMAIN\SQL and it did start, so I am > >> perplexed as to what I need to do to fix this. > >> > >> Any ideas? > >> > > Hi,
Sorry if I didn't explain clearly. What happens is when I am in the SSMS I see the name of the databases for ForeFront and MOM in the list but I can't expand the trees (i.e. view the tables, etc) if I right click on one of them and go to properties it gives me an error regarding not being able to find the files, or not enough disk space/memory and tells me to check the SQL log for more details, when I look at the SQL log I get the login error I pasted originally. thanks, -Drew Show quoteHide quote "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message news:FEF19375-9D4E-4AAC-8FEE-0545B52749D1@microsoft.com... > So you are logged in as admin via SSMS and expect to see a database on the > list, but you don't see it. Try select * from sys.databases to see if it > is > listed there. > > Linchi > > "Andrew Weaver" wrote: > >> I'm logging in as administrator... >> >> shouldn't I be able to see it? >> >> thanks, >> -Drew >> >> "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message >> news:29E75AE0-7C2C-451A-A90D-0077BDA8F636@microsoft.com... >> > Did you try to login to teh SQL instance using some other login and >> > check >> > if >> > the database is online? >> > >> > Linchi >> > >> > "Andrew Weaver" wrote: >> > >> >> I just noticed today that my MOM/ForeFront server wasn't working >> >> anymore, >> >> so >> >> I've worked backwards and I notice now that SQL cannot open the >> >> OnePoint >> >> database via the SQL Management studio. >> >> >> >> I've checked the logs and it says: >> >> >> >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open >> >> database "OnePoint" requested by the login. The login failed. >> >> [SQLSTATE >> >> 42000] >> >> 07/08/2009 09:35:01,,Error,[298] SQLServer Error: 18456<c/> Login >> >> failed >> >> for >> >> user 'domain\sql'. [SQLSTATE 28000] >> >> >> >> The SQL server process is running as DOMAIN\SQL and it did start, so I >> >> am >> >> perplexed as to what I need to do to fix this. >> >> >> >> Any ideas? >> >> >> >> Andrew Weaver (awea***@ee.net) writes:
> What happens is when I am in the SSMS I see the name of the databases So the OnePoint database is not feeling well. What does> for ForeFront and MOM in the list but I can't expand the trees (i.e. > view the tables, etc) if I right click on one of them and go to > properties it gives me an error regarding not being able to find the > files, or not enough disk space/memory and tells me to check the SQL log > for more details, when I look at the SQL log I get the login error I > pasted originally. SELECT status_desc, user_acceess_desc FROM sys.databases WHERE name = 'OnePoint' say? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx .... also check the SQL Server errorlog file for related errors.
-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9C42F2AEC5201Yazorman@127.0.0.1... > Andrew Weaver (awea***@ee.net) writes: >> What happens is when I am in the SSMS I see the name of the >> databases >> for ForeFront and MOM in the list but I can't expand the trees >> (i.e. >> view the tables, etc) if I right click on one of them and go to >> properties it gives me an error regarding not being able to find >> the >> files, or not enough disk space/memory and tells me to check the >> SQL log >> for more details, when I look at the SQL log I get the login error >> I >> pasted originally. > > So the OnePoint database is not feeling well. What does > > SELECT status_desc, user_acceess_desc > FROM sys.databases > WHERE name = 'OnePoint' > > say? > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > Hi,
The only errors in the SQL error log over and over say that it cannot open the database OnePoint due to a login failure and then below that it says login failed for user DOMAIN\SQL thanks, Show quoteHide quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:Oel7sZFAKHA.5068@TK2MSFTNGP03.phx.gbl... > ... also check the SQL Server errorlog file for related errors. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Erland Sommarskog" <esq***@sommarskog.se> wrote in message > news:Xns9C42F2AEC5201Yazorman@127.0.0.1... >> Andrew Weaver (awea***@ee.net) writes: >>> What happens is when I am in the SSMS I see the name of the databases >>> for ForeFront and MOM in the list but I can't expand the trees (i.e. >>> view the tables, etc) if I right click on one of them and go to >>> properties it gives me an error regarding not being able to find the >>> files, or not enough disk space/memory and tells me to check the SQL log >>> for more details, when I look at the SQL log I get the login error I >>> pasted originally. >> >> So the OnePoint database is not feeling well. What does >> >> SELECT status_desc, user_acceess_desc >> FROM sys.databases >> WHERE name = 'OnePoint' >> >> say? >> >> -- >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> Links for SQL Server Books Online: >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >> SQL 2000: >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> > I think we need more detailed error messages from a to z. You do
something in some application (be it SSMS or something else), where you get some errors: You said in your OP: >>>> What happens is when I am in the SSMS I see the name of the I think we would need more details about exactly what/where you click >>>> databases >>>> for ForeFront and MOM in the list but I can't expand the trees >>>> (i.e. >>>> view the tables, etc) if I right click on one of them and go to >>>> properties it gives me an error regarding not being able to find >>>> the >>>> files, or not enough disk space/memory and tells me to check the >>>> SQL log >>>> for more details, when I look at the SQL log I get the login >>>> error I >>>> pasted originally. and the exact error messages. Also, a re-start of SQL Server and posting the messages from errorlog file would help. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Andrew Weaver" <awea***@ee.net> wrote in message news:24127BED-D0B6-4858-8680-E83BD9540DBB@microsoft.com... > Hi, > > The only errors in the SQL error log over and over say that it > cannot open the database OnePoint due to a login failure and then > below that it says login failed for user DOMAIN\SQL > > thanks, > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:Oel7sZFAKHA.5068@TK2MSFTNGP03.phx.gbl... >> ... also check the SQL Server errorlog file for related errors. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Erland Sommarskog" <esq***@sommarskog.se> wrote in message >> news:Xns9C42F2AEC5201Yazorman@127.0.0.1... >>> Andrew Weaver (awea***@ee.net) writes: >>>> What happens is when I am in the SSMS I see the name of the >>>> databases >>>> for ForeFront and MOM in the list but I can't expand the trees >>>> (i.e. >>>> view the tables, etc) if I right click on one of them and go to >>>> properties it gives me an error regarding not being able to find >>>> the >>>> files, or not enough disk space/memory and tells me to check the >>>> SQL log >>>> for more details, when I look at the SQL log I get the login >>>> error I >>>> pasted originally. >>> >>> So the OnePoint database is not feeling well. What does >>> >>> SELECT status_desc, user_acceess_desc >>> FROM sys.databases >>> WHERE name = 'OnePoint' >>> >>> say? >>> >>> -- >>> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >>> >>> Links for SQL Server Books Online: >>> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >>> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >>> SQL 2000: >>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >>> >> > Okay,
I restart SQL. There are no errors in the log. The "OnePoint" database is in the menu in SMSS put has no + sign next to it, so you cannot expand it, look at the tables, or do anything with it. I right click on "OnePoint" and click properties. An error is displayed: Cannot show requested dialog. Additional Information cannot show requested dialog. (SqlMgmt) An exception occured while executing a transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Database 'OnePoint' cannot be opened due to inaccessible files or insufficent memory or disk space. See the SQL server errorlog for details. (Microsoft SQL Server, Error: 945) The log: Date,Source,Severity,Message 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open database "OnePoint" requested by the login. The login failed. [SQLSTATE 42000] 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'domain\sql'. [SQLSTATE 28000] 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open database "OnePoint" requested by the login. The login failed. [SQLSTATE 42000] 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open database "OnePoint" requested by the login. The login failed. [SQLSTATE 42000] 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'domain\sql'. [SQLSTATE 28000] 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login failed for user 'domain\sql'. [SQLSTATE 28000] Hope this is more clear. thanks, -Drew Show quoteHide quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uHPpt0KAKHA.1208@TK2MSFTNGP03.phx.gbl... >I think we need more detailed error messages from a to z. You do something >in some application (be it SSMS or something else), where you get some >errors: You said in your OP: > >>>>> What happens is when I am in the SSMS I see the name of the databases >>>>> for ForeFront and MOM in the list but I can't expand the trees (i.e. >>>>> view the tables, etc) if I right click on one of them and go to >>>>> properties it gives me an error regarding not being able to find the >>>>> files, or not enough disk space/memory and tells me to check the SQL >>>>> log >>>>> for more details, when I look at the SQL log I get the login error I >>>>> pasted originally. > > I think we would need more details about exactly what/where you click and > the exact error messages. Also, a re-start of SQL Server and posting the > messages from errorlog file would help. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Andrew Weaver" <awea***@ee.net> wrote in message > news:24127BED-D0B6-4858-8680-E83BD9540DBB@microsoft.com... >> Hi, >> >> The only errors in the SQL error log over and over say that it cannot >> open the database OnePoint due to a login failure and then below that it >> says login failed for user DOMAIN\SQL >> >> thanks, >> >> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote >> in message news:Oel7sZFAKHA.5068@TK2MSFTNGP03.phx.gbl... >>> ... also check the SQL Server errorlog file for related errors. >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://sqlblog.com/blogs/tibor_karaszi >>> >>> >>> "Erland Sommarskog" <esq***@sommarskog.se> wrote in message >>> news:Xns9C42F2AEC5201Yazorman@127.0.0.1... >>>> Andrew Weaver (awea***@ee.net) writes: >>>>> What happens is when I am in the SSMS I see the name of the databases >>>>> for ForeFront and MOM in the list but I can't expand the trees (i.e. >>>>> view the tables, etc) if I right click on one of them and go to >>>>> properties it gives me an error regarding not being able to find the >>>>> files, or not enough disk space/memory and tells me to check the SQL >>>>> log >>>>> for more details, when I look at the SQL log I get the login error I >>>>> pasted originally. >>>> >>>> So the OnePoint database is not feeling well. What does >>>> >>>> SELECT status_desc, user_acceess_desc >>>> FROM sys.databases >>>> WHERE name = 'OnePoint' >>>> >>>> say? >>>> >>>> -- >>>> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >>>> >>>> Links for SQL Server Books Online: >>>> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >>>> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >>>> SQL 2000: >>>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >>>> >>> >> > > There are no errors in the log. I would have expected errors in the SQL Server errorlog file. Are you 100% certain you are looking in the right one - double and tripple checked? > The "OnePoint" database is in the menu in SMSS put has no + sign The messages you describe here really do suggest that there is a > next to it, so you cannot expand it, look at the tables, or do > anything with it. > > I right click on "OnePoint" and click properties. problem with one or more of the database files that constitutes that database. The errorlog file would/should have details. Checking eventlog might also be an option. > Hmm, OK. Seems like some login (domain\sql) is trying to connect, but > Date,Source,Severity,Message > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot > open database "OnePoint" requested by the login. The login failed. > [SQLSTATE 42000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login > failed for user 'domain\sql'. [SQLSTATE 28000] the database which is either default for this login or as specified in the connection string for the app in question isn't available. I'm out of ideas, I'm afraid unless you can hunt down those startup messages. If there really aren't any, I suggest you open a case with MS Support... -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Andrew Weaver" <awea***@ee.net> wrote in message news:DD7040C7-8159-4CA3-9E74-D72CA12EF844@microsoft.com... > Okay, > > I restart SQL. > > There are no errors in the log. > > The "OnePoint" database is in the menu in SMSS put has no + sign > next to it, so you cannot expand it, look at the tables, or do > anything with it. > > I right click on "OnePoint" and click properties. > > An error is displayed: > > Cannot show requested dialog. > Additional Information > cannot show requested dialog. (SqlMgmt) > An exception occured while executing a transact-SQL statement > or batch. (Microsoft.SqlServer.ConnectionInfo) > Database 'OnePoint' cannot be opened due to inaccessible > files or insufficent memory or disk space. See the SQL server > errorlog for details. (Microsoft SQL Server, Error: 945) > > The log: > > Date,Source,Severity,Message > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot > open database "OnePoint" requested by the login. The login failed. > [SQLSTATE 42000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login > failed for user 'domain\sql'. [SQLSTATE 28000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot > open database "OnePoint" requested by the login. The login failed. > [SQLSTATE 42000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot > open database "OnePoint" requested by the login. The login failed. > [SQLSTATE 42000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login > failed for user 'domain\sql'. [SQLSTATE 28000] > 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login > failed for user 'domain\sql'. [SQLSTATE 28000] > > Hope this is more clear. > > thanks, > -Drew > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> > wrote in message news:uHPpt0KAKHA.1208@TK2MSFTNGP03.phx.gbl... >>I think we need more detailed error messages from a to z. You do >>something in some application (be it SSMS or something else), where >>you get some errors: You said in your OP: >> >>>>>> What happens is when I am in the SSMS I see the name of the >>>>>> databases >>>>>> for ForeFront and MOM in the list but I can't expand the trees >>>>>> (i.e. >>>>>> view the tables, etc) if I right click on one of them and go to >>>>>> properties it gives me an error regarding not being able to >>>>>> find the >>>>>> files, or not enough disk space/memory and tells me to check >>>>>> the SQL log >>>>>> for more details, when I look at the SQL log I get the login >>>>>> error I >>>>>> pasted originally. >> >> I think we would need more details about exactly what/where you >> click and the exact error messages. Also, a re-start of SQL Server >> and posting the messages from errorlog file would help. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Andrew Weaver" <awea***@ee.net> wrote in message >> news:24127BED-D0B6-4858-8680-E83BD9540DBB@microsoft.com... >>> Hi, >>> >>> The only errors in the SQL error log over and over say that it >>> cannot open the database OnePoint due to a login failure and then >>> below that it says login failed for user DOMAIN\SQL >>> >>> thanks, >>> >>> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> >>> wrote in message news:Oel7sZFAKHA.5068@TK2MSFTNGP03.phx.gbl... >>>> ... also check the SQL Server errorlog file for related errors. >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://sqlblog.com/blogs/tibor_karaszi >>>> >>>> >>>> "Erland Sommarskog" <esq***@sommarskog.se> wrote in message >>>> news:Xns9C42F2AEC5201Yazorman@127.0.0.1... >>>>> Andrew Weaver (awea***@ee.net) writes: >>>>>> What happens is when I am in the SSMS I see the name of the >>>>>> databases >>>>>> for ForeFront and MOM in the list but I can't expand the trees >>>>>> (i.e. >>>>>> view the tables, etc) if I right click on one of them and go to >>>>>> properties it gives me an error regarding not being able to >>>>>> find the >>>>>> files, or not enough disk space/memory and tells me to check >>>>>> the SQL log >>>>>> for more details, when I look at the SQL log I get the login >>>>>> error I >>>>>> pasted originally. >>>>> >>>>> So the OnePoint database is not feeling well. What does >>>>> >>>>> SELECT status_desc, user_acceess_desc >>>>> FROM sys.databases >>>>> WHERE name = 'OnePoint' >>>>> >>>>> say? >>>>> >>>>> -- >>>>> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >>>>> >>>>> Links for SQL Server Books Online: >>>>> SQL 2008: >>>>> http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >>>>> SQL 2005: >>>>> http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >>>>> SQL 2000: >>>>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >>>>> >>>> >>> >> > >> Date,Source,Severity,Message That error is written to the log when I try to connect to the OnePoint >> 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot open >> database "OnePoint" requested by the login. The login failed. [SQLSTATE >> 42000] >> 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login failed >> for user 'domain\sql'. [SQLSTATE 28000] > > Hmm, OK. Seems like some login (domain\sql) is trying to connect, but the > database which is either default for this login or as specified in the > connection string for the app in question isn't available. > database from SMSS.......... There is no application involved here. -Drew > That error is written to the log when I try to connect to the Then SSMS is the application. It will attempt to connect either to the > OnePoint database from SMSS.......... > > There is no application involved here. default database for the login, or to the database as specified in the connect dialog. See if Erland's suggestion will help out. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Andrew Weaver" <awea***@ee.net> wrote in message news:5C7F9D33-1500-4F8F-A0A2-05DF0A8EBFFA@microsoft.com... >>> Date,Source,Severity,Message >>> 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 4060<c/> Cannot >>> open database "OnePoint" requested by the login. The login failed. >>> [SQLSTATE 42000] >>> 07/09/2009 13:20:01,,Error,[298] SQLServer Error: 18456<c/> Login >>> failed for user 'domain\sql'. [SQLSTATE 28000] >> >> Hmm, OK. Seems like some login (domain\sql) is trying to connect, >> but the database which is either default for this login or as >> specified in the connection string for the app in question isn't >> available. >> > > That error is written to the log when I try to connect to the > OnePoint database from SMSS.......... > > There is no application involved here. > > -Drew > Hi,
SELECT status_desc, user_access_desc FROM sys.databases WHERE name = 'OnePoint' returns: Msg 207, Level 16, State 1, Line 1 Invalid column name 'status_desc'. SELECT user_access_desc FROM sys.databases WHERE name = 'OnePoint' returns: MULTI_USER Thanks for taking a stab at this. Show quoteHide quote "Erland Sommarskog" <esq***@sommarskog.se> wrote in message news:Xns9C42F2AEC5201Yazorman@127.0.0.1... > Andrew Weaver (awea***@ee.net) writes: >> What happens is when I am in the SSMS I see the name of the databases >> for ForeFront and MOM in the list but I can't expand the trees (i.e. >> view the tables, etc) if I right click on one of them and go to >> properties it gives me an error regarding not being able to find the >> files, or not enough disk space/memory and tells me to check the SQL log >> for more details, when I look at the SQL log I get the login error I >> pasted originally. > > So the OnePoint database is not feeling well. What does > > SELECT status_desc, user_acceess_desc > FROM sys.databases > WHERE name = 'OnePoint' > > say? > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > Andrew Weaver (awea***@ee.net) writes:
> SELECT status_desc, user_access_desc I'm sorry about the spelling error, the correct column name is state_desc.> FROM sys.databases > WHERE name = 'OnePoint' > > returns: Msg 207, Level 16, State 1, Line 1 > Invalid column name 'status_desc'. > > SELECT user_access_desc > FROM sys.databases > WHERE name = 'OnePoint' This is the query: SELECT state_desc, user_access_desc, is_auto_close_on FROM sys.databases WHERE name = 'OnePoint' Note that I've added one more column. In any case, it's clear from the error message you posted that your database is in trouble. You said you restarted SQL Server. If you open the SQL Server errorlog, and search for "OnePoint" from the beginning, what does the first messages say? Can you go to the directory where the MDF and LDF files are supposed to be, and check that the files are there? Also check that there is space on the disk. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  
Other interesting topics
using profiler to log master.sysprocesses entries ?
Best Practices - using params passed to stored procedure Locks and SQLAgent - Generic refresher, Alert Engine Connection server utilizing trusted connection to other SQL Server RESTORING drop table not showing up in the transaction log deleting DB Backups & Transaction Files How best to move large databases? SQL 2k and autonumbering |
|||||||||||||||||||||||
