RE: HELP! Cannot connect to SQL Server
- From: "Chaplain Doug" <ChaplainDoug@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 28 Jan 2006 23:29:34 -0800
Read another post in this forum that said to change the SQL Server
Registration" to use "SQL Server authentication." I did that and was able to
bring up the databases under (LOCAL). However, I could not see the tables,
etc. under my finance databases. Yet they are "working" as I was able to use
the finance software and see all the data. I am able to see the tables, etc.
for all the other DBs under (LOCAL). Hem?
How now may I change the "user default database" which Enterprise Manager
said could not be opened when I was using Windows Authentication? Is this
done in the "Startup parameters" on the "General" tab of the server
properties? If so, it looks like it currently has a default database:
-dC:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf
If this is the case, I do not understand the problem. This file exists, and
the Master database shows up under the databases for (LOCAL) and I can see
its tables etc.
ANY HELP WILL BE GREATLY APPRECIATED. God Bless and thanks.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
"Chaplain Doug" wrote:
> SQL Server 2000. I am new to SQL Server. I have simply had some databases
> that use it, but I have not had to do much with it. However, I went into the
> SQL Server Enterprise Manager and may have hosed myself. Here is my
> configuration:
>
> 1. I have one group called "SQL Server Group"
> 2. It has two "servers," one called (LOCAL) and the other HQSERVER\BKUPEXEC.
>
> I can see the databases under HQSERVER\BKUPEXEC. I can no longer connect to
> the server called (LOCAL), nor see the databases under it. It is this
> "server" that has two of my financial databases under it. When I try to
> connect to this server I get the following error:
>
> >A connection could not be established to (LOCAL)
> >Reason: Cannot open user default database. Login failed.
> >Please verify SQL Server is running and check your SQL Server registration properties.
>
> I recall expanding (LOCAL) and deleting a couple sample databases that
> appeared under it. These were sample financial databases that we do not use,
> but which come with the financial database products. Perhaps this has caused
> my problem?
>
> Can anyone help me? Is there a way to find out what default database
> (LOCAL) is looking for and change it to something that exists? Perhaps in
> the registry? Any help will be GREATLY appreciated. Thanks and God bless.
> --
> Dr. Doug Pruiett
> Good News Jail & Prison Ministry
> www.goodnewsjail.org
.
- Prev by Date: Re: New Install
- Next by Date: Re: New Install
- Previous by thread: Re: New Install
- Next by thread: tempdb size too large
- Index(es):
Relevant Pages
|
