Re: Connecting to SQL server from ASP.NET app
- From: "Paul Shapiro" <paul@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 13:33:08 -0400
The error message "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" is suggesting that the default installation of SQL
Server 2005 does not enable TCP/IP access. In the Start menu go to All
Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server
Configuration Manager. There you can enable TCP/IP connectivity. Or you
could change the connection string to use Local Named Pipes instead of TCP.
Try changing "(local)" to "." (that's a single period).
Paul Shapiro
"RJT" <RJT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE243E8D-D7CD-4A82-A8B1-1D7BAB62E70A@xxxxxxxxxxxxxxxx
I am using SBS 2003 Premium edition. I created an ASP.NET application on a
development box using the SQLExpress express engine and everything there
worked great. When I migrated it to the SBS 2003, I cannot get it to find
the instance of SQL server and I constantly receive:
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)
I've done much research over the past 2 days and not a single posting has
been helpful. I've disabled the Windows firewall (have an external
firewall
device), SQL logs do not show an attempted login (so it's not a user
rejection issue), the connection string is simple:
Server=(local);Initial Catalog=TASCMgr;Integrated Security=True;
The IIS application user id IUSR_<server> has been added to the SQL Server
security lists...
.
- Prev by Date: Re: Outlook Express with SBS2K3 Premium
- Next by Date: Re: SBS2000 SBS2003 conversion/migration question - same machine name
- Previous by thread: Re: Hardware for Next Version of SBS
- Next by thread: Re: Backup Issues w/SBS2003
- Index(es):
Relevant Pages
|
