473,722 Members | 2,363 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server on Windows XP Pro and ASP

I want to set up SQL Server on Windows XP Pro so that I can use the database
capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:
When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760
(Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-12-19 15:51:28.20 server Copyright (C) 1988-2002 Microsoft
Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992.
2003-12-19 15:51:28.21 server Logging SQL Server messages in file
'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class
'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode
processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock
Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'.
2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database
'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database 'master'
(1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-12-19 15:51:29.23 spid5 Starting up database 'model'.
2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'.
2003-12-19 15:51:29.59 spid5 Clearing tempdb database.
2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'.
2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is
created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory.
2003-12-19 15:51:32.20 server SQL Server is ready for client connections
When I go to Data Sources (ODBC) --> System DSN --> Configure I see the
following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial
Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; .NET
CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how to give
XP Pro's IIS DB capabilities, I would GREATLY appreciate it. Thank you.
--
Nathan Sokalski
nj********@hotm ail.com
Jul 19 '05 #1
6 4454
See http://www.aspfaq.com/2126 for valid connection strings.

Followups set to microsoft.publi c.inetserver.as p.db only.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:#s******** ******@TK2MSFTN GP09.phx.gbl...
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:
When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760
(Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-12-19 15:51:28.20 server Copyright (C) 1988-2002 Microsoft
Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992.
2003-12-19 15:51:28.21 server Logging SQL Server messages in file
'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class
'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode
processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock
Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'.
2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database
'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database 'master' (1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-12-19 15:51:29.23 spid5 Starting up database 'model'.
2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'.
2003-12-19 15:51:29.59 spid5 Clearing tempdb database.
2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'.
2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is
created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory.
2003-12-19 15:51:32.20 server SQL Server is ready for client connections

When I go to Data Sources (ODBC) --> System DSN --> Configure I see the
following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial
Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; .NET
CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how to give XP Pro's IIS DB capabilities, I would GREATLY appreciate it. Thank you.
--
Nathan Sokalski
nj********@hotm ail.com

Jul 19 '05 #2
I guess Aaron Bertrand site should solve ur Question.
Good Site Aaron Bertrand...
Let me know is u have any other questions!!
Patrick

-----Original Message-----
See http://www.aspfaq.com/2126 for valid connection strings.
Followups set to microsoft.publi c.inetserver.as p.db only.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Nathan Sokalski" <nj********@hot mail.com> wrote in messagenews:#s******* *******@TK2MSFT NGP09.phx.gbl.. .
I want to set up SQL Server on Windows XP Pro so that I can use the
database
capabilities of ASP and IIS. I am probably using some
incorrect settings, but I am not sure what they are. Here is what I am currently doing:

When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760 (Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2003-12-19 15:51:28.20 server Copyright (C) 1988- 2002 Microsoft Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992. 2003-12-19 15:51:28.21 server Logging SQL Server messages in file 'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class 'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'. 2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database 'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database'master'
(1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL'
version '8.0.766'. 2003-12-19 15:51:29.23 spid5 Starting up database 'model'. 2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'. 2003-12-19 15:51:29.59 spid5 Clearing tempdb database. 2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'. 2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory. 2003-12-19 15:51:32.20 server SQL Server is ready for clientconnections


When I go to Data Sources (ODBC) --> System DSN -->
Configure I see the following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:
Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist oraccess
denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
FunWebProducts; .NET CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how togive
XP Pro's IIS DB capabilities, I would GREATLY

appreciate it. Thank you. --
Nathan Sokalski
nj********@hotm ail.com

.

Jul 19 '05 #3
I agree that the site about what the connection strings should look like is
a very good site, but I think my problem is in the settings in my
configuration. I am having trouble figuring out what settings I need to
change, and what I need to change them to. I think it would help me more if
someone told some of the changes I need to make in control panel, because I
am new to server configuration. Any help would be greatly appreciated.
Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
"Naijacoder " <am*****@yahoo. com> wrote in message
news:00******** *************** *****@phx.gbl.. .
I guess Aaron Bertrand site should solve ur Question.
Good Site Aaron Bertrand...
Let me know is u have any other questions!!
Patrick

-----Original Message-----
See http://www.aspfaq.com/2126 for valid connection

strings.

Followups set to microsoft.publi c.inetserver.as p.db only.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Nathan Sokalski" <nj********@hot mail.com> wrote in

message
news:#s******* *******@TK2MSFT NGP09.phx.gbl.. .
I want to set up SQL Server on Windows XP Pro so that I can use the
database
capabilities of ASP and IIS. I am probably using some

incorrect settings, but I am not sure what they are. Here is what I am currently doing:

When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760 (Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2003-12-19 15:51:28.20 server Copyright (C) 1988- 2002 Microsoft Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992. 2003-12-19 15:51:28.21 server Logging SQL Server messages in file 'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class 'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'. 2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database 'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database
'master'
(1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL'

version '8.0.766'. 2003-12-19 15:51:29.23 spid5 Starting up database 'model'. 2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'. 2003-12-19 15:51:29.59 spid5 Clearing tempdb database. 2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'. 2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory. 2003-12-19 15:51:32.20 server SQL Server is ready for client
connections


When I go to Data Sources (ODBC) --> System DSN -->

Configure I see the following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:
Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;

FunWebProducts; .NET CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how to
give
XP Pro's IIS DB capabilities, I would GREATLY

appreciate it. Thank you. --
Nathan Sokalski
nj********@hotm ail.com

.

Jul 19 '05 #4
Nathan Sokalski wrote:
I agree that the site about what the connection strings should look
like is a very good site, but I think my problem is in the settings
in my configuration. I am having trouble figuring out what settings I
need to change, and what I need to change them to. I think it would
help me more if someone told some of the changes I need to make in
control panel,


No one has told you any because there aren't any. As long as you have MDAC
installed (which is very likely due to the fact that you did not get a
"could not create object" error, you should be able to connect to the
database without making any settings in the control panel.

I suspect your problem is due to your attempt to use integrated security.
Beginners usually do not realize that asp is not running under their
security: the Internet Guest account is the account used when asp pages are
running.

Instead of attempting to use integrated security, I suggest creating a SQL
login using SQL Enterprise Manager (have you installed the SQL client
tools?).

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #5
You are attempting a connection from an app that allows anonymous access. It
uses the IUSR account to connect when a non-domain account connects.

You have choices:
1) Get rid of anon access and force all users to log in
2) Switch to mixed mode authentication (ie, adding a user name and password)
NOTE: SQL Server will have to be set up mixed mode.
3) Add IUSR_ComputerNa me (where ComputerName is the name of the computer in
question) to the SQL Server (works real well, but a major security hole).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:
When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760
(Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-12-19 15:51:28.20 server Copyright (C) 1988-2002 Microsoft
Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992.
2003-12-19 15:51:28.21 server Logging SQL Server messages in file
'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class
'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode
processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock
Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'.
2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database
'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database 'master' (1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-12-19 15:51:29.23 spid5 Starting up database 'model'.
2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'.
2003-12-19 15:51:29.59 spid5 Clearing tempdb database.
2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'.
2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is
created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory.
2003-12-19 15:51:32.20 server SQL Server is ready for client connections

When I go to Data Sources (ODBC) --> System DSN --> Configure I see the
following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial
Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; .NET
CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how to give XP Pro's IIS DB capabilities, I would GREATLY appreciate it. Thank you.
--
Nathan Sokalski
nj********@hotm ail.com

Jul 19 '05 #6
P.S. I hate DSNs.

Adds a lot of weight to the app and no benefit. Forces you to use ODBC
instead of OleDb. Very messy overall.

Correct SQL Server connString for mixed mode (example):

Provider=SQLOLE DB.1;Server={Se rver Name Here};Database= {DB name
here};UID={User name here};
PWD={password here};

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:
When I run sqlservr.exe I see the following:

2003-12-19 15:51:28.20 server Microsoft SQL Server 2000 - 8.00.760
(Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-12-19 15:51:28.20 server Copyright (C) 1988-2002 Microsoft
Corporation.

2003-12-19 15:51:28.20 server All rights reserved.
2003-12-19 15:51:28.20 server Server Process ID is 2992.
2003-12-19 15:51:28.21 server Logging SQL Server messages in file
'C:\Program
Files\Microsoft SQL Server\MSSQL\LO G\ERRORLOG'.
2003-12-19 15:51:28.28 server SQL Server is starting at priority class
'norma
l'(2 CPUs detected).
2003-12-19 15:51:28.56 server SQL Server configured for thread mode
processin
g.
2003-12-19 15:51:28.57 server Using dynamic lock allocation. [500] Lock
Block
s, [1000] Lock Owner Blocks.
2003-12-19 15:51:28.79 spid4 Starting up database 'master'.
2003-12-19 15:51:29.14 spid4 0 transactions rolled back in database
'master'
(1).
2003-12-19 15:51:29.14 spid4 Recovery is checkpointing database 'master' (1)

2003-12-19 15:51:29.23 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-12-19 15:51:29.23 spid5 Starting up database 'model'.
2003-12-19 15:51:29.28 spid4 Server name is 'NJS'.
2003-12-19 15:51:29.28 spid4 Starting up database 'msdb'.
2003-12-19 15:51:29.59 spid5 Clearing tempdb database.
2003-12-19 15:51:30.15 spid5 Starting up database 'tempdb'.
2003-12-19 15:51:30.26 spid4 Recovery complete.
2003-12-19 15:51:30.28 spid4 SQL global counter collection task is
created.
2003-12-19 15:51:32.18 server SQL server listening on Shared Memory.
2003-12-19 15:51:32.20 server SQL Server is ready for client connections

When I go to Data Sources (ODBC) --> System DSN --> Configure I see the
following after choosing my settings:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Data Source Name: NJS
Data Source Description:
Server: NJS
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Do not create temporary procedures
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

And running Test Data Source... gives me the following:

Microsoft SQL Server ODBC Driver Version 03.81.9041

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!
My ASP code that is supposed to connect to the Database is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
connectstring=" Provider=SQLOLE DB.1;Data Source=NJS;Init ial
Catalog=pubs;In tegrated Security=SSPI"
conn.Open connectstring
And the error I receive when I open the ASP page is:

Technical Information (for support personnel)

a.. Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/testdb.asp, line 25
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; .NET
CLR 1.0.3705; .NET CLR 1.1.4322)

c.. Page:
GET /testdb.asp

d.. Time:
Friday, December 19, 2003, 3:49:59 PM

If anyone is able to help me or tell me specific instructions on how to give XP Pro's IIS DB capabilities, I would GREATLY appreciate it. Thank you.
--
Nathan Sokalski
nj********@hotm ail.com

Jul 19 '05 #7

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

Similar topics

8
3440
by: Brad Tilley | last post by:
Does Python run on Windows Server 2003? http://www.python.org/download/download_windows.html only lists the following: Python for Windows 95, 98, NT, 2000, ME, XP
2
15225
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000 Personal disk from the SQL Server 2000 Enterprise kit as this is reported here on the MSDN web site to be the version that is supported on Windows XP. In fact so many of you kind people confess to having succeeded in doing it. I have tried...
2
2133
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an issue with Active Directory. Our network consists of Windows-2000 Servers (SP 4) and Windows-2000 workstations and Windows-XP workstations. We also have SQL Server 2000 (SP2) in three Windows-2000 servers. All work fine. Recently, we get a...
2
588
by: Petr PALAS | last post by:
Hi, when I open ANY ASP.NET application on my computer I get this message: ---------------------------------------------------------------------------- ---- Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser
5
2787
by: Ken Cox [Microsoft MVP] | last post by:
MS has posted this here: http://www.asp.net/faq/ms03-32-issue.aspx Fix for: 'Server Application Unavailable' Error after Applying Security Update for IE ------------------------------------------------------------------------------- -
1
2975
by: Reza Sadeghi | last post by:
Hi I am getting this error when I tried to browse any asp.net in visual studio.net. I can build the project but when I try to run and debug the project I get error message that "Unable to start debugging on the web server. server side error occurred on sending debug HTTP Request. I am running WinXP Pro SP1 with all hotfixes and VS.NET 2002 and .NET Framework 1.0
2
3213
by: Vaap | last post by:
I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000 database. Tried all possible combinations but it still fails. I have Windows 2003 server having SQL Server 2000 installed with SP2. The installation went Ok on a XP professional machine and I was able to create database and user logins etc on...
22
3299
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to load DLL (aspnet_isapi.dll)." Of course the dll is able to be found, it's still in the framework directory and for grins I even put it in my service's local directory. This is apparantly server 2003 not allowing asp.net to be run if IIS was not...
4
7300
by: coosa | last post by:
Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always get the same error message: "An error occurred while creating one or more registry entries. Please see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a low registry quota condition" I have tried to clean the registry and i...
14
3033
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
0
8861
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8739
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9383
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9236
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9088
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4502
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4762
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3207
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2601
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.