| Author |
Topic |
|
georgesmith
Starting Member
6 Posts |
 Posted - 2008-04-04 : 11:54:28
|
| Hello friends,I have got a windows 2003 server with SQL 2005.I have tried to connect to SQL DB from my local computer suing SQL query analyser.But I am unable to connect to it.Can anyone help me in this.Thanking you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 11:59:06
|
| Do you have permissions in SQL server? |
 |
|
|
georgesmith
Starting Member
6 Posts |
Posted - 2008-04-04 : 12:01:21
|
| Yes. Its a dedicated server we are using. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-04-04 : 12:11:16
|
| What's the error you're getting?By default SQL 2005 only allows local connections. (I think this is the case for express). Check the surface area config of the express server, see if remote connections are enabled.--Gail Shaw |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 12:14:04
|
| Yes, only for Express edition only. |
|
|
|
georgesmith
Starting Member
6 Posts |
Posted - 2008-04-04 : 12:24:16
|
| server: Msg 14, Level 16, State 1[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 12:25:21
|
| Are you developer or DBA? |
|
|
|
georgesmith
Starting Member
6 Posts |
Posted - 2008-04-04 : 12:27:22
|
| I am a developer. Previously, I have the same SQL 2005 express, but never had problems with it. I can still connect to the old SQL 2005 server. But I am unable to connect to the new one. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 12:28:50
|
| Ask your DBA if they can give permission to DB you are trying to connect? |
|
|
|
georgesmith
Starting Member
6 Posts |
Posted - 2008-04-04 : 12:33:23
|
| I am trying to connect to the SQL 2005 server using SQL query analyser. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 12:34:55
|
| Doesn't matter!! you have to have permission for DB.Are you getting what i am saying? |
|
|
|
georgesmith
Starting Member
6 Posts |
Posted - 2008-04-04 : 12:36:26
|
| No. Can you please explain. this SQL 2005 DB is on a dedicated server which I leased. The customer support for it is not helping me.Please help me on how to get the DB permissions. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 23:42:25
|
| >> I have tried to connect to SQL DB from my local computer Can you ping that sql server from your machine? Can you telnet it with sql port? There is no way to connect to it if those two steps fail. |
|
|
|
|
cannot connect SQL express from SQL 2000