SQL 2005, SSL - Certificate Request, Ports

Nov 14, 2006

I would like to use SSL on SQL Server 2005.

With SSL, is all traffic from the client to the database on port 443 ? Or are other ports needed ?

With Windows Certificate Management Snap-in, a request for a certificate assumes that there is a local Certificate Authority. I don't have one and it is my understanding that I should buy a third party certificate to avoid a man in the middle attack. With IIS there is a certificate request process. Is there something similar I should use with SQL ?

Thank you.

View 6 Replies


ADVERTISEMENT

SQL 2005, Multiple Instances - What About Ports?

Apr 18, 2006

When multiple instances of SQL 2005 are installed on a cluster or standalone server, is it best to have each instance configured to listen on a different port or will one port for all do? We don't use port 1433 and the port we do use is blocked at the firewall. I'd like to standardize on one port for all instances but I'm not sure of the ramifications. Any thoughts?

Thanks.

View 10 Replies View Related

Sql 2005 Instance; Dynamic Ports And Firewall Issue

Jan 27, 2008

We have an internal sql 2000 server that acts as the database backend for our
Internet presence. I believe that the sql server can be accessed because of a
firewall "exception" (?) that allows the external web server to talk to the
sql server using a specific IP address and port (namely that of the sql server.)


Now we need to install a sql 2005 instance on the same box which needs to act
as an Internet backend. The sql browser service will resolve all client
requests to the default or named instance. But I read that the sql browser service
assigns a "dynamic" port to the Instance! If that is the case, it's unlikely that,
unless the firewall has all ports open for outgoing traffic, that the sql instance will be
able to communicate with the web server.



My conclusion:

Leave the default instance (sql 2000) port at its current value;
assign the named instance an unused port;
Make sure the sql browser is running on the box!
Tell the firewall guys to make an exception for the new port.

Does this seems reasonable to you?


TIA,

barkingdog

View 4 Replies View Related

SQL 2005 SKUUpgrade Certificate Error

Jan 29, 2008



I am trying to upgrade from SQL 2005 Standard to Enterprise in our Production environment. I am testing this currently on a VM to document and script the steps necessary what we would need to do during a maintenance window when I can have this server offline.

I am getting the following error:
'SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]
The certificate cannot be dropped because one or more entities are either signed or encrypted using it.. To continue, correct the problem, and the run SQL Server Setup again.'

How can I find the entries, or remove them. We do not typically do this, and I explicitly didn't do this on the test server. I have tried this with 2 different VM builds and I'm getting the same error.

When going in to Control Panel, AddRemove Programs, SQL 2005 x64, Change, I can rerun the Suspended setup and it errors with the same Problem.

How can I get around this short of uninstalling and reinstalling the product? Is there another part of the SKUupgrade switch I need to append? I'm saving this as a batch file and running it from the command line.

Here is my command line entry:

Net use Z: /delete
Net use Z: "\<Fileserver>SoftwareMicrosoftSQL2005Enterprise Edition x64"
start /wait Z:serverssetup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

View 1 Replies View Related

Certificate Limitations In SQL Server 2005

Dec 7, 2005

I have a Web site that has a database backend, which stores user information.  I would like to encrypt the user information in a granular way.

View 16 Replies View Related

Cannot Install Sql Server 2005 As SSL-certificate Is Missing

Mar 30, 2007

Hi there U all,



for the third time I am installing SQL-Server 2005 express and i have an error.

Cannot install sql because .NET 2.0 framework is missing allthough I have the .NET 2.0 framework allready installed and even re-installed it too. When trying again I get the message that there isn't an SSL-certificate present.



My question is, would this probably cause the error when installing?



Anyone?



Grtz and thx,



Recloose(Thomas)

View 1 Replies View Related

CERTIFICATE PROBLEM WHILE ENABLING SSL ON SQL SERVER 2005

Jun 13, 2007

Hi ,

How do we install a certificate for enabling security on MS -SQL Server 2005?
I tried to install through MMC but it says no " certificate authority found " . Any
help will be highly appreciated , Thanks to you all in advance :-)

Best Regards,

Sudhansu Tiwari

View 3 Replies View Related

Certificate Loading Issue - When Creating Certificate From SQL Server To SQL Server Express On The Same Machine

Jun 29, 2007

Hi, We are trying to implement Service Broker between SQL Server Express and SQL Server on the Same machine and we are having problems with certificates. We are creating a certificate on SQL Server, backing up the certificate on a file system and then loading certificate on the SQL Server Express from the file and we are keep getting the following error: Msg 15208, Level 16, State 1, Line 1 The certificate, asymmetric key, or private key file does not exist or has invalid format.



Following script runs fine on SQL Server.




Code Snippet

use master



Create Master Key Encryption BY Password = '45Gme*3^&fwu';

BACKUP MASTER KEY TO FILE = 'C:ServiceBrokerPrivateKeyMasterB.pvk'

ENCRYPTION BY PASSWORD = '45Gme*3^&fwu'

Create Certificate EndPointCertificateC

WITH Subject = 'C.Server.Local',

START_DATE = '06/01/2006',

EXPIRY_DATE = '01/01/2008'

ACTIVE FOR BEGIN_DIALOG = ON;

BACKUP CERTIFICATE EndPointCertificateC

TO FILE = 'C:ServiceBrokerEndPointCertificateC.cer'



Following script runs on SQL Server Express:






Code Snippet

Create Certificate EndPointCertificateC

From FILE = 'C:ServiceBrokerEndPointCertificateC.cer'

WITH PRIVATE KEY (

FILE = 'C:ServiceBrokerPrivateKeyMasterB.pvk',

DECRYPTION BY PASSWORD = '45Gme*3^&fwu'

);





If we run the script other way around, it works fine. If we use the SQL Server on some other machine, the script works fine. But only on the same machine, it throws this error. We made sure the permissions and everything. Let us know if there is any work around or what are we doing wrong.



Any help is appreciated. Thank you,

View 4 Replies View Related

The Request Failed With HTTP Status 400: Bad Request. (Microsoft.SqlServer.Management.UI.RSClient)

Feb 23, 2008

I get this error message when I try to connect to Reporting Services via the Management Studio.

I can see my machine listed in the Server Name > Browse For More > Local Servers dialogue. But no luck,

Ive tried:

Servername: localhost
Servername: DED1774 (the machine name)
Servername: localhost/reportserver
Servername: DED1774/reportserver
Servername: http://ded1774/reportserver (from the rsreportserver.config file

<UrlRoot>http://ded1774/reportserver</UrlRoot>)



I've Googled the error message and found postings for solutions, but none of these helped. Can anyone suggest some simple steps I can take to try to find the issue and get the connection working?

Thanks

View 3 Replies View Related

Import OpenSSL Certificate With Private Key Into Sql Server 2005 Express Edtion

Jul 7, 2006

hey,

i have a problem, to import a self signed openssl certificate into the sql server 2005.

my final idea is to get encrypted columns from the database over an jdbc connection in a java client.

when i use a certificate generated by the sql server 2005, i can encryt columns of a table. then i catch the

the result in my java client. but in java, i need a keystore with the private key of the certificate.

ok. i have export the the certificate and the private key of the sql server 2005.

problem: in a keystore i can only import the certificate (signed public key) but not the private key.

my new idea is to import an openssl certificate or an certificate generated by the keytool (java) into the

sql server 2005 and encypt the data with the imported certificate. Problem: The SQL Server give me an

Exception: (Sorry i drag & drop the exception, is written in german)

Msg 15208, Level 16, State 1, Line 2

Die Datei für das Zertifikat, den asymmetrischen Schlüssel oder den privaten Schlüssel ist nicht vorhanden oder weist ein ungültiges Format auf.

My Import Statement is:



CREATE CERTIFICATE InsuranceCertOpenSSL

FROM

FILE = 'E:masterkeysinsuranceservice_tomcat_apr_x509_certificate_with_cygwin_openssl_20060630insuranceservice_tomcat_x509_certificate_with_openssl.crt'

WITH PRIVATE KEY (

FILE = 'E:masterkeysinsuranceservice_tomcat_apr_x509_certificate_with_cygwin_openssl_20060630insuranceservice_tomcat_x509_certificate_with_openssl_private.key',

DECRYPTION BY PASSWORD = 'testit2_',

ENCRYPTION BY PASSWORD = 'testit2_'

)

I use password encryption, and not the internal master key (or service master key)

Hope for help :)

nils



View 18 Replies View Related

Install SQL Server 2005 Express - The Certificate Chain Was Issued By An Authority That Is Not Trusted

Sep 6, 2006

Hi
I am trying to install SQL Server 2005 Express on my machine, which has Windows Server 2003 with Service Pack 1. I could not able to install properly and i am getting error always.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.

Please help
Thanks
Here is the Error message from Summary.txt

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Tue Sep 05 12:31:18 2006

--------------------------------------------------------------------------------
Machine : SERVIDORCC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_SERVIDORCC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 05 17:12:41 2006

View 1 Replies View Related

How To Make HTTP Request From SQL 2005

Oct 28, 2007

Hi All,


I want to make a simple http request from SQL to a web server, something like this:
HTTP_REQUEST('http://www.domain.com/page.asp?var=value')
I don't want to get any response back, just a request.
Is there something like this in SQL 2005? or if anyone had wrote something like this.. I'll be greatfull if you can help me.

Thanks in advance

View 1 Replies View Related

Send HTTP Request Using SQL Sever 2005

Apr 16, 2007

I have Lotus Notes Database which stores employee database. If I request following http URL on browser, which fetch data from Lotus Notes Database and response me following XML text. I need to pass some id as a parameter in HTTP request to retrieve particular data.

HTTP Request:
http://kernel.com/global/corp/ecd.nsf/xmlemployeesactivebyguid?readviewentries&StartKey=sesa249&count=1

HTTP Response:
<?xml version="1.0" encoding="UTF-8" ?>
<viewentries toplevelentries="53656">
<viewentry position="14310" unid="FC86BCB9224169F4C12570AD005A775C" noteid="D9FA2" siblings="53656">
<entrydata columnnumber="0" name="GUID">
<text>SESA24941</text>
</entrydata>
</viewentry>
</viewentries>

I need to send this http request programmatically. To do that,

1) Is thr any functionality in SQL Server 2005, which can send http request to any other server like LOTUS NOTES
2) If not,thn do you know how to do it programmatically using c# ?

When U have some time, let me know. Thanks in advance man.

Satyam

View 4 Replies View Related

Request For Confirmation Of SQL 2005 Optimiser Bug With Derived Table And Convert()

Jul 23, 2007

I have discovered what looks like a bug in the optimiser. I've posted it at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=288243 but I wonder if any of you with SQL 2005 RTM, 2005 SP1 or 2008 CTP could confirm when this was introduced and whether it is still an issue?






Code Snippet

-- Bug report

-- 2007/07/19

-- Alasdair Cunningham-Smith

-- alasdair at acs-solutions dot co dot uk

set nocount on

go

-- example date in in British date format

set dateformat dmy

go



use tempdb

go



create table foo( bar varchar( 30 ) not null )

go



insert into foo( bar ) values ( 'fishy' )

insert into foo( bar ) values ( '19/07/2007' )

go



-- this works fine in all versions - only valid dates are passed to the convert function

select

convert( smalldatetime, bar, 103 ) as bardate

from

foo

where

bar like '__/__/____'

go



-- this works on SQL 2000, but fails on SQL 2005 SP2 (I've not tried other SPs of SQL 2005):

-- Msg 295, Level 16, State 3, Line 2

-- Conversion failed when converting character string to smalldatetime data type.

--

-- I believe the query is rewritten as if the derived table query contained

-- "and convert( smalldatetime, bar, 103 ) < getdate()"

-- which would expose the convert to the invalid data

select

*

from

(

select

convert( smalldatetime, bar, 103 ) as bardate

from

foo

where

bar like '__/__/____'

) as derived

where

bardate < getdate()

go



-- Workaround:

-- Use a case statement to protect the convert operator from the invalid data

select

*

from

(

select

case when bar like '__/__/____' then

convert( smalldatetime, bar, 103 )

else

null

end as bardate

from

foo

where

bar like '__/__/____'

) as derived

where

bardate < getdate()

go



drop table foo

go



The workaround I discovered is simple but ugly. I invite your comments...



alasdair.

View 5 Replies View Related

Ports?

Aug 11, 2000

What ports does SQLMail use to access MS Exchange Server?? We have SQL 7 running on a seperate non-trusted domain(within the same DMZ) from where Exchange Server exists. The only trust we want between the 2 domains is the SQLMail functionality for the DBA's and Administrators to use. I am aware that MS Exchange uses 110 port for POP3 and port 25 for SMTP. Does this apply to SQLMail as well? Thanks in advance for your support.

View 1 Replies View Related

Ports

Jul 24, 2007

hi every on am searching for a file which contains information about
the instance in my sql server and the ports that this instances are running on ,am sure that there is a file like this but i cant find it please if u know it answer me ,,, and thanks alot for ur time//

MobashA

View 8 Replies View Related

PORTS USED

May 23, 2007

Hey all

I am using Transactional replication with updatebale subscriptions

What network ports are used for SQL server 2005 replication

This is for firewall config.

Thanx

View 3 Replies View Related

SQL Server Ports

Sep 11, 1998

Does anyone know what ports are required to be open (non-NT). We are placing the SQL-Server behind a UNIX firewall, and want to minimize the ports open.

View 1 Replies View Related

Ports And Protocols

Sep 9, 2004

Hi Folks ,

Got one for you .....

By default what ports and protocols do the following sql tools use....?

Enterprise Manager
SQL Query Analyser
SQL Profiler

And if anybody knows :

Performance Monitor
Mapping drives
Event Viewer
User/Server Manager

Any help would be greatly appreciated .....

View 1 Replies View Related

SQL Instances Ports

Jul 23, 2005

Hello,How to determine, which ports do MS SQL Server instances listen to?I want to conect to sql server using PHP and I need to know exact portnumber. I suspect that my SQL (msde) server instances don't listen ondefault 1433 :]--Stefan

View 1 Replies View Related

Regarding Ports For Db Mirroring

Aug 7, 2006

I'll have about 5 db's from an instance(server1instance1) mirrored to another server(server2/instance1). Do all of these db's have to have endpoints configured with different ports? I hope I'm clear on my question. Do I have to create a different endpoint for every db or can use the same endpoint? Thank you



Tej

View 1 Replies View Related

Required Ports

Mar 26, 2008

Hopefully someone can answer this as I am yet to find any definitive information.

User access reports by default on port 80.

Report Manager and Report Viewer are on machine A. Catalog database is on SQL Server machine B along with the database being reported on.

What ports are required to be open between machine A and machine B? Does it use standard SQL port 1433, are there any other ports used?

Thanks

View 1 Replies View Related

Dynamic Ports Value Changes

May 23, 2007

Hi,


Using SQL Configuration Manager, i have set my local instance to use TCP Dynamic Ports by setting the value under IPAll to be 0 (the value TCP Port is blank). However, when i start up the server this value gets set to a specific port. ie Before startup TCP Dynamic Ports = 0, After startup TCP Dynamic Ports = 2832. This value persists throughout SQL Server restarts.



Is this behaviour correct as I would have expected this value to stay 0?



I am using SQL Standard, SP2. SQL Browser is running.


Thanks in advance!

View 4 Replies View Related

Opening Ports On The Server

Dec 31, 2002

How would i open up ports on the server? Are they all open or do i have to specify which ones i want open? thanks

View 7 Replies View Related

Changeing Remote Ports

May 30, 2007

I have two instances of SQl 2005 running on a server. One I'm going to allow outside remote access to. But I don't want to do it on the default port. though I have it allowing remote and that seems to be working. I can seem to find where to change the default listening port.

and I scimmed the help and topics I saw. But didn't see one relevant to this question.

View 1 Replies View Related

Ports Used By ReportViewer Web Controls

Jan 15, 2007

When a ReportViewer control is used to access a report on a remote SQL Server database, on what ports does the communcation occur? Does the control communicate on on the SQL Server ports of 1433 and 1434 or does it communcate as a web service on port 80 (or 443 for HTPPS)?

View 1 Replies View Related

TCP/UDP Ports Used For Index Server OpenQuery

Nov 4, 2005

If I am doing an Index Server query from SQL, such as:SELECTQ.*FROMOPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcountFROM SCOPE('DEEP TRAVERSAL OF .....can anyone tell me which TCP/UDP ports will be used between the SQLServer and the Index server if the Index Server is on another machine?I'm doing the query from SQL so that I can join the results with atable in the database and am not interested in doing the Index queryfrom the app server. I haven't been able to find any info on the netfor which firewall ports are used for this.

View 5 Replies View Related

SQL Server Ports - Net-Library Encryption

Jul 20, 2005

I was reading that Net-Library Encryption is an SSL utility. Does thatmean the traffic uses TCP port 443 or does it still use TCP 1433?Thanks.http://msdn.microsoft.com/library/d..._ar_cs_6fu6.asp

View 1 Replies View Related

Tis Has More Than Likely Been Asked Before But, How Do I IIS Without Opening External Ports On My Pc?

Apr 26, 2007

Hi Everyone,



I am new to the forum and would like to have a question answered. I want to to install Sql Server Express with advanced services but also want to have IIS installed as well. My question is, how do I install IIS without it opening Port 45? When I installed it, it would not let me finish installation without letting it act as a server. Is there any work around to solve this problem that any of you have managed to use?

View 1 Replies View Related

Workaround To Connect To SQL Server When Ports Blocked?

Jan 11, 2006

My SQL Server is a shared account at MaximumASP.com a client just deployed my .NET application on GoDaddy.com and they have all there ports blocked and my app cannot connect to the SQL Server. Using "Network Library =dbmssocn" in the connection string did not help and GoDaddy will not help.  MY QUESTION IS: how can I get my .NET app to connect to the SQL Server? web service? This is the first time I have run into this problem. There seems like there has to be some way. THANKS IN ADVANCE!

View 2 Replies View Related

DB Engine :: SSMS Connects To Different Instance With Same Hostname - If Ports Are Same

Jun 9, 2015

We have a 2 servers  with 2 default instances, 

Environment- SQL server 2012 SP2 | Windows Server 2008 R2

1server:
hostname-serverA , Instance-serverA and port-2040 Ip-192.164.1.1

2server:
hostname-serverB , Instance-serverB and port-2040 Ip-192.164.1.2

If i do a SSMS connection-the possible connections strings which can be used to connect to Instance "serverB" should be,

a.serverBserverB
b.serverB,2040
c.192.164.1.2,2040

Note: but even the connection string "serverBserverA,2040" also connects to Instance "serverB", when i try to connect from SSMS, In SSMS it shows the wrong instance name like, "serverBserverB", but it actually connects to  Instance "serverA"

i.what is the reason behind this?
ii.Is there any way to avoid this connection, by performing server property changes, if any ?

View 5 Replies View Related

SQL Server Admin 2014 :: Ports Firewalls And A New Named Instance

Nov 12, 2014

I have an existing 2012 default SQL Express. It's set up on a VPS managed by a third party. I have an administrator account on this 2012 Windows server. I'm not much of a sysadmin or a DBA but I get around. ;)

I've installed a new NAMED instance on this VPS and can not connect to it with client tools (SSMS). If I remote in, I can connect this way.

What steps might a seasoned DBA expect to make when getting a new named instance ready for the world.

Assign a port? Check the port?

Open the firewall for the port?

Will this new named instance listen on a different port than the previously installed SQL Express instance?

View 6 Replies View Related

Reg : Certificate

Mar 4, 2008

Hello all,

can ayone tell me which exam i have to pass to get sql 2005 certificate andi n which site or link will get more information.

would be appreciated .
thanks folks.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved