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.

Can't locate RS 2005 in MSDN library

I'm having trouble locating the RS 2005 install in the MSDN subscription
catalog. Can anyone tell me on which CD/DVD the install in located. I have
the SQL Server DVD. I can't seem to locate it when I search the online
subscription list either.
Thanks.If I put the unfiltered by as unfiltered and then look for reporting
services I find it.
Have you installed SQL Server Books On Line for SQL Server 2005? If you
don't see it in MSDN Library you will find it in Books On line SQL Server
2005
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> I'm having trouble locating the RS 2005 install in the MSDN subscription
> catalog. Can anyone tell me on which CD/DVD the install in located. I
> have
> the SQL Server DVD. I can't seem to locate it when I search the online
> subscription list either.
> Thanks.|||Sorry for the confusion. I'm looking for the install DVD in my MSDN
subscription. I was of the understanding that reporting services 2005 would
be in my December shipment but can't locate it. I also can't find it when I
search the subscription index here:
http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
subscription download.
"Bruce L-C [MVP]" wrote:
> If I put the unfiltered by as unfiltered and then look for reporting
> services I find it.
> Have you installed SQL Server Books On Line for SQL Server 2005? If you
> don't see it in MSDN Library you will find it in Books On line SQL Server
> 2005
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "JW" <JW@.discussions.microsoft.com> wrote in message
> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
> > I'm having trouble locating the RS 2005 install in the MSDN subscription
> > catalog. Can anyone tell me on which CD/DVD the install in located. I
> > have
> > the SQL Server DVD. I can't seem to locate it when I search the online
> > subscription list either.
> >
> > Thanks.
>
>|||RS does not have a separate DVD/CD. It is part of the SQL Server 2005
install. The only reason it did initially was that it was release mid cycle
for SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JW" <JW@.discussions.microsoft.com> wrote in message
news:B68EAD4B-993D-47AB-9721-DABC2A0ACCD0@.microsoft.com...
> Sorry for the confusion. I'm looking for the install DVD in my MSDN
> subscription. I was of the understanding that reporting services 2005
> would
> be in my December shipment but can't locate it. I also can't find it when
> I
> search the subscription index here:
> http://msdn.microsoft.com/subscriptions/index/default.aspx or in my online
> subscription download.
> "Bruce L-C [MVP]" wrote:
>> If I put the unfiltered by as unfiltered and then look for reporting
>> services I find it.
>> Have you installed SQL Server Books On Line for SQL Server 2005? If you
>> don't see it in MSDN Library you will find it in Books On line SQL Server
>> 2005
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "JW" <JW@.discussions.microsoft.com> wrote in message
>> news:9DF6DFF8-246B-4E82-9442-18F0F4E59D40@.microsoft.com...
>> > I'm having trouble locating the RS 2005 install in the MSDN
>> > subscription
>> > catalog. Can anyone tell me on which CD/DVD the install in located. I
>> > have
>> > the SQL Server DVD. I can't seem to locate it when I search the online
>> > subscription list either.
>> >
>> > Thanks.
>>