Can't backup Remote database

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.
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

cant access to remote MS SQL server!

Here is the connection string i used:

"Data Source=<IP>,1433;Network Library=DBMSSOCN;Initial Catalog=<dbname>;User ID=sa;Password=<pwd>;"

i use that to connect to the remote SQL server, which has status of port 1433 at "Stealth"... do i need to open the port complete, if yes how i do that ?

does the SQL Server must use SQL authentication ?

Your help is greatly appreciated.Try this:

server=<ip>;uid=sa;pwd=<pwd>;database=<dbname
Remove everything else from the connection string.|||thnx, btw, do i need to add the port # after the IP ?|||yes, if it is not default (not 1433)
if it is 1433, there is no need to specify it

Can't access linked server through Query Analyzer

Hi, i created a linked server and can see the tables shown in Enterprise Manager. When I log into Query Analyzer, I try to access the remote tables with the 4 part naming convention and i get
SELECT COUNT(*) FROM PGJE_06_sp.nodo_sp.bts.caso
Servidor: mensaje 208, nivel 16, estado 1, lXnea 1
El nombre de objeto 'nodo_sp.bts.caso' no es válido.
which means "Object name is invalid"
I've tried changing its case, login through windows authentication and sqlserver authentication, but I get the same problem.
I created a linked server "backwards", that is from server B to A, and it works fine. Other servers have a linked server to this same server B (PGJE_SP_06) and they work fine.
Thanks for your help
Israel,
1. Did you try selecting "Tools --> Query Analyzer" from the Enterprise Manager -- this should open the QA connection with the same credentials with which the Enterprise Manager is running.
2. Did you confirm that your FROM clause does not have any typos? (e.g., Is the linked server name correct? Did you check on your server "B" that "SELECT COUNT(*) FROM nodo_sp.bts.caso").
3. Did you try to use the OPENQUERY (LinkedServerName, 'Select count(*) from Table') syntax?
4. Can you double check your linked server settings match the settings (e.g. Provider) that you have on the servers which are able to execute the query successfully.
Thanks,
Tea C.
"Israel Perez" wrote:

> Hi, i created a linked server and can see the tables shown in Enterprise Manager. When I log into Query Analyzer, I try to access the remote tables with the 4 part naming convention and i get
> SELECT COUNT(*) FROM PGJE_06_sp.nodo_sp.bts.caso
> Servidor: mensaje 208, nivel 16, estado 1, lXnea 1
> El nombre de objeto 'nodo_sp.bts.caso' no es válido.
> which means "Object name is invalid"
> I've tried changing its case, login through windows authentication and sqlserver authentication, but I get the same problem.
> I created a linked server "backwards", that is from server B to A, and it works fine. Other servers have a linked server to this same server B (PGJE_SP_06) and they work fine.
> Thanks for your help

Can't access linked server through Query Analyzer

Hi, i created a linked server and can see the tables shown in Enterprise Man
ager. When I log into Query Analyzer, I try to access the remote tables with
the 4 part naming convention and i get
SELECT COUNT(*) FROM PGJE_06_sp.nodo_sp.bts.caso
Servidor: mensaje 208, nivel 16, estado 1, l_nea 1
El nombre de objeto 'nodo_sp.bts.caso' no es válido.
which means "Object name is invalid"
I've tried changing its case, login through windows authentication and sqlse
rver authentication, but I get the same problem.
I created a linked server "backwards", that is from server B to A, and it wo
rks fine. Other servers have a linked server to this same server B (PGJE_SP_
06) and they work fine.
Thanks for your helpIsrael,
1. Did you try selecting "Tools --> Query Analyzer" from the Enterprise Mana
ger -- this should open the QA connection with the same credentials with wh
ich the Enterprise Manager is running.
2. Did you confirm that your FROM clause does not have any typos? (e.g., Is
the linked server name correct? Did you check on your server "B" that "SELE
CT COUNT(*) FROM nodo_sp.bts.caso").
3. Did you try to use the OPENQUERY (LinkedServerName, 'Select count(*) from
Table') syntax?
4. Can you double check your linked server settings match the settings (e.g.
Provider) that you have on the servers which are able to execute the query
successfully.
Thanks,
Tea C.
"Israel Perez" wrote:

> Hi, i created a linked server and can see the tables shown in Enterprise M
anager. When I log into Query Analyzer, I try to access the remote tables wi
th the 4 part naming convention and i get
> SELECT COUNT(*) FROM PGJE_06_sp.nodo_sp.bts.caso
> Servidor: mensaje 208, nivel 16, estado 1, l_nea 1
> El nombre de objeto 'nodo_sp.bts.caso' no es válido.
> which means "Object name is invalid"
> I've tried changing its case, login through windows authentication and sql
server authentication, but I get the same problem.
> I created a linked server "backwards", that is from server B to A, and it
works fine. Other servers have a linked server to this same server B (PGJE_S
P_06) and they work fine.
> Thanks for your helpsql

can't (re)start SQLServerAgent after changing its logon credentials

Since Copy Databas Wizard failed to copy anything from remote SS20005 (both are with SP2 3054) in any combination,
I changed SQLServerAgent(myinstance_name) to run under Network from Local System with the help of SQL Server Configuration Manager

For this change it was restarted, failed to start again and continues to be stopped giving
"SQLServerAgent could not be started (reason: Unable to connect to server '<mymachine_name>\<myinstance_name>'; SQLServerAgent cannot start)."

I changed SQL Server Agent (myinstance_name) back to Local Service, then to Local System and still can't start it.

So, my questions:
1)
What has happened and how can I start SQLServerAgent?

2)
Why cannot I start it under Network Service? since it apparently should access remote resources for CDW to copy from remote SS2005

This is on MS Windows XP SP2

PS
After few trials I amnaged to restart it again under Local System but still cannot change to any different one

If you change the account under which SQL Agent starts you need to make sure that the account has permissions within SQL server or else each tim eit tries to access SQL Server it will fail. Have a look at these:

http://support.microsoft.com/kb/283811

http://support.microsoft.com/kb/907557

|||

You can verify the permissions, windows group membership required, etc for the service accounts in the following books online topic:

Setting Up Windows Service Accounts

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

The NT Rights and Privleges section has the local windows group membership requirements - that one often gets overlooked for some reason. The help topic is pretty thorough and does a good job of covering the requirements.

Also note that as the article states, using Network Service isn't recommended. A domain account can provide the same network access but in a more secure manner. Otherwise you open some holes - network service means you give permissions needed for the CDW to the machine account. And then other apps, services running under network service get the permissions as well as they would be operating under the machine account.

-Sue

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot see the SQL Express Instance on the Network Server list...

I have installed SQL Server Express and I can connect with it locally using "localcomputername\SQLEXPRESS". It is configured for remote connection and for some reason, when I browse for this instance on the Network Server, it does not appear in the list. I have unistalled/installed it several times and still I cannot see this instance on the SQL Network server list. Can anyone help troble shoot this frustrating issue...

Thanks!

SAM

hi Sam,

is the SQL Browser service up and running?

regards

cannot see SQL Jobs on remote server

Hi,
I'm having troubles brining up details of existing SQL Jobs from remote
server. When I double-click existing job, it brings up "New Job" dialog box
instead of job details.
I needed to see and modify steps of a job on my collegue's machine. I can
connect to her SQL Server 2005 all right. But when I find the job I need,
right click it and select "Properties", I get "New Job" dialog box with all
tabs empty. What's interesting is I can still use "Script job as" menu item.
Another thing is that I see error messages like this in my error log:
DCOM was unable to communicate with the computer AAA using any of the
configured protocols.
I looked up this message and verified that I don't have UDP or IPX enabled,
only Connection-oriented TCP/IP and Connection-oriented SPX.
My other collegue can see the jobs fine, so I suppose the configuration
issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
Server 2000 and 2005 on our machines. 2005's version is
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I'd really appreciate if anyone has ideas on that.
thanks,
LucyI think the two errors are separate issues. I've seen the
issue with viewing jobs come up a few times. I suspect that
it's caused by problems with the smo dll - did you install
visual studio service packs to your PC? Try applying SQL
Server 2005 SP2 on your PC. That worked for me a couple of
times that I've run into this.
-Sue
On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:

>Hi,
>I'm having troubles brining up details of existing SQL Jobs from remote
>server. When I double-click existing job, it brings up "New Job" dialog box
>instead of job details.
>I needed to see and modify steps of a job on my collegue's machine. I can
>connect to her SQL Server 2005 all right. But when I find the job I need,
>right click it and select "Properties", I get "New Job" dialog box with all
>tabs empty. What's interesting is I can still use "Script job as" menu item
.
>Another thing is that I see error messages like this in my error log:
>DCOM was unable to communicate with the computer AAA using any of the
>configured protocols.
>I looked up this message and verified that I don't have UDP or IPX enabled,
>only Connection-oriented TCP/IP and Connection-oriented SPX.
>My other collegue can see the jobs fine, so I suppose the configuration
>issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
>Server 2000 and 2005 on our machines. 2005's version is
>Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Window
s
>NT 5.1 (Build 2600: Service Pack 2)
>I'd really appreciate if anyone has ideas on that.
>thanks,
>Lucy|||Hi Sue, thanks for answering.
I already have SP2, and SMO appears to be ok too.
The errors in the log appear at the time when I try to access the remote
jobs, so there has to be some connection between them...
"Sue Hoegemeier" wrote:

> I think the two errors are separate issues. I've seen the
> issue with viewing jobs come up a few times. I suspect that
> it's caused by problems with the smo dll - did you install
> visual studio service packs to your PC? Try applying SQL
> Server 2005 SP2 on your PC. That worked for me a couple of
> times that I've run into this.
> -Sue
> On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
> <Lucy@.discussions.microsoft.com> wrote:
>
>|||Sorry, Sue, you were right. I looked at it once more and noticed that it was
my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
went away.
Thanks a lot,
Lucy
"Lucy" wrote:
[vbcol=seagreen]
> Hi Sue, thanks for answering.
> I already have SP2, and SMO appears to be ok too.
> The errors in the log appear at the time when I try to access the remote
> jobs, so there has to be some connection between them...
> "Sue Hoegemeier" wrote:
>|||No problem...thanks for posting back.
-Sue
On Mon, 2 Apr 2007 12:32:06 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sorry, Sue, you were right. I looked at it once more and noticed that it wa
s
>my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
>went away.
>Thanks a lot,
>Lucy
>"Lucy" wrote:
>

cannot see SQL Jobs on remote server

Hi,
I'm having troubles brining up details of existing SQL Jobs from remote
server. When I double-click existing job, it brings up "New Job" dialog box
instead of job details.
I needed to see and modify steps of a job on my collegue's machine. I can
connect to her SQL Server 2005 all right. But when I find the job I need,
right click it and select "Properties", I get "New Job" dialog box with all
tabs empty. What's interesting is I can still use "Script job as" menu item.
Another thing is that I see error messages like this in my error log:
DCOM was unable to communicate with the computer AAA using any of the
configured protocols.
I looked up this message and verified that I don't have UDP or IPX enabled,
only Connection-oriented TCP/IP and Connection-oriented SPX.
My other collegue can see the jobs fine, so I suppose the configuration
issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
Server 2000 and 2005 on our machines. 2005's version is
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I'd really appreciate if anyone has ideas on that.
thanks,
Lucy
I think the two errors are separate issues. I've seen the
issue with viewing jobs come up a few times. I suspect that
it's caused by problems with the smo dll - did you install
visual studio service packs to your PC? Try applying SQL
Server 2005 SP2 on your PC. That worked for me a couple of
times that I've run into this.
-Sue
On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:

>Hi,
>I'm having troubles brining up details of existing SQL Jobs from remote
>server. When I double-click existing job, it brings up "New Job" dialog box
>instead of job details.
>I needed to see and modify steps of a job on my collegue's machine. I can
>connect to her SQL Server 2005 all right. But when I find the job I need,
>right click it and select "Properties", I get "New Job" dialog box with all
>tabs empty. What's interesting is I can still use "Script job as" menu item.
>Another thing is that I see error messages like this in my error log:
>DCOM was unable to communicate with the computer AAA using any of the
>configured protocols.
>I looked up this message and verified that I don't have UDP or IPX enabled,
>only Connection-oriented TCP/IP and Connection-oriented SPX.
>My other collegue can see the jobs fine, so I suppose the configuration
>issue is with my machine. We all have WinXP Proferssional SP2 and both SQL
>Server 2000 and 2005 on our machines. 2005's version is
>Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
>NT 5.1 (Build 2600: Service Pack 2)
>I'd really appreciate if anyone has ideas on that.
>thanks,
>Lucy
|||Hi Sue, thanks for answering.
I already have SP2, and SMO appears to be ok too.
The errors in the log appear at the time when I try to access the remote
jobs, so there has to be some connection between them...
"Sue Hoegemeier" wrote:

> I think the two errors are separate issues. I've seen the
> issue with viewing jobs come up a few times. I suspect that
> it's caused by problems with the smo dll - did you install
> visual studio service packs to your PC? Try applying SQL
> Server 2005 SP2 on your PC. That worked for me a couple of
> times that I've run into this.
> -Sue
> On Fri, 30 Mar 2007 15:06:01 -0700, Lucy
> <Lucy@.discussions.microsoft.com> wrote:
>
>
|||Sorry, Sue, you were right. I looked at it once more and noticed that it was
my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
went away.
Thanks a lot,
Lucy
"Lucy" wrote:
[vbcol=seagreen]
> Hi Sue, thanks for answering.
> I already have SP2, and SMO appears to be ok too.
> The errors in the log appear at the time when I try to access the remote
> jobs, so there has to be some connection between them...
> "Sue Hoegemeier" wrote:
|||No problem...thanks for posting back.
-Sue
On Mon, 2 Apr 2007 12:32:06 -0700, Lucy
<Lucy@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sorry, Sue, you were right. I looked at it once more and noticed that it was
>my Windows that had SP2. Now I installed SP2 for SQL Server and the problem
>went away.
>Thanks a lot,
>Lucy
>"Lucy" wrote:

cannot save storedproc after SP3

hi
we found a bug in EM. we are unable to save/export/transfer a DTS package to
another remote box. is there any workaround or hotfix available?
AlexAlex
See if this helps
http://www.sqldts.com/default.aspx?6,105,204,0,1
Regards
John|||How are you trying ?
File | Save As | SQL Server ?
File | Save As | Structured Storage File ?
Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"alex" <ntnewsNO@.SPAM.hrz3.hrz.tu-darmstadt.de> wrote in message
news:OgI#tPoUDHA.1280@.tk2msftngp13.phx.gbl...
> hi
> we found a bug in EM. we are unable to save/export/transfer a DTS package
to
> another remote box. is there any workaround or hotfix available?
>
> Alex
>|||hi
> How are you trying ?
> File | Save As | SQL Server ?
> File | Save As | Structured Storage File ?
this are 3 "save as" options in SP3 and 4 "save as" options in SP2 and
prior.
the third in SP3 is "Visual Basic File". in SP2 there is another Option
"Save as DTS package file" (sorry - the options is gone - i don't know the
exact name). we need this DTS package option for transfer...
Alex

Cannot restore database from a remote server

I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>

Cannot restore database from a remote server

I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>

Cannot restore database from a remote server

I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
--
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> I am unable to restore a new database from a backup located in a
>> different
>> server. The MSSQLSERVER service starts with the same network
> administrator,
>> who has sysadmin rights, for both servers. The problem is that when
> trying
>> to restore from the Enterprise Manager I cannot see the mapped drive nor
> can
>> I setup a backup device to the computer containing the backup. Are there
>> any pointers that any of you can give me on how to resolve this problem?
>> Thanks in advance for your help.
>>
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>

Cannot restore database from a remote server

I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>