Re: Separate Webserver and SQL Server -- error when connecting asp.net app to a database

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Ann Marinas" <ka_marinas@xxxxxxxxxx> wrote in message
news:O8EQVObPFHA.2604@xxxxxxxxxxxxxxxxxxxxxxx

> Please help! I would really appreciate it!!

1) Are you using the native .NET data provider, OleDb or (surely not!) ODBC?

2) What ConnectionString are you using?

3) When you installed SQL Server, what authentication mode did you choose
(SQL Server, Windows or mixed)?

4) On the SQL Server machine, launch SQL Query Analyzer (NOT ENTERPRISE
MANAGER!) and try to log in using the UserID and password from the
ConnectionString in 2) above - can you? If so, can you drop the database
dropdown and select the database from the ConnectionString in 2) above? If
so, run SELECT * FROM sysobjects - what do you see?


.

Relevant Pages

  • Re: ADP - Copy mdb table to SQL Server
    ... opening a table using ADO in code requires ... connect to sql server and to your database. ... I suspect that the ConnectionString Provider I am using is incorrect - ...
    (microsoft.public.access.formscoding)
  • Re: Membership Provider deployment/App_Data directory just wont die!!! :-)
    ... Of course you don't care about Using Access. ... database for other purposes. ... connectionstring, and have defined a new provider that uses this ... aspnetdb database that is registered on the SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Accessing SqlServer(Express) data on the server
    ... As for the ASP.NET, it is built upon the .net framework, so generally all ... you can change the connectionstring to point to another ... manually create another database (named "MyASPNETDB" in SQL Express ... you can even use SQL Server authentication(specify username/password ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Session variable. Secure ?
    ... well - as long as you have a secret (connectionstring with password) you can't escape having that secret in memory in plain text. ... Use integrated security for the database and no password is exposed at all. ... SQL Server, you could run the application pool under a special ... session/application variables get submitted "across the wire" og ...
    (microsoft.public.dotnet.security)
  • Re: Help on Connection Code
    ... What is the error message? ... If it is related to the permissions, ... > work on my XP workstation connecting to our Live SQL server. ... > Dim ConnectionString As String ...
    (microsoft.public.vb.database.ado)