Job Fails to Linked Server
Thu, 18 Mar 2010 08:30:06 -0700
Server A: SQL 2008
Server B: SQL 2005
I am running a job on Server A that executes a stored procedure, but I get
this error:
Access to the remote server is denied because the current security context
is not trusted. [SQLSTATE 42000]
I can execute the stored procedure in management studio and it runs fi ...
|
connection error #17:
Tue, 2 Mar 2010 22:49:01 -0800
I am trying to install the ODBC SQL SErver system driver in the System ODBC
Manager in
the ODBC Services control Panel. I have Windows XP Professional. I should
have the latest updates and service packs. I have SQL Server Express 2005
service running. I also have the SQL SErver browser service running.
...
|
Strange problem connecting to SQL Server with windows authentifica
Tue, 2 Mar 2010 13:11:01 -0800
Hi there,
I'm struggling for hours with a very strange problem trying to connect from
Microsoft Dynamics Nav to SQL Server using Windows authentification.
The scenario: I have a Windows XP client at which a domain user is logged
in. (Login: TESTDOMAIN\TESTUSER)
This domain user tries to connect with the D ...
|
Sequel Server issue
Wed, 24 Feb 2010 03:09:08 GMT
We have installed a new sonic wall and router to an existing server ,we have
Lytec for a pm system, we now have big connectivity issues.
We can run it on one or two stations but it will shut down after a little
while, stating can't find sequel server can be found and it looks like it
want to create a new conne ...
|
Cannot initialize the data source...
Mon, 22 Feb 2010 12:08:14 -0800
Using SQL Express 2005, why do I get the error below from this query:
SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\MyDB.MDB'; 'admin'; '',
Table1) AS Table1_1
Error:
SQL Execution Error.
Executed SQL statement: SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\M ...
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote
Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 51358
Fri, 19 Feb 2010 19:24:06 -0800
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas ? 01M
Preço: ...
|
Can't connect to linked server
Fri, 19 Feb 2010 16:27:28 -0400
I have a default SQL 2005 instance (DTSERVER2) and a named SQL 2005 instance
(DTSERVER2\HOMAX01). I can connect to either instance remotely via
Management Studio using Windows Authentication.
I have created a linked server on DTSERVER2 with the following properties:
name: homax01
server type: SQL server
...
|
|
|
SQL express connection problem via VPN
Thu, 18 Feb 2010 00:23:27 -0800
Hi,
We've just run into a nearly same problem.
In our case, there is a server, and a clinet in the same LAN.
When there is no VPN connection in the clinet machine, all seems good, connections are fine.
When the client machine connect to a VPN, the sql express connections seems fails. At least we noticed the p ...
|
sql2005 connect dialog window - how to not remember username?
Wed, 17 Feb 2010 08:17:01 -0800
I logged into my sql server (2005) from a remote computer that has sql2005
tools --in sql server authentication mode. I left the remember password
checkbox unchecked. When I re-log in from this remote computer the password
box is blank but the username box still has my username. Is there a way to
clear o ...
|
Login failed for user''.
Wed, 17 Feb 2010 06:49:02 -0800
I am getting the error "login failed for user''" when trying to connect to my
SQL 2005 from a remote server using windows authentication. Using SQL
authentication works, but is not a suitable work-around.
The database is in mixed mode.
The user has DBO access to the database.
This worked last week, but ...
|