SQLServer Connection Problems...

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: SBS 2003 server sharing a folder to a non authenticated user or device (can it be done?)
    ... Plus exchange and SQL do consume quite a bit of non-paged pool and this has the effect of making the server cough occasionally, you only see this at high IO times. ... What you MUST be aware of the the whapping security hole the guest account will drive into your network. ... Someone must have done an impact analysis for enabling the guest account on a default SBS install.. ... authentication and will use Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: OWA Authentication Problem With SBS 2003
    ... > Thank you for posting in the SBS newsgroup. ... > the OWA from SBS 2003 Server itself, one of internal clients or Internet? ... Please re-run the CEICW (Configure Email and Internet Connection ... > configure the correct Authentication type for OWA. ...
    (microsoft.public.windows.server.sbs)
  • Re: OWA Authentication Problem With SBS 2003
    ... you are able to log in OWA after disabling the form based ... authentication, and you would like to let the OWA work when you re-enable ... obtain access to your Exchange Server 2003 mailbox. ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Cannot access companyweb
    ... to migrate from SBS 2003 to SBS2003, in this period, you can't achieve this ... 825763 How to configure Internet access in Windows Small Business Server ... By this method, you need to manually restore Exchange data, SharePoint ... Another way is to create a local profile, ...
    (microsoft.public.windows.server.sbs)
  • Re: R2 w/ISA User type account cannot use my companys internal website
    ... Alerts\Core Server Alerts ... Microsoft CSS Online Newsgroup Support ... And our product group is still reviewing the impact of the upgrade SBS ...
    (microsoft.public.windows.server.sbs)
Quantcast