Cant locate SQL Server Express from client pc

Hot Topic

image causing extra page in PDF export
Connect to remote RS in SSMS
How to SubTotal with top N grouping?
Return random rows
ALTER TABLE MODIFY
Package Templates?
Sage and SQL 2005/2000
Blocking Transaction
Remote Connection problem on MS SQL 2000
Problem generating error file using BULK INSERT or BCP thru xp_cmdshell.

SQL Server

SQL2K5 SP1-CTP fails while upgrading "Database Services"
Creation of offline Cubes in SSAS 2005
TRACE FREEZES CURRENT CONTEXT
Error when using VariableDispenser in a custom task.
Ignore Null in a Column that otherwise needs a Unique Value
Connecting to SQL Server with a login form.
Using Custom Code
Export a report as JPEG format
FOREIGN KEY problem on Creating new table
Passing a report parameter to Reporting Services from VB

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.

Answer this question

Cant locate SQL Server Express from client pc

  • Chris_Guzak

    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

  • sivakishore

    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
    ---

  • Shaile

    Hi,

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

    Thanks.

  • shaufe

    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

  • Rodrigo Diaz

    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
    ---

  • raj mishra

    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

  • esteves_plk

    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.

  • Joel Leavitt

    Hi,

    the error message would be helpful for us.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Cant locate SQL Server Express from client pc
Answer this question