472,354 Members | 2,215 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

Separate Webserver and SQL Server -- error when connecting asp.netapp 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
Nov 19 '05 #1
12 2619
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********@xtra.co.nz]
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

Nov 19 '05 #2
"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:O8**************@TK2MSFTNGP10.phx.gbl...
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?
Nov 19 '05 #3
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********@xtra.co.nz]
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

Nov 19 '05 #4
Hi, Mark!

Thank you for helping me out.

1) I am using System.Data.SqlClient for my data access.
2) I have changed the connection string which was located in my
web.config file when we separated the webserver to the sql db server
3) The authenticatio is set to Mixed mode -- SQL Server and Windows
Authentication
4) On the Webserver, the Query Analyzer is not installed on the
webserver. However if I am going to access the query analyzer, I have to
access the sql server itself.

Thanks again!

Mark Rae wrote:
"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:O8**************@TK2MSFTNGP10.phx.gbl...

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?

Nov 19 '05 #5
- 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********@xtra.co.nz]
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********@xtra.co.nz]
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


Nov 19 '05 #6
"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:er**************@TK2MSFTNGP09.phx.gbl...

Ann,
1) I am using System.Data.SqlClient for my data access.
That's a good thing.
2) I have changed the connection string which was located in my web.config
file when we separated the webserver to the sql db server
I'm sure you have but, if we're going to help you, you're going to have to
tell us what the ConnectionString is... :-)
3) The authenticatio is set to Mixed mode -- SQL Server and Windows
Authentication
Even easier.
4) On the Webserver, the Query Analyzer is not installed on the webserver.
However if I am going to access the query analyzer, I have to access the
sql server itself.


No - just use any machine which can "see" the SQL Server and which has the
SQL Client Tools installed.
Nov 19 '05 #7
Ann,

You are getting an error in accessing database. This means that server
connections is ok, just database is not accessible. Most likely you have to
have another look into permissions for the login you are connecting under
for the database you are connecting to. Or make sure the database name is
correct.

Eliyahu

"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:O8**************@TK2MSFTNGP10.phx.gbl...
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

Nov 19 '05 #8
the connection string is:

Data Provider=myDB; Initial Catalog=myDBName; Integrated Securit=SSPI

tried doing the telnet, and it says:
Connecting To database...Could not open a connection to host on port 1433 :
Connect failed
Really do appreciate your help!

"Wessel Troost" wrote:
- 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********@xtra.co.nz]
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********@xtra.co.nz]
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


Nov 19 '05 #9
Hi, Eliyahu!

I've checked the name of the database and the windows user access name that
will be used for the database connection. Before I did that, I've double-
checked as well the user account that will be used to impersonate the access
if it has permissions on the SQL Server database, but to no avail.

It keeps on saying that the db is not existing or access is denied -- in
which I could clearly see the database on the database folder.

Thanks for helping me out! Really appreciate it! :)
"Eliyahu Goldin" wrote:
Ann,

You are getting an error in accessing database. This means that server
connections is ok, just database is not accessible. Most likely you have to
have another look into permissions for the login you are connecting under
for the database you are connecting to. Or make sure the database name is
correct.

Eliyahu

"Ann Marinas" <ka********@xtra.co.nz> wrote in message
news:O8**************@TK2MSFTNGP10.phx.gbl...
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


Nov 19 '05 #10
Hi Ann,

Looks like there's more than one issue. I think a connection string for
SQL server looks like this:

data source=...;user id=...;password=...;initial catalog=...;

The data provider is the driver that serves your database, not the
database.

Below this, on the network layer, there's no chance your connection is
going to work if you can't connect to the database server on port 1433.

Greetings,
Wessel

-----Original Message-----
From: Ann Marinas [mailto:Ann Ma*****@discussions.microsoft.com]
Posted At: Sunday, April 10, 2005 11:15 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

the connection string is:

Data Provider=myDB; Initial Catalog=myDBName; Integrated Securit=SSPI

tried doing the telnet, and it says:
Connecting To database...Could not open a connection to host on port
1433 :
Connect failed
Really do appreciate your help!

"Wessel Troost" wrote:
- 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********@xtra.co.nz]
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********@xtra.co.nz]
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



Nov 19 '05 #11
One of my developers had the same problem and I fixed it by changing the
identity with which ASP.NET
process was running that web-application. Add the following section to your
application's web.config file:
<system.web>
<identity impersonate="true" userName="someaccount" password="something"
/>
</system.web>

Note that provided windows user account must have granted required
permissions to access the remote database.

I also tried something else which worked but this one was more preferred. I
will be pleased if you let me know other solutions you may find.

Jamal

----- Original Message -----
From: "Ann Marinas" <ka********@xtra.co.nz>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Sent: Sunday, April 10, 2005 2:41 PM
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

Nov 19 '05 #13

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Kevin R | last post by:
I'm trying to get asp.net 1.1 running on my home PC. When I try creating a new ASP.NET Web Application in 'Visual Studio .NET 2003' I get the following error: "Visual Studio .NET has detected...
0
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
2
by: |J | last post by:
Dear all, Please help~~ I have a problem in connecting my new FC5 webserver (apache 2.2 + php 5.1.4) to a few database servers through the PHP scripts (RH9, FC2, FC3). I have set host...
5
by: James | last post by:
Hello, I have written a simple logon page that redirects to another page when successful. All works fine on my computer but when I upload it I get the error message below. I have written it...
1
by: Jurgen Haan | last post by:
Hiya... I'm trying to get db2 LUW 8.2.6 X86_64 working on a netapp. We're running SLES 10. The software and instance are created locally, but when I try to create a database on a path mounted...
3
by: LamSoft | last post by:
I am not going to write a aspx to connect a SQL Server... but it tries to connect the SQL Server... Some of the Code.. protected void LoginButton_Click(object sender, EventArgs e) { if...
2
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express...
2
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
1
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
0
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.