Re: System.Data.SqlClient.SqlException: SQL Server does not exist or a

Tech-Archive recommends: Fix windows errors by optimizing your registry



Does your local system have a default instance of SQL Server installed on
the target server? Is it setup to accept mixed-mode security? Are the ports
open? Is the server running? Do you have a login account setup with the
right password? Does this account have rights to the Initial Catalog? Have
you paid your phone bill? Have you read my book on ADO.NET?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"guru" <guru@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05535763-BE1B-4859-9A3D-FE4AF3151B89@xxxxxxxxxxxxxxxx
>I am getting this error when I try to open database connection.
>
> SqlConnection conn = new SqlConnection();
> conn.ConnectionString = "Persist Security Info=False;User
> ID=ABC;Pwd=XYZ;Initial Catalog=MYDB;Data Source=MYSQLSERVER";
> conn.Open();
> This is happening on my local machin, when I tryed same code on my collges
> system it work....
>
> There is no issue with connection string, user id and pwd and
> database!!!!!
>
> Can any one please let me know how to fix this problem?
>


.



Relevant Pages

  • Re: Indexing Service
    ... the index, but now that the local system doesnt have access, they change to ... Or these were setup as no when they were ... "Hilary Cotter" wrote: ... >>> Looking for a SQL Server replication book? ...
    (microsoft.public.inetserver.indexserver)
  • Re: How to configure for Two different IP subnets
    ... Active Directory will go haywire in a setup like that. ... AD integrates with the local DNS, so you cannot use the DNS at your ISP ... With Server 2003 Standard ... for its internal interface (ie the VPN endpoint). ...
    (microsoft.public.windows.server.networking)
  • RE: To Setup Exchange or not to Setup Exchange...That is the Question.
    ... enough rescources to handle the load that Exchange will put on it. ... into your server in no time, so you will either have to have a very fast RAID ... You can also setup RPC over HTTP for your sales people to reteive e-mail ... phones can download a simple POP client to the phone to get E-mail. ...
    (microsoft.public.exchange.setup)
  • trouble with shared fax service
    ... I setup the shared fax service for the first time on a machine that has SBS ... Our server has one network card connected to a wireless ... Client problem: After setting up shared fax service on the server, ...
    (microsoft.public.windows.server.sbs)
  • Re: Specified network name is no longer available
    ... ISP says nothing wrong with the connection.. ... Also it works just fine if the guys make a dial up VPN connection to ... On it's own the SBS2003 server worked well, ... So Site B was setup. ...
    (microsoft.public.windows.server.sbs)