MSDE Database not accessable by network users

We have SBS2003 Standard (phx1) as Domain Controller,
MS 2003 Standard (phx2) as additional server.

SQL is NOT installed on either server.

Veritas is installed on PHX1 (SBS).

When trying to access a MSDE database for the application
TimeMatters on either Phx1 or Phx2, the SQL error says
its "not available or online" etc. etc. However, the
database is on the network share and other files can be
moved to and from and users have "full control" for that
share.

Any idea why the database is not accessable?

Thanks

 

Not familiar with the application TimeMatters, maybe the problem is caused
by the fact that MSDE doesn't have any protocols loaded.

Try running Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe,
then select the BackupExec instance, move Named Pipes and TCP/IP to the
Enabled Protocols.

Ray Fong
Microsoft SBS Product Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

Last night we had an issue where the administrator could use the time
database but the regular users could not. We right clicked on the
shared folder and got to the share tab and everyone was listed as full
control. We went to the security tab and then advanced and added full
control to domain users. Application then worked. My clicks may be
slightly off but try going to the advanced security setting to change
regular user permissions.

Jim B. SBS MVP
remove the mvp to send email