Cant connect to local sql server 2000 from VB.NET running WinXP Pro SP2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dee (dee_at_1)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 13:29:49 -0500

Hi

I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC.
When I run the following VB.NET code:

Protected Const SQL_CONNECTION_STRING As String = _
        "Server=localhost;" & _
        "DataBase=Northwind;" & _
        "Integrated Security=SSPI"

 Dim connectionString As String = SQL_CONNECTION_STRING

Dim cnnNW As New SqlConnection(connectionString)

I can't connect to sql server.
This code works fine on a Windows 2000 Pro SP2 pc.

Thanks.

Dee

Relevant Pages

  • Cannot connect to local sql server 2000 from VB.NET on pc running WinXP Pro SP2
    ... I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. ... Dim cnnNW As New SqlConnection ...
    (microsoft.public.sqlserver.connect)
  • RE: SQL server 2005 express setup fails unexpectedly
    ... My error was on WIN XP Pro sp2 with SQL Server ... uninstall and reinstall sql server 2005. ... This fix worked to solve that problem even though the Local AppData key ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Developer Edition Install Error
    ... in the body of your post you refer to Standard Edition. ... understand things you can only install some client-side SQL Server ... 2005 Standard Edition components on XP Pro SP2. ... >minimum system requirements for this SQL Server release.Microsoft SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Slow first connection to SQL Server
    ... When I make the first connection ... to sql server it takes about 10 to 30 seconds to make the ... I can use the exact same code in a windows app with exact same connect ... I am running XP Pro SP2 and I tried disabling the firewall but it didn't ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: WinXP ATA drive to WinXP SATA migration: options and ideas needed
    ... Pro SP2 (all updates); CD/DVD RW ... SATA drive with a 'copy/clone' of WinXP Pro SP2? ... to make it work with a repair install. ...
    (microsoft.public.windowsxp.setup_deployment)