Login stoped working with install of Visual Studio

From: grs (gsmith1943_at_earthlink.net)
Date: 05/17/03


Date: Sat, 17 May 2003 10:09:15 -0500


Last weekend I finally connected a workstation to a server running SQL with
the following:

aString = "server=dell330;uid=sa;pwd=XXXXXX;database=northwind";
SqlConnection mySqlConnection = new SqlConnection(aString);
SqlCommand mySqlCommand = new SqlCommand("select * from customers",
mySqlConnection);
try
  {
    mySqlConnection.Open();
    .....

NOW, after installing Visual Studio 2003 (I first uninstalled 2002) I get
following error message:
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.
   at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
   at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnection.Open()
   at ConnectToNorthwind.frmMain.UseDataReader() in
c:\grsprojectvisualstudio\connecttonorthwind\frmmain.cs:line 334

This is a home network that I want to program on but all the time is spent
in networking problems.

The SQL server is running on a 2003 domain controller.
Also I never did get the windows authentication to work that is why I am
using the sql authentication.

thanks
grs



Relevant Pages

  • Re: EXECing on SQL Server 2008 from 2000
    ... new server running SQL Server 2008. ... EXEC SQL commands on the new server from the old one. ... running the same command on our old 2000 server gives me this ...
    (comp.databases.ms-sqlserver)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)