aspose file tools*
The moose likes JDBC and the fly likes configuring Microsoft SQL Server 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "configuring Microsoft SQL Server 2005" Watch "configuring Microsoft SQL Server 2005" New topic
Author

configuring Microsoft SQL Server 2005

Kunal Lakhani
Ranch Hand

Joined: Jun 05, 2010
Posts: 618
i have installed microsoft sql server 2005...and i am using NET BEANS 6.8. . after installation, a dialog box appears , which asks

Server type: Database engine
SERVER NAME: ???
Authentication: WINDOWS AUTHENTICATION (another option: SQL SERVER AUTHENTICATION with USER NAME & PASSWORD)

i have to use sql for jdbc... what should i provide in SERVER NAME?? and what about other options mentioned above.

kunal
Kunal Lakhani
Ranch Hand

Joined: Jun 05, 2010
Posts: 618
No reply!!!
Its urgent
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

After installation of what? What shows a dialog box SQL Server or Net Beans? It's worth having a read of this. You get a better response if you follow the suggestions there.

You don't have to use SQL Server authentication for JDBC, assuming you are using the latest MS JDBC driver or jTDS you can use NTLM. The server name is likely to be the name of your server. So the host name or IP address of the SQL Server instance.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Kunal Lakhani
Ranch Hand

Joined: Jun 05, 2010
Posts: 618
I think my way of asking Question was wrong. After installing MICROSOFT SQL SERVER ENTERPRISE EDITION
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

The SQL Server installation is asking for a server name? Are you sure - the term SQL Server uses for the server is usually an "instance". Unless you are installing a second instance of the server I can't think of what you would put in there (the name of the server is after all already defined). Your best bet is probably to read the install documentation (particularaly if its urgent).
Kunal Lakhani
Ranch Hand

Joined: Jun 05, 2010
Posts: 618
no no.. i have successfully installed them. but when i am opening SQL server management studio, its asking for SERVER name
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

The server name is the name of the server you installed SQL Server on.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: configuring Microsoft SQL Server 2005
 
Similar Threads
configuring Microsoft SQL Server 2005
Configuring Microsoft SQL Server 2005
count number of coulmns in table?
Where is Yukon
No access to SQL Express 2005/2008 database