Cant find Server

[ozzroo]

Hi

I have created an SQL Server using Microsoft SQL Server 2005 express edition.

I can see the server and create databases on it, but I cant make a data source to the server as it doesnt appear in the sql server list.

Any ideas what I am doing wrong

Thanks

 

[deepsheep]

The first things to check:
-is the sql express set up to accept a remote conneciton (if you are connecting from a machine other than the same one as the server)?
-do you have the right drivers installed on the machine that you are accessing from? (it's call SQL Native Client or SQLCNI - the SQL server driver won't work right)
If those seem ok:
-have you tried creating a DSN to check for basic connectivity?
-have you tried a different machine (or the same one as the sql server)?

if this doesn't help, please send more information. Where are you connecting from and to, what connecting with and anything else would help.

I've found that 90% of my problems will be found in one of the steps above, so I hope it helps you.

 

[mrdenny]

First you will need to enable the machine to accept remote connections (in the Surface Area Configuration Tool).

Then you will need to make sure that the SQL Browser service is listening.

You can use the SQL Server driver or the SQLCNI.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com