Cant locate SQL Server Express from client pc

Hi,

I have a 5 user network running SBS 2000.

I have installed SQL Server Express on one of the client machines (not the SBS Server) I can connect locally without problem. However i cant connect from the other client machines.

I have enabled TCP/IP, Remote Connections Etc

I am attempting to test the connection using an .udl file. The server name is found but i still cant connect.

Any help would be apreciated.

Hi,

the error message would be helpful for us.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi

I am using the following information on the Data Link Properties Dialog:

Provider: Microsoft OLE DB Provider for SQL Server
Server Name: DIMENSION1100\SQLEXPRESS

Use Windows NT Integrated security

At "Select the database on the server" combo i recieve the following error:

[DBNETLIB] [ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Loging Failed Catalog information can not be found

Thanks

|||

Hi,

I have now managed to connect to SQLServer Express from the remote machine, but the only databases available are:

Master, msdb and tempdb.

Any ideas?

Thanks

|||SQL Server 2005 introduced the feature that only objects where you have permissions on are reflected in the Information_Schemas and in the other interfaces. So, I guess the user you are connecting to the database isn′t priviledged to access the databases.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

Thanks for the quick reply. I have started to look at permissions but there's alot to take in, where do i begin? Is there an easy way to allow 100% access then lock down at a later date? (Just to test connectivity)

Thanks for your help

|||Grant the database role dbo to the user.

But keep in mind to change the role after testing (!) :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Where is this done from?

Also are there any instruction available that outline security for sql express running in Windows Authentication mode?

Thanks again for all your help.

|||

Hi,

"Played around" < with 'user mapping' via ssms and gained access from remote pc's.

Thanks.