SQLExpress

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

McHenry - 28 Mar 2006 12:55 GMT

Just installed SQLExpress and am trying to create an Access ADP that can be
access from another computer on the LAN.

The service is runnng...
I have enabled TCP/IP under "Protocols for MSSQLServer" in the config
manager...
I can create the db in Access however I cannot create any tables etc ?

Not sure if the following helps however this is the output from the basic
command specified in the ReadMe file...

C:\>sqlcmd -S dimension9150\SQLExpress
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified
[xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

C:\>

Reply to this Message

Roger Wolter[MSFT] - 28 Mar 2006 17:20 GMT

I you are running SQL Express as the Named Instance SQLEXPRESS (the default
setup) then you will need to enable and start the sqlbrowser service for the
client to find the SQLEXPRESS instance.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> Just installed SQLExpress and am trying to create an Access ADP that can
> be access from another computer on the LAN.
[quoted text clipped - 21 lines]
>
> C:\>

Reply to this Message

Dan Jones (MS) - 28 Mar 2006 17:20 GMT

Take a look at this blog for configuring remote connections:
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Signature

Cheers,
Dan
Lead Program Manager
SQL Server Manageability Platform Team
"This posting is provided "AS IS" with no warranties, and confers no rights"

> Just installed SQLExpress and am trying to create an Access ADP that can
> be access from another computer on the LAN.
[quoted text clipped - 21 lines]
>
> C:\>

Reply to this Message

McHenry - 28 Mar 2006 23:21 GMT

worked thanks:

C:\>sqlcmd -S dimension9150\SQLExpress,1433
1> exit

C:\>

> Take a look at this blog for configuring remote connections:
> https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
[quoted text clipped - 24 lines]
>>
>> C:\>

Reply to this Message