Trying to get Native XML Web Services setup in our test enviroment, and I've
hit a problem.
When the HTTP EndPoint is set to use Integrated Authentication, I can browse
to the endpoint (using IE7 from a seperate PC) and get the WSDL back, but

I have created an Application Role with DEFAULT_SCHEMA=dbo.
From MS-Access, I retrieve the AR password and execute sp_setapprole as
follows:
 qd.Connect = strODBCConnect

I tried to connect to SQL Server 2005 using JDBC Driver 1.2 But I got the
error as follows
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
'Gurumurthy-PC\Gurumurthy'. The user is not associated with a trusted SQL

When inserting unicode data, we would like to programmatically override the
setting and send the data encoded in unicode(UTF-16), instead of defaulting
the whole app to unicode=true and take a performance hit.
Configuration:  MS SQL server 2005 SP2, and MS jdbc driver version: 1.1

I restored a database to a new server. On the new server I can access the
database. When I go to a workstation I receive the error "user name does not
exist" any help is greatly appreciated.

I set up a new SQL 2005 SP1 server.  Everything was fine for 2 weeks.  
Suddently I got error "cannot generate SSPI context" when connecting to it
from a client PC, as shown below.  When I use setspn to check the server I
see the line with port 1709.  I check netstat -an and found ...

I am having problems registering a SQL 7 database in
Enterprise manager.
The node that is causing problems is running W2KSP3 and
SQL7SP3. Each node (bar this one) on our network (VPN) is

I have to query Oracle database from SQL server 2000. But I do not
want to create linked server in SQL server 2000. I tried the
opendatasource as following.
SELECT * FROM OPENDATASOURCE( 'MSDAORA.1',

I've got two servers to be a subscriber and publisher resp. The server
machines are in a secured environ. and I usually use my own laptop with SQL
Server 2005 on XP SP2 to connect to these machines either through Man. Studio
over TCP/IP or sometimes I connect using mstsc (remote ...

With either MS SQL 2000 or MS SQL 2005, how can I set up a username/password that has
READ ONLY access?

i dont connect db (sql server 2005)  in vista. why?
i have a cod in asp and no conect database.
the error is:
"Microsoft SQL Native Client Version 09.00.3042

I'm having a spot of bother creating a linked MySQL server on SQL2K.
I'm using the following code on an SP4 SQL2K instance. MySQL 5.1 is
installed on the same box, and I've installed the MySQL ODBC 3.51 Driver.
sp_addlinkedserver

I'm trying to get a job to run on a particular database - how do I
select the database to go with the rest of the syntax I need ?
Thanks
Elaine

I have an instance of SQL Server that gets recycled every night (SQL 2000
sp4, windows 2000 sp4).  Every couple of weeks or so users can't connect in
the morning, and I see in the SQL log the error message 'SuperSocket Info:
Bind failed on TCP port 1433.'  When I restart the SQL ...

Dont shoot the messenger....
I inheited a system that uses an Access MDB as the front end with local
tables in it.  There is a SQL server 2005 database which pulls data from the
Access tables and inserts into SQL tables to create invoices.  Information is