Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/uoc/include/Common.asp, line 100
In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_<computername>. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )
Thanks for any help you can give me.
http://spaces.msn.com/members/anthonyarms/
is there an OLEDB connection string in that Common.asp page? it sounds
like thats your connection string. you may need to modify it
accordingly.
|||Thanks for the reply
My connection looks like this :
Application("Connection_ConnectionString") = "Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=[database_name];Initial Catalog=UOC;Data
Source=[computer_name];Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=[computer_name];Use Encryption for Data=False;Tag
with column collation when possible=False;User
Id=[user_name];PASSWORD=[password];"
I don't know if I need to change anything on Server 2003 (the only things I
changed is the text in the square brackets )
Do you think it could be something else?
thanks for any incite you can provide
http://spaces.msn.com/members/anthonyarms/
"GlennThomas5" wrote:

> is there an OLEDB connection string in that Common.asp page? it sounds
> like thats your connection string. you may need to modify it
> accordingly.
>

Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
/uoc/include/Common.asp, line 100
In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_<computername>. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )
Thanks for any help you can give me.
--
http://spaces.msn.com/members/anthonyarms/Try adding a SQL Server UID and PWD to the connection string.
"ARMS" <anthonyarms@.gmail.com> wrote in message
news:289D8794-31E0-4F67-BC55-F07E18A0875C@.microsoft.com...
> Hi
> I,m new to Server 2003 and I'm moving an ASP website to it.
> This is what I have; an basic ASP web site that connects to a "SQL server
> 2000" database on Windows XP box, using IIS.
> Now I have moved the site to Server 2003, on IIS 6, but I'm still using
"SQL
> Server 2000"
> However I can't get the website to connect to the database. this is the
> error I'm am geting
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o
r access
> denied.
> /uoc/include/Common.asp, line 100
> In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
> and it uses the user IUSR_<computername>. Also I have Integrated Windows
> authentication checked off. Is there some security setting that I need to
> set, or do I need to give more access to the "IUSR" user? (oh and I also
> confirmed that SQL server is using SQL Server and Windows Authentication )
> Thanks for any help you can give me.
> --
> http://spaces.msn.com/members/anthonyarms/

Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/uoc/include/Common.asp, line 100
In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_<computername>. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )
Thanks for any help you can give me.
http://spaces.msn.com/members/anthonyarms/
Try adding a SQL Server UID and PWD to the connection string.
"ARMS" <anthonyarms@.gmail.com> wrote in message
news:289D8794-31E0-4F67-BC55-F07E18A0875C@.microsoft.com...
> Hi
> I,m new to Server 2003 and I'm moving an ASP website to it.
> This is what I have; an basic ASP web site that connects to a "SQL server
> 2000" database on Windows XP box, using IIS.
> Now I have moved the site to Server 2003, on IIS 6, but I'm still using
"SQL
> Server 2000"
> However I can't get the website to connect to the database. this is the
> error I'm am geting
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> /uoc/include/Common.asp, line 100
> In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
> and it uses the user IUSR_<computername>. Also I have Integrated Windows
> authentication checked off. Is there some security setting that I need to
> set, or do I need to give more access to the "IUSR" user? (oh and I also
> confirmed that SQL server is using SQL Server and Windows Authentication )
> Thanks for any help you can give me.
> --
> http://spaces.msn.com/members/anthonyarms/

Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
/uoc/include/Common.asp, line 100
In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_<computername>. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )
Thanks for any help you can give me.
--
http://spaces.msn.com/members/anthonyarms/is there an OLEDB connection string in that Common.asp page? it sounds
like thats your connection string. you may need to modify it
accordingly.|||Thanks for the reply
My connection looks like this :
Application("Connection_ConnectionString") = "Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=[database_name];Initial Catalog=UOC;Data
Source=[computer_name];Use Procedure for Prepare=1;Auto Translate=True;P
acket
Size=4096;Workstation ID=[computer_name];Use Encryption for Data=False;T
ag
with column collation when possible=False;User
Id=[user_name];PASSWORD=[password];"
I don't know if I need to change anything on Server 2003 (the only things I
changed is the text in the square brackets )
Do you think it could be something else?
thanks for any incite you can provide
--
http://spaces.msn.com/members/anthonyarms/
"GlennThomas5" wrote:

> is there an OLEDB connection string in that Common.asp page? it sounds
> like thats your connection string. you may need to modify it
> accordingly.
>

Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000

Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't get the website to connect to the database. this is the
error I'm am geting
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/uoc/include/Common.asp, line 100
In IIS 6.0, under the Directory Security tab, I'm using anonymous access,
and it uses the user IUSR_<computername>. Also I have Integrated Windows
authentication checked off. Is there some security setting that I need to
set, or do I need to give more access to the "IUSR" user? (oh and I also
confirmed that SQL server is using SQL Server and Windows Authentication )
Thanks for any help you can give me.
--
http://spaces.msn.com/members/anthonyarms/is there an OLEDB connection string in that Common.asp page? it sounds
like thats your connection string. you may need to modify it
accordingly.|||Thanks for the reply
My connection looks like this :
Application("Connection_ConnectionString") = "Provider=SQLOLEDB.1;Persist
Security Info=False;User ID=[database_name];Initial Catalog=UOC;Data
Source=[computer_name];Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=[computer_name];Use Encryption for Data=False;Tag
with column collation when possible=False;User
Id=[user_name];PASSWORD=[password];"
I don't know if I need to change anything on Server 2003 (the only things I
changed is the text in the square brackets )
Do you think it could be something else?
thanks for any incite you can provide
--
http://spaces.msn.com/members/anthonyarms/
"GlennThomas5" wrote:
> is there an OLEDB connection string in that Common.asp page? it sounds
> like thats your connection string. you may need to modify it
> accordingly.
>

Help: Moving SQL Database to another machine

Hi All,
I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a fe
w things in mind.
1) Need to keep the old SQL Server as is
2) Reduce data loss to the mimimum
3) The simpliest and most straight-forward option as I am kind of new to SQL Server
Also, I will like to know where I can find some good documentation on managing SQL Servers.
Thanks in advance,
Dee.
You can find the steps for moving databases to another
server in the following articles:
INF: Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/?id=224071
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
For documentation on managing servers, books online is a
good resource. In addition, you may want to go through the
Operations Guide:
http://www.microsoft.com/TechNet/pro...n/sqlops0.mspx
-Sue
On Wed, 19 May 2004 12:21:05 -0700, "Bond_007"
<anonymous@.discussions.microsoft.com> wrote:

>Hi All,
>I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a f
ew things in mind.
>1) Need to keep the old SQL Server as is
>2) Reduce data loss to the mimimum
>3) The simpliest and most straight-forward option as I am kind of new to SQL Server
>Also, I will like to know where I can find some good documentation on managing SQL Servers.
>Thanks in advance,
>Dee.

Help: Moving SQL Database to another machine

Hi All,
I will like to get some pointers on moving a SQL database to another machine
. I know that I have a couple of options such as: backup and restore, Sp_de
tach_db and Sp_attach_db, and import adn export. I was wondering which is t
he best option keeping a fe
w things in mind.
1) Need to keep the old SQL Server as is
2) Reduce data loss to the mimimum
3) The simpliest and most straight-forward option as I am kind of new to SQL
Server
Also, I will like to know where I can find some good documentation on managi
ng SQL Servers.
Thanks in advance,
Dee.You can find the steps for moving databases to another
server in the following articles:
INF: Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/?id=224071
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
For documentation on managing servers, books online is a
good resource. In addition, you may want to go through the
Operations Guide:
http://www.microsoft.com/TechNet/pr...in/sqlops0.mspx
-Sue
On Wed, 19 May 2004 12:21:05 -0700, "Bond_007"
<anonymous@.discussions.microsoft.com> wrote:

>Hi All,
>I will like to get some pointers on moving a SQL database to another machine. I kn
ow that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_
attach_db, and import adn export. I was wondering which is the best option keeping
a f
ew things in mind.
>1) Need to keep the old SQL Server as is
>2) Reduce data loss to the mimimum
>3) The simpliest and most straight-forward option as I am kind of new to SQ
L Server
>Also, I will like to know where I can find some good documentation on manag
ing SQL Servers.
>Thanks in advance,
>Dee.

Help: Moving SQL Database to another machine

Hi All
I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a few things in mind
1) Need to keep the old SQL Server as i
2) Reduce data loss to the mimimu
3) The simpliest and most straight-forward option as I am kind of new to SQL Serve
Also, I will like to know where I can find some good documentation on managing SQL Servers
Thanks in advance
Dee.HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql2k
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bond_007" <anonymous@.discussions.microsoft.com> wrote in message
news:A78A0D05-51C5-465A-BD14-74C9F8EE8F0A@.microsoft.com...
> Hi All,
> I will like to get some pointers on moving a SQL database to another
machine. I know that I have a couple of options such as: backup and
restore, Sp_detach_db and Sp_attach_db, and import adn export. I was
wondering which is the best option keeping a few things in mind.
> 1) Need to keep the old SQL Server as is
> 2) Reduce data loss to the mimimum
> 3) The simpliest and most straight-forward option as I am kind of new to
SQL Server
> Also, I will like to know where I can find some good documentation on
managing SQL Servers.
> Thanks in advance,
> Dee.|||You can find the steps for moving databases to another
server in the following articles:
INF: Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/?id=224071
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
For documentation on managing servers, books online is a
good resource. In addition, you may want to go through the
Operations Guide:
http://www.microsoft.com/TechNet/prodtechnol/sql/2000/maintain/sqlops0.mspx
-Sue
On Wed, 19 May 2004 12:21:05 -0700, "Bond_007"
<anonymous@.discussions.microsoft.com> wrote:
>Hi All,
>I will like to get some pointers on moving a SQL database to another machine. I know that I have a couple of options such as: backup and restore, Sp_detach_db and Sp_attach_db, and import adn export. I was wondering which is the best option keeping a few things in mind.
>1) Need to keep the old SQL Server as is
>2) Reduce data loss to the mimimum
>3) The simpliest and most straight-forward option as I am kind of new to SQL Server
>Also, I will like to know where I can find some good documentation on managing SQL Servers.
>Thanks in advance,
>Dee.