Sql server does not exist or access denied

• steve1_rm

  Grasshopper

  Points: 17

  More actions

  May 7, 2003 at 12:18 am

  #76017

  Hello

  I am having trouble with my connection string on MSDE.The error message l keep on getting is

  Sql server does not exist or access denied

  The connections string l have tried are as follows:

  Dim objConnection as New SqlClient.SqlConnection("Server = steves-pc; Database = keepfit; User ID = steves-pc\netsdk; Pwd =; trusted_ connection = false")

  and l have also tried the following

  Dim objConnection as New SqlClient.SqlConnection("Server = steves-pc; Database = keepfit; Trusted_Connection = True")

  One question l have, is that l do l need to supply a password, as l don't know of any password that l can use.

  Many thanks in advance

  I don't have enterprise manager, is there another way to set up a ASPNET login, as l think that could be a problem

  Many thanks in advance

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 7, 2003 at 8:05 am

  #456397

  Read this KB articles.

  http://support.microsoft.com/default.aspx?scid=kb;en-us;316989

  http://support.microsoft.com/default.aspx?scid=kb;en-us;815154

  Edited by - Allen_Cui on 05/07/2003 08:05:49 AM

• steve1_rm

  Grasshopper

  Points: 17

  More actions

  May 7, 2003 at 8:54 am

  #456406

  Hello

  Thanks for you reply, and giving me the web site to go to. But l am still a bit lost. Could you give me a example connection string that l can use to get a connection using MSDE.

  Thanks for your help

  Steve

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 7, 2003 at 9:32 am

  #456420

  See example in the link below.

  http://www.asp.net/Tutorials/quickstart.aspx and click 'Server-Side Data Access' on left panel.

  Edited by - Allen_Cui on 05/07/2003 09:34:37 AM

• blackroc

  Grasshopper

  Points: 15

  More actions

  May 7, 2003 at 11:30 pm

  #456477

  I'm getting the same error and its driving me crazy. Before I updated to sql2000 sp3 and framework 1.1, I didn't have any problems but now I can't get it to log into the server.

  Sorry i'm not any help but at least this will help keep this topic up top for some guru to buzz in.