Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-20 : 09:14:07
|
| Oliver writes "Hello there,I am trying to connect to the sql server 2005. However, in the stack trace of my Java app there is an exception (in German). Translated it states that a TCP/IP connection to the given host name could not be initiated.I have changed the server setting to TCP/IP enabled and am still getting the same message. I am aking myself at the moment wether I have remembered my password/username correctly! Is there an admin area where I can view users and passwords and if so how do I access/use it. At the moment I see this as being the only possible problem preventing the connection.I'd be very grateful for any help,Thanks in advance,Oliver" |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-20 : 10:10:02
|
| Are you able to connect to your server using any of the clients tools. and also check on Server under Surface Area Configuration make sure that you have enabled remote connections. since it not enabled my default. Hope this helpsSucess Comes to those who Believe in Beauty of their Dream.. |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2006-03-21 : 10:46:05
|
| What version of SQL 2005 are you running? When I installed Visual Studio 2005 and installed the Dev edition of SQL 2005 it defaulted to an instance. I think it was 'devexpress.' So, in order to actualy access sql server I needed to use: '{servername}\devexpress'Also, the dev version, be default (I think), has named pipes and TCP/IP disabled. Or else it doesn't allow connections from an outside computer. It's been a while since I configured it.Hope that helps,-Lamprey |
|
|
|
|
|
|
Can't connect to sql server 2005