Client not accessing SQL Server

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Client not accessing SQL Server

Author

Topic

jeer
Starting Member

32 Posts

Posted - 2008-02-20 : 02:03:29

hi

i have installed sql server 2005 on one machine and client on another machine. client is not detecting sql server on server machine. what type of settings should i do so that client can access server.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-02-20 : 02:27:52

Allow remote connections in Surface Area Configuration.

jeer
Starting Member

32 Posts

Posted - 2008-02-20 : 05:45:06

i am beginner to sql server. plz guide me for surface area configuration

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-02-20 : 07:14:16

On the Server, Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools

Once open click Surface Area Configuration for Services and Connections

jeer
Starting Member

32 Posts

Posted - 2008-02-20 : 23:17:23

what should i do, if i use sql server 2000 (this is forum for sql server 2005, i am sorry for putting my question here)

thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-02-21 : 03:45:46

You shouldn't have these issues with 2000. Your first post said 2005?!?

Which is it?

jeer
Starting Member

32 Posts

Posted - 2008-02-21 : 04:21:49

I have to do it with both sql server 2000 and sql server 2005.