SQLDeveloperMSSQL

From SifWiki
(Difference between revisions)
Jump to: navigation, search
(Created page with "File:SQLDeveloper.png Configuring a Microsoft SQL server for usage with Oracles SQLDeveloper.app isn't quite as simple as it could be, the login and authentication when u...")
 
 
Line 6: Line 6:
  
 
In the example here, the Port field has the value;
 
In the example here, the Port field has the value;
1433;instance=MSSQLSERVER01;domain=DOMAIN;appName=MadeUp;
+
1433;instance=MSSQLSERVER01;domain=DOMAIN;appName=MadeUp;
  
Where;
+
'''instance=MSSQLSERVER01''' is the instance name of the SQL server (this could be optional depending on your installation).
instance=MSSQLSERVER01 is the instance name of the SQL server (this could be optional depending on your installation).
+
 
domain=DOMAIN is the login domain of your windows user account. If I were logging into this server via RDP I'd be logging in as DOMAIN\siftah
+
'''domain=DOMAIN''' is the login domain of your windows user account. If I were logging into this server via RDP I'd be logging in as DOMAIN\siftah
 +
 
 +
'''appName=MadeUp''' doesn't seem to be used.

Latest revision as of 14:59, 22 October 2014

SQLDeveloper.png

Configuring a Microsoft SQL server for usage with Oracles SQLDeveloper.app isn't quite as simple as it could be, the login and authentication when using Windows Authentication doesn't seem to work. Specifically, it doesn't look like the "Windows Domain Name" parameter is picked up from the configuration.

Instead, amend the entries in the Port field instead and suffix them with the domain= parameter.

In the example here, the Port field has the value;

1433;instance=MSSQLSERVER01;domain=DOMAIN;appName=MadeUp;

instance=MSSQLSERVER01 is the instance name of the SQL server (this could be optional depending on your installation).

domain=DOMAIN is the login domain of your windows user account. If I were logging into this server via RDP I'd be logging in as DOMAIN\siftah

appName=MadeUp doesn't seem to be used.

Personal tools
Namespaces

Variants
Actions
Navigation
Tools
Google AdSense