CODEWITHSUNDEEP
sqldatabasedatabase-connectionsql-server-expressoracle-sqldeveloper
ReinForce
ReinForce

Reputation: 101

How to connect sql developer to a database on localhost? instance=sqlexpress, db name = Equipment

Oracle SQL Developer Version 2.1.1.64

Database created in MS SQL Server management studio 2008. computer name: server instance: sqlexpress DB name: equipment No security, or windows security I guess.

what do I enter in the following sql developer fields: hostname, port, SID/service name.

Upvotes: 0

Views: 13011

Answers (1)

simonecampora
simonecampora

Reputation: 397

I think you have to use the SQL Server own JDBC Drivers in order to connect to it. SID Is a Oracle only concept.

Take a look here: http://djiang.wordpress.com/2007/02/27/using-oracle-sqldeveloper-to-access-sqlserver/

Upvotes: 0

Related Questions