Re: unable to connect to sql db

Yes, I've checked it several times and still unable to connect to it.

I'm lost on it now.


<ciccone1978@xxxxxxxxx> wrote in message
news:1188310112.505455.128030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 28, 2:47 pm, "Steve" <St...@xxxxxxxxxxxxxxxxxxxx> wrote:
I moved my database from one server to another SQL server. I did a backup
and restore of the database. I can connect to the database on server A
from my asp.net app but when I try to connect to my database server B,
I'm gettting 'login failed for user 'username'

I've added the username to the database on server B, I can open up SMS
and connect to the database that way, but I can't connect from my asp.net
web app.

any suggestions on what may be causing me not to be able to connect to my
sql server B database?

Hi,
have you checked the connection string in the 'web.config' file?
Try to check if all parameters in the connection string are correct
for the srv B database.

Bye



.

Relevant Pages

  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • RE: C++ Validating SQL user credentials
    ... All I want to do is take SQL credentials: server, database, username, ... CString connectionString = GetConnectionString(authenticationType, server, ...
    (microsoft.public.data.odbc)
Loading