Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

configuring Microsoft SQL Server 2005

 
Kunal Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No reply!!!
Its urgent
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Kunal Lakhani
Ranch Hand
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think my way of asking Question was wrong. After installing MICROSOFT SQL SERVER ENTERPRISE EDITION
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 622
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
no no.. i have successfully installed them. but when i am opening SQL server management studio, its asking for SERVER name
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The server name is the name of the server you installed SQL Server on.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic