Communicating With SQL
Sep 4, 2001
Hi, I am fairly new to MS SQL and have it running on SP1. When I try to run SP3, I get an error that the account (SA) cannot be authenticated. I went into the SQL Enterprise Manager-Security-Logins and changed the SA account password to what we have it documented as, but still cannot be authenticated.
The reason I am attempting to run SP3 is that our Arcserve Backup Agent running on the SQL server will not allow me to attach to it. We have a different server that we backup to and I had it working fine, but then updated our accounting package and now SQL will not allow me to authenticate to it. The accounting package is working fine, but backups are not. The accounting application support has no clue.
Is there a way to test that I have communication with the SQL?
Thanks.
View 1 Replies
May 15, 2008
Our ERP uses a Progress db but several of our web apps are developed in vb.Net and use a SQL backend. I need to pull some data in from Progress using TSQL queries.
Experimenting a little I find that a simple query, i.e. from 1 Progress table, takes anywhere from 20 seconds to a couple of minutes. However, when I joined on a 2nd table, I had to cancel the query after it ran for over 10 minutes.
SQL server is connected to Progress via a Linked server.
Any advice on improving the query will be appreciated.
I believe the query has to be in the T-SQL syntax; is that right? Where does the translation into Progress syntax occur?
Thank you,
LadyReader
View 7 Replies
View Related
Mar 22, 2006
In a proposed architecture, a production SQL Server will live in the DMZ, and an additional internal Production server will reside on the internal network. If Port 1433 is opened on the firewall and access to the DMZ SQL is restricted to only the internal SQL server, is this secure?
I've been told two stories:
1) That if port 1433 is opened, that a hacker can enter the DMZ and then browse ANY SQL Server on the internal network, not just the internal SQL server mentioned in the proposed architecture above.
2) If you define a rule on the firewall and you use a trusted connection, then ONLY those two SQL servers can communicate with each other and that it is secure.
Which is true? Are there other methods necessary to allow secure access between the LAN and the DMZ when two SQL servers need to talk with each other? Is allowing this kind of direct SQL communication considered to be bad practice?
Thanks, in advance, for the assistance.
View 4 Replies
View Related
Nov 21, 2006
Hello,
I am writting two applications that talk to each other. I create a service and then a dialog that points to Client2Service which means it is talking to it self. When I do that it works because I get pack the string "client1" which I am forcing it to send if it is calling ServiceProc in client1. I cahnge the Client2Service to Client1Service and it does not work any more. I do not understand why but am guessing it has something to do with the way I have the database setup. The installation script is bellow. Please share your thoughts because I am running out of ideas.
USE master;
GO
CREATE DATABASE ssb_FloorSystem;
GO
USE ssb_FloorSystem;
GO
CREATE MESSAGE TYPE Request VALIDATION = None;
CREATE MESSAGE TYPE Response VALIDATION = None;
GO
CREATE CONTRACT MessageTalk(
Request SENT BY INITIATOR,
Response SENT BY TARGET
);
GO
-- Install assemblies
BEGIN TRY
CREATE ASSEMBLY BrokerLibraryAssembly
FROM 'c:ServiceBrokerClient1Client1inDebugServiceBrokerInterface.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
BEGIN TRY
CREATE ASSEMBLY SqlClient1BrokerServiceAssembly
FROM 'c:ServiceBrokerClient1Client1inDebugSqlClient1BrokerService.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
BEGIN TRY
CREATE ASSEMBLY SqlClient2BrokerServiceAssembly
FROM 'c:ServiceBrokerClient2Client2inDebugSqlClient2BrokerService.dll'
END TRY
BEGIN CATCH
-- Catch and handle exception
END CATCH;
GO
CREATE PROCEDURE Client1ServiceProc
AS
EXTERNAL NAME SqlClient1BrokerServiceAssembly.[SqlBrokerServiceNS.SqlBrokerService].ServiceProc
GO
CREATE PROCEDURE Client2ServiceProc
AS
EXTERNAL NAME SqlClient2BrokerServiceAssembly.[SqlBrokerServiceNS.SqlBrokerService].ServiceProc
GO
CREATE QUEUE Client1ServiceQueue
WITH
STATUS = ON,
RETENTION = ON,
ACTIVATION (
STATUS = ON,
PROCEDURE_NAME = Client2ServiceProc,
MAX_QUEUE_READERS = 4,
EXECUTE AS SELf
)
ON [default];
GO
CREATE QUEUE Client2ServiceQueue
WITH
STATUS = ON,
RETENTION = ON,
ACTIVATION (
STATUS = ON,
PROCEDURE_NAME = Client1ServiceProc,
MAX_QUEUE_READERS = 4,
EXECUTE AS SELf
)
ON [default];
GO
CREATE QUEUE [dbo].[ClientQueue] WITH STATUS = ON;
GO
CREATE SERVICE Client1Service ON QUEUE Client1ServiceQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
CREATE SERVICE Client2Service ON QUEUE Client2ServiceQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
CREATE SERVICE HelloWorldClient ON QUEUE ClientQueue (
MessageTalk,
[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]
);
GO
EXEC sp_configure 'clr enabled', 1
GO
RECONFIGURE WITH OVERRIDE
GO
USE master;
GO
Thanks,
Scott Allison...
View 3 Replies
View Related
Jun 14, 2007
I have SQL Server 2005 express installed on my machine, and I was wondering if there is any way to have an asp.net 2.0 web service hosted by a different company be able to send sql commands to the sql server on my machine.
View 3 Replies
View Related
Jun 29, 2007
Hi there,
I have a flat file source in my data flow that is suppose to feed through a couple of columns to a script component. All of the columns have data but when I debug in my script component (with the aid of messageboxes) I can see that one of then is empty.
This is wrong because when I preview that data in the flat file source, I can see that the columns are all populated.
Has anyone ever encountered that a flat file source doesn't communicate with a script component properly? I mean it does pass through the data of all other columns except for one.
I have replaced the components in case it had become corrupt and I even rebuild the package but the problem still persists.
Any advice would be welcome
Regards
Mike
View 11 Replies
View Related
