| Author |
configuring Microsoft SQL Server 2005
|
Kunal Lakhani
Ranch Hand
Joined: Jun 05, 2010
Posts: 609
|
|
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: 609
|
|
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: 609
|
|
|
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: 609
|
|
|
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.
|
 |
 |
|
|
subject: configuring Microsoft SQL Server 2005
|
|
|