Hi,
I've already configured a few databases from our server A to use mirroring
to our DR server. Now I've got a different primary server B and I am trying
to configure it so it mirrors to the same DR server. But I can't.
Is it supposed to work on the same port number as the first mirroring
connection between A & DR? or B & DR has to use a different port number? I've
also tried using a different port number (first check with netstat that it's
not used), but the Wizard doesn't allow me to enter a different port number
it still defaults to the same as between A & DR.
The error says that: The server network address "TCP://DR-server.local:5022"
can not be reached or does not exist. Check the network address name and that
the ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)
Any ideas? Thanks.
Panos.
I have the same problem. Three new servers setting up a mirror from a to b
with c as the witness. I have verified that I can connect to each from each
by going to a DOS prompt on each and executing "osql -Usa
-SserverDNSname,5022" It returns with an osql command prompt. I am using SQL
server 2005 Standard with SP2 on windows server 2003 sp1.
While going through the mirror setup wizard I get the error:
An error occurred while starting mirroring.
Additional information:
Alter fail for database 'test'. (Microsoft.sqlserver.smo)
An exception occurred while executing a transact-sql statement or batch.
(Micorosft.sqlserver.connectioninfo)
The server networkaddress "TCP://address.given.here.com:5022" can not be
reached or does not exists. Check the network address name and that the ports
for the local and remote endpoints are operational. (Microsoft sql server,
Error: 1418)
I did verify that the dsn names resolve. I used both integrated NT accounts
for authentication and the SQL Server sa account for setting up security
between all the servers and the same message results.
I used a port scanner and netstat to verify that 5022 is live.
It gets this message when it attempts to connect to the local host where
mirroring is being initiated from. There is no opportunity to put in
authentication information for the local host when setting up mirroring. I am
using an account that is in the administrators group on all three servers.
These servers are not part of a domain.
Seems to me there is a fundamental flaw with mirror setup.
Suggestions for further diagnosing this problem would be helpful.
|||Well mine is slightly different as the DR server (B) I am trying to make the
target has already been set-up successfully for mirroring with another server
(A). I am now trying to setup mirroring from Server C to server B but I get
the error message. Are you sure you can use mirroring with Developer edition?
I thought you need Enterprise but maybe that was before SP2. Check this
anyway.
Panos.
"DBA449" wrote:
> I have the same problem. Three new servers setting up a mirror from a to b
> with c as the witness. I have verified that I can connect to each from each
> by going to a DOS prompt on each and executing "osql -Usa
> -SserverDNSname,5022" It returns with an osql command prompt. I am using SQL
> server 2005 Standard with SP2 on windows server 2003 sp1.
> While going through the mirror setup wizard I get the error:
> An error occurred while starting mirroring.
> Additional information:
> Alter fail for database 'test'. (Microsoft.sqlserver.smo)
> An exception occurred while executing a transact-sql statement or batch.
> (Micorosft.sqlserver.connectioninfo)
> The server networkaddress "TCP://address.given.here.com:5022" can not be
> reached or does not exists. Check the network address name and that the ports
> for the local and remote endpoints are operational. (Microsoft sql server,
> Error: 1418)
> I did verify that the dsn names resolve. I used both integrated NT accounts
> for authentication and the SQL Server sa account for setting up security
> between all the servers and the same message results.
> I used a port scanner and netstat to verify that 5022 is live.
> It gets this message when it attempts to connect to the local host where
> mirroring is being initiated from. There is no opportunity to put in
> authentication information for the local host when setting up mirroring. I am
> using an account that is in the administrators group on all three servers.
> These servers are not part of a domain.
> Seems to me there is a fundamental flaw with mirror setup.
> Suggestions for further diagnosing this problem would be helpful.
|||Mirroring is now supported for SQL Server Standard edition 2005 with SP2
installed. I saw this on the Microsoft web site.
"Panos Stavroulis." wrote:
[vbcol=seagreen]
> Well mine is slightly different as the DR server (B) I am trying to make the
> target has already been set-up successfully for mirroring with another server
> (A). I am now trying to setup mirroring from Server C to server B but I get
> the error message. Are you sure you can use mirroring with Developer edition?
> I thought you need Enterprise but maybe that was before SP2. Check this
> anyway.
> Panos.
> "DBA449" wrote:
|||Microsoft?
I think we need a little help here?
What da ya sa...
"Panos Stavroulis." wrote:
> Hi,
> I've already configured a few databases from our server A to use mirroring
> to our DR server. Now I've got a different primary server B and I am trying
> to configure it so it mirrors to the same DR server. But I can't.
> Is it supposed to work on the same port number as the first mirroring
> connection between A & DR? or B & DR has to use a different port number? I've
> also tried using a different port number (first check with netstat that it's
> not used), but the Wizard doesn't allow me to enter a different port number
> it still defaults to the same as between A & DR.
>
> The error says that: The server network address "TCP://DR-server.local:5022"
> can not be reached or does not exist. Check the network address name and that
> the ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
> Any ideas? Thanks.
> Panos.
|||Solution found.
In my case the problem was that I had used the SQL Server Configuration
Manager to configure SQL Server to listen on port 5022. The documentation had
led me to believe that this had to be confgured manually when I couldn't
originally get it to work.
Apparently SQLServer will automatically set up that port to listen on when
mirroring is configured. If you set it up manually, it conflicts with the
automatic configuration.
I opened a case with Microsoft to resolve this issue, and they led me down a
path to configure SQLServer to run under a domain account. Previously I had
it configured to run as a local account in the administrators group. This
path led nowhere, the same error always resulted. Currently I have SQL server
to run under a local account that is part of the administrators group on all
three servers, principle, mirror and witness. And it seems to be functioning
fine.
Further, I was led to believe that you had to log in to the server using the
same account that SQL Server was running under in order to properly configure
SQLServer. This is not true either. I use one account to log into the server
for administrative purposes, and SQLServer runs under a different account.
"DBA449" wrote:
[vbcol=seagreen]
> Mirroring is now supported for SQL Server Standard edition 2005 with SP2
> installed. I saw this on the Microsoft web site.
> "Panos Stavroulis." wrote:
|||I had to revisit this!! The issue is resolved by creating a certificate on
the server, then linking it with the end point. Transferring the file to the
target, load and link with the other end point.
Panos.
"DBA449" wrote:
[vbcol=seagreen]
> Microsoft?
> I think we need a little help here?
> What da ya sa...
> "Panos Stavroulis." wrote:
|||that is what microsoft told me to do. But as indicated in the previous post,
it was not necessary
"Panos Stavroulis." wrote:
[vbcol=seagreen]
> I had to revisit this!! The issue is resolved by creating a certificate on
> the server, then linking it with the end point. Transferring the file to the
> target, load and link with the other end point.
> Panos.
> "DBA449" wrote:
sql
Showing posts with label databases. Show all posts
Showing posts with label databases. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Can't automate backup of a database
When I try and do a maintenace plan to backup all databases there is one tha
t
does not get backedup. All the others seem to work fine. So I try to make
a
new maintenance plan to backup only that database and when I try and create
the plan that database is not in the list of databases. I suppose that is
why it is not working. However I can right click the database and back it u
p
manually with no problems.
Anyone know why it does not show in the list of avaliable databases to be
backed up?
Thanks,
EdIs that a system database or user? If system which database is it?
"Ed R." wrote:
> When I try and do a maintenace plan to backup all databases there is one t
hat
> does not get backedup. All the others seem to work fine. So I try to mak
e a
> new maintenance plan to backup only that database and when I try and creat
e
> the plan that database is not in the list of databases. I suppose that is
> why it is not working. However I can right click the database and back it
up
> manually with no problems.
> Anyone know why it does not show in the list of avaliable databases to be
> backed up?
> Thanks,
> Ed|||It is a user database.
"Bob" wrote:
[vbcol=seagreen]
> Is that a system database or user? If system which database is it?
> "Ed R." wrote:
>|||Ed R. wrote:
> It is a user database.
> "Bob" wrote:
>
Is this a FULL backup or a transaction log backup? What recovery model
is the database using?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The recovery model is simple. When I start a new maintenance task, I drag
the 'backup database task' to the right and then click on it to edit. By
default 'FULL' is selected and greyed out. Then when I try to select the
database from those avaliable it does not show up.
"Tracy McKibben" wrote:
> Ed R. wrote:
> Is this a FULL backup or a transaction log backup? What recovery model
> is the database using?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Lines: 1
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
In-Reply-To: <6BE17578-B64D-496D-96FE-4E4CCAD48E14@.microsoft.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ncsgate.ncspearson.com 12.106.111.10
Xref: leafnode.mcse.ms microsoft.public.sqlserver.server:10199
Ed R. wrote:
> The recovery model is simple. When I start a new maintenance task, I drag
> the 'backup database task' to the right and then click on it to edit. By
> default 'FULL' is selected and greyed out. Then when I try to select the
> database from those avaliable it does not show up.
>
I guess I don't have any further suggestions... I don't use the
maintenance plan wizards, for this very reason. When one of them
doesn't work, you have no idea why.
You might be interested in this script that I use to do backups:
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
It will automatically backup any database on your server, including
transaction logs if appropriate. Schedule it once and forget it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A user db doesn't show up in the list only when it's taken offline. Right
click on the database then go to Tasks and click on Bring online then you
should be able to see it.
Another thing, you can't create maintenance plans if you are not a sysadmin
on a server. If you have dbo rights on the database or you are backup
operator you can take the backup from Enterprise Manager but not using
maintenance plans.
If it's none of the above then someone else might need to jump on this issue
to help you out.
Bob
"Tracy McKibben" wrote:
> Ed R. wrote:
> I guess I don't have any further suggestions... I don't use the
> maintenance plan wizards, for this very reason. When one of them
> doesn't work, you have no idea why.
> You might be interested in this script that I use to do backups:
> http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
> It will automatically backup any database on your server, including
> transaction logs if appropriate. Schedule it once and forget it.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||I would guess it's related to whatever the state is of the
database. There are different database states and statuses
that will keep the database from being displayed in the
maintenance plan screen. Being that it's just the one
database for which a maintenance plan can't be created, I
would suspect it's related to whatever the state or the
other status values are for the database in sys.databases.
-Sue
On Wed, 23 Aug 2006 12:27:01 -0700, Bob
<Bob@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>A user db doesn't show up in the list only when it's taken offline. Right
>click on the database then go to Tasks and click on Bring online then you
>should be able to see it.
>Another thing, you can't create maintenance plans if you are not a sysadmin
>on a server. If you have dbo rights on the database or you are backup
>operator you can take the backup from Enterprise Manager but not using
>maintenance plans.
>If it's none of the above then someone else might need to jump on this issu
e
>to help you out.
>Bob
>"Tracy McKibben" wrote:
>sql
t
does not get backedup. All the others seem to work fine. So I try to make
a
new maintenance plan to backup only that database and when I try and create
the plan that database is not in the list of databases. I suppose that is
why it is not working. However I can right click the database and back it u
p
manually with no problems.
Anyone know why it does not show in the list of avaliable databases to be
backed up?
Thanks,
EdIs that a system database or user? If system which database is it?
"Ed R." wrote:
> When I try and do a maintenace plan to backup all databases there is one t
hat
> does not get backedup. All the others seem to work fine. So I try to mak
e a
> new maintenance plan to backup only that database and when I try and creat
e
> the plan that database is not in the list of databases. I suppose that is
> why it is not working. However I can right click the database and back it
up
> manually with no problems.
> Anyone know why it does not show in the list of avaliable databases to be
> backed up?
> Thanks,
> Ed|||It is a user database.
"Bob" wrote:
[vbcol=seagreen]
> Is that a system database or user? If system which database is it?
> "Ed R." wrote:
>|||Ed R. wrote:
> It is a user database.
> "Bob" wrote:
>
Is this a FULL backup or a transaction log backup? What recovery model
is the database using?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The recovery model is simple. When I start a new maintenance task, I drag
the 'backup database task' to the right and then click on it to edit. By
default 'FULL' is selected and greyed out. Then when I try to select the
database from those avaliable it does not show up.
"Tracy McKibben" wrote:
> Ed R. wrote:
> Is this a FULL backup or a transaction log backup? What recovery model
> is the database using?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Lines: 1
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
In-Reply-To: <6BE17578-B64D-496D-96FE-4E4CCAD48E14@.microsoft.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: ncsgate.ncspearson.com 12.106.111.10
Xref: leafnode.mcse.ms microsoft.public.sqlserver.server:10199
Ed R. wrote:
> The recovery model is simple. When I start a new maintenance task, I drag
> the 'backup database task' to the right and then click on it to edit. By
> default 'FULL' is selected and greyed out. Then when I try to select the
> database from those avaliable it does not show up.
>
I guess I don't have any further suggestions... I don't use the
maintenance plan wizards, for this very reason. When one of them
doesn't work, you have no idea why.
You might be interested in this script that I use to do backups:
http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
It will automatically backup any database on your server, including
transaction logs if appropriate. Schedule it once and forget it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A user db doesn't show up in the list only when it's taken offline. Right
click on the database then go to Tasks and click on Bring online then you
should be able to see it.
Another thing, you can't create maintenance plans if you are not a sysadmin
on a server. If you have dbo rights on the database or you are backup
operator you can take the backup from Enterprise Manager but not using
maintenance plans.
If it's none of the above then someone else might need to jump on this issue
to help you out.
Bob
"Tracy McKibben" wrote:
> Ed R. wrote:
> I guess I don't have any further suggestions... I don't use the
> maintenance plan wizards, for this very reason. When one of them
> doesn't work, you have no idea why.
> You might be interested in this script that I use to do backups:
> http://realsqlguy.com/serendipity/a...-Send-In-Backup!.html
> It will automatically backup any database on your server, including
> transaction logs if appropriate. Schedule it once and forget it.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||I would guess it's related to whatever the state is of the
database. There are different database states and statuses
that will keep the database from being displayed in the
maintenance plan screen. Being that it's just the one
database for which a maintenance plan can't be created, I
would suspect it's related to whatever the state or the
other status values are for the database in sys.databases.
-Sue
On Wed, 23 Aug 2006 12:27:01 -0700, Bob
<Bob@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>A user db doesn't show up in the list only when it's taken offline. Right
>click on the database then go to Tasks and click on Bring online then you
>should be able to see it.
>Another thing, you can't create maintenance plans if you are not a sysadmin
>on a server. If you have dbo rights on the database or you are backup
>operator you can take the backup from Enterprise Manager but not using
>maintenance plans.
>If it's none of the above then someone else might need to jump on this issu
e
>to help you out.
>Bob
>"Tracy McKibben" wrote:
>sql
Can't automate backup of a database
When I try and do a maintenace plan to backup all databases there is one that
does not get backedup. All the others seem to work fine. So I try to make a
new maintenance plan to backup only that database and when I try and create
the plan that database is not in the list of databases. I suppose that is
why it is not working. However I can right click the database and back it up
manually with no problems.
Anyone know why it does not show in the list of avaliable databases to be
backed up?
Thanks,
EdIs that a system database or user? If system which database is it?
"Ed R." wrote:
> When I try and do a maintenace plan to backup all databases there is one that
> does not get backedup. All the others seem to work fine. So I try to make a
> new maintenance plan to backup only that database and when I try and create
> the plan that database is not in the list of databases. I suppose that is
> why it is not working. However I can right click the database and back it up
> manually with no problems.
> Anyone know why it does not show in the list of avaliable databases to be
> backed up?
> Thanks,
> Ed|||It is a user database.
"Bob" wrote:
> Is that a system database or user? If system which database is it?
> "Ed R." wrote:
> > When I try and do a maintenace plan to backup all databases there is one that
> > does not get backedup. All the others seem to work fine. So I try to make a
> > new maintenance plan to backup only that database and when I try and create
> > the plan that database is not in the list of databases. I suppose that is
> > why it is not working. However I can right click the database and back it up
> > manually with no problems.
> >
> > Anyone know why it does not show in the list of avaliable databases to be
> > backed up?
> >
> > Thanks,
> > Ed|||Ed R. wrote:
> It is a user database.
> "Bob" wrote:
>
Is this a FULL backup or a transaction log backup? What recovery model
is the database using?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The recovery model is simple. When I start a new maintenance task, I drag
the 'backup database task' to the right and then click on it to edit. By
default 'FULL' is selected and greyed out. Then when I try to select the
database from those avaliable it does not show up.
"Tracy McKibben" wrote:
> Ed R. wrote:
> > It is a user database.
> >
> > "Bob" wrote:
> >
> Is this a FULL backup or a transaction log backup? What recovery model
> is the database using?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Ed R. wrote:
> The recovery model is simple. When I start a new maintenance task, I drag
> the 'backup database task' to the right and then click on it to edit. By
> default 'FULL' is selected and greyed out. Then when I try to select the
> database from those avaliable it does not show up.
>
I guess I don't have any further suggestions... I don't use the
maintenance plan wizards, for this very reason. When one of them
doesn't work, you have no idea why.
You might be interested in this script that I use to do backups:
http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
It will automatically backup any database on your server, including
transaction logs if appropriate. Schedule it once and forget it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A user db doesn't show up in the list only when it's taken offline. Right
click on the database then go to Tasks and click on Bring online then you
should be able to see it.
Another thing, you can't create maintenance plans if you are not a sysadmin
on a server. If you have dbo rights on the database or you are backup
operator you can take the backup from Enterprise Manager but not using
maintenance plans.
If it's none of the above then someone else might need to jump on this issue
to help you out.
Bob
"Tracy McKibben" wrote:
> Ed R. wrote:
> > The recovery model is simple. When I start a new maintenance task, I drag
> > the 'backup database task' to the right and then click on it to edit. By
> > default 'FULL' is selected and greyed out. Then when I try to select the
> > database from those avaliable it does not show up.
> >
> I guess I don't have any further suggestions... I don't use the
> maintenance plan wizards, for this very reason. When one of them
> doesn't work, you have no idea why.
> You might be interested in this script that I use to do backups:
> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
> It will automatically backup any database on your server, including
> transaction logs if appropriate. Schedule it once and forget it.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||I would guess it's related to whatever the state is of the
database. There are different database states and statuses
that will keep the database from being displayed in the
maintenance plan screen. Being that it's just the one
database for which a maintenance plan can't be created, I
would suspect it's related to whatever the state or the
other status values are for the database in sys.databases.
-Sue
On Wed, 23 Aug 2006 12:27:01 -0700, Bob
<Bob@.discussions.microsoft.com> wrote:
>A user db doesn't show up in the list only when it's taken offline. Right
>click on the database then go to Tasks and click on Bring online then you
>should be able to see it.
>Another thing, you can't create maintenance plans if you are not a sysadmin
>on a server. If you have dbo rights on the database or you are backup
>operator you can take the backup from Enterprise Manager but not using
>maintenance plans.
>If it's none of the above then someone else might need to jump on this issue
>to help you out.
>Bob
>"Tracy McKibben" wrote:
>> Ed R. wrote:
>> > The recovery model is simple. When I start a new maintenance task, I drag
>> > the 'backup database task' to the right and then click on it to edit. By
>> > default 'FULL' is selected and greyed out. Then when I try to select the
>> > database from those avaliable it does not show up.
>> >
>> I guess I don't have any further suggestions... I don't use the
>> maintenance plan wizards, for this very reason. When one of them
>> doesn't work, you have no idea why.
>> You might be interested in this script that I use to do backups:
>> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
>> It will automatically backup any database on your server, including
>> transaction logs if appropriate. Schedule it once and forget it.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
does not get backedup. All the others seem to work fine. So I try to make a
new maintenance plan to backup only that database and when I try and create
the plan that database is not in the list of databases. I suppose that is
why it is not working. However I can right click the database and back it up
manually with no problems.
Anyone know why it does not show in the list of avaliable databases to be
backed up?
Thanks,
EdIs that a system database or user? If system which database is it?
"Ed R." wrote:
> When I try and do a maintenace plan to backup all databases there is one that
> does not get backedup. All the others seem to work fine. So I try to make a
> new maintenance plan to backup only that database and when I try and create
> the plan that database is not in the list of databases. I suppose that is
> why it is not working. However I can right click the database and back it up
> manually with no problems.
> Anyone know why it does not show in the list of avaliable databases to be
> backed up?
> Thanks,
> Ed|||It is a user database.
"Bob" wrote:
> Is that a system database or user? If system which database is it?
> "Ed R." wrote:
> > When I try and do a maintenace plan to backup all databases there is one that
> > does not get backedup. All the others seem to work fine. So I try to make a
> > new maintenance plan to backup only that database and when I try and create
> > the plan that database is not in the list of databases. I suppose that is
> > why it is not working. However I can right click the database and back it up
> > manually with no problems.
> >
> > Anyone know why it does not show in the list of avaliable databases to be
> > backed up?
> >
> > Thanks,
> > Ed|||Ed R. wrote:
> It is a user database.
> "Bob" wrote:
>
Is this a FULL backup or a transaction log backup? What recovery model
is the database using?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The recovery model is simple. When I start a new maintenance task, I drag
the 'backup database task' to the right and then click on it to edit. By
default 'FULL' is selected and greyed out. Then when I try to select the
database from those avaliable it does not show up.
"Tracy McKibben" wrote:
> Ed R. wrote:
> > It is a user database.
> >
> > "Bob" wrote:
> >
> Is this a FULL backup or a transaction log backup? What recovery model
> is the database using?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||Ed R. wrote:
> The recovery model is simple. When I start a new maintenance task, I drag
> the 'backup database task' to the right and then click on it to edit. By
> default 'FULL' is selected and greyed out. Then when I try to select the
> database from those avaliable it does not show up.
>
I guess I don't have any further suggestions... I don't use the
maintenance plan wizards, for this very reason. When one of them
doesn't work, you have no idea why.
You might be interested in this script that I use to do backups:
http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
It will automatically backup any database on your server, including
transaction logs if appropriate. Schedule it once and forget it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||A user db doesn't show up in the list only when it's taken offline. Right
click on the database then go to Tasks and click on Bring online then you
should be able to see it.
Another thing, you can't create maintenance plans if you are not a sysadmin
on a server. If you have dbo rights on the database or you are backup
operator you can take the backup from Enterprise Manager but not using
maintenance plans.
If it's none of the above then someone else might need to jump on this issue
to help you out.
Bob
"Tracy McKibben" wrote:
> Ed R. wrote:
> > The recovery model is simple. When I start a new maintenance task, I drag
> > the 'backup database task' to the right and then click on it to edit. By
> > default 'FULL' is selected and greyed out. Then when I try to select the
> > database from those avaliable it does not show up.
> >
> I guess I don't have any further suggestions... I don't use the
> maintenance plan wizards, for this very reason. When one of them
> doesn't work, you have no idea why.
> You might be interested in this script that I use to do backups:
> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
> It will automatically backup any database on your server, including
> transaction logs if appropriate. Schedule it once and forget it.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||I would guess it's related to whatever the state is of the
database. There are different database states and statuses
that will keep the database from being displayed in the
maintenance plan screen. Being that it's just the one
database for which a maintenance plan can't be created, I
would suspect it's related to whatever the state or the
other status values are for the database in sys.databases.
-Sue
On Wed, 23 Aug 2006 12:27:01 -0700, Bob
<Bob@.discussions.microsoft.com> wrote:
>A user db doesn't show up in the list only when it's taken offline. Right
>click on the database then go to Tasks and click on Bring online then you
>should be able to see it.
>Another thing, you can't create maintenance plans if you are not a sysadmin
>on a server. If you have dbo rights on the database or you are backup
>operator you can take the backup from Enterprise Manager but not using
>maintenance plans.
>If it's none of the above then someone else might need to jump on this issue
>to help you out.
>Bob
>"Tracy McKibben" wrote:
>> Ed R. wrote:
>> > The recovery model is simple. When I start a new maintenance task, I drag
>> > the 'backup database task' to the right and then click on it to edit. By
>> > default 'FULL' is selected and greyed out. Then when I try to select the
>> > database from those avaliable it does not show up.
>> >
>> I guess I don't have any further suggestions... I don't use the
>> maintenance plan wizards, for this very reason. When one of them
>> doesn't work, you have no idea why.
>> You might be interested in this script that I use to do backups:
>> http://realsqlguy.com/serendipity/archives/11-Send-In-Backup!.html
>> It will automatically backup any database on your server, including
>> transaction logs if appropriate. Schedule it once and forget it.
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
Thursday, March 22, 2012
can't add current login as user
Hi all. I'm having problems trying to add a current login
as a user to any databases. The logins are there, but
when I try to give one access to another db, or even if I
try to add user from within the db itself, I get error
15401 (Windows NT user or group not found). I looked in
KB but could only find this error in reference to adding a
new login. As stated, the logins are already setup and
have been for about two years now, the system just won't
let me add them as users.
What really gets me is how SQL Server will let me use the
necessary tool to pick the login from the list, but then
it says it's not found. (?)
Thanks in advance for any help!
Sandy MachCheck the following KB article:
HOW TO: Troubleshoot Error 15401
http://support.microsoft.com/?id=324321
-Sue
On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>Hi all. I'm having problems trying to add a current login
>as a user to any databases. The logins are there, but
>when I try to give one access to another db, or even if I
>try to add user from within the db itself, I get error
>15401 (Windows NT user or group not found). I looked in
>KB but could only find this error in reference to adding a
>new login. As stated, the logins are already setup and
>have been for about two years now, the system just won't
>let me add them as users.
>What really gets me is how SQL Server will let me use the
>necessary tool to pick the login from the list, but then
>it says it's not found. (?)
>Thanks in advance for any help!
>Sandy Mach|||As previously stated, I read that article before posting
here, and it refers only to adding new logins... these
LOGINs are already existing within SQL Server Security
Logins. SQL Server will not let me grant any of the
current logins access to any additional databases (will
NOT let me add current LOGIN as NEW USER), and the only
error I get is that 15401 which doesn't make sense in this
situation.
SQL Server lets me use the drop-down box showing current
logins to choose as new user, so it's finding them fine
there. It lets me go thru all the motions until it comes
time to save, then it says it can't find the user or group
(when IT let me find them thru its own nav tools!!).
Any other suggestions?
>--Original Message--
>Check the following KB article:
>HOW TO: Troubleshoot Error 15401
>http://support.microsoft.com/?id=324321
>-Sue
>On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
login
I
a
the
>.
>|||Hi, I'd the same error when I tried to add an user group (domain user group)
to new login (sql server).
What I did was instead of clicking on be "..." button (browse no Name), I ty
ped in manually "BUILTIN\Users" (assuming I want to add "Users" user group)
and click "OK". and guess what? It works for me.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.
as a user to any databases. The logins are there, but
when I try to give one access to another db, or even if I
try to add user from within the db itself, I get error
15401 (Windows NT user or group not found). I looked in
KB but could only find this error in reference to adding a
new login. As stated, the logins are already setup and
have been for about two years now, the system just won't
let me add them as users.
What really gets me is how SQL Server will let me use the
necessary tool to pick the login from the list, but then
it says it's not found. (?)
Thanks in advance for any help!
Sandy MachCheck the following KB article:
HOW TO: Troubleshoot Error 15401
http://support.microsoft.com/?id=324321
-Sue
On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
<anonymous@.discussions.microsoft.com> wrote:
>Hi all. I'm having problems trying to add a current login
>as a user to any databases. The logins are there, but
>when I try to give one access to another db, or even if I
>try to add user from within the db itself, I get error
>15401 (Windows NT user or group not found). I looked in
>KB but could only find this error in reference to adding a
>new login. As stated, the logins are already setup and
>have been for about two years now, the system just won't
>let me add them as users.
>What really gets me is how SQL Server will let me use the
>necessary tool to pick the login from the list, but then
>it says it's not found. (?)
>Thanks in advance for any help!
>Sandy Mach|||As previously stated, I read that article before posting
here, and it refers only to adding new logins... these
LOGINs are already existing within SQL Server Security
Logins. SQL Server will not let me grant any of the
current logins access to any additional databases (will
NOT let me add current LOGIN as NEW USER), and the only
error I get is that 15401 which doesn't make sense in this
situation.
SQL Server lets me use the drop-down box showing current
logins to choose as new user, so it's finding them fine
there. It lets me go thru all the motions until it comes
time to save, then it says it can't find the user or group
(when IT let me find them thru its own nav tools!!).
Any other suggestions?
>--Original Message--
>Check the following KB article:
>HOW TO: Troubleshoot Error 15401
>http://support.microsoft.com/?id=324321
>-Sue
>On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
><anonymous@.discussions.microsoft.com> wrote:
>
login
I
a
the
>.
>|||Hi, I'd the same error when I tried to add an user group (domain user group)
to new login (sql server).
What I did was instead of clicking on be "..." button (browse no Name), I ty
ped in manually "BUILTIN\Users" (assuming I want to add "Users" user group)
and click "OK". and guess what? It works for me.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.
Tuesday, March 20, 2012
Can't access database
Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.
Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.
Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
Can't access database
Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx
.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx
.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
Can't access database
Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.
Cant Access a Database via the Database Explorer
Hi,
I have been able to view the databases and all of their tables but now when I cilck the "+" next to the database or try to connect a new one i get an error message:
"Generating user instances in SQL Server is disabled. Use sp_configure 'user Instances enabled' to generate user instances"
I don't know what I have done and I don't know how to fix it, Please help me!
Best regards,
Elliot
I would do a backup first, before trying anything! Two backups!
It sounds like Sql Server wants you to enter the following command in a query window:
exec sp_configure 'user Instances enabled'
But you might want to google on that first...
|||
Thanks you didn't answer it 100% but I googled it and found the answer in another forum:http://www.mydatabasesupport.com/forums/sqlserver-faq/339672-generating-user-instances-sql-server-disabled.html
Thanks for your help,
Elliot
Monday, March 19, 2012
Cannot View Reports in Report Manager
Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.
Sunday, March 11, 2012
Cannot view databases in view list for SQL 2005
I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
Mark
Hi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
Mark
Hi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
Cannot view databases in view list for SQL 2005
I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databas
es
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQ
L
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databas
es
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQ
L
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
Cannot view databases in view list for SQL 2005
I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John
Cannot view database properties
Hello all....
I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.
I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.
The user databases have been restored and are accessible by all applications.
If I try to view the properties of any database (system or user), I get the following error:
*********************************************************************************************************************************
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)
****************************************************************************************************************************************
I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?
Thanks,
Forch
What is the collation or all the databases?
run select * from sys.databases.
How did you restore the databases, backup/restore, attach/dettach?
|||Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.
I can't remember how I restored.... it was probably backup / restore.
Thanks,
Forch
|||Hi Forch,
Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.
You can do:
ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }
to change the collation of the restored databases to the new collation
Cheers
|||Have you tried to access the database from the query analyzer too?Cannot view database properties
Hello all....
I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.
I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.
The user databases have been restored and are accessible by all applications.
If I try to view the properties of any database (system or user), I get the following error:
*********************************************************************************************************************************
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)
****************************************************************************************************************************************
I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?
Thanks,
Forch
What is the collation or all the databases?
run select * from sys.databases.
How did you restore the databases, backup/restore, attach/dettach?
|||Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.
I can't remember how I restored.... it was probably backup / restore.
Thanks,
Forch
|||Hi Forch,
Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.
You can do:
ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }
to change the collation of the restored databases to the new collation
Cheers
|||Have you tried to access the database from the query analyzer too?Cannot use file for clustered server
I have a clustered server with a clustered instance of SQL Server 2000
running on it. I'm attempting to restore several databases to the clustered
server from our production, non-clustered database server. I also want to do
a move of log files at the same time. On the production server, the database
and log files are on the same raid array. On the clustered server, I've
created two raid arrays, drive H: for the databases which is in cluster group
0 and drive g: for the logs which is in cluster group 1. The database server
on the cluster is in group 0, by the way. I'm doing a restore using an sql
file that works restoring databases and logs to a backup server on different
drives so I'm reasonably sure that the restore syntax is correct. When I
attempt to do a restore of the log files on the cluster server, I receive the
following error.
Msg 5184, Level 16, State 2, Line 1
Cannot use file g:\logs\ims.ldf for clustered server. Only formatted files
on which the cluster resource of the server has a dependency can be used.
What does that mean? Does that mean that I have to put the log array in the
same group as the clustered instance of sql server? If that's the case, how
do I do that?
TIA
Ernie
Move the G: Drive into the SQL Group (group 0 from you post).
Stop the SQL clustered group.
Double click SQL Server resource and add G: Drive as a dependency.
Bring the SQL Group back online.
Restore away
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"ebferro" <ebferro@.discussions.microsoft.com> wrote in message
news:24628F06-9C5C-4B4F-B7C6-50E82D24CF8F@.microsoft.com...
>I have a clustered server with a clustered instance of SQL Server 2000
> running on it. I'm attempting to restore several databases to the
> clustered
> server from our production, non-clustered database server. I also want to
> do
> a move of log files at the same time. On the production server, the
> database
> and log files are on the same raid array. On the clustered server, I've
> created two raid arrays, drive H: for the databases which is in cluster
> group
> 0 and drive g: for the logs which is in cluster group 1. The database
> server
> on the cluster is in group 0, by the way. I'm doing a restore using an
> sql
> file that works restoring databases and logs to a backup server on
> different
> drives so I'm reasonably sure that the restore syntax is correct. When I
> attempt to do a restore of the log files on the cluster server, I receive
> the
> following error.
> Msg 5184, Level 16, State 2, Line 1
> Cannot use file g:\logs\ims.ldf for clustered server. Only formatted
> files
> on which the cluster resource of the server has a dependency can be used.
> What does that mean? Does that mean that I have to put the log array in
> the
> same group as the clustered instance of sql server? If that's the case,
> how
> do I do that?
> TIA
> Ernie
|||Rod:
Many thanks for the help. My restore appears to be running nicely right now
so I think that fixed the problem.
"Rodney R. Fournier [MVP]" wrote:
> Move the G: Drive into the SQL Group (group 0 from you post).
> Stop the SQL clustered group.
> Double click SQL Server resource and add G: Drive as a dependency.
> Bring the SQL Group back online.
> Restore away
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "ebferro" <ebferro@.discussions.microsoft.com> wrote in message
> news:24628F06-9C5C-4B4F-B7C6-50E82D24CF8F@.microsoft.com...
>
>
running on it. I'm attempting to restore several databases to the clustered
server from our production, non-clustered database server. I also want to do
a move of log files at the same time. On the production server, the database
and log files are on the same raid array. On the clustered server, I've
created two raid arrays, drive H: for the databases which is in cluster group
0 and drive g: for the logs which is in cluster group 1. The database server
on the cluster is in group 0, by the way. I'm doing a restore using an sql
file that works restoring databases and logs to a backup server on different
drives so I'm reasonably sure that the restore syntax is correct. When I
attempt to do a restore of the log files on the cluster server, I receive the
following error.
Msg 5184, Level 16, State 2, Line 1
Cannot use file g:\logs\ims.ldf for clustered server. Only formatted files
on which the cluster resource of the server has a dependency can be used.
What does that mean? Does that mean that I have to put the log array in the
same group as the clustered instance of sql server? If that's the case, how
do I do that?
TIA
Ernie
Move the G: Drive into the SQL Group (group 0 from you post).
Stop the SQL clustered group.
Double click SQL Server resource and add G: Drive as a dependency.
Bring the SQL Group back online.
Restore away
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"ebferro" <ebferro@.discussions.microsoft.com> wrote in message
news:24628F06-9C5C-4B4F-B7C6-50E82D24CF8F@.microsoft.com...
>I have a clustered server with a clustered instance of SQL Server 2000
> running on it. I'm attempting to restore several databases to the
> clustered
> server from our production, non-clustered database server. I also want to
> do
> a move of log files at the same time. On the production server, the
> database
> and log files are on the same raid array. On the clustered server, I've
> created two raid arrays, drive H: for the databases which is in cluster
> group
> 0 and drive g: for the logs which is in cluster group 1. The database
> server
> on the cluster is in group 0, by the way. I'm doing a restore using an
> sql
> file that works restoring databases and logs to a backup server on
> different
> drives so I'm reasonably sure that the restore syntax is correct. When I
> attempt to do a restore of the log files on the cluster server, I receive
> the
> following error.
> Msg 5184, Level 16, State 2, Line 1
> Cannot use file g:\logs\ims.ldf for clustered server. Only formatted
> files
> on which the cluster resource of the server has a dependency can be used.
> What does that mean? Does that mean that I have to put the log array in
> the
> same group as the clustered instance of sql server? If that's the case,
> how
> do I do that?
> TIA
> Ernie
|||Rod:
Many thanks for the help. My restore appears to be running nicely right now
so I think that fixed the problem.
"Rodney R. Fournier [MVP]" wrote:
> Move the G: Drive into the SQL Group (group 0 from you post).
> Stop the SQL clustered group.
> Double click SQL Server resource and add G: Drive as a dependency.
> Bring the SQL Group back online.
> Restore away
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "ebferro" <ebferro@.discussions.microsoft.com> wrote in message
> news:24628F06-9C5C-4B4F-B7C6-50E82D24CF8F@.microsoft.com...
>
>
Wednesday, March 7, 2012
Cannot start SQL Server 2005 service
I have a SQL Server 2005 instance installed. I have created databases and
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
Thanks
The error message is pretty straight forward. Does the SQL Server service account have permissions
on that folder? Did you change the service account after installation. Changing service account
should only be done using the "SQL Server Configuration Manager" applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>
|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service account have permissions
> on that folder? Did you change the service account after installation. Changing service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>
|||Though, this means the error doesn't reflect reality. How about if you log on to the machine
interactively and try to access that folder? And add, read etc to a file in the directory...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...[vbcol=seagreen]
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log on to the machine
> interactively and try to access that folder? And add, read etc to a file in the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>
|||Hmm, if the directory exists with the exact same name as in the error message and the service
account indeed has permissions, then you seem to have some serious problem with the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...[vbcol=seagreen]
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
Thanks
The error message is pretty straight forward. Does the SQL Server service account have permissions
on that folder? Did you change the service account after installation. Changing service account
should only be done using the "SQL Server Configuration Manager" applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>
|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service account have permissions
> on that folder? Did you change the service account after installation. Changing service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>
|||Though, this means the error doesn't reflect reality. How about if you log on to the machine
interactively and try to access that folder? And add, read etc to a file in the directory...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...[vbcol=seagreen]
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log on to the machine
> interactively and try to access that folder? And add, read etc to a file in the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>
|||Hmm, if the directory exists with the exact same name as in the error message and the service
account indeed has permissions, then you seem to have some serious problem with the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...[vbcol=seagreen]
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
Cannot start SQL Server 2005 service
I have a SQL Server 2005 instance installed. I have created databases and
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
ThanksThe error message is pretty straight forward. Does the SQL Server service ac
count have permissions
on that folder? Did you change the service account after installation. Chang
ing service account
should only be done using the "SQL Server Configuration Manager" applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific erro
r
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
--
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service
account have permissions
> on that folder? Did you change the service account after installation. Cha
nging service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>|||Though, this means the error doesn't reflect reality. How about if you log o
n to the machine
interactively and try to access that folder? And add, read etc to a file in
the directory...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...[vbcol=seagreen]
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for
a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
--
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log
on to the machine
> interactively and try to access that folder? And add, read etc to a file i
n the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>|||Hmm, if the directory exists with the exact same name as in the error messag
e and the service
account indeed has permissions, then you seem to have some serious problem w
ith the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is
a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...[vbcol=seagreen]
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
ThanksThe error message is pretty straight forward. Does the SQL Server service ac
count have permissions
on that folder? Did you change the service account after installation. Chang
ing service account
should only be done using the "SQL Server Configuration Manager" applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific erro
r
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
--
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service
account have permissions
> on that folder? Did you change the service account after installation. Cha
nging service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>|||Though, this means the error doesn't reflect reality. How about if you log o
n to the machine
interactively and try to access that folder? And add, read etc to a file in
the directory...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...[vbcol=seagreen]
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for
a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
--
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log
on to the machine
> interactively and try to access that folder? And add, read etc to a file i
n the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>|||Hmm, if the directory exists with the exact same name as in the error messag
e and the service
account indeed has permissions, then you seem to have some serious problem w
ith the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is
a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...[vbcol=seagreen]
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>
Cannot start SQL Server 2005 service
I have a SQL Server 2005 instance installed. I have created databases and
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
ThanksThe error message is pretty straight forward. Does the SQL Server service account have permissions
on that folder? Did you change the service account after installation. Changing service account
should only be done using the "SQL Server Configuration Manager" applet.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
--
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service account have permissions
> on that folder? Did you change the service account after installation. Changing service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
> >I have a SQL Server 2005 instance installed. I have created databases and
> > schema on the SQL Server. I cannot start the service for the SQL Server. I
> > ahve tried using every account possible. It always errors out with the
> > following message:
> >
> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> > denied.).
> >
> > The event ID in the application log is 17058.
> > Also the following error message appears in the system log
> >
> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
> > 17058 (0x42A2).
> > Please help, there is not a lot of information out there on this issue
> > Thanks
> >
> >
> >
>|||Though, this means the error doesn't reflect reality. How about if you log on to the machine
interactively and try to access that folder? And add, read etc to a file in the directory...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>> The error message is pretty straight forward. Does the SQL Server service account have
>> permissions
>> on that folder? Did you change the service account after installation. Changing service account
>> should only be done using the "SQL Server Configuration Manager" applet.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>> >I have a SQL Server 2005 instance installed. I have created databases and
>> > schema on the SQL Server. I cannot start the service for the SQL Server. I
>> > ahve tried using every account possible. It always errors out with the
>> > following message:
>> >
>> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
>> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
>> > denied.).
>> >
>> > The event ID in the application log is 17058.
>> > Also the following error message appears in the system log
>> >
>> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
>> > 17058 (0x42A2).
>> > Please help, there is not a lot of information out there on this issue
>> > Thanks
>> >
>> >
>> >
>>|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
--
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log on to the machine
> interactively and try to access that folder? And add, read etc to a file in the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
> > The SQL Service acoount does have permissions on that folder. The service
> > account was not changed. The SQL Server was working fine. It was down for a
> > couple of days and then the service started giving this errors.
> > --
> > batgirl
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> The error message is pretty straight forward. Does the SQL Server service account have
> >> permissions
> >> on that folder? Did you change the service account after installation. Changing service account
> >> should only be done using the "SQL Server Configuration Manager" applet.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> >> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
> >> >I have a SQL Server 2005 instance installed. I have created databases and
> >> > schema on the SQL Server. I cannot start the service for the SQL Server. I
> >> > ahve tried using every account possible. It always errors out with the
> >> > following message:
> >> >
> >> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> >> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> >> > denied.).
> >> >
> >> > The event ID in the application log is 17058.
> >> > Also the following error message appears in the system log
> >> >
> >> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
> >> > 17058 (0x42A2).
> >> > Please help, there is not a lot of information out there on this issue
> >> > Thanks
> >> >
> >> >
> >> >
> >>
> >>
>|||Hmm, if the directory exists with the exact same name as in the error message and the service
account indeed has permissions, then you seem to have some serious problem with the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>> Though, this means the error doesn't reflect reality. How about if you log on to the machine
>> interactively and try to access that folder? And add, read etc to a file in the directory...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>> > The SQL Service acoount does have permissions on that folder. The service
>> > account was not changed. The SQL Server was working fine. It was down for a
>> > couple of days and then the service started giving this errors.
>> > --
>> > batgirl
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The error message is pretty straight forward. Does the SQL Server service account have
>> >> permissions
>> >> on that folder? Did you change the service account after installation. Changing service
>> >> account
>> >> should only be done using the "SQL Server Configuration Manager" applet.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> >> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>> >> >I have a SQL Server 2005 instance installed. I have created databases and
>> >> > schema on the SQL Server. I cannot start the service for the SQL Server. I
>> >> > ahve tried using every account possible. It always errors out with the
>> >> > following message:
>> >> >
>> >> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
>> >> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
>> >> > denied.).
>> >> >
>> >> > The event ID in the application log is 17058.
>> >> > Also the following error message appears in the system log
>> >> >
>> >> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
>> >> > 17058 (0x42A2).
>> >> > Please help, there is not a lot of information out there on this issue
>> >> > Thanks
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>>
schema on the SQL Server. I cannot start the service for the SQL Server. I
ahve tried using every account possible. It always errors out with the
following message:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
denied.).
The event ID in the application log is 17058.
Also the following error message appears in the system log
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Please help, there is not a lot of information out there on this issue
ThanksThe error message is pretty straight forward. Does the SQL Server service account have permissions
on that folder? Did you change the service account after installation. Changing service account
should only be done using the "SQL Server Configuration Manager" applet.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>I have a SQL Server 2005 instance installed. I have created databases and
> schema on the SQL Server. I cannot start the service for the SQL Server. I
> ahve tried using every account possible. It always errors out with the
> following message:
> initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> denied.).
> The event ID in the application log is 17058.
> Also the following error message appears in the system log
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
> Please help, there is not a lot of information out there on this issue
> Thanks
>
>|||The SQL Service acoount does have permissions on that folder. The service
account was not changed. The SQL Server was working fine. It was down for a
couple of days and then the service started giving this errors.
--
batgirl
"Tibor Karaszi" wrote:
> The error message is pretty straight forward. Does the SQL Server service account have permissions
> on that folder? Did you change the service account after installation. Changing service account
> should only be done using the "SQL Server Configuration Manager" applet.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
> >I have a SQL Server 2005 instance installed. I have created databases and
> > schema on the SQL Server. I cannot start the service for the SQL Server. I
> > ahve tried using every account possible. It always errors out with the
> > following message:
> >
> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> > denied.).
> >
> > The event ID in the application log is 17058.
> > Also the following error message appears in the system log
> >
> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
> > 17058 (0x42A2).
> > Please help, there is not a lot of information out there on this issue
> > Thanks
> >
> >
> >
>|||Though, this means the error doesn't reflect reality. How about if you log on to the machine
interactively and try to access that folder? And add, read etc to a file in the directory...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
> The SQL Service acoount does have permissions on that folder. The service
> account was not changed. The SQL Server was working fine. It was down for a
> couple of days and then the service started giving this errors.
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>> The error message is pretty straight forward. Does the SQL Server service account have
>> permissions
>> on that folder? Did you change the service account after installation. Changing service account
>> should only be done using the "SQL Server Configuration Manager" applet.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>> >I have a SQL Server 2005 instance installed. I have created databases and
>> > schema on the SQL Server. I cannot start the service for the SQL Server. I
>> > ahve tried using every account possible. It always errors out with the
>> > following message:
>> >
>> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
>> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
>> > denied.).
>> >
>> > The event ID in the application log is 17058.
>> > Also the following error message appears in the system log
>> >
>> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
>> > 17058 (0x42A2).
>> > Please help, there is not a lot of information out there on this issue
>> > Thanks
>> >
>> >
>> >
>>|||I have already tried that, it did not help. The only thing that has changed
on the machine is it's IP address. It is a test machine, I was going to
uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
have no idea what to do next
Thanks
--
batgirl
"Tibor Karaszi" wrote:
> Though, this means the error doesn't reflect reality. How about if you log on to the machine
> interactively and try to access that folder? And add, read etc to a file in the directory...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
> > The SQL Service acoount does have permissions on that folder. The service
> > account was not changed. The SQL Server was working fine. It was down for a
> > couple of days and then the service started giving this errors.
> > --
> > batgirl
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> The error message is pretty straight forward. Does the SQL Server service account have
> >> permissions
> >> on that folder? Did you change the service account after installation. Changing service account
> >> should only be done using the "SQL Server Configuration Manager" applet.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
> >> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
> >> >I have a SQL Server 2005 instance installed. I have created databases and
> >> > schema on the SQL Server. I cannot start the service for the SQL Server. I
> >> > ahve tried using every account possible. It always errors out with the
> >> > following message:
> >> >
> >> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
> >> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
> >> > denied.).
> >> >
> >> > The event ID in the application log is 17058.
> >> > Also the following error message appears in the system log
> >> >
> >> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
> >> > 17058 (0x42A2).
> >> > Please help, there is not a lot of information out there on this issue
> >> > Thanks
> >> >
> >> >
> >> >
> >>
> >>
>|||Hmm, if the directory exists with the exact same name as in the error message and the service
account indeed has permissions, then you seem to have some serious problem with the installation. I
know you can get some strange errors with compressed drives...
In what way doesn't the uninstall work? Error messages? I know that there is a KB article on how to
manually uninstall 2000, perhaps there is one for 2005 as well?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"batgirl" <batgirl@.discussions.microsoft.com> wrote in message
news:6CACF67A-FC57-4722-A6E8-B12B81D36DB9@.microsoft.com...
>I have already tried that, it did not help. The only thing that has changed
> on the machine is it's IP address. It is a test machine, I was going to
> uninstall and reinstall SQL 2005 but it will not even let me uninstall. I
> have no idea what to do next
> Thanks
> --
> batgirl
>
> "Tibor Karaszi" wrote:
>> Though, this means the error doesn't reflect reality. How about if you log on to the machine
>> interactively and try to access that folder? And add, read etc to a file in the directory...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> news:4EEB5F4B-E834-4681-A9A8-917402FE4149@.microsoft.com...
>> > The SQL Service acoount does have permissions on that folder. The service
>> > account was not changed. The SQL Server was working fine. It was down for a
>> > couple of days and then the service started giving this errors.
>> > --
>> > batgirl
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The error message is pretty straight forward. Does the SQL Server service account have
>> >> permissions
>> >> on that folder? Did you change the service account after installation. Changing service
>> >> account
>> >> should only be done using the "SQL Server Configuration Manager" applet.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "batgirl" <batgirl@.discussions.microsoft.com> wrote in message
>> >> news:BAEDC4F7-3F13-44BB-8394-63B2BDC5A638@.microsoft.com...
>> >> >I have a SQL Server 2005 instance installed. I have created databases and
>> >> > schema on the SQL Server. I cannot start the service for the SQL Server. I
>> >> > ahve tried using every account possible. It always errors out with the
>> >> > following message:
>> >> >
>> >> > initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL
>> >> > Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is
>> >> > denied.).
>> >> >
>> >> > The event ID in the application log is 17058.
>> >> > Also the following error message appears in the system log
>> >> >
>> >> > The SQL Server (MSSQLSERVER) service terminated with service-specific error
>> >> > 17058 (0x42A2).
>> >> > Please help, there is not a lot of information out there on this issue
>> >> > Thanks
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>>
Friday, February 24, 2012
Cannot Shrink Database
All,
We have a data modeling group in here that can grow databases to 150Gb or
200Gb.
When they have run a scenario they will get rid of lots of the data and ask
me to shrink the database for them. This usually works no problem.
Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
when I shrink with a 10% free space option nothing happens to the size.
I am a bit hazy about the details but is it something to do with where data
gets written to?
Any ideas on how to get around this problem would be very welcome.
Thanks In AdvanceVerify that the tranlog has been backed up recently and then run
CHECKPOINT against the database. This will force all of the dirty and
log pages that haven't been written to get written. Most likely there
is a dirty page preventing the database from shrinking any further than
it has.
HTH
Jason|||Is if the ldf file which is big? If so, I have some info in below article (approx middle of article)
regarding shrinking of tlog files:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:DFC25D21-F281-4A2C-9C21-920500732936@.microsoft.com...
> All,
> We have a data modeling group in here that can grow databases to 150Gb or
> 200Gb.
> When they have run a scenario they will get rid of lots of the data and ask
> me to shrink the database for them. This usually works no problem.
> Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
> when I shrink with a 10% free space option nothing happens to the size.
> I am a bit hazy about the details but is it something to do with where data
> gets written to?
> Any ideas on how to get around this problem would be very welcome.
> Thanks In Advance
>|||Jason,
Thanks for the info. Appreciate the help.
"j strate" wrote:
> Verify that the tranlog has been backed up recently and then run
> CHECKPOINT against the database. This will force all of the dirty and
> log pages that haven't been written to get written. Most likely there
> is a dirty page preventing the database from shrinking any further than
> it has.
> HTH
> Jason
>
We have a data modeling group in here that can grow databases to 150Gb or
200Gb.
When they have run a scenario they will get rid of lots of the data and ask
me to shrink the database for them. This usually works no problem.
Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
when I shrink with a 10% free space option nothing happens to the size.
I am a bit hazy about the details but is it something to do with where data
gets written to?
Any ideas on how to get around this problem would be very welcome.
Thanks In AdvanceVerify that the tranlog has been backed up recently and then run
CHECKPOINT against the database. This will force all of the dirty and
log pages that haven't been written to get written. Most likely there
is a dirty page preventing the database from shrinking any further than
it has.
HTH
Jason|||Is if the ldf file which is big? If so, I have some info in below article (approx middle of article)
regarding shrinking of tlog files:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:DFC25D21-F281-4A2C-9C21-920500732936@.microsoft.com...
> All,
> We have a data modeling group in here that can grow databases to 150Gb or
> 200Gb.
> When they have run a scenario they will get rid of lots of the data and ask
> me to shrink the database for them. This usually works no problem.
> Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
> when I shrink with a 10% free space option nothing happens to the size.
> I am a bit hazy about the details but is it something to do with where data
> gets written to?
> Any ideas on how to get around this problem would be very welcome.
> Thanks In Advance
>|||Jason,
Thanks for the info. Appreciate the help.
"j strate" wrote:
> Verify that the tranlog has been backed up recently and then run
> CHECKPOINT against the database. This will force all of the dirty and
> log pages that haven't been written to get written. Most likely there
> is a dirty page preventing the database from shrinking any further than
> it has.
> HTH
> Jason
>
Cannot Shrink Database
All,
We have a data modeling group in here that can grow databases to 150Gb or
200Gb.
When they have run a scenario they will get rid of lots of the data and ask
me to shrink the database for them. This usually works no problem.
Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
when I shrink with a 10% free space option nothing happens to the size.
I am a bit hazy about the details but is it something to do with where data
gets written to?
Any ideas on how to get around this problem would be very welcome.
Thanks In Advance
Verify that the tranlog has been backed up recently and then run
CHECKPOINT against the database. This will force all of the dirty and
log pages that haven't been written to get written. Most likely there
is a dirty page preventing the database from shrinking any further than
it has.
HTH
Jason
|||Is if the ldf file which is big? If so, I have some info in below article (approx middle of article)
regarding shrinking of tlog files:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:DFC25D21-F281-4A2C-9C21-920500732936@.microsoft.com...
> All,
> We have a data modeling group in here that can grow databases to 150Gb or
> 200Gb.
> When they have run a scenario they will get rid of lots of the data and ask
> me to shrink the database for them. This usually works no problem.
> Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
> when I shrink with a 10% free space option nothing happens to the size.
> I am a bit hazy about the details but is it something to do with where data
> gets written to?
> Any ideas on how to get around this problem would be very welcome.
> Thanks In Advance
>
|||Jason,
Thanks for the info. Appreciate the help.
"j strate" wrote:
> Verify that the tranlog has been backed up recently and then run
> CHECKPOINT against the database. This will force all of the dirty and
> log pages that haven't been written to get written. Most likely there
> is a dirty page preventing the database from shrinking any further than
> it has.
> HTH
> Jason
>
We have a data modeling group in here that can grow databases to 150Gb or
200Gb.
When they have run a scenario they will get rid of lots of the data and ask
me to shrink the database for them. This usually works no problem.
Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
when I shrink with a 10% free space option nothing happens to the size.
I am a bit hazy about the details but is it something to do with where data
gets written to?
Any ideas on how to get around this problem would be very welcome.
Thanks In Advance
Verify that the tranlog has been backed up recently and then run
CHECKPOINT against the database. This will force all of the dirty and
log pages that haven't been written to get written. Most likely there
is a dirty page preventing the database from shrinking any further than
it has.
HTH
Jason
|||Is if the ldf file which is big? If so, I have some info in below article (approx middle of article)
regarding shrinking of tlog files:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:DFC25D21-F281-4A2C-9C21-920500732936@.microsoft.com...
> All,
> We have a data modeling group in here that can grow databases to 150Gb or
> 200Gb.
> When they have run a scenario they will get rid of lots of the data and ask
> me to shrink the database for them. This usually works no problem.
> Today I have 2 databases they want to shrink, both have 85 - 90 Gb free, but
> when I shrink with a 10% free space option nothing happens to the size.
> I am a bit hazy about the details but is it something to do with where data
> gets written to?
> Any ideas on how to get around this problem would be very welcome.
> Thanks In Advance
>
|||Jason,
Thanks for the info. Appreciate the help.
"j strate" wrote:
> Verify that the tranlog has been backed up recently and then run
> CHECKPOINT against the database. This will force all of the dirty and
> log pages that haven't been written to get written. Most likely there
> is a dirty page preventing the database from shrinking any further than
> it has.
> HTH
> Jason
>
Subscribe to:
Posts (Atom)