Viewing 12 posts - 1 through 13 (of 13 total)
Also, If I use OPENQUERY to execute the stored procedure, it works too.
Use database2
Go
CREATE Procedure usp_Document2
as
Begin
SET nocount ON
Truncate Table dbo.document2
Insert...
May 18, 2017 at 12:39 pm
It works,
Thank you Sue.
May 18, 2017 at 12:35 pm
A default database has been set for the login.
A user in the default database is mapped for this login with db_owner rights
February 1, 2013 at 12:25 pm
The server is set for SQL Server and Windows Authentication Mode
January 30, 2013 at 2:58 pm
I could not find any error that is related to what I am doing.
January 29, 2013 at 1:58 pm
The Windows Firewall is turn OFF
January 29, 2013 at 1:25 pm
Both TCP/IP and Names Pipes have been enabled in the SQL Server
January 29, 2013 at 1:09 pm
When both machines belong to the same network (replacing the x.x.x.x with the internal IP address of the SQL server), I have no problem connecting to the SQL server through...
January 29, 2013 at 12:40 pm
Yes I have tried,
Basically, Stunnel allows you to encrypt the TCP connection between the client and the SQL server using SSL. On both side, you install stunnel and configure...
January 29, 2013 at 12:26 pm
Thank you for your reply
The login has the proper permission.
I forgot to mention that I was able to connect to the remote SQL server from within our network.
From...
January 29, 2013 at 11:13 am
Viewing 12 posts - 1 through 13 (of 13 total)