Deletetion of an old Remote Server

I am trying to set up a publisher and I get an Error 18482: Could not
connect to server 'servername' because 'WEB1' is not defined as a remote
server. I went to the Remote Servers where WEB1' is listed, although this
server is no longer on our network. When I try to delete the listing, I get
the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to show
available servers. I do this and it is not listed of course. How do I
remove this server with a query?
Thank you.Do you mean linked server?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> I am trying to set up a publisher and I get an Error 18482: Could not
> connect to server 'servername' because 'WEB1' is not defined as a remote
> server. I went to the Remote Servers where WEB1' is listed, although this
> server is no longer on our network. When I try to delete the listing, I
get
> the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to
show
> available servers. I do this and it is not listed of course. How do I
> remove this server with a query?
> Thank you.|||No, it is listed under Remote Servers, not under Linked Servers.
"Jack Vamvas" wrote:
> Do you mean linked server?
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> > I am trying to set up a publisher and I get an Error 18482: Could not
> > connect to server 'servername' because 'WEB1' is not defined as a remote
> > server. I went to the Remote Servers where WEB1' is listed, although this
> > server is no longer on our network. When I try to delete the listing, I
> get
> > the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to
> show
> > available servers. I do this and it is not listed of course. How do I
> > remove this server with a query?
> >
> > Thank you.
>
>

Deleted Default Database

I had two databases on my server, and I just deleted the one which SQL Server
has identified as the default database. Now I can't connect to the server
via SQL Enterprise Manager. How can I rectify this situation? The server
itself is not having a problem, I'm just not able to connect remotely.
Actually, EM is the source of the problem. Login via another program (e.g.,
query analyzer) and reset the default db to one that exists (using
sp_defaultdb).
"KitCaz" <KitCaz@.discussions.microsoft.com> wrote in message
news:8F218C95-680F-4656-8AF9-354EA23E0694@.microsoft.com...
> I had two databases on my server, and I just deleted the one which SQL
Server
> has identified as the default database. Now I can't connect to the server
> via SQL Enterprise Manager. How can I rectify this situation? The server
> itself is not having a problem, I'm just not able to connect remotely.
|||Great, thanks! I see now it was a user ID thing.
"Scott Morris" wrote:

> Actually, EM is the source of the problem. Login via another program (e.g.,
> query analyzer) and reset the default db to one that exists (using
> sp_defaultdb).
> "KitCaz" <KitCaz@.discussions.microsoft.com> wrote in message
> news:8F218C95-680F-4656-8AF9-354EA23E0694@.microsoft.com...
> Server
>
>

Deleted Default Database

I had two databases on my server, and I just deleted the one which SQL Serve
r
has identified as the default database. Now I can't connect to the server
via SQL Enterprise Manager. How can I rectify this situation? The server
itself is not having a problem, I'm just not able to connect remotely.Actually, EM is the source of the problem. Login via another program (e.g.,
query analyzer) and reset the default db to one that exists (using
sp_defaultdb).
"KitCaz" <KitCaz@.discussions.microsoft.com> wrote in message
news:8F218C95-680F-4656-8AF9-354EA23E0694@.microsoft.com...
> I had two databases on my server, and I just deleted the one which SQL
Server
> has identified as the default database. Now I can't connect to the server
> via SQL Enterprise Manager. How can I rectify this situation? The server
> itself is not having a problem, I'm just not able to connect remotely.|||Great, thanks! I see now it was a user ID thing.
"Scott Morris" wrote:

> Actually, EM is the source of the problem. Login via another program (e.g
.,
> query analyzer) and reset the default db to one that exists (using
> sp_defaultdb).
> "KitCaz" <KitCaz@.discussions.microsoft.com> wrote in message
> news:8F218C95-680F-4656-8AF9-354EA23E0694@.microsoft.com...
> Server
>
>