I have a Windows 2003 server which has an instance of Sql Server 2005
(express I assume, showing as version 9) running on it that was installed by
Backup Exec.
On this server is another application that installated an MSDE database
(showing as version 8).
I can see both databases OK on the server using Management Studio Express,
and I can see the Server 2005 database from other PCs. However I cannot see
the MSDE database from anywhere else.
I've checked the configuration and using the surface configuration tool (but
this doesn't show the MSDE database) I've checked the configuration
svrnetcn.exe tool and the port is correctly set to 1433. The database is set
to allow remote connections over named pipes and tcpip.
So I'm stumped - nothing can connect to this database unless its on the
server itself. I have noticed that runing netstat shows that port 1433 isn't
open?
.
RE: sps Recovery ERROR:database schema is too old to perform ... Basically I was trying to use both the content and the configuration... database files of WSS on a virtual server "MyWSS" that used to ... "MyServer2" with the same virtual server name... ...database server needed to be changed as well. ... (microsoft.public.sharepoint.portalserver)
Re: major security concern - any sql user with minimal permission can see code for all stored procs ... this you may well enter the realm of an unsupported configuration and that's ... > things - and hence has enterprise manager - then this approach won't work. ... > If you just want to lock down a database, then I'd try my approace - lock ... >>> who needed to execute an SP on my server at his location. ... (microsoft.public.sqlserver.security)
Create SharePoint Portal failed. ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ... (microsoft.public.sharepoint.portalserver)
Re: Issues with Share Point Services after removing and restoring companyweb ... 1.Please check the server configuration at ... click set configuration database server,in the database server textbox,it ... message when you access your Windows SharePoint Services Web site... (microsoft.public.windows.server.sbs)
Re: ADO Connection Timeout ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ... (microsoft.public.data.ado)
