Re: SQLServer Connection Problems...

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: RWW problem with SBS2003
    ... This SBS server is new since the ex left, ... >> the default RDP port from 3389. ... >>> of the RDP connection can stay at their defaults, ...
    (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: Remote Web Workplace Partially Works
    ... Les Connor [SBS Community Member - SBS MVP] ... > a) I opened port 4125 on the SBS server following the guidance of KB ... > c) Remote connection should be enabled on the wotkstations as I did use ...
    (microsoft.public.windows.server.sbs)
  • Re: Urgent! New router and big disaster
    ... seleting full time broadband connection. ... Les Connor [SBS Community Member - SBS MVP] ... check the router as well and unless I missed a firewall setting on it, ... Anyway the Server Ipconfig /all is this... ...
    (microsoft.public.windows.server.sbs)
  • Re: Urgent! New router and big disaster
    ... Anyway the Server Ipconfig /all is this... ... Server Local Area Connection: ... Les Connor [SBS Community Member - SBS MVP] ... First Page of the Internet Connection Wizard, ...
    (microsoft.public.windows.server.sbs)