Tuesday, March 27, 2012
Can't backup Remote database
and it tells me the path for the backup is no good, but it will not
let me change it, any ideas.
Rick
hi Rick,
Rick wrote:
> I am using the SQL express manager to try to backup a remote database
> and it tells me the path for the backup is no good, but it will not
> let me change it, any ideas.
>
try using SQL Server Management Studio Express you can download from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e,
instead of SQLExpress Manager..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Jun 15, 12:59 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi Rick,
> Rick wrote:
> try using SQL Server Management Studio Express you can download fromhttp://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...,
> instead of SQLExpress Manager..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I tried that with same results, If I remove the backup device and try
to add another one, I get the error Property Backupdirectory is not
available for settings "microsoft.sqlserver.management.smo.settings"
Rick
|||hi Rick,
Rick wrote:
> I tried that with same results, If I remove the backup device and try
> to add another one, I get the error Property Backupdirectory is not
> available for settings "microsoft.sqlserver.management.smo.settings"
>
please verify the account running SQLExpress has enought permissions on the
backup device at the NTFS file system level as well..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Jun 15, 3:40 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi Rick,
> Rick wrote:
> please verify the account running SQLExpress has enought permissions on the
> backup device at the NTFS file system level as well..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
i had to add a backupDevice key on the sqlserver pointing to c:, that
solved the problem
thanks
Rick
Sunday, February 12, 2012
Cannot restore from a UNC file in sql 2005 management studio
In sql 2005 management studio, when I tried to restore a database from disk
file saved on a UNC path, I got the following error.
The Database Engine service could not resolve the specified file location.
Either the location does not exist, or the current login account does not
have access to it. Verify that the file location exists, and that the login
account has permissions on it.
The following are the options I selected:
Source for restore: From device
Backup media: File
Selected path: \\home.dept.some.edu\me\sql2005\backups\
Files of type: Backup Files (*.bak, *.trn)
File name: db.bak
The error showed up when I clicked OK to start the restore process.
In Start->Run, the UNC path opens fine. So it's not the permissions issue.
And the path exists. Do I have to restore using the 'restore' command
instead of using the management studio GUI interface if I want to restore
from UNC?
Thanks in advance,
Bing
The fully qualified domain name might be what is tripping it up - have you
tried specifying the IP address or using a non-qualified name. This is
assuming, of course, that this server is on the same domain that you're
trying to restore to...
"bing" wrote:
> Hi,
> In sql 2005 management studio, when I tried to restore a database from disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing
|||Thanks for the response.
I tried the IP address, the same error.
The netwrok share and the sql 2005 server are not in the same domain.
Bing
"James Luetkehoelter" wrote:
[vbcol=seagreen]
> The fully qualified domain name might be what is tripping it up - have you
> tried specifying the IP address or using a non-qualified name. This is
> assuming, of course, that this server is on the same domain that you're
> trying to restore to...
> "bing" wrote:
|||"bing" <bing@.discussions.microsoft.com> wrote in message
news:18DF4B33-FFB8-49B7-9526-E6AB310FDB34@.microsoft.com...
> Thanks for the response.
> I tried the IP address, the same error.
> The netwrok share and the sql 2005 server are not in the same domain.
>
Actually this probably IS a permissions issue.
The user context that the SQL is operating in is most likely not the same as
the one you're logged into to run SMS.
[vbcol=seagreen]
> Bing
> "James Luetkehoelter" wrote:
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||The SQLServer Service and SQL Agent windows services should always be set up
to login as domain-level accounts with appropriate permissions to access all
system-wide resources they may need access to. This especially includes
network file shares, which is almost certainly the problem here.
TheSQLGuru
President
Indicium Resources, Inc.
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C2BD8088-BEE0-4581-9214-5D37F305118C@.microsoft.com...
> Hi,
> In sql 2005 management studio, when I tried to restore a database from
> disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the
> login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions
> issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing
Cannot restore from a UNC file in sql 2005 management studio
In sql 2005 management studio, when I tried to restore a database from disk
file saved on a UNC path, I got the following error.
The Database Engine service could not resolve the specified file location.
Either the location does not exist, or the current login account does not
have access to it. Verify that the file location exists, and that the login
account has permissions on it.
The following are the options I selected:
Source for restore: From device
Backup media: File
Selected path: \\home.dept.some.edu\me\sql2005\backups\
Files of type: Backup Files (*.bak, *.trn)
File name: db.bak
The error showed up when I clicked OK to start the restore process.
In Start->Run, the UNC path opens fine. So it's not the permissions issue.
And the path exists. Do I have to restore using the 'restore' command
instead of using the management studio GUI interface if I want to restore
from UNC?
Thanks in advance,
BingThe fully qualified domain name might be what is tripping it up - have you
tried specifying the IP address or using a non-qualified name. This is
assuming, of course, that this server is on the same domain that you're
trying to restore to...
"bing" wrote:
> Hi,
> In sql 2005 management studio, when I tried to restore a database from dis
k
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the log
in
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions issue
.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing|||Thanks for the response.
I tried the IP address, the same error.
The netwrok share and the sql 2005 server are not in the same domain.
Bing
"James Luetkehoelter" wrote:
[vbcol=seagreen]
> The fully qualified domain name might be what is tripping it up - have you
> tried specifying the IP address or using a non-qualified name. This is
> assuming, of course, that this server is on the same domain that you're
> trying to restore to...
> "bing" wrote:
>|||"bing" <bing@.discussions.microsoft.com> wrote in message
news:18DF4B33-FFB8-49B7-9526-E6AB310FDB34@.microsoft.com...
> Thanks for the response.
> I tried the IP address, the same error.
> The netwrok share and the sql 2005 server are not in the same domain.
>
Actually this probably IS a permissions issue.
The user context that the SQL is operating in is most likely not the same as
the one you're logged into to run SMS.
[vbcol=seagreen]
> Bing
> "James Luetkehoelter" wrote:
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||The SQLServer Service and SQL Agent windows services should always be set up
to login as domain-level accounts with appropriate permissions to access all
system-wide resources they may need access to. This especially includes
network file shares, which is almost certainly the problem here.
TheSQLGuru
President
Indicium Resources, Inc.
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C2BD8088-BEE0-4581-9214-5D37F305118C@.microsoft.com...
> Hi,
> In sql 2005 management studio, when I tried to restore a database from
> disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the
> login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions
> issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing
Cannot restore from a UNC file in sql 2005 management studio
In sql 2005 management studio, when I tried to restore a database from disk
file saved on a UNC path, I got the following error.
The Database Engine service could not resolve the specified file location.
Either the location does not exist, or the current login account does not
have access to it. Verify that the file location exists, and that the login
account has permissions on it.
The following are the options I selected:
Source for restore: From device
Backup media: File
Selected path: \\home.dept.some.edu\me\sql2005\backups\
Files of type: Backup Files (*.bak, *.trn)
File name: db.bak
The error showed up when I clicked OK to start the restore process.
In Start->Run, the UNC path opens fine. So it's not the permissions issue.
And the path exists. Do I have to restore using the 'restore' command
instead of using the management studio GUI interface if I want to restore
from UNC?
Thanks in advance,
BingThe fully qualified domain name might be what is tripping it up - have you
tried specifying the IP address or using a non-qualified name. This is
assuming, of course, that this server is on the same domain that you're
trying to restore to...
"bing" wrote:
> Hi,
> In sql 2005 management studio, when I tried to restore a database from disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing|||Thanks for the response.
I tried the IP address, the same error.
The netwrok share and the sql 2005 server are not in the same domain.
Bing
"James Luetkehoelter" wrote:
> The fully qualified domain name might be what is tripping it up - have you
> tried specifying the IP address or using a non-qualified name. This is
> assuming, of course, that this server is on the same domain that you're
> trying to restore to...
> "bing" wrote:
> > Hi,
> >
> > In sql 2005 management studio, when I tried to restore a database from disk
> > file saved on a UNC path, I got the following error.
> >
> > The Database Engine service could not resolve the specified file location.
> > Either the location does not exist, or the current login account does not
> > have access to it. Verify that the file location exists, and that the login
> > account has permissions on it.
> >
> > The following are the options I selected:
> >
> > Source for restore: From device
> > Backup media: File
> > Selected path: \\home.dept.some.edu\me\sql2005\backups\
> > Files of type: Backup Files (*.bak, *.trn)
> > File name: db.bak
> >
> > The error showed up when I clicked OK to start the restore process.
> >
> > In Start->Run, the UNC path opens fine. So it's not the permissions issue.
> > And the path exists. Do I have to restore using the 'restore' command
> > instead of using the management studio GUI interface if I want to restore
> > from UNC?
> >
> > Thanks in advance,
> >
> > Bing|||"bing" <bing@.discussions.microsoft.com> wrote in message
news:18DF4B33-FFB8-49B7-9526-E6AB310FDB34@.microsoft.com...
> Thanks for the response.
> I tried the IP address, the same error.
> The netwrok share and the sql 2005 server are not in the same domain.
>
Actually this probably IS a permissions issue.
The user context that the SQL is operating in is most likely not the same as
the one you're logged into to run SMS.
> Bing
> "James Luetkehoelter" wrote:
>> The fully qualified domain name might be what is tripping it up - have
>> you
>> tried specifying the IP address or using a non-qualified name. This is
>> assuming, of course, that this server is on the same domain that you're
>> trying to restore to...
>> "bing" wrote:
>> > Hi,
>> >
>> > In sql 2005 management studio, when I tried to restore a database from
>> > disk
>> > file saved on a UNC path, I got the following error.
>> >
>> > The Database Engine service could not resolve the specified file
>> > location.
>> > Either the location does not exist, or the current login account does
>> > not
>> > have access to it. Verify that the file location exists, and that the
>> > login
>> > account has permissions on it.
>> >
>> > The following are the options I selected:
>> >
>> > Source for restore: From device
>> > Backup media: File
>> > Selected path: \\home.dept.some.edu\me\sql2005\backups\
>> > Files of type: Backup Files (*.bak, *.trn)
>> > File name: db.bak
>> >
>> > The error showed up when I clicked OK to start the restore process.
>> >
>> > In Start->Run, the UNC path opens fine. So it's not the permissions
>> > issue.
>> > And the path exists. Do I have to restore using the 'restore' command
>> > instead of using the management studio GUI interface if I want to
>> > restore
>> > from UNC?
>> >
>> > Thanks in advance,
>> >
>> > Bing
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||The SQLServer Service and SQL Agent windows services should always be set up
to login as domain-level accounts with appropriate permissions to access all
system-wide resources they may need access to. This especially includes
network file shares, which is almost certainly the problem here.
--
TheSQLGuru
President
Indicium Resources, Inc.
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C2BD8088-BEE0-4581-9214-5D37F305118C@.microsoft.com...
> Hi,
> In sql 2005 management studio, when I tried to restore a database from
> disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the
> login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions
> issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing
Friday, February 10, 2012
Cannot resolve a package path
I have a parent package - Main.dtsx that calls a number of child packages. I also use configuration packages as I must deploy the application across multiple environments.
Main.dtsx contains a single Ccnfiguration file - Child_Packages.dtsConfig. This contains the connection strings for all the child packages.
Each child package contains a single configuration file - Main.dtsConfig that contains a superset of OLE DB connections. That is no single child package uses all of the connections contained in main.dtsConfig.
Each child package will execute independently without error. However, when called from Main.dtsx, I get the following errors:
Error: 2007-08-15 15:44:22.93
Code: 0xC001000E
Source: UserSecurity
Description: The connection "CRM" is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
Warning: 2007-08-15 15:44:22.93
Code: 0x8001F02F
Source: UserSecurity
Description: Cannot resolve a package path to an object in the package ".Connections[CRM].Properties[ConnectionString]". Verify that the package path is valid.
End Warning
Warning: 2007-08-15 15:44:22.94
Code: 0x80012017
Source: UserSecurity
Description: The package path referenced an object that cannot be found: "\Package.Connections[CRM].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.
End Warning
I have seen discussions that suggest that these errors occur where the connection in the config file is not found in the child package. Is there any way of suppressing this ?
Are there any simpler methods that allow me to change connections in each environment?
I suspect I will end up having to tailor config files for each child package, but I live in hope.
Michael M.
Duh! The main cause of this error is the fact that the child packages do not contain all of the connections that are in Main.dtsConfig.
But it is a pain to have to add connections that you don't use to each package.
And it is pain that you can't use the Deployment utility because it crashes attempting to copy the same config files over.
|||You can use individual configuration files if you want; that way each package uses only the config files that really requires. BTW, I think, a package does not fail because the configuration file has an entry that is not used by that package; rather you see a warning.
|||Regarding: BTW, I think, a package does not fail...
What caused this error?
Code Snippet
Error: 2007-08-15 15:44:22.93
Code: 0xC001000E
Source: UserSecurity
Description: The connection "CRM" is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
As to writing individual config files, this is creates unneccessary work, IMHO. Other ETL packages can use a single config file.
The best solution would be to build a tool that updates the .dtsx files in each environment and then we don't need config files at all.
Cannot resolve a package path
I have a parent package - Main.dtsx that calls a number of child packages. I also use configuration packages as I must deploy the application across multiple environments.
Main.dtsx contains a single Ccnfiguration file - Child_Packages.dtsConfig. This contains the connection strings for all the child packages.
Each child package contains a single configuration file - Main.dtsConfig that contains a superset of OLE DB connections. That is no single child package uses all of the connections contained in main.dtsConfig.
Each child package will execute independently without error. However, when called from Main.dtsx, I get the following errors:
Error: 2007-08-15 15:44:22.93
Code: 0xC001000E
Source: UserSecurity
Description: The connection "CRM" is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
Warning: 2007-08-15 15:44:22.93
Code: 0x8001F02F
Source: UserSecurity
Description: Cannot resolve a package path to an object in the package ".Connections[CRM].Properties[ConnectionString]". Verify that the package path is valid.
End Warning
Warning: 2007-08-15 15:44:22.94
Code: 0x80012017
Source: UserSecurity
Description: The package path referenced an object that cannot be found: "\Package.Connections[CRM].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.
End Warning
I have seen discussions that suggest that these errors occur where the connection in the config file is not found in the child package. Is there any way of suppressing this ?
Are there any simpler methods that allow me to change connections in each environment?
I suspect I will end up having to tailor config files for each child package, but I live in hope.
Michael M.
Duh! The main cause of this error is the fact that the child packages do not contain all of the connections that are in Main.dtsConfig.
But it is a pain to have to add connections that you don't use to each package.
And it is pain that you can't use the Deployment utility because it crashes attempting to copy the same config files over.
|||You can use individual configuration files if you want; that way each package uses only the config files that really requires. BTW, I think, a package does not fail because the configuration file has an entry that is not used by that package; rather you see a warning.
|||Regarding: BTW, I think, a package does not fail...
What caused this error?
Code Snippet
Error: 2007-08-15 15:44:22.93
Code: 0xC001000E
Source: UserSecurity
Description: The connection "CRM" is not found. This error is thrown by Connections collection when the specific connection element is not found.
End Error
As to writing individual config files, this is creates unneccessary work, IMHO. Other ETL packages can use a single config file.
The best solution would be to build a tool that updates the .dtsx files in each environment and then we don't need config files at all.