Hi, all..
I want to know the query to retrieve Column information that we can see from table Design view of Enterprise manager, such as Column name, Pk or not, FK table, Data Type, Null or not, Description(Specially Descrition).
Is there any sp for this or any query for this?
Thank you all...type
sp_help tablename|||select * from INFORMATION_SCHEMA.TABLES
select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
See BOL for more information about schema.|||You can also use
INFORMATION_SCHEMA.columns
cheers
-ss|||I too would like to get at the Description and I tried all of the above but Description doesn't seem to be there. I looked at all the INFORMATION_SCHEMA views and found nothing. I checked the system tables for the DB in question and found nothing. Could the Description be something internal to EM that isn't available to clients?|||What do you mean by description?|||I assume the Column Description you can enter in EM when designing a table. It's the first item on the Columns tab.|||OK...I usually maitain my data dictionary separatley...
You need to look up
fn_listextendedproperty
Never really used it....|||I assume the Column Description you can enter in EM when designing a table. It's the first item on the Columns tab.
Check this table:
select * from sysproperties|||Yup... Works fine.
Thanks Brett..|||select * from sysproperties
Works as well but may take extra coding to figure out the id and smallid so the data for the correct column can be identified.
Thanks...|||It works!!! Assuming a Table name of 'KB' and a column named 'Title' this gets the description.
declare @.tbid integer
declare @.colid integer
Select @.tbid=id from sysobjects where xtype='u' and name='KB'
Select @.colid = colid from syscolumns Where id=@.tbid And name='Title'
select value from sysproperties where id=@.tbid and smallid=@.colid and name='MS_Description'
Thanks snail for the pointer to sysProperties.|||Thanks all..
I think we have to know sysproperties table joined with which table..|||Can't help with the JOIN. There are three tables here and I haven't figured out how to JOIN two yet! :)|||Now I am finishing ...
This works! the following three tables joined gives what I asked.
I hope this helps all...
Thank you all for considering
Use Northwind
SELECT sysobjects.name AS [Table], syscolumns.name AS [Column], sysproperties.[value] AS Description
FROM (sysobjects INNER JOIN syscolumns
ON syscolumns.id = sysobjects.id) LEFT JOIN sysproperties
ON sysproperties.smallid = syscolumns.colid AND
sysproperties.id = syscolumns.id
where sysobjects.name = 'Orders'
-- PS
sysobjects.name : table Name (WHERE sysobjects.xtype = 'U')
sysobjects.id : table ID
sysproperties.smallid : Column id
sysproperties.[value] : Description
You can add following
WHERE sysobjects.xtype = 'U' xtype='U' means only select Table object
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Friday, March 30, 2012
How can I restore the db successfully
I'm a new user to SQL Server.
I use the Restore Database function in the Entreprise Manager to restore a database. But I have no idea about why it prompt error when I click OK and say :
Cannot find file ID 2 on device c:\Program File\Microsoft SQL Server\MSSQL\BACKUP\abc'. RESTORE DATABASE is terminating abnormally.
On the other hand, if I have a backup database file from someone, how can I restore it in the normal way.
1st Step: New a Database (no change to the setting)
2nd Step: Right click DB->Restore Database-> but how can I choose the backup database file that someone give me.?
Best regards,
Grace
Hi,
How can I choose the backup database file that someone give me.?
In the Restore databaase window -- Select the option button "From Device" ,
Click the "Select Device" -- Click "Add"
and in the file name get the .BAK file from the directory and click "OK".
There you select Backup Number "View contents" . This
will show you all the files associated with the backup file.
If you have mutiple files select the one you require and click "OK" to
restore.
Cannot find file ID 2 on device c: ?
I feel that this Backup is taken in mutiple files (Devices) and you have
only one file. In that case you cant restore till u get the other file.
Thanks
Hari
MCDBA
"Grace" <anonymous@.discussions.microsoft.com> wrote in message
news:17BBF6CC-AC73-44FE-A31D-AE0848ED7B83@.microsoft.com...
> I'm a new user to SQL Server.
> I use the Restore Database function in the Entreprise Manager to restore a
database. But I have no idea about why it prompt error when I click OK and
say :
> Cannot find file ID 2 on device c:\Program File\Microsoft SQL
Server\MSSQL\BACKUP\abc'. RESTORE DATABASE is terminating abnormally.
> On the other hand, if I have a backup database file from someone, how can
I restore it in the normal way.
> 1st Step: New a Database (no change to the setting)
> 2nd Step: Right click DB->Restore Database-> but how can I choose the
backup database file that someone give me.?
> Best regards,
> Grace
|||Grace,
The restore dialog in EM can use the backup history produced when you took the backup. But that doesn't
necessarily reflect what you actually have on the backup files. In this case, it seems like the backup history
say that there should be at least two backups on the backup file, and there isn't. Perhaps the backup file
doesn't exist at all...
If you want to restore a backup for a database which doesn't exists, *do not* create the database first. If
you do, you will most probably not create it with the same file structure as you had when you took the backup.
Let the restore process create the database for you. Just enter the restore dialog, type in the database name,
and select "from device". Here you can specify the backup file from which you want to do the restore.
I strongly suggest you read about how backup and restore work in Books Online, without that knowledge, you
might find above a bit difficult to understand. Also, I find it easier to work with the BACKUP and RESTORE
commands from Query Analyzer instead of using a GUI like EM. At least until you have good understanding about
the architecture of backup and restore and then understand more of how it work and what EM does when you
select options in the GUI. Just my opinion, that is...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Grace" <anonymous@.discussions.microsoft.com> wrote in message
news:17BBF6CC-AC73-44FE-A31D-AE0848ED7B83@.microsoft.com...
> I'm a new user to SQL Server.
> I use the Restore Database function in the Entreprise Manager to restore a database. But I have no idea
about why it prompt error when I click OK and say :
> Cannot find file ID 2 on device c:\Program File\Microsoft SQL Server\MSSQL\BACKUP\abc'. RESTORE DATABASE
is terminating abnormally.
> On the other hand, if I have a backup database file from someone, how can I restore it in the normal way.
> 1st Step: New a Database (no change to the setting)
> 2nd Step: Right click DB->Restore Database-> but how can I choose the backup database file that someone give
me.?
> Best regards,
> Grace
|||You are trying to restore from database, which uses the history of backups. The history path is different from the path of the file on the disk you are trying to restore from.
To restore from the file you have, you should click the bullet marked device (change from database) and browse to the actual file system file you are trying to restore the database to(via select devices... then Add...button).
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
I use the Restore Database function in the Entreprise Manager to restore a database. But I have no idea about why it prompt error when I click OK and say :
Cannot find file ID 2 on device c:\Program File\Microsoft SQL Server\MSSQL\BACKUP\abc'. RESTORE DATABASE is terminating abnormally.
On the other hand, if I have a backup database file from someone, how can I restore it in the normal way.
1st Step: New a Database (no change to the setting)
2nd Step: Right click DB->Restore Database-> but how can I choose the backup database file that someone give me.?
Best regards,
Grace
Hi,
How can I choose the backup database file that someone give me.?
In the Restore databaase window -- Select the option button "From Device" ,
Click the "Select Device" -- Click "Add"
and in the file name get the .BAK file from the directory and click "OK".
There you select Backup Number "View contents" . This
will show you all the files associated with the backup file.
If you have mutiple files select the one you require and click "OK" to
restore.
Cannot find file ID 2 on device c: ?
I feel that this Backup is taken in mutiple files (Devices) and you have
only one file. In that case you cant restore till u get the other file.
Thanks
Hari
MCDBA
"Grace" <anonymous@.discussions.microsoft.com> wrote in message
news:17BBF6CC-AC73-44FE-A31D-AE0848ED7B83@.microsoft.com...
> I'm a new user to SQL Server.
> I use the Restore Database function in the Entreprise Manager to restore a
database. But I have no idea about why it prompt error when I click OK and
say :
> Cannot find file ID 2 on device c:\Program File\Microsoft SQL
Server\MSSQL\BACKUP\abc'. RESTORE DATABASE is terminating abnormally.
> On the other hand, if I have a backup database file from someone, how can
I restore it in the normal way.
> 1st Step: New a Database (no change to the setting)
> 2nd Step: Right click DB->Restore Database-> but how can I choose the
backup database file that someone give me.?
> Best regards,
> Grace
|||Grace,
The restore dialog in EM can use the backup history produced when you took the backup. But that doesn't
necessarily reflect what you actually have on the backup files. In this case, it seems like the backup history
say that there should be at least two backups on the backup file, and there isn't. Perhaps the backup file
doesn't exist at all...
If you want to restore a backup for a database which doesn't exists, *do not* create the database first. If
you do, you will most probably not create it with the same file structure as you had when you took the backup.
Let the restore process create the database for you. Just enter the restore dialog, type in the database name,
and select "from device". Here you can specify the backup file from which you want to do the restore.
I strongly suggest you read about how backup and restore work in Books Online, without that knowledge, you
might find above a bit difficult to understand. Also, I find it easier to work with the BACKUP and RESTORE
commands from Query Analyzer instead of using a GUI like EM. At least until you have good understanding about
the architecture of backup and restore and then understand more of how it work and what EM does when you
select options in the GUI. Just my opinion, that is...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Grace" <anonymous@.discussions.microsoft.com> wrote in message
news:17BBF6CC-AC73-44FE-A31D-AE0848ED7B83@.microsoft.com...
> I'm a new user to SQL Server.
> I use the Restore Database function in the Entreprise Manager to restore a database. But I have no idea
about why it prompt error when I click OK and say :
> Cannot find file ID 2 on device c:\Program File\Microsoft SQL Server\MSSQL\BACKUP\abc'. RESTORE DATABASE
is terminating abnormally.
> On the other hand, if I have a backup database file from someone, how can I restore it in the normal way.
> 1st Step: New a Database (no change to the setting)
> 2nd Step: Right click DB->Restore Database-> but how can I choose the backup database file that someone give
me.?
> Best regards,
> Grace
|||You are trying to restore from database, which uses the history of backups. The history path is different from the path of the file on the disk you are trying to restore from.
To restore from the file you have, you should click the bullet marked device (change from database) and browse to the actual file system file you are trying to restore the database to(via select devices... then Add...button).
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
How can i remove a server from enterprise manager
Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks Alfred
I found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!
|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard
|||try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||man forgot attachment - bad day ..
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:%23bs6bC4jEHA.1356@.TK2MSFTNGP09.phx.gbl...
> (sorry fat fingers)
> try attached vbscript uses DMO to delete the server registration - rename
to
> .vbs and run on the server with registration u want to delete by using :
> CSCRIPT DELSQLRegistration.vbs SERVER
> where SERVER is the name of the server Registration you want to delete
> Note for it to no longer appear in Enterprise Manager , you need to
restart
> Enterprise Manager.
> Andy.
> "Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
> news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
>
begin 666 DelSQLRegistration.txt
M)R J*BH@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B<R J*BH-"B<@.=7-I;F<@.1$U/
M(%-C<FEP="!O=70@.<F]L;"!T:')O=6=H(%-E<G9E<G,@.4F5G:7-T97)E9"!I
M;B!%;G1E<G!R:7-E($UA;F%G97(@.#0HG(&%N9"!T<GD@.86YD(&1E;&5T90T*
M)R!0<F5S=6UE(%-!($%C8V5S<PT*)R!!;F1Y($)A;&P@.,S$O."\R,# T#0H-
M"D]P=&EO;B!%>'!L:6-I= T*( T*#0I$:6T@.;T%R9W,@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.)R!!<F=U;65N=',-"D1I;2!7<VA3:&5L;" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G(&9O<B!7:6YD;W=S(%-C<FEP
M=&EN9R!(;W-T#0I$:6T@.3&]C86Q397)V97).86UE(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.)R!T:&4@.4V5R=F5R#0I$:6T@.3&]C86Q$0DYA;64@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.)R!T:&4@.9&%T86)A<V4-"D1I;2!,;V-A;%-13%5S
M97).86UE(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!5<V5R($YA;64-"D1I
M;2!,;V-A;%-13%!A<W-W;W)D(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!0
M87-S=V]R9 T*#0HG($YE960@.4'5B;&EC($%R<F%Y(&)E8V%U<V4@.=&AE(%-U
M8B!T;R!E;G5M97)A=&4@.=&AE(%-E<G9E<G,@.9G)O;2!$34\@.:7,@.<F5C=7)S
M:79E+BX-"E!U8FQI8R!397)V97)!<G)A>2@.I#0I0=6)L:6,@.07)R87E0;W ,-
M"D%R<F%Y4&]S/3 -"@.T*#0IS970@.5W-H4VAE;&P@./2!#<F5A=&5/8FIE8W0@.
M*")7<V-R:7!T+E-H96QL(BD-"@.T*)R!087)A;65T97)S#0IS970@.;T%R9W,@.
M/2!7<V-R:7!T+D%R9W5M96YT<PT*#0HG(&-H96-K(&-O<G)E8W0@.;G5M8F5R
M(&]F(&%R9W,-"DEF("AO07)G<RY#;W5N=" \/B Q*2!4:&5N#0H)5W-C<FEP
M="Y%8VAO(")5<V%G92 Z(&-S8W)I<'0@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B
M<R \4V5R=F5R/B(-"@.E7<V-R:7!T+D5C:&\@.(FDN92X@.(#H@.8W-C<FEP="!$
M96Q344Q296=I<W1R871I;VXN=F)S($]L9%-E<G9E<B(-"@.E7<V-R:7!T+E%U
M:70@.(" @.#0I%;'-E#0H)"4QO8V%L4V5R=F5R3F%M92 @.(" @.(" @.(#T@.;T%R
M9W,H,"D-"D5N9"!)9@.T*#0HG("HJ*B!-86EN(%-C<FEP=" J*BH-"D-A;&P@.
M1&5L4U%,4F5G:7-T<F%T:6]N*$QO8V%L4V5R=F5R3F%M92P@.3F]T:&EN9RD-
M"B<@.*BHJ($5N9"!-86EN("HJ*@.T*#0HG(%-U8B!T;R!%;G5M97)A=&4@.=&AR
M;W5G:"!296=I<W1E<F5D4V5R=F5R<R M(&YO=&4@.8F5C875S92!O9B!T:&4@.
M:&EE<F%C:&%C86P@.;F%T=7)E(&]F(%-E<G9E<B!296=I<W1R871I;VYS( T*
M)R!T:&ES('-U8B!I<R!R96-U<G-I=F4N+@.T*4')I=F%T92!3=6(@.1&5L4U%,
M4F5G:7-T<F%T:6]N*%-E<G9E<DYA;64L(&]2;V]T3V)J96-T*0T*"2<@.5F%R
M:6%B;&5S#0H)1&EM(%-C<FEP=%-T<FEN9R @.(" @.(" @.(" @.(" @.(" G(')E
M='5R;G,@.:6YT;R!H97)E('1R86YS86-T('-Q;"!F;W(@.;V)J96-T#0H)1&EM
M(&9S(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G($9I;&53>7-T96T@.;V)J
M96-T('9A<B M('1O(&%L;&]W(&9I;&4@.;W!E<F%T:6]N<RX-"@.E$:6T@.> D)
M"0DG('5S960@.:6X@.1F]R#0H)1&EM('(-"@.D-"@.E$:6T@.;T%P<&QI8V%T:6]N
M"0DG(%-13$1-3R!!<'!L:6-A=&EO;B!O8FIE8W0-"@.E$:6T@.;U)E9VES=&5R
M961397)V97)S"0T*"41I;2!O0W5R<F5N=%-E<G9E<D=R;W5P#0H-"@.E$:6T@.
M4F5G:7-T97)E9%-E<G9E<@.T*"41I;2!.=6U397)V97)'<F]U<',-"@.E$:6T@.
M8E-E<G9E<D9O=6YD#0H-"@.DG(&EE(&EF('1H92!F:7)S="!C86QL('=E(&YE
M960@.=&\@.8W)E871E(&$@.1$U/($%P<&QI8V%T:6]N(&]B:F5C="!T;R!S=&%R
M="!F<F]M(&%N9"!A<W-I9VX@.:70@.=&\@.;U)O;W1/8FIE8W0-"@.DG(&%L<V\@.
M<VAO=R!M97-S86=E('-A>6EN9R!I=&5R871I;F<@.<F5G:7-T97)E9"!S97)V
M97)S#0H)268@.;U)O;W1/8FIE8W0@.:7,@.3F]T:&EN9R!4:&5N( T*"0E7<V-R
M:7!T+D5C:&\@.(DET97)A=&EN9R!296=I<W1E<F5D(%-E<G9E<G,@.+BXN(@.T*
M"0E7<V-R:7!T+D5C:&\-"@.D)<V5T(&]2;V]T3V)J96-T(#T@.0W)E871E3V)J
M96-T*")344Q$34\N07!P;&EC871I;VXB*0T*"0E.=6U397)V97)'< F]U<',@.
M/2!O4F]O=$]B:F5C="Y397)V97)'<F]U<',N0V]U;G0-"@.E%;'-E#0H)"4YU
M;5-E<G9E<D=R;W5P<R ](&]2;V]T3V)J96-T+E-E<G9E<D=R;W5P<RY#;W5N
M= T*"45N9"!)9B -"@.T*"2<@.:2YE('-E="!S;R!397)V97(@.3F]T(&9O=6YD
M#0H)8E-E<G9E<D9O=6YD(#T@.," -"@.T*"2<@.:71E<F%T92!T:')O=6=H(%-E
M<G9E<D=R;W5P<R!S:&]W:6YG($YA;64-"@.E&;W(@.>" ](#$@.=&\@.3G5M4V5R
M=F5R1W)O=7!S#0H)"7-E="!O0W5R<F5N=%-E<G9E<D=R;W5P(#T@.;U)O;W1/
M8FIE8W0N4V5R=F5R1W)O=7!S*'@.I#0H)"5=38W)I<'0N16-H;R B1W)O=7 @.
M/2 B("L@.;T-U<G)E;G1397)V97)'<F]U<"Y.86UE#0H-"@.D)<V5T(&]296=I
M<W1E<F5D4V5R=F5R<R ](&]#=7)R96YT4V5R=F5R1W)O=7 N4F5G:7-T97)E
M9%-E<G9E<G,-"@.D)1F]R($5A8V@.@.4F5G:7-T97)E9%-E<G9E<B!I;B!O4F5G
M:7-T97)E9%-E<G9E<G,-"@.D)"5=38W)I<'0N16-H;R!V8E1!0B K(")397)V
M97(@./2 B("L@.4F5G:7-T97)E9%-E<G9E<BY.86UE#0H)"0D-"@.D)"2<@.*BHJ
M(%-E<G9E<B!&;W5N9"!H97)E("HJ*B -"@.D)"4EF(%5#05-%*%)E9VES=&5R
M961397)V97(N3F%M92D@./2!50T%312A397)V97).86UE*2!4:&5N#0H)"0D)
M5W-C<FEP="Y%8VAO('9B5$%"("L@.54-!4T4H4V5R=F5R3F%M92D@.*R B(&ES
M(')E9VES=&5R960N($1E;&5T:6YG(@.T*"0D)"5)E9VES=&5R9 61397)V97(N
M4F5M;W9E#0H)"0D)8E-E<G9E<D9O=6YD(#T@.,0T*"0D)"2<@.2&%V92!T;R!Q
M=6ET(&-O<R!R96-U<G-I=F4@.<W5B+"!%;F0@.4W5B('=O;B=T(&-U="!I= T*
M"0D)"5=S8W)I<'0N475I=" -"@.D)"45N9"!)9B -"@.D)3F5X= T*#0H)"2<@.
M:64@.=V4@.:&%V92!397)V97)'<F]U<',@.8F5L;W<@.=&AI<R!O;F4L('-O(')E
M8W5R<VEV96QY(&-A;&P@.=&AE(%-U8B!A9V%I;B!W:71H('1H92!C=7)R96YT
M(%-E<G9E<@.T*"0DG($=R;W5P(&%S('1H92!2;V]T3V)J96-T"0T*"0E)9B!O
M0W5R<F5N=%-E<G9E<D=R;W5P+E-E<G9E<D=R;W5P<RY#;W5N=" ^(# @.5&AE
M;B -"@.D)"4-A;&P@.1&5L4U%,4F5G:7-T<F%T:6]N("A397)V97).86UE+"!O
M0W5R<F5N=%-E<G9E<D=R;W5P*0T*"0E%;F0@.268@.#0H)3F5X= T*16YD(%-U
%8@.T*#0H`
`
end
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks Alfred
I found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!
|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard
|||try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||man forgot attachment - bad day ..
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:%23bs6bC4jEHA.1356@.TK2MSFTNGP09.phx.gbl...
> (sorry fat fingers)
> try attached vbscript uses DMO to delete the server registration - rename
to
> .vbs and run on the server with registration u want to delete by using :
> CSCRIPT DELSQLRegistration.vbs SERVER
> where SERVER is the name of the server Registration you want to delete
> Note for it to no longer appear in Enterprise Manager , you need to
restart
> Enterprise Manager.
> Andy.
> "Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
> news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
>
begin 666 DelSQLRegistration.txt
M)R J*BH@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B<R J*BH-"B<@.=7-I;F<@.1$U/
M(%-C<FEP="!O=70@.<F]L;"!T:')O=6=H(%-E<G9E<G,@.4F5G:7-T97)E9"!I
M;B!%;G1E<G!R:7-E($UA;F%G97(@.#0HG(&%N9"!T<GD@.86YD(&1E;&5T90T*
M)R!0<F5S=6UE(%-!($%C8V5S<PT*)R!!;F1Y($)A;&P@.,S$O."\R,# T#0H-
M"D]P=&EO;B!%>'!L:6-I= T*( T*#0I$:6T@.;T%R9W,@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.)R!!<F=U;65N=',-"D1I;2!7<VA3:&5L;" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G(&9O<B!7:6YD;W=S(%-C<FEP
M=&EN9R!(;W-T#0I$:6T@.3&]C86Q397)V97).86UE(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.)R!T:&4@.4V5R=F5R#0I$:6T@.3&]C86Q$0DYA;64@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.)R!T:&4@.9&%T86)A<V4-"D1I;2!,;V-A;%-13%5S
M97).86UE(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!5<V5R($YA;64-"D1I
M;2!,;V-A;%-13%!A<W-W;W)D(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!0
M87-S=V]R9 T*#0HG($YE960@.4'5B;&EC($%R<F%Y(&)E8V%U<V4@.=&AE(%-U
M8B!T;R!E;G5M97)A=&4@.=&AE(%-E<G9E<G,@.9G)O;2!$34\@.:7,@.<F5C=7)S
M:79E+BX-"E!U8FQI8R!397)V97)!<G)A>2@.I#0I0=6)L:6,@.07)R87E0;W ,-
M"D%R<F%Y4&]S/3 -"@.T*#0IS970@.5W-H4VAE;&P@./2!#<F5A=&5/8FIE8W0@.
M*")7<V-R:7!T+E-H96QL(BD-"@.T*)R!087)A;65T97)S#0IS970@.;T%R9W,@.
M/2!7<V-R:7!T+D%R9W5M96YT<PT*#0HG(&-H96-K(&-O<G)E8W0@.;G5M8F5R
M(&]F(&%R9W,-"DEF("AO07)G<RY#;W5N=" \/B Q*2!4:&5N#0H)5W-C<FEP
M="Y%8VAO(")5<V%G92 Z(&-S8W)I<'0@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B
M<R \4V5R=F5R/B(-"@.E7<V-R:7!T+D5C:&\@.(FDN92X@.(#H@.8W-C<FEP="!$
M96Q344Q296=I<W1R871I;VXN=F)S($]L9%-E<G9E<B(-"@.E7<V-R:7!T+E%U
M:70@.(" @.#0I%;'-E#0H)"4QO8V%L4V5R=F5R3F%M92 @.(" @.(" @.(#T@.;T%R
M9W,H,"D-"D5N9"!)9@.T*#0HG("HJ*B!-86EN(%-C<FEP=" J*BH-"D-A;&P@.
M1&5L4U%,4F5G:7-T<F%T:6]N*$QO8V%L4V5R=F5R3F%M92P@.3F]T:&EN9RD-
M"B<@.*BHJ($5N9"!-86EN("HJ*@.T*#0HG(%-U8B!T;R!%;G5M97)A=&4@.=&AR
M;W5G:"!296=I<W1E<F5D4V5R=F5R<R M(&YO=&4@.8F5C875S92!O9B!T:&4@.
M:&EE<F%C:&%C86P@.;F%T=7)E(&]F(%-E<G9E<B!296=I<W1R871I;VYS( T*
M)R!T:&ES('-U8B!I<R!R96-U<G-I=F4N+@.T*4')I=F%T92!3=6(@.1&5L4U%,
M4F5G:7-T<F%T:6]N*%-E<G9E<DYA;64L(&]2;V]T3V)J96-T*0T*"2<@.5F%R
M:6%B;&5S#0H)1&EM(%-C<FEP=%-T<FEN9R @.(" @.(" @.(" @.(" @.(" G(')E
M='5R;G,@.:6YT;R!H97)E('1R86YS86-T('-Q;"!F;W(@.;V)J96-T#0H)1&EM
M(&9S(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G($9I;&53>7-T96T@.;V)J
M96-T('9A<B M('1O(&%L;&]W(&9I;&4@.;W!E<F%T:6]N<RX-"@.E$:6T@.> D)
M"0DG('5S960@.:6X@.1F]R#0H)1&EM('(-"@.D-"@.E$:6T@.;T%P<&QI8V%T:6]N
M"0DG(%-13$1-3R!!<'!L:6-A=&EO;B!O8FIE8W0-"@.E$:6T@.;U)E9VES=&5R
M961397)V97)S"0T*"41I;2!O0W5R<F5N=%-E<G9E<D=R;W5P#0H-"@.E$:6T@.
M4F5G:7-T97)E9%-E<G9E<@.T*"41I;2!.=6U397)V97)'<F]U<',-"@.E$:6T@.
M8E-E<G9E<D9O=6YD#0H-"@.DG(&EE(&EF('1H92!F:7)S="!C86QL('=E(&YE
M960@.=&\@.8W)E871E(&$@.1$U/($%P<&QI8V%T:6]N(&]B:F5C="!T;R!S=&%R
M="!F<F]M(&%N9"!A<W-I9VX@.:70@.=&\@.;U)O;W1/8FIE8W0-"@.DG(&%L<V\@.
M<VAO=R!M97-S86=E('-A>6EN9R!I=&5R871I;F<@.<F5G:7-T97)E9"!S97)V
M97)S#0H)268@.;U)O;W1/8FIE8W0@.:7,@.3F]T:&EN9R!4:&5N( T*"0E7<V-R
M:7!T+D5C:&\@.(DET97)A=&EN9R!296=I<W1E<F5D(%-E<G9E<G,@.+BXN(@.T*
M"0E7<V-R:7!T+D5C:&\-"@.D)<V5T(&]2;V]T3V)J96-T(#T@.0W)E871E3V)J
M96-T*")344Q$34\N07!P;&EC871I;VXB*0T*"0E.=6U397)V97)'< F]U<',@.
M/2!O4F]O=$]B:F5C="Y397)V97)'<F]U<',N0V]U;G0-"@.E%;'-E#0H)"4YU
M;5-E<G9E<D=R;W5P<R ](&]2;V]T3V)J96-T+E-E<G9E<D=R;W5P<RY#;W5N
M= T*"45N9"!)9B -"@.T*"2<@.:2YE('-E="!S;R!397)V97(@.3F]T(&9O=6YD
M#0H)8E-E<G9E<D9O=6YD(#T@.," -"@.T*"2<@.:71E<F%T92!T:')O=6=H(%-E
M<G9E<D=R;W5P<R!S:&]W:6YG($YA;64-"@.E&;W(@.>" ](#$@.=&\@.3G5M4V5R
M=F5R1W)O=7!S#0H)"7-E="!O0W5R<F5N=%-E<G9E<D=R;W5P(#T@.;U)O;W1/
M8FIE8W0N4V5R=F5R1W)O=7!S*'@.I#0H)"5=38W)I<'0N16-H;R B1W)O=7 @.
M/2 B("L@.;T-U<G)E;G1397)V97)'<F]U<"Y.86UE#0H-"@.D)<V5T(&]296=I
M<W1E<F5D4V5R=F5R<R ](&]#=7)R96YT4V5R=F5R1W)O=7 N4F5G:7-T97)E
M9%-E<G9E<G,-"@.D)1F]R($5A8V@.@.4F5G:7-T97)E9%-E<G9E<B!I;B!O4F5G
M:7-T97)E9%-E<G9E<G,-"@.D)"5=38W)I<'0N16-H;R!V8E1!0B K(")397)V
M97(@./2 B("L@.4F5G:7-T97)E9%-E<G9E<BY.86UE#0H)"0D-"@.D)"2<@.*BHJ
M(%-E<G9E<B!&;W5N9"!H97)E("HJ*B -"@.D)"4EF(%5#05-%*%)E9VES=&5R
M961397)V97(N3F%M92D@./2!50T%312A397)V97).86UE*2!4:&5N#0H)"0D)
M5W-C<FEP="Y%8VAO('9B5$%"("L@.54-!4T4H4V5R=F5R3F%M92D@.*R B(&ES
M(')E9VES=&5R960N($1E;&5T:6YG(@.T*"0D)"5)E9VES=&5R9 61397)V97(N
M4F5M;W9E#0H)"0D)8E-E<G9E<D9O=6YD(#T@.,0T*"0D)"2<@.2&%V92!T;R!Q
M=6ET(&-O<R!R96-U<G-I=F4@.<W5B+"!%;F0@.4W5B('=O;B=T(&-U="!I= T*
M"0D)"5=S8W)I<'0N475I=" -"@.D)"45N9"!)9B -"@.D)3F5X= T*#0H)"2<@.
M:64@.=V4@.:&%V92!397)V97)'<F]U<',@.8F5L;W<@.=&AI<R!O;F4L('-O(')E
M8W5R<VEV96QY(&-A;&P@.=&AE(%-U8B!A9V%I;B!W:71H('1H92!C=7)R96YT
M(%-E<G9E<@.T*"0DG($=R;W5P(&%S('1H92!2;V]T3V)J96-T"0T*"0E)9B!O
M0W5R<F5N=%-E<G9E<D=R;W5P+E-E<G9E<D=R;W5P<RY#;W5N=" ^(# @.5&AE
M;B -"@.D)"4-A;&P@.1&5L4U%,4F5G:7-T<F%T:6]N("A397)V97).86UE+"!O
M0W5R<F5N=%-E<G9E<D=R;W5P*0T*"0E%;F0@.268@.#0H)3F5X= T*16YD(%-U
%8@.T*#0H`
`
end
How can i remove a server from enterprise manager
Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
How can i remove a server from enterprise manager
Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfredsql
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfredsql
Wednesday, March 7, 2012
How can i go to my SQL Query Manager
anybody can help me how to get into the SQL Query Manager. I downloaded already the MSSQL Server 2000 and it's already running.
efrend/l mssql? from where?|||yes, MSSQL. I'm wondering on how can i go to my SQL Server Enterprise Manager (Console Root). I wnat to create a database for my application.|||where did you d/l ms sql from?|||from MSDE 2000 for Developers Using Visual Studio .NET. the fike name is sql2kdesksp3.exe.|||from MSDE 2000 for Developers Using Visual Studio .NET. the file name is sql2kdesksp3.exe. why? does it matter where i downloaded the exe file? Am confused.
Friday, February 24, 2012
How can I get Enterprise Manager to see my remote server?
I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>
How can I get Enterprise Manager to see my remote server?
I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
How can I get Enterprise Manager to see my remote server?
I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
How can I get Enterprise Manager to see my remote server?
I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from
my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from
my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>
Subscribe to:
Posts (Atom)