I have done some research and I just want to verify what I believe are the
security options for SQL server 2005 native XML web services (using ENDPOINT
and WebMethod).
1. Application roles cannot be used (I assume this because the connection is

My client has once again got the "cannot generate SSPI context" error and
this time i managed to notice that the time on the client is abt 20 mins
earlier than that of the server.
How can i synch the time bet the client & the server ? and prevent it from

(DC=AdvServer200; SQL 2000; wkstation XP pro (logged into domain with Admin
rights) -- all with latest SPs applied).
We just got hacked via ftp and have strengthened our Administrator pwd.  Now
I cannot use EM or connect to a db with existing programs (I can connect

  Happy Holidays to all. I developed a windows application that connects to
Sql server 2000, using windows authentication and it works, able to retrive
and other data process. But when I used it on Sql Server 2005 Express, it was
unable to retrive data. What is wrong with it? ...

A netstat on my MSSQL server shows
 TCP    MSSQL12:ms-sql-s      c2-asp1.mydomain.com:2060  ESTABLISHED
 TCP    MSSQL12:ms-sql-s      c2-asp1.mydomain.com:2114  ESTABLISHED
 TCP    MSSQL12:ms-sql-s      c2-asp1.mydomain.com.com:2195  ESTABLISHED

On occasion, I will open Service Manager and I will see a Server Name that I
do not recognize. I don't understand how it got there. The latest server name
was USATLBMUTZ1. I am a beginner using SS2000. Is it possible for someone to
hack their way into my local version from the ...

Need some help on this, and I could not find an answer after going
through newsgroup/google.
I have 2 servers, both on win2k3sp1, and sql2k sp4.
I am having problem doing RPC of store procedures from either server to

I am facing a connection error occasionally. Im using MSDE2000a and
Dbamgr2k. The connection seems to have the following error
occasionally. Can anyone of u help me to troubleshoot this problem?
thank you.

 Use SQL Servere 2005 Express. I try to add new database diagram but I get
"This database doesn't have valid owner,...,Use ALTER AUTHENTICATION to
setup dbo to valid database owner...". I  login as dbo, please help how to
resolve this .

I have been asked to provide the following info. for all our sql server
databases (of which there are many)
For the servers running Windows/Mixed security:
-Which NT groups are granted permissions to which databases

Can I log on to SQL Server 2000 being loged on to a computer (local
user account) which is added to a domain? Here is the issue:
I am logged on to my Win XP using local account which is a member of
local Administrators group (I am NOT logged on to a domain) but the

After having been in contact with Microsoft Support in various countries,
both by mail and phone, what I was told to do is to post here.
Given that a few prerequisites are in place, I'm able to grant myself
access to data that I'm explicitly denied access to. No big surprise, this ...

Hello.  I have a problem with assigning permissions in SQLExpress.  First a
little background.  A couple of weeks ago we upgraded from MSDE to
SQLExpress.  The database came over fine, tables, stored procedures, roles
and since everything ran ok I am sure that it preserved all ...

Is it normal for an opti job to blow the T-log on a 80GB db to 50 GB from
2GB?

I wanted a query regarding archiving the data from the log files. Really wha
t I wanted here is as follows:
When we change the data through the application, we can have the log to see
who has changed what data. But when the data is modified through the SQL