Error remotely connecting to SQL Server Express

I've been trying to configure remote connections to my sql server express to no avail.

First here are some constants to clear some things up:
- OS: Windows XP Pro
- SQL Express version: April CTP release
- Windows Firewall: disabled (to avoid any problems there)
- Network type: two computers connected a router.
- Router firewall: Enabled (I may be wrong but the router firewall only blocks external traffic, so I left it on.)

First, I configured my SQL server to allow remote connections in the SQL Surface Area Configuration. (Set it to both TCP/IP and named pipes)

Second, I enabled and configured sql server browser.

Third, I enabled TCP/IP and named pipes in the 'Protocols for SQL Express' option of the SQL Server Configuration Manager.

According to http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
I have done everything I need to (including edit the registry to enable the SQL Server Browser service) and the error I continue to get is:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"

So I tinkered and had no success in messing with anything that would fix it. Although, ***when I browsed for network servers on different machine, the server instance DID show up in the list***. So I find it odd that it can find the instance when browsing, but fails to 'find' it when making a connection.

So I didn't stop there, I decided to try the non-sql server browser method of remotely connecting: specifying the IP.

I went back to the blog of instructions referenced above and re-did the steps, this time specifying a TCP Port for the server instance and then after specifying the port on the remote computer connection string, and attempting to connect, I get this error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)"

I've done all I know how, read all the possible blogs I can, and nothing's come up. If anyone can shed some light on me, I'd pay you 1 billion pretend dollars. Any help would be appreciated. Thank you!

First of all, why are you using a CTP version of SQL Server Express ?

What is your connection string / with which application are you trying to connect ?

Is SQL Server Browser started on the server ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Error on Configure Web Synchronization Wizard

Got the following error on the last part of the wizard, after setting all the requirements:

Setting the snapshot share permissions (Error)

Messages

The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)

Any tips thanks

Did you run Web Synchronization Wization upon Windows XP?

Thanks.

|||No, the machine where the publisher is located is running on Windows Server 2003... Thanks for the reply|||

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

|||

Mahesh Dudgikar - MSFT wrote:

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

Thanks for the reply.

The machine publishing the articles is just part of a workgroup.

Error on configure Distributor

I got an error while trying to configure sql Server 2000 as distributor
Error description:
Error: 14114 '(null)' is configured is a Distributor
Maybe i need to check some services ? Which?
Any suggestion?
Thanks
Message posted via http://www.droptable.com
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Error message: Setup failed to configure the server

Re: SQL Server 2000 Developer Edition

Error message: Setup failed to configure the server

I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)

The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.

I downloaded it (via MSDN license) and accepted the defaults on the install.

Any feedback is appreciated.

Thanks,

RLN

Can you read through this post and see if it applies to your environment?

http://www.dbforums.com/showthread.php?t=374088

Thanks,
Sam Lester (MSFT)

|||

Samuel,

>>HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,<<

Your link mentioned an advisory to delete the following registry entry and re-install. This fixed it. Thank you for the tip and I apologize for not responding back sooner to your suggestion.

Thank you.

Error message: Setup failed to configure the server

Re: SQL Server 2000 Developer Edition

Error message: Setup failed to configure the server

I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)

The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.

I downloaded it (via MSDN license) and accepted the defaults on the install.

Any feedback is appreciated.

Thanks,

RLN

Can you read through this post and see if it applies to your environment?

http://www.dbforums.com/showthread.php?t=374088

Thanks,
Sam Lester (MSFT)

|||

Samuel,

>>HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,<<

Your link mentioned an advisory to delete the following registry entry and re-install. This fixed it. Thank you for the tip and I apologize for not responding back sooner to your suggestion.

Thank you.