I'm able to connect to a sql server db on another server from my local
computer, so if I do:
(this is sql 2000)
Enterprise manager --> Sql Server Group -- > New Sql Registration --> select
my db server I want to connect to --> connect using windows account --> add
to sql server group --> finish. I get the following error message:
SQL Server does not exsit or access denied. ConnectionOpen(Connect())
but if I go to the server directly, log in open up sql enterprise manager
connect using windows auth I can open and view every database on the server.
so what would prevent me from opening the database server from my local
computer using enterprse manager?
RE: SBS 2003 Unable to connect to database STS_Config ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ...Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT)... If AV software install any extra IIS virtual directory, ... (microsoft.public.windows.server.sbs)
RE: migrating from wmsde to sql server ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration....Microsoft CSS Online Newsgroup Support... This newsgroup only focuses on SBS technical issues. ... (microsoft.public.windows.server.sbs)
RE: SBS 2003 Unable to connect to database STS_Config ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ...Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT)... If AV software install any extra IIS virtual directory, ... (microsoft.public.windows.server.sbs)
Re: Best replication architecture? ... Looking for a SQL Server replication book?... So if it is subscribing to Publisher 1, ... (microsoft.public.sqlserver.replication)
RE: Insufficient memory Available ...Insufficient memory available. ... within the scope of SQL Server...."MemToLeave" area. ... (microsoft.public.sqlserver.server)
