Re: SQLServer Connection Problems...

I suggest adding some error capturing to the error handling block in your
web page. (Write it to a trace file or a log file.)

What error are you receiving?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Jon" <jon_olson@xxxxxxx> wrote in message
news:uwG318AvGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
SQL port 1433 requests are limited to internal ip address of web server...


"Jon" <jon_olson@xxxxxxx> wrote in message
news:%23we1bzAvGHA.4512@xxxxxxxxxxxxxxxxxxxxxxx
We are not running ISA.
Port 1433 is open....

... checking on the rule to limit connection to web server ip address...


"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:ur2QCpAvGHA.2436@xxxxxxxxxxxxxxxxxxxxxxx
Is your SBS box running ISA?
Do you have port 1433 open? (Which is a big mistake unless you have a
rule to limit the connection to the web server ip address.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Jon" <jon_olson@xxxxxxx> wrote in message
news:OPGNMlAvGHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
I have read all I can find and am just frustrated...

Our system uses SBS on a company network and Server 2003 for our web
server that is not in the company domain. I am developing a web based
system with VS2005 Pro.

I can connect to SQLServer Express on my computer running on localhost.
I can not connect to the database on SBS SQL2000 after I publish the
site to the web server.

I have created 2 different sets of matching User Accounts on both the
web server and the SQL server with no luck.

The SQL Server is listening on port 1433, TCP and named pipes are
enabled. MultiUser mode is on. Mixed mode authentication is on.

I have given up on Integrated Authentication and tried SQL
Authentication.

Establishing a database connection within VS2005 is no problem.
here is the connection string, just for the heck of it...

connectionString="Data Source=sbscomputer; net=dbmssocn;
Database=Northwind; Integrated Security=False; User ID=ASPNET_Person;
Password=12345 "

From the webserver I am getting "Login failed for user 'ASPNET_Person'"
(my common identity on both web and SBS servers)


Got no idea why... I am stuck...









.

Relevant Pages

  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)
  • Re: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... Most good judgment comes from experience. ... But I have another 2000 server that I can connect to fine, ... it doesn't seem to want to open the port! ... "An error has occurred while establishing connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)