When I try to connect to SQL Server with windows NT authentication using the
network login ID from my machine (Win XP) it gives me SQL Server error
18452 -  [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user '(dejan)'. Reason: Not associated with a trusted SQL

I created a linked server in SQL server in order to connect another SQL
Sever. I used the domain window account. I put my domain ID in Local login
and checked Impersonate in Security panel and I chose “Be made using the
login’s current security context.

I'm not the SQL admin, but I'm trying to help fix a problem.  Here's the
situation:
Microsoft SQL Server running Windows 2000 Server.  Workstation connecting
via ODBC using SQL Driver.

I work for DataDirect-Technologies. My customer is using our Connect for ODBC
5.00.0059 driver on Solaris 8 to connect to SQL Server 7 on Win 2000. When he
tries to connect using a simple C application he gets the error
"[DataDirect][ODBC SQL Server Driver][SQL Server]Cannot open ...

I am attempting to shrink a datafile (I have 2 primary data files) when I
receive this error message 'Error 8985 cannot locate file xxx in sysfiles'.
I have repeatedly verified the data file name and even did a 'cut n paste'
into a query in qa dbcc shrinkfile with the same results.  ...

What is the propery syntax to establish a connection with a named instance
of MSDE on a server from a client workstation using the SQL Query analyzer
(or EM for that matter)?
I have tried "myServer\myInstance"  to no positive effect.

I wrote a batch import process that uses connection pooling, i.e. the
connections are never closed until the process is finished. I am writing
large chunks of data (byte[]) into the database, and I made absolutely
sure that my application does not hold any references to the ...

Anybody know if it possible to connect to an as2000 database and run mdx
queries
using the microsoft jdbc drivers?
thanks,

I've read through many posts regarding this type of issue and all posts were
relevant but not exactly my problem.
I use Access 2003 and I have a simple linked table to a Sql2000 DB table, I
then have a form that I can use to view/amend data directly on the sql

i have one database with sql server
i want with asp vbsript to connect with database
my code is
<%

Hi, I have a problem...
Supposed that in a store procedure, I have two operation for example:
insert into mytable field1,field2 values ('bob','bobby')
select max(id) as id_last from mytable