The 'guest' user doesn't have any database permissions in master database. Like any other users, it is a memeber of public role so It has all permissions the public role...

The guest user allows a login without a user account in database to access that database. The login obtains the database permissions granted to this 'guest' account.

Have you removed 'guest' user from master database or changed 'guest' user's permissions?

You may try sp3a. It fixed some problems of sp3.

dbcc opentran

quote:

---

There is the database problems, I send to the vendor, they repaired and send it back to me

---

Install SQL Server client tools (including EM) in one workstation and try to open EM's property from there to see any problems.

sp3a or sp3?

You need to install SQL Server first as default instance and then MSDE 2000 as named instance.

quote:

---

Our SQL servers are set up to use NT authentication, and permissions and db ownerships are all based on the domain...

You can use sp_help_job to view status of your own jobs if you are not the member of sysadmin.

From BOL.

"To create a linked server to access an Oracle database instance

Ensure the Oracle client software on the server running SQL Server is at the level required by the...

Do you have Oracle client (SQLNET) installed in your SQL Server? Check your tnsname.ora file too.

Try use odbcping.exe to verify connectivity to SQL Server through ODBC SQL Server drivers.

http://support.microsoft.com:80/support/kb/articles/Q138/5/41.ASP&NoWebContent=1

http://support.microsoft.com/servicedesks/webcasts/en/wc020603/WC020603.ppt

Edited by - Allen_Cui on 07/16/2003 08:57:35 AM

You really don't have to make any changes to authentication mode. SQL Server will verify the connection from application and authenticate the login with 'NT Authentication' automatically if your application...