Re: forms authentction against sql server 2000

Are you using the same Connectionstring from the Visual Studio.
Try using Query Analyzer using the same login and see.
And " Integrated Security=false;"
is this not suppose to be set to true?
Patrick

"Liming" <rootdev@xxxxxxxxxxxxx> wrote in message
news:%23aoGo0eXGHA.4120@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm using sql server 2000 on a remote machine and I have a login.aspx page
with a simple bare bone login control on the page for entering login
information.

I have a virtaul directory setup that points to the physical directory,
and when I access that login page from the virtual directory path say (
http://localhost/test/login.aspx) and entering username, passowrd, I get

"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: Named Pipes Provider, error: 40 - Could not open a connection
to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +73510"

What's the problem? When I launch the same page from within Visual studio
(which lauches its build-in web server), entering my login informaiton,
bang, i get through just fine.

I checked the follwing

1. Using ASP.NET configuration tool in VS 2005, I created some new user
2. Uisng Enteprrise manager of sql 2000, I see the new users being
created in the remote db.
3. I enabled Named Pipes and TCP/IP on the remote sql server 2000
4. I'm able to login from the build in webserver.


below is my connection string

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=NEMO;Initial
Catalog=TestDB;Integrated Security=false; User ID=test password=test;"
providerName="System.Data.SqlClient" />
</connectionStrings>

What gives? Is there anything in the IIS 5.1 that I need to configure?

thanks.




.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Login Seems OK but doesnt behave correctly
    ... Using MS SQL server on a shared host (www.joglab.com shows the ... login but not behaving on the pages ie LoginView/ Login Status not ... Web Site Administration Tool I get "Could not establish a connection ... <LoggedInTemplate> ...
    (comp.databases.ms-sqlserver)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... Rick Byham (MSFT), SQL Server Books Online ... against the slow SQL 2005 remote server succesfully (through the SSMSE ... will tell you what process ID is your current connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Login failure...
    ... loop) -- I'm suspecting the connection overhead with rapid ... connection/disconnect timing problem (i.e. my remote SQL Server can't keep ... > Private Sub MyMethod ... and I get Login failure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: 1st login always fails, 2nd always ok
    ... no errors in any event logs for either the server or the PCs trying to ... connectivity no longer works properly - it breaks the RDP connection ... momentarily when I try to copy files between local & remote drives. ... delay between hitting Ctrl-Alt-Del and the login window appearing? ...
    (microsoft.public.windows.terminal_services)