Remote connection to the SQL 2005

Question

Remote connection to the SQL 2005

tpandza

SSC Rookie

Points: 32
More actions
April 25, 2008 at 7:10 am

#189626

Is urgent and I would like to ask anyone who might know anything about to get back to me. I have a Windows 2003 server, SQL server\instance 2005 on Raid 5 installed and If I'm connecting to the data base locally from the server or through Terminal Services it is working just fine. If another users (SQL developers) trying to connect to the same data base on this sql server it just doesn't go and they are getting message saying that SQL 2005 by default doesn't allow remote connection..I have checked and remote connection on server itself is checked on and is allowed.
Any help is more than appreciated.
Thanks in advance
Toni

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

Toni,

When you enable 'allow remote' connections you will need to stop and restart the SQL service for the changes to take affect. maybe a place to start.

Hope this helps

Gethyn

Gethyn Elliswww.gethynellis.com

tpandza SSC Rookie Points: 32 More actions · Answer 2

Elis thanks for a fast respond. I do appreciate it.

Tell me please wich serivices you are talkin about? Services on - right mouse click - mycomputer- services or Services on SQL itself meaning, SQL server configurations manager services????

Please

Thanks

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 3

Better Restart the server from services-->SQL Server.Also check whether you have enable TCP/IP and Named pipes.

tpandza SSC Rookie Points: 32 More actions · Answer 4

Ellis!

there are 7 services all thogether, you think I need to restart all of them

Server integration

Server Browser

Server Agent instance

SQL server instance

Server full text instance

Server analysis service instance

Server reporting service instance

TCP and Pipes have been enabled for sure??

Thanks!

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 5

You need to restart:

SQL server instance service that relates to the instacne in question

You do not need to restart the other services

Gethyn Elliswww.gethynellis.com

tpandza SSC Rookie Points: 32 More actions · Answer 6

Thanks Ellias!

I did and unfortunatelly nothing helps.

I'm conecting to SQL instance on this server fine but if another college is trying it just doesn't go. This is 64 bit windows 2003 Raid5 with 64 bit SQL 2005 on it.

Any clou??????

THanks, Toni

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 7

Does he have a login for the server in question? is it SQL Server or Windows...If its SQL Server login is the server security setting set to mixed mode?

Gethyn Elliswww.gethynellis.com

tpandza SSC Rookie Points: 32 More actions · Answer 8

What's mean "security setting set to mixed mode" please!!!!???????

College is using the tool to connect to SQL database. Tool name is "Server Management studio express"

Thanks

Toni

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 9

Attached is a screen shot. You can see the setting in the properties of SQL Server instance. You can get to this dialog by right clicking SQL Server instance in Management studio and click Properties.

tpandza SSC Rookie Points: 32 More actions · Answer 10

Hi Ellis!

Sorry I didn't know you tough on that. Yes, this has been set up like you said, meaning SQL and windows authentication. Sorry about that. Anyhow thanks for attachment.

I think that everything posibile has been set up properly and there are others SQL servers that are available for remote login but this "bastard" just doesn't wana go????

Any clou???

Thanks, Toni