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

Tech-Archive recommends: Speed Up your PC by fixing your registry

- Post the connection string, we might be able to help.
- "telnet sqlserver 1433" to see if you can reach the SQL server. 1433
is the default SQL server port.
- Check the firewall settings on the SQL Server.
- Check if the SQL Server user has a default database, and if the user
is valid in that database.

Greetings,
Wessel

-----Original Message-----
From: Ann Marinas [mailto:ka_marinas@xxxxxxxxxx]
Posted At: Sunday, April 10, 2005 12:55 PM
Posted To: microsoft.public.dotnet.framework.aspnet
Conversation: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database
Subject: Re: Separate Webserver and SQL Server -- error when connecting
asp.net app to a database

Hi, Wessel!

Thank you for your reply.

I've changed my connectionstring property after the database was
transfered to another server and it has got all the correct values, but
still no avail.

Thanks again for helping me out! Really do appreciate it!

Cheers,
Ann

Wessel Troost wrote:
> An ASP.NET application typically connects to the database through a
> System.Data.SqlClient.SqlConnection object.
> To change the SQL server, you need to find all SqlConnection objects
and
> update their ConnectionString property to point to the new database
> server.
>
> Greetings,
> Wessel
>
> -----Original Message-----
> From: Ann Marinas [mailto:ka_marinas@xxxxxxxxxx]
> Posted At: Sunday, April 10, 2005 12:11 PM
> Posted To: microsoft.public.dotnet.framework.aspnet
> Conversation: Separate Webserver and SQL Server -- error when
connecting
> asp.net app to a database
> Subject: Separate Webserver and SQL Server -- error when connecting
> asp.net app to a database
>
> Hi all,
>
> I would like to ask for some help regarding separating the asp.net
> webserver and the sql server.
>
> I have created an asp.net application for a certain company.
Initially,
> we installed both the iis and sql server in a single machine. Not too
> long ago, the machine had some hardware problems, and management has
> decided to purchase new servers, for both asp.net and sql server.
>
> Once we installed my webapp on the first server and the sql server on
> another, we have encountered some errors with it. Basically, the
> exception that keeps on saying was:
>
> "SQL Server database does not exist or access denied."
>
> Tried creating a windows account for the webapp to use to connect and
> configure it to the sql server, but it does not work.
>
> Tried also connecting with the database using a SQL Server account,
but
> to no avail.
>
> Please help! I would really appreciate it!!
>
>
> Regards,
> Ann Marinas
>

.

Relevant Pages

  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)
  • Re: SQL Licensing
    ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
    (microsoft.public.sqlserver.clients)
  • Re: Help! Cant connect via ODBC DSN file to SQL server 2005 if not considered a default database
    ... ODBC, just the original database. ... you connect to a SQL Server ... connecting to SQL Server. ... connecting to allows you to install a training or release version of the ...
    (microsoft.public.sqlserver.odbc)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)