configuring SQL server 7.0 client on a windows xp pro machine

I am about to attempt to configure a SQL server 7.0 client on a windows XP
workstation. Does anyone have any suggestions or advice that will make this
install go smoothly?
I am not sure what will happen, but any advice would be helpful.
Edward Letendre
Client?
As in the MDAC stack?
XP has MDAC v2.8, which is backward compatible with SQL 7.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Edward Letendre" <EdwardLetendre@.discussions.microsoft.com> wrote in
message news:B78F2F42-36E6-496A-B09F-56E27B2CA50B@.microsoft.com...
> I am about to attempt to configure a SQL server 7.0 client on a windows XP
> workstation. Does anyone have any suggestions or advice that will make
this
> install go smoothly?
> I am not sure what will happen, but any advice would be helpful.
> Edward Letendre
>
|||Actually I was talking about installing the SQL server client software on a
windows xp professional workstation. I just inserted the cd and followed the
instructions. Everything seemed to work.
I also setup the ODBC settings for the various databases that were to be
connected for various applications that are used on this workstation.
Are there anything else I should look into with SQL server 7.0 and windows
xp professional.
Are there any updates to any of the drivers, applications, etc?
Edward Letendre.
"Mike Epprecht (SQL MVP)" wrote:

> Client?
> As in the MDAC stack?
> XP has MDAC v2.8, which is backward compatible with SQL 7.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Edward Letendre" <EdwardLetendre@.discussions.microsoft.com> wrote in
> message news:B78F2F42-36E6-496A-B09F-56E27B2CA50B@.microsoft.com...
> this
>
>
|||Just make sure you apply the latest SQL 7 Service Pack to your client.
David Gugick
Imceda Software
www.imceda.com
Edward Letendre wrote:
> Actually I was talking about installing the SQL server client
> software on a windows xp professional workstation. I just inserted
> the cd and followed the instructions. Everything seemed to work.
> I also setup the ODBC settings for the various databases that were
> to be connected for various applications that are used on this
> workstation.
> Are there anything else I should look into with SQL server 7.0 and
> windows xp professional.
> Are there any updates to any of the drivers, applications, etc?
>

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

For your information (in case it makes any difference), the computer is connected to a domain. And the authentication methods for the virtual directory (in IIS) is configured for "Anonymous access" and "Integrated Windows authentication."

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!
|||Thanks for the post! Saved my life after hours of searching!!!

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

For your information (in case it makes any difference), the computer is connected to a domain. And the authentication methods for the virtual directory (in IIS) is configured for "Anonymous access" and "Integrated Windows authentication."

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!
|||Thanks for the post! Saved my life after hours of searching!!!

Configuring SQL Express -- getting login failed exception

I have a machine with Windows XP Pro w/SP 2, IIS, SQL Server Express and Visual Studio 2005 installed. When I attempt to open a database from an ASPX page, I'm getting an exception with the message:

"Cannot open database "Tasks" requested by the login. The login failed.
Login failed for user 'MYDEV\ASPNET'."

I've searched the web and found a number of pages that talk about the "Login failed for MACHINE\ASPNET" issue, but I didn't find any with a solution.

For your information (in case it makes any difference), the computer is connected to a domain. And the authentication methods for the virtual directory (in IIS) is configured for "Anonymous access" and "Integrated Windows authentication."

Does anyone know how to configure SQL Server Express (or is it IIS?) so the web page can access the database?

RichardR

Okay, I found a solution.

For anyone else experiencing this problem, here's what I did:

First, I installed the November CTP of SQL Server Management Studio Express.

Then, I added the account MACHINENAME\ASPNET under Security | Logins. I did a right-mouse click on the ASPNET login name and clicked on Properties.

This brought up the Login Properties page for ASPNET. I mapped the ASPNET account to my database selecting the database in the "Default Database" dropdown.

In order for the stored procedures to execute, I also needed to check the db_owner box under the Mappings tab.

Finally, I needed to change the connection string to:

Data Source=MYDEV\SQLEXPRESS;Connect Timeout=30;User Instance=False;initial catalog=Tasks;Integrated Security=SSPI;Persist Security Info=False

Hope this helps anyone else encountering this problem.

Richard

|||Thanks - that was very helpful!!!|||Thanks for the post! Saved my life after hours of searching!!!